Config File getting wiped out

[HLP]

Having to constantly rebuild config table..  geting same error over and over..

Notice: `name` is not allowed as a key in 'CubeCart_config' table! in /home/xxxREDACTEDXXX/public_html/classes/db/database.class.php on line 858

 

Cannot find any errors...

[bsmither]

Getting the configuration array from the database table CubeCart_config is right there at the top of the list of things CubeCart does when waking up.

So, take a look at the values in the file /includes/global.inc.php and verify the user, pass, database, and host are all correct.

Then, using an external utility, such as phpMyAdmin (a tool found in your hosting account's control panel), examine the contents of the database, specifically the table CubeCart_config.

[HLP]

Thanks for your reply...

In the table Cubecart_config, the actual config entry goes completely blank whenever this happens and all the settings are reset.  I can restore the entry and things work again for a little while, but any changes to the site and the config blanks out again....

[bsmither]

OK, so I understand that there is no problem with the structure of the database. That is, viewing the table CubeCart_config in phpMyAdmin does not trigger a warning saying the table is corrupt and needs repaired.

For CubeCart to complain that a column name is not allowed, such as what you have posted above:
Notice: `name` is not allowed as a key in 'CubeCart_config' table!

tells me that the communications channel that PHP makes with the database is getting lost or the database is simply not responding within a timeout.

See if there is a message to that effect in admin, Error Log, System Error Log tab.

Finally, contact your hosting provider to ask that they monitor your account for database availability problems.

What's weird is that, as you say, you notice that the column `array` becomes empty for the table row where the column `name` is "config".