Jump to content

Moving a CubeCart: Notice: `name` is not allowed as a key in 'Cube


Big Spender

Recommended Posts

I have just been moving a CubeCart v5.2.14 from local to live and in doing so I have received the error: -

 

"Notice: `name` is not allowed as a key in 'CubeCart_config' table!"

 

I am now just doing a new install instead and using that - but I will be following the same process soon for another website where I don't have the option of starting fresh.

 

I checked the config file to ensure the database entries were correct.

 

On the live website I was attempting to put this store in a folder on root, on local this was also in a folder on root.

 

There are a number of similar posts on here and the third party forum with no real answer.

Link to comment
Share on other sites

When this message appears, CubeCart is complaining that, for any of a few reasons, when it is wanting to read or write to a database table, there is no table column with that name.

 

If you check using phpMyAdmin or similar utility, of course there is a column with that name.

 

Also, CubeCart is coded to deal with attempting to put data into or read from non-existent columns.

 

But there are circumstances where a missing column is a critical issue to discover why it is happening.

 

Why would CubeCart think there are missing columns? Because the database did not return a list of columns for that table when it was asked. The few reasons why CubeCart will report this is generally caused by the connection to the database being lost.

 

You mention that the store was behaving fine locally. Now that you have put it on someone else's server, effectively in a different environment, the database connection is iffy. Perhaps there is a limit to how many open connections can exist simultaneously. Perhaps some other limit. (All imposed by the server administrator.) Please contact your hosting provider and ask if they have database logs that refer to your hosting account.

 

If you can, tell PHP to display all errors. This may help. We actually need your environment to also have all database errors displayed.

 

There is no relevance as to where CubeCart is installed to why this error appears. This error could also be from a badly written plugin, but that would have been seen locally.

Link to comment
Share on other sites

Just to check - other than the config file edits are there any other changes I need to make?

 

When doing these on other platforms I usually have to update the URL somewhere?

 

Anyway I have recreated this to try and find a fix for the future.

 

This is the PHP log:-

[10-Nov-2014 16:52:55 UTC] PHP Notice:  `name` is not allowed as a key in 'CubeCart_config' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `session_id` is not allowed as a key in 'CubeCart_sessions' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `language` is not allowed as a key in 'CubeCart_lang_strings' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `enabled` is not allowed as a key in 'CubeCart_hooks' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `enabled` is not allowed as a key in 'CubeCart_code_snippet' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Warning:  Last ditch skin in /home/g8f9x9j5/public_html/sitemovetest/classes/gui.class.php on line 1256
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `name` is not allowed as a key in 'CubeCart_config' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `status` is not allowed as a key in 'CubeCart_logo' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `module` is not allowed as a key in 'CubeCart_modules' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `status` is not allowed as a key in 'CubeCart_modules' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `code` is not allowed as a key in 'CubeCart_currency' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `session_id` is not allowed as a key in 'CubeCart_sessions' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `doc_home` is not allowed as a key in 'CubeCart_documents' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `doc_status` is not allowed as a key in 'CubeCart_documents' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `status` is not allowed as a key in 'CubeCart_inventory' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `featured` is not allowed as a key in 'CubeCart_inventory' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `name` is not allowed as a key in 'CubeCart_config' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `active` is not allowed as a key in 'CubeCart_currency' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `cat_parent_id` is not allowed as a key in 'CubeCart_category' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `status` is not allowed as a key in 'CubeCart_category' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `hide` is not allowed as a key in 'CubeCart_category' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `name` is not allowed as a key in 'CubeCart_config' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `doc_parent_id` is not allowed as a key in 'CubeCart_documents' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `doc_status` is not allowed as a key in 'CubeCart_documents' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `navigation_link` is not allowed as a key in 'CubeCart_documents' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `name` is not allowed as a key in 'CubeCart_config' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `status` is not allowed as a key in 'CubeCart_inventory' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `name` is not allowed as a key in 'CubeCart_config' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `time` is not allowed as a key in 'CubeCart_access_log' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:52:55 UTC] PHP Notice:  `session_last` is not allowed as a key in 'CubeCart_sessions' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `name` is not allowed as a key in 'CubeCart_config' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `session_id` is not allowed as a key in 'CubeCart_sessions' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `language` is not allowed as a key in 'CubeCart_lang_strings' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `enabled` is not allowed as a key in 'CubeCart_hooks' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `enabled` is not allowed as a key in 'CubeCart_code_snippet' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Warning:  Last ditch skin in /home/g8f9x9j5/public_html/sitemovetest/classes/gui.class.php on line 1256
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `name` is not allowed as a key in 'CubeCart_config' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `status` is not allowed as a key in 'CubeCart_logo' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `module` is not allowed as a key in 'CubeCart_modules' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `status` is not allowed as a key in 'CubeCart_modules' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `code` is not allowed as a key in 'CubeCart_currency' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `session_id` is not allowed as a key in 'CubeCart_sessions' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `doc_home` is not allowed as a key in 'CubeCart_documents' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `doc_status` is not allowed as a key in 'CubeCart_documents' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `status` is not allowed as a key in 'CubeCart_inventory' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `featured` is not allowed as a key in 'CubeCart_inventory' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `name` is not allowed as a key in 'CubeCart_config' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `active` is not allowed as a key in 'CubeCart_currency' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `cat_parent_id` is not allowed as a key in 'CubeCart_category' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `status` is not allowed as a key in 'CubeCart_category' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `hide` is not allowed as a key in 'CubeCart_category' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `name` is not allowed as a key in 'CubeCart_config' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `doc_parent_id` is not allowed as a key in 'CubeCart_documents' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `doc_status` is not allowed as a key in 'CubeCart_documents' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `navigation_link` is not allowed as a key in 'CubeCart_documents' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `name` is not allowed as a key in 'CubeCart_config' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `status` is not allowed as a key in 'CubeCart_inventory' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `name` is not allowed as a key in 'CubeCart_config' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `time` is not allowed as a key in 'CubeCart_access_log' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
[10-Nov-2014 16:54:56 UTC] PHP Notice:  `session_last` is not allowed as a key in 'CubeCart_sessions' table! in /home/g8f9x9j5/public_html/sitemovetest/classes/db/database.class.php on line 807
As for the database logs, is this something I may have access to myself if I have access to WHM/cPanel?
Link to comment
Share on other sites

If the database server is on a Virtual/Actual Private Server machine, then it is possible that you have access to how the database server behaves by configuring its config file and viewing its log files. If you are on a shared server, then all bets are off.

 

Look at the /includes/config.inc.php file. Does the database 'host' point to an actual place (and this is the correct place), or does it say 'localhost'? (It may have said 'localhost' relative to when this installation was being run locally.)

 

I also have to ask, just to verify, you copied your database from the local machine and restored it to the hosted account? You can see the tables, and the columns in the tables, in the database that is provided to you by your hosting provider using a utility like phpMyAdmin in cPanel?

 

The section of log you provided indicates that CubeCart/PHP is not talking to the correct database, or an incomplete database.

Link to comment
Share on other sites

It is localhost in the config, which it should be for the live hosting too.

If I change it to something else then I get username/password access denied errors, if changed back to localhost or 127.0.0.1 it results in the key error.

The database is an import of the exported database from local, here are the contents of that database table:

Link to comment
Share on other sites

I see 'localhost' as the database host, and 'g8f9x9j5_sitemovetest' as the database name. I also see 'cubecart_config' as the table name.

 

I am going to ask that you give some thought to what kind of operating system your account is being hosted on. Please be aware that with some operating systems. lettercase does not matter, meaning that similarly spelled names (or the database, table, column, filename, whatever) that differ only with uppercase and lowercase letters are treated the same. Most every other operating system is very much lettercase-aware.

 

So, I see you pulled up the table name cubecart_config, yet CubeCart is asking for CubeCart_config. You may need to rename all the tables so that CubeCart has the capitol 'C' letters. Or, if you still have the SQL file you used to restore the database, load it into a programmer's text editor and find all the 'cubecart' sequences and replace them with 'CubeCart' sequences.

 

I can understand how this could have happened. Dumping the database to a SQL file from Windows would most likely have generated all-lowercase names.

Link to comment
Share on other sites

Okay I'll give this a try when I get a second tomorrow evening.
 
Here are the details available from cPanel:
 
cPanel Version 11.42.1 (build 27)
Apache version 2.2.26
PHP version 5.4.32
MySQL version 5.5.40-36.1
Architecture x86_64
Operating system Linux
Perl version 5.8.8
Kernel version 2.6.32-504.el6.x86_64
Link to comment
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.

×
×
  • Create New...