solved Nginx install dbase error

jimmyk
jimmyk
@jimmy
9 years ago
514 posts
I'm trying to get Jamroom working with Centminmod LEMP and got the vhost conf file working, sends me to the install page, no problem.

I'm having an issue during install with the database. I'm running Mariadb and haven't had any problem installing other scripts on my local machine.

When I run the installer, I get this error.

CRI: Query Error: Table 'jamroom3.jr_jrblog_item_key' doesn't exist

Any idea what could be happening here?
updated by @jimmy: 03/24/16 06:06:41PM
michael
@michael
9 years ago
7,692 posts
Try removing the jrBlog module and see if it goes through.

That would eliminate the possibility that it could be an issue with the blog module.
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
Sounds good. I'll try it now.
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
Now I'm getting:

CRI: Query Error: Table 'jamroom.jr_jrpage_item_key' doesn't exist
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
Deleted the jrpage and jrblog module. Got a success on the install.

Sends me to the main page of the site. In the newest profiles I see:

CRI: Query Error: Table 'jamroom2.jr_jrprofile_item_key' doesn't exist

That might have to do with no users on the site. Have to work on the conf file some more because clicking create account sends me to 404 page.

Though, the two errors while installing the dbase was a little weird. It sounds like I might have to do a little more work with the conf file, because it's the php file populating that dbase.

Arrr! Though I love a challenge... especially when I'm so tired and about to fall asleep! LOL!
updated by @jimmy: 12/18/15 11:42:29PM
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
@michael do you have an example direct link to a page on the site? If I wanted to go to example.com/user/signup what would be the direct link. I'm getting 404 pages for all the links and I wanted to test out if it was because of the dbase or my conf file.
michael
@michael
9 years ago
7,692 posts
If url's aren’t working its probably the equivalent of .htaccess not being there. Not sure if ngix uses .htaccess as I think its an apache thing.

/user/signup should work as that provided by the jrUser module.
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
Yea, no htaccess in Nginx. I figured it out. Now the links are working. Still another problem, I go to create a new user and I get the error below.

CRI: Query Error: Table 'jamroom1.jr_jruser_item_key' doesn't exist

Here is the page it errors out on.

https://10.0.0.123/user/signup_save
updated by @jimmy: 12/19/15 12:53:26AM
michael
@michael
9 years ago
7,692 posts
Yeah its not a "somethings wrong with a module" problem by the looks of it, looks more like a "database not connecting correctly if tables cant be created" type problem.
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
Hmmm... wonder how I should proceed with this one. Didn't have any problems with the other scripts I installed, they're all working no db issues. The only thing I can think of besides something in the my.cnf would be that I'm using the same user for this dbase as another dbase. I could create a new user, maybe for some strange reason that is affecting the DB.

Do you know of any setting in the my.cnf that might need to be changed for JR. Maybe I have something set too low?

The only thing I changed was the session.serialize_handler from igbinary to php which I need for IPB, but that's PHP related. I can't really see how that would be an issue. I'll mention nevertheless.

Maybe tomorrow, it's late here on the US east coast, I'll create a new VM with stock settings. Try to install JR again. Though, this local machine is pretty much stock right now.
updated by @jimmy: 12/19/15 01:18:46AM
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
Attached is the my.cnf file I'm using if anyone wants to take a gander.
zip
my.zip  •  2KB

jimmyk
jimmyk
@jimmy
9 years ago
514 posts
For some reason it's skipping tables. Why would it create some tables and not others? I even went in and switched the default to MyISAM just to see if that might be the issue. Below are the tables JR created with a "successful" install - successful meaning that I got to the "success" page - after removing the jrPages and jrBlog modules which would give me an error during the install.

MariaDB [jr5]> show tables;
+----------------------------+
| Tables_in_jr5 |
+----------------------------+
| jr_jraction_item |
| jr_jrcore_cache |
| jr_jrcore_count_ip |
| jr_jrcore_form |
| jr_jrcore_form_session |
| jr_jrcore_item |
| jr_jrcore_log |
| jr_jrcore_log_debug |
| jr_jrcore_menu |
| jr_jrcore_modal |
| jr_jrcore_module |
| jr_jrcore_pending |
| jr_jrcore_pending_reason |
| jr_jrcore_performance |
| jr_jrcore_play_key |
| jr_jrcore_queue |
| jr_jrcore_setting |
| jr_jrcore_skin |
| jr_jrcore_temp |
| jr_jrcore_template |
| jr_jrfollower_item |
| jr_jrmailer_throttle |
| jr_jrmarket_channel |
| jr_jrmarket_install |
| jr_jrmarket_system |
| jr_jrprofile_item |
| jr_jrprofile_profile_link |
| jr_jrprofile_quota |
| jr_jrprofile_quota_setting |
| jr_jrprofile_quota_value |
| jr_jrsearch_fulltext |
| jr_jrsearch_item |
| jr_jruser_cookie |
| jr_jruser_device |
| jr_jruser_forgot |
| jr_jruser_item |
| jr_jruser_language |
| jr_jruser_session |
| jr_jruser_url |
+----------------------------+
39 rows in set (0.00 sec)

I appear to have the re-writes working in the vhost conf file. I'm getting a successful routing to the installer, create account, login, create new account, etc. Why it's creating some and not all the tables is beyond me, unless those tables have something special about them which is forcing some kind of skip.

I've also checked the mysqld.log and the site error_log file to see if anything was showing up, nothing out of the ordinary. The error log is showing some broken image files, but that's probably a specific re-write issue I have to handle when and if I get JR working.

I'm not getting any help from the CENTMINMOD developer, he doesn't have time to test out JR (he's never even heard of it). Every other piece of software works fine on CENTMINMOD - IPB, Xenforo, VB, Wordpress, Drupal, etc.

I did my last test with very minor tweaks to CENTMINMOD and the initial install test of JR was done with STOCK Centminmod install. I only did tweaks after I will still getting the errors.

At this point, I'm kinda stuck. I'm really out of energy creating a new database every time the install fails to create the tables I need to have the site working. I really would love to get this working for everyone. Any help with this would be much appreciated.
updated by @jimmy: 12/19/15 10:34:42PM
brian
@brian
9 years ago
10,136 posts
My guess here based on the tables showing is that you do NOT have the InnoDB engine enabled - make sure InnoDB is an enabled engine in MariaDB.

Let me know if that helps.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
brian:
My guess here based on the tables showing is that you do NOT have the InnoDB engine enabled - make sure InnoDB is an enabled engine in MariaDB.

Let me know if that helps.

InnoDB engine is enable and is actually the default engine. You can see in the my.cnf above that the engine is enabled.

I tested with the InnoDB engine enabled and disabled. No luck.





updated by @jimmy: 12/20/15 08:57:50AM
brian
@brian
9 years ago
10,136 posts
jimmyk:
brian:
My guess here based on the tables showing is that you do NOT have the InnoDB engine enabled - make sure InnoDB is an enabled engine in MariaDB.

Let me know if that helps.

InnoDB engine is enable and is actually the default engine. You can see in the my.cnf above that the engine is enabled.

I tested with the InnoDB engine enabled and disabled. No luck.

I use MariaDB here and don't have issues, but something is not working right on your install - the tables being created are just the MyISAM ones - the InnoDB ones are NOT being created, so regardless of your config something is not setup right.

Check your MariaDB error log (I think it is at /var/log/mysql/error.log).


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
I have all the errors going to log-error=/var/log/mysqld.log in the my.cnf

[mysqld_safe] 
socket=/var/lib/mysql/mysql.sock
log-error=/var/log/mysqld.log
#nice = -5
open-files-limit = 8192

Output:

(snipped)
updated by @jimmy: 12/20/15 09:20:18AM
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
Got a post back from the developer of Centminmod:

Quote: early MariaDB 5.5 installs had this, MariaDB 10 with 123.08 stable and higher switched to enable InnoDB by default

https://community.centminmod.com/posts/22756/
brian
@brian
9 years ago
10,136 posts
Not sure what to suggest - clearly the InnoDB tables are not being created. I don't see any issues in your error log, but something is not right. I have MariaDB 10.1 running here and don't see this issue, so unfortunately I am not sure what to suggest.

Try running this query from the MySQL command line client:

CREATE TABLE `jr_jruser_item_key` (
  `_item_id` int(11) unsigned NOT NULL DEFAULT '0',
  `key` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `index` smallint(5) unsigned NOT NULL DEFAULT '0',
  `value` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  PRIMARY KEY (`key`,`_item_id`,`index`),
  KEY `_item_id` (`_item_id`),
  KEY `index` (`index`),
  KEY `value` (`value`(255))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

and see if it works or gives you an error.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
Results:

MariaDB [(none)]> use jr5
Database changed
MariaDB [jr5]> CREATE TABLE `jr_jruser_item_key` (
    ->   `_item_id` int(11) unsigned NOT NULL DEFAULT '0',
    ->   `key` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    ->   `index` smallint(5) unsigned NOT NULL DEFAULT '0',
    ->   `value` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    ->   PRIMARY KEY (`key`,`_item_id`,`index`),
    ->   KEY `_item_id` (`_item_id`),
    ->   KEY `index` (`index`),
    ->   KEY `value` (`value`(255))
    -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Query OK, 0 rows affected (0.06 sec)

MariaDB [jr5]>


MariaDB [jr5]> show tables;
+--------------------+
| Tables_in_jr5      |
+--------------------+
| jr_jruser_item_key |
+--------------------+
1 row in set (0.00 sec)

MariaDB [jr5]>

updated by @jimmy: 12/20/15 09:32:58AM
brian
@brian
9 years ago
10,136 posts
You should have no issues installing JR then - that is an exact query for creating one of the DS item_key tables in JR. If it works from the command line, I see no reason why it wouldn't work from the web. I'm not sure if you can limit engine type to specific accounts, but check your MariaDB user's credentials and make sure the DB user you are using for JR has access to use InnoDB.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
I use

GRANT ALL PRIVILEGES ON jr5. * TO 'peachpum'@'localhost';

So that should allow for creating anything.
updated by @jimmy: 12/20/15 09:39:06AM
brian
@brian
9 years ago
10,136 posts
jimmyk:
So, we know for sure that the system is able to create InnoDB tables. That leads me to the conf file for JR. But why would my vhost conf file - being that it's super simple routing everything through the router.php file, allow the creating of MyISAM tables and not InnoDB tables?

It wouldn't - it's not going to be related to the web server config - it's going to be related to the permissions for the DB user in MariaDB.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
Sorry, I updated my last post with what I use to grant the permissions in mysql server.
brian
@brian
9 years ago
10,136 posts
jimmyk:
Sorry, I updated my last post with what I use to grant the permissions in mysql server.

When you created the table above from the MariaDB CLI - did you do that as the root user?


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
brian:
jimmyk:
Sorry, I updated my last post with what I use to grant the permissions in mysql server.

When you created the table above from the MariaDB CLI - did you do that as the root user?

Now that you mention that, yes I did.
brian
@brian
9 years ago
10,136 posts
Try installing Jamroom using the root credentials and see if it works - if it does, we know it is a grant issue with the JR user.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
I just deleted the dbase and created a new one. Added all the permissions, etc.

Logged into the mysql server with

mysql --user=peachpum --password=0HSnJWDFIlUfKI1VsLhu jr5

Result of running your code above.

MariaDB [jr5]> CREATE TABLE `jr_jruser_item_key` (
    ->   `_item_id` int(11) unsigned NOT NULL DEFAULT '0',
    ->   `key` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    ->   `index` smallint(5) unsigned NOT NULL DEFAULT '0',
    ->   `value` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    ->   PRIMARY KEY (`key`,`_item_id`,`index`),
    ->   KEY `_item_id` (`_item_id`),
    ->   KEY `index` (`index`),
    ->   KEY `value` (`value`(255))
    -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Query OK, 0 rows affected (0.06 sec)


MariaDB [jr5]> show tables;
+--------------------+
| Tables_in_jr5      |
+--------------------+
| jr_jruser_item_key |
+--------------------+
1 row in set (0.00 sec)

MariaDB [jr5]> Ctrl-C -- exit!
brian
@brian
9 years ago
10,136 posts
It doesn't make sense then that it's not working from the installer - that's the query it creates.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
I can try the root creds later today when I get back from an Xmas party. I will report back my findings from that when I do it.

Thanks Brian for helping out. I'm sure this is going to end up getting solved at some point. :)
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
brian:
It doesn't make sense then that it's not working from the installer - that's the query it creates.

YEA! I was up to 4am trying to figure this out. Weirdest thing. I need that Staples "Easy" button!
brian
@brian
9 years ago
10,136 posts
jimmyk:
I can try the root creds later today when I get back from an Xmas party. I will report back my findings from that when I do it.

Thanks Brian for helping out. I'm sure this is going to end up getting solved at some point. :)

No problem - I've never seen an issue like this before, so it would be good to figure it out :)

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
Created a new database. Uploaded new files to the public folder. Got the install page, used root instead of the user and got the same results. Note: In the results below I didn't remove the jrBlog and jrPages modules which were giving me an issue when I installed (though the issue is still there).

MariaDB [jr5]> show tables;
+----------------------------+
| Tables_in_jr5              |
+----------------------------+
| jr_jraction_item           |
| jr_jrblog_item             |
| jr_jrcore_cache            |
| jr_jrcore_count_ip         |
| jr_jrcore_form             |
| jr_jrcore_form_session     |
| jr_jrcore_item             |
| jr_jrcore_log              |
| jr_jrcore_log_debug        |
| jr_jrcore_menu             |
| jr_jrcore_modal            |
| jr_jrcore_module           |
| jr_jrcore_pending          |
| jr_jrcore_pending_reason   |
| jr_jrcore_performance      |
| jr_jrcore_play_key         |
| jr_jrcore_queue            |
| jr_jrcore_setting          |
| jr_jrcore_skin             |
| jr_jrcore_temp             |
| jr_jrcore_template         |
| jr_jrfollower_item         |
| jr_jrmailer_throttle       |
| jr_jrmarket_channel        |
| jr_jrmarket_install        |
| jr_jrmarket_system         |
| jr_jrpage_item             |
| jr_jrprofile_item          |
| jr_jrprofile_profile_link  |
| jr_jrprofile_quota         |
| jr_jrprofile_quota_setting |
| jr_jrprofile_quota_value   |
| jr_jrsearch_fulltext       |
| jr_jrsearch_item           |
| jr_jruser_cookie           |
| jr_jruser_device           |
| jr_jruser_forgot           |
| jr_jruser_item             |
| jr_jruser_language         |
| jr_jruser_session          |
| jr_jruser_url              |
+----------------------------+
41 rows in set (0.00 sec)


updated by @jimmy: 12/20/15 05:14:10PM
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
Just so that it's posted here. This is the current vhost file I'm using with CENTMINMOD LEMP. If someone reading this wants to test out the install on Centminmod, to try to help solve this problem, you can use this demo vhost file.

# Jamroom Working NGINX site conf file
# This file is for a FORCED SSL site.  Non-SSL requests will be directed to SSL.

# Jamroom forum thread:  https://www.jamroom.net/the-jamroom-network/forum/off-topic/35854/jamroom-and-nginx-centmin-mod-lemp-stack
# Centminmod forum thread:  
# 10.0.0.151 is a demo IP.  Replace with your domain. Example:  yourdomain.com

# Redirect to HTTPS from port 80
# Redirect from www to non-www with forced SSL
server {
    listen  80;
    server_name 10.0.0.151;
    return 301 https://10.0.0.151$request_uri;
    
    # Access and Error Logs
    access_log /home/nginx/domains/10.0.0.151/log/access_via80.log combined buffer=256k flush=60m;
    error_log /home/nginx/domains/10.0.0.151/log/error_via80.log;
}

server {
    listen 443 ssl http2;
    server_name  10.0.0.151;
    root /home/nginx/domains/10.0.0.151/public;
    
    ssl_dhparam /usr/local/nginx/conf/ssl/10.0.0.151/dhparam.pem;
    ssl_certificate      /usr/local/nginx/conf/ssl/10.0.0.151/10.0.0.151.crt;
    ssl_certificate_key  /usr/local/nginx/conf/ssl/10.0.0.151/10.0.0.151.key;
    include /usr/local/nginx/conf/ssl_include.conf;
    
    # Mozilla Recommended
    ssl_ciphers ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:kEDH+AESGCM:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:AES:CAMELLIA:DES-CBC3-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK:!aECDH:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA:!CAMELLIA:!DES-CBC3-SHA;
    ssl_prefer_server_ciphers   on;
    #add_header Strict-Transport-Security "max-age=31536000; includeSubdomains;";
    #add_header  X-Content-Type-Options "nosniff";
    #add_header X-Frame-Options DENY;
    ssl_buffer_size 1400;
    ssl_session_tickets on;

    # ngx_pagespeed & ngx_pagespeed handler
    # include /usr/local/nginx/conf/pagespeed.conf;
    # include /usr/local/nginx/conf/pagespeedhandler.conf;
    # include /usr/local/nginx/conf/pagespeedstatslog.conf;

    # Limit Connections Per IP Address
    # Modified from default to allow Admin directory to have more connections
    # Modified in nginx.conf
    # limit_conn_zone $limitconn_map zone=limit_per_ip:16m;
    
    # ssi  on;

    # Access and Error Logs
    access_log /home/nginx/domains/10.0.0.151/log/access_via443.log combined buffer=256k flush=60m;
    error_log /home/nginx/domains/10.0.0.151/log/error_via443.log;

    # Prevent access to ./directories and files
    #location ~ (?:^|/)\. {
    #    deny all;
    #}

    location / {

        # block common exploits, sql injections etc
        # include /usr/local/nginx/conf/block.conf;

        # Enables directory listings when index file not found
        # autoindex  on;

        # Shows file listing times as local time
        autoindex_localtime on;
        
        index index.html index.php sitemap.xml $uri/modules/jrCore/router.php;

        try_files  $uri $uri/modules/jrCore/router.php?_uri=$1;
        
        rewrite ^(.*)$ /modules/jrCore/router.php?_uri=$1;

    }

    #location ^(.*)$ {
    #    try_files  $uri /modules/jrCore/router.php?_uri=$query_string;
    #}

    include /usr/local/nginx/conf/staticfiles.conf;
    include /usr/local/nginx/conf/php.conf;
    include /usr/local/nginx/conf/drop.conf;
    #include /usr/local/nginx/conf/errorpage.conf;
    include /usr/local/nginx/conf/vts_server.conf;
}

updated by @jimmy: 12/20/15 05:03:38PM
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
I tried a few more things.

Made some setting changes in the my.cnf
Tried to install JR non-SSL

Both yielded the same results.

If you can think of anything else I can try, please let me know.
Developer Networks
Developer Networks
@developer-networks
9 years ago
566 posts
I am having this same error during a new install. I have jamroom installed on this server already working fine with various domains. However when I added a new domain today and I received this error.


I tried checking permissions, and different versions of Jamroom (5.2) yet nothing helps. I do have the Jamroom 5.3 beta installed on this server also.
help1.jpg
help1.jpg  •  70KB


updated by @developer-networks: 12/21/15 02:06:59PM
Developer Networks
Developer Networks
@developer-networks
9 years ago
566 posts
Here is a screenshot of the database. It appears the installation did not complete.
help2.jpg
help2.jpg  •  440KB


updated by @developer-networks: 12/21/15 02:12:50PM
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
b360:
I am having this same error during a new install. I have jamroom installed on this server already working fine with various domains. However when I added a new domain today and I received this error.


I tried checking permissions, and different versions of Jamroom (5.2) yet nothing helps. I do have the Jamroom 5.3 beta installed on this server also.

What's your system? Apache?
Developer Networks
Developer Networks
@developer-networks
9 years ago
566 posts
The Error Log is:

PHP Fatal error: Call to undefined function jrUser_session_start() in /home/admin/web/dev-networks.com/public_html/modules/jrCore/router.php on line 90


The Debug Log is:

(2015-12-21T21:55:53+00:00.0.92047900 : 0)-(mem: 9699328)-(pid: 15159)-(ip: 12.34.56.78)-(uri: mysite.com/install.php?action=install)
Array
(
    [error] => Query Error: Specified key was too long; max key length is 767 bytes
    [_post] => 
    [query] => CREATE TABLE jr_jrcore_item_key (`_item_id` INT(11) UNSIGNED NOT NULL DEFAULT '0', `key` VARCHAR(128) NOT NULL DEFAULT '', `index` SMALLINT(5) UNSIGNED NOT NULL DEFAULT '0', `value` VARCHAR(512) NOT NULL DEFAULT '', PRIMARY KEY (`key`,`_item_id`,`index`), INDEX `_item_id` (`_item_id`), INDEX `index` (`index`), INDEX `value` (`value`)) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE utf8_unicode_ci
)


updated by @developer-networks: 12/21/15 02:30:48PM
Developer Networks
Developer Networks
@developer-networks
9 years ago
566 posts
My server Information is:

Php Version: 5.5.9 ubuntu 4.9
MySQL 5.6.25

Ubuntu 14.04.2 LTS
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
I can confirm that error. Didn't even think about checking the PHP error log. Good catch!

PHP Fatal error:  Call to undefined function jruser_session_start() in /home/nginx/domains/10.0.0.151/public/modules/jrCore/router.php on line 90

My system specs for the install

PHP 7.0.1 (first test)
PHP 5.6.16 (multiple tests)

Centos 7
MariaDB 10
updated by @jimmy: 12/21/15 02:42:10PM
brian
@brian
9 years ago
10,136 posts
jrUser_session_start() is defined in modules/jrUser/include.php.

What version are you trying to install?


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
brian
@brian
9 years ago
10,136 posts
OK I think this may be the issue:

INDEX `value` (`value`))

Are you trying to install 5.2.41? If so, try the latest 5.3.0b9 - it should work.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
I got a reply back from the CENTMINMOD developer.

Quote:
Centmin Mod out of box /etc/my.cnf templates should of taken care of that in /etc/my.cnf with
Code (Text): innodb_large_prefix=1
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
The version was 5.2.41 on my end. I will try the beta version. I just downloaded what was on the main page of Jamroom for all my test installs.
updated by @jimmy: 12/21/15 03:08:33PM
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
@brian I went to the modules page https://www.jamroom.net/download/modules and both the jrCore versions download a file called jamroom-core-5.2.41.zip. Is that just a naming issue or is the beta core file named differently?
Developer Networks
Developer Networks
@developer-networks
9 years ago
566 posts
I am trying the latest 5.2.41

I will try the beta version now instead.
Developer Networks
Developer Networks
@developer-networks
9 years ago
566 posts
How do I download the Beta Core with out the marketplace installed?
brian
@brian
9 years ago
10,136 posts
I've just uploaded an updated 5.2.41 that SHOULD fix this - try the latest Core download and let me know.

Thanks!


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
Developer Networks
Developer Networks
@developer-networks
9 years ago
566 posts
Thanks so much. I will try now.
brian
@brian
9 years ago
10,136 posts
jimmyk:
@brian I went to the modules page https://www.jamroom.net/download/modules and both the jrCore versions download a file called jamroom-core-5.2.41.zip. Is that just a naming issue or is the beta core file named differently?

This is the latest beta Core download page:

https://www.jamroom.net/the-jamroom-network/networkmarket/271/system-core

But just install 5.2.41, and then go into your Marketplace -> Tools -> Release Channels and ENABLE the beta channel, and then update to 5.3.0.


--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
jimmyk
jimmyk
@jimmy
9 years ago
514 posts
Yup that did it. Install successful! Thanks @b360 for finding the error and @brian for fixing it so quickly. Now I can finish the vhost file and update the Nginx thread here.
Developer Networks
Developer Networks
@developer-networks
9 years ago
566 posts
Thanks for the help. The 5.2.41 now installed successfully.
help3.jpg
help3.jpg  •  366KB

Tags