Jump to content
Sign in to follow this  
yangxuan

report 500 error,`session_id` is not allowed as a key in 'CubeCart_sessions' table!

Recommended Posts

[20-Feb-2019 01:03:49 UTC] PHP Notice:  `session_id` is not allowed as a key in 'CubeCart_sessions' table! in /home/pcsensor/public_html/classes/db/database.class.php on line 914
[20-Feb-2019 01:04:22 UTC] PHP Notice:  `session_id` is not allowed as a key in 'CubeCart_sessions' table! in /home/pcsensor/public_html/classes/db/database.class.php on line 914
[20-Feb-2019 01:04:55 UTC] PHP Notice:  `session_id` is not allowed as a key in 'CubeCart_sessions' table! in /home/pcsensor/public_html/classes/db/database.class.php on line 914

Share this post


Link to post
Share on other sites

If your database server is overloaded, it may "disappear". If the database server disappears, this is CubeCart's response: tell PHP to log an error.

This error describes CubeCart's wanting to get a list of all the columns of a table from the database server. If the subject column(s) is not in the list, or no list is returned, CubeCart will not allow a query to use that column name and has PHP log a notice. Unfortunately, to CubeCart, a database server that has gone away is the same as no list having been returned.

 

Share this post


Link to post
Share on other sites

Thanks for the response.how can i fix this problem,

1 hour ago, bsmither said:

If your database server is overloaded, it may "disappear". If the database server disappears, this is CubeCart's response: tell PHP to log an error.

This error describes CubeCart's wanting to get a list of all the columns of a table from the database server. If the subject column(s) is not in the list, or no list is returned, CubeCart will not allow a query to use that column name and has PHP log a notice. Unfortunately, to CubeCart, a database server that has gone away is the same as no list having been returned.

 

 

Share this post


Link to post
Share on other sites

Your hosting provider can help.

If this is a local development environment, and you have absolute control of everything, then there are a couple of settings for the databse server you should look at.

An internet search for MySQL server has gone away will discuss those settings.

Share this post


Link to post
Share on other sites
6 hours ago, yangxuan said:

Thanks for the response.how can i fix this problem,

A lack of server resources is the cause, so if you have external hosting then use a better hosting company - very cheap hosting is that way for a reason with massively overloaded servers

Share this post


Link to post
Share on other sites

Have to agree with Havenswift here. I had a similar problem and changed to a recommended hosting company (yes it was Havenswift) and not had the problem again. Its the old adage you pay for what yo get.

  • Thanks 1

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Sign in to follow this  

×
×
  • Create New...