Forum Activity for @michael

michael
@michael
04/27/22 05:50:04PM
7,717 posts

Jamroom Installation Error (No tables being created)
Installation and Configuration

only thing that looks weirdish is that you're using nginx instead of apache2 other than that I would expect errors to be sent back from the install script during the install.

For absolute safety of expecting install to work I'd try Php: 7.4 with apache.

Here's my system install locally thats all working: (screenshot).

Also make sure you've set up a domain name in your /etc/hosts file. Jamroom doesnt run well on an ipaddress or 'localhost'.
check.png check.png - 169KB
michael
@michael
04/20/22 07:33:46PM
7,717 posts

Still Unable To Update Modules
Installation and Configuration

Do a manual upgrade. Something about the server you're on isn't co-operating with the jamroom marketplace system the permissions idea would be the correct way to fix it, but since that doesn't work you can download the latest version from here:

https://www.jamroom.net/products

Click "Download Open Source". Then un-zip that and use SFTP to upload it to your server. Over-write any files on the server and you will be upgraded.

After that run the integrity check from ACP -> MODULES -> CORE -> SYSTEM CORE -> TOOLS -> INTEGRITY CHECK

Then you can look at the ACP -> MODULES -> CORE -> SYSTEM CORE -> TOOLS -> SYSTEM CHECK to see if there are any orange lights for things that are not working on your server.

It could be that your server does not have 'symlink' enabled. Or something else, I'm just guessing.
michael
@michael
04/17/22 11:26:20PM
7,717 posts

Upgrading an ancient Jamrooom
Installation and Configuration

localhost is fine. All you're looking to do is get the data into a format that works with the current version.

I don't think I have even seen what JR2's sql data looked like. If you want to send the SQL file to support at jamroom dot net I can take a look at the structure you have to see if there are any shortcuts.
michael
@michael
04/17/22 06:57:14PM
7,717 posts

Upgrading an ancient Jamrooom
Installation and Configuration

another possible issue you might run into is PHP versions. I don't know what Jamroom2 required by Jamroom4 could only run on php 5.2 but JR5 needs 5.6+.

So likely you'd need either 2 servers to run the old site and the new.
michael
@michael
04/13/22 08:59:28PM
7,717 posts

2 databases
Installation and Configuration

He's around. Ask a difficult server question and we'll all direct it to him ;)
michael
@michael
04/12/22 08:48:44PM
7,717 posts

2 databases
Installation and Configuration

Look in your config.php file found via SFTP at:
your-site.com/public_html/data/config/config.php

In it it will have the name of the database in use.

in the databases a good place to look for identifying info is in the 'jr_jrcore_settings' table look in the 'module' column for the value 'jrCore' then in the 'name' column for 'system_name' and it should tell you what was set for the sites system name.

It may be from an old site.
michael
@michael
04/08/22 11:09:39PM
7,717 posts

Chinese + Bots = ?
Ning To Jamroom

Could be connected. Whats the goal? You can ban anyone anytime for anything you like, its your site. So if someone creates an account "Chris Smith" but has a location where that feels like its a fake name and also accompanied by a suspicious email address buy.cheap.meds@gmail.com you're not wrong to just block them. You can do that from the WHOS ONLINE tab, there's a BLOCK USER button.
michael
@michael
04/08/22 03:52:34AM
7,717 posts

Name of Database Tables for users
Design and Skin Customization

The users are all in a datastore, same with the audio module. So the best way to get access to the data in the templates is via
{jrCore_list module="jrUser" .........}
and if you're accessing via module code then by using jrCore_db_search_items
 $_sp = array(
        'search'          => array(
            "user_email = {$_post['q']}"
        ),
        'return_keys'     => array('_user_id', '_profile_id', '_updated', 'user_name', 'user_first_name', 'user_last_name', 'user_image_time', 'user_image_extension'),
        'limit'           => 1
    );

    $_rt = jrCore_db_search_items('jrUser', $_sp);

A datastore is split over 2 tables the key and the item, so you'll find all the info at:
jr_jruser_item
jr_jruser_item_key

tables.
  24