matchattaxoutlet Posted September 9, 2013 Share Posted September 9, 2013 Just been checking my error log and found the following errors / notices. Anyone shed any light on what these messages are? [09-Sep-2013 11:33:53 UTC] PHP Notice: `time` is not allowed as a key in 'CubeCart_access_log' table! in /home/xxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 11:33:53 UTC] PHP Notice: `session_last` is not allowed as a key in 'CubeCart_sessions' table! in /home/xxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 12:34:24 Europe/London] PHP Notice: `time` is not allowed as a key in 'CubeCart_access_log' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 12:34:24 Europe/London] PHP Notice: `session_last` is not allowed as a key in 'CubeCart_sessions' table! in /home/xxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 11:36:47 UTC] PHP Notice: `enabled` is not allowed as a key in 'CubeCart_hooks' table! in /home/xxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 11:36:47 UTC] PHP Notice: `enabled` is not allowed as a key in 'CubeCart_code_snippet' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 11:36:47 UTC] PHP Notice: `path` is not allowed as a key in 'CubeCart_seo_urls' table! in /home/xxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 11:36:47 UTC] PHP Notice: `time` is not allowed as a key in 'CubeCart_access_log' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 12:07:21 UTC] PHP Notice: `enabled` is not allowed as a key in 'CubeCart_hooks' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 12:07:21 UTC] PHP Notice: `enabled` is not allowed as a key in 'CubeCart_code_snippet' table! in /home/xxxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 12:07:21 UTC] PHP Notice: `name` is not allowed as a key in 'CubeCart_config' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 12:07:21 UTC] PHP Notice: `module` is not allowed as a key in 'CubeCart_modules' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 12:07:21 UTC] PHP Notice: `status` is not allowed as a key in 'CubeCart_modules' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 12:07:21 UTC] PHP Notice: `code` is not allowed as a key in 'CubeCart_currency' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 12:07:21 UTC] PHP Notice: `session_id` is not allowed as a key in 'CubeCart_sessions' table! in /home/xxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `doc_home` is not allowed as a key in 'CubeCart_documents' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `doc_status` is not allowed as a key in 'CubeCart_documents' table! in /home/xxxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `status` is not allowed as a key in 'CubeCart_inventory' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `featured` is not allowed as a key in 'CubeCart_inventory' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `name` is not allowed as a key in 'CubeCart_config' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `active` is not allowed as a key in 'CubeCart_currency' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `type` is not allowed as a key in 'CubeCart_seo_urls' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `item_id` is not allowed as a key in 'CubeCart_seo_urls' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `path` is not allowed as a key in 'CubeCart_seo_urls' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `type` is not allowed as a key in 'CubeCart_seo_urls' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `item_id` is not allowed as a key in 'CubeCart_seo_urls' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `path` is not allowed as a key in 'CubeCart_seo_urls' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `type` is not allowed as a key in 'CubeCart_seo_urls' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `item_id` is not allowed as a key in 'CubeCart_seo_urls' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `path` is not allowed as a key in 'CubeCart_seo_urls' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `type` is not allowed as a key in 'CubeCart_seo_urls' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `item_id` is not allowed as a key in 'CubeCart_seo_urls' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `path` is not allowed as a key in 'CubeCart_seo_urls' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `doc_parent_id` is not allowed as a key in 'CubeCart_documents' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `doc_status` is not allowed as a key in 'CubeCart_documents' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `navigation_link` is not allowed as a key in 'CubeCart_documents' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `name` is not allowed as a key in 'CubeCart_config' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `status` is not allowed as a key in 'CubeCart_inventory' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `time` is not allowed as a key in 'CubeCart_access_log' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:07:21 Europe/London] PHP Notice: `session_last` is not allowed as a key in 'CubeCart_sessions' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 [09-Sep-2013 13:19:42 Europe/London] PHP Notice: No image mode set in /home/xxxxx/public_html/classes/catalogue.class.php on line 845 [09-Sep-2013 12:19:43 UTC] PHP Warning: Security Warning: Illegal array key "amp;PHPSESSID" was detected and was removed. in /home/xxxxx/public_html/classes/sanitize.class.php on line 88 [09-Sep-2013 13:19:43 Europe/London] PHP Notice: No image mode set in /home/xxxxx/public_html/classes/catalogue.class.php on line 845 Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted September 9, 2013 Share Posted September 9, 2013 Someone else will have to help with this, but I checked the seo_urls table on my store, and path IS the Primary key on mine.Is the store working correctly?Do you know what was going on when these errors were made? Quote Link to comment Share on other sites More sharing options...
matchattaxoutlet Posted September 9, 2013 Author Share Posted September 9, 2013 Hi, Thanks for the reply, my store seems to be working fine. Please take a look at www.matchattaxoutlet.co.uk (any feedback would also be useful). I can't really pinpoint anything that was going on with the store or admin at the time, these statements or similar have appeared approx 3 times today. the following line also appeared [09-Sep-2013 08:00:29 Europe/London] PHP Notice: `product_id` is not allowed as a key in 'CubeCart_inventory' table! in /home/xxxxx/public_html/classes/db/database.class.php on line 794 Puzzled!!!!! Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted September 9, 2013 Share Posted September 9, 2013 Please turn on Debug for your IP address and see if that helps you spot what action creates these errors. Quote Link to comment Share on other sites More sharing options...
matchattaxoutlet Posted September 9, 2013 Author Share Posted September 9, 2013 I enabled debugging in my admin but am not seeing any errors. Interestingly, i did a search on google for the messages and it gave me links to another cubecart store see below http://www.gamblesgifts.com/eye-patches/plain-brown-with-leather-stitching.html This shows similar messages in the debugging section!!!! I have just cleared the log (after saving the original) and will try to monitor what triggers the problem. Quote Link to comment Share on other sites More sharing options...
bsmither Posted September 9, 2013 Share Posted September 9, 2013 An error that clams to say that `something` is not an allowed key into a database table, where the key (actually, the table column name) obviously exists, is indicative of a lost connection to the database. Either the connection parameters as stated in /includes/global.inc.php are wrong, or the server that is hosting your CubeCart installation cannot communicate with the server that is hosting the MySQL database. From 11:33 to 12:19 UTC, access to the database was being interfered with, and the error that CubeCart is best programmed to respond is that the name of the column was not found in the response from the database of a list of all column names for that table (security feature). No list was returned, so the column name was not found, so the error gets logged. Maybe your hosting provider was conducting some maintenance on the database server at the times indicated in the error log. Quote Link to comment Share on other sites More sharing options...
matchattaxoutlet Posted September 9, 2013 Author Share Posted September 9, 2013 I shall check with my hosting provider, thanks for the pointers. Quote Link to comment Share on other sites More sharing options...
Dirty Butter Posted September 9, 2013 Share Posted September 9, 2013 A couple of tiny tweaks on your site - "it's" is not correct in your Topps disclaimer in the footer. Your store title would look better centered in the Document blurb about your store. I centered mine in content.homepage.php <center><h1>{$DOCUMENT.title}</h1></center> Quote Link to comment Share on other sites More sharing options...
matchattaxoutlet Posted September 9, 2013 Author Share Posted September 9, 2013 I Had a word with my hosting company and it seems the errors were related to issues with the server load. Thanks for the tweaks Dirty Butter, i was wondering where the setting was to centre the title on my homepage. Can i be a real pain in the derriere and ask for a bit more info on the following message from the same log? PHP Notice: No image mode set in /home/xxxx/public_html/classes/catalogue.class.php on line 84 This seems to occur fairly often too. Quote Link to comment Share on other sites More sharing options...
bsmither Posted September 9, 2013 Share Posted September 9, 2013 Perhaps you meant line 845, not 84. There would need to be some code tracing made to learn what routine is calling Catalogue->imagePath() with a bad 'mode' parameter. Have you made any edits to the config.xml file in the Kurouto skin folder? Quote Link to comment Share on other sites More sharing options...
matchattaxoutlet Posted September 9, 2013 Author Share Posted September 9, 2013 I did mean line 845, copy & paste let me down!!! I have changed the config.xml file, if i recall i did this to remove the thumbnail image from my product details pages. This was the original config.xml section i edited; -<images> <!-- Common --> <image default="noimage_thumbnail.png" quality="75" maximum="138" reference="thumbnail"/> <!-- Category Page --> <image default="" quality="100" maximum="580" reference="category"/> <!-- Doesnt need a default --> <image default="noimage_subcategory.png" quality="70" maximum="70" reference="subcategory"/> <!-- Product Page --> <image default="noimage_gallery.png" quality="60" maximum="50" reference="gallery"/> <image default="noimage_normal.png" quality="90" maximum="270" reference="normal"/> <image default="" quality="90" maximum="600" reference="enlarge"/> <!-- Doesnt need a default --> <!-- Possible names (sizes): thumbnail (138), product(300-ish), enlarged (big), zoom (bigger, poss. source?) --> <!-- These are the ones currently in use --> <image default="noimage_thumbnail_tiny.png" quality="75" maximum="30" reference="tiny"/> <image default="noimage_thumbnail.png" quality="75" maximum="138" reference="small"/> <image default="noimage_normal.png" quality="90" maximum="270" reference="medium"/> <image default="" quality="90" maximum="600" reference="large"/> <!-- Doesnt need a default --> And this is following the changes; -<images> <!-- Common --> <image default="noimage_thumbnail.png" quality="75" maximum="138" reference="thumbnail"/> <!-- Category Page --> <image default="" quality="100" maximum="580" reference="category"/> <!-- Doesnt need a default --> <image default="noimage_subcategory.png" quality="70" maximum="70" reference="subcategory"/> <!-- Product Page --> <image default="noimage_normal.png" quality="90" maximum="270" reference="normal"/> <!-- Possible names (sizes): thumbnail (138), product(300-ish), enlarged (big), zoom (bigger, poss. source?) --> <!-- These are the ones currently in use --> <image default="noimage_thumbnail_tiny.png" quality="75" maximum="30" reference="tiny"/> <image default="noimage_thumbnail.png" quality="75" maximum="138" reference="small"/> <image default="noimage_normal.png" quality="90" maximum="270" reference="medium"/> I assume this is wrong!!! Quote Link to comment Share on other sites More sharing options...
bsmither Posted September 9, 2013 Share Posted September 9, 2013 The edits made are only wrong if they cause errors. There is no penalty for keeping the config.xml file as it was. "If I recall, I did this to remove the thumbnail image from my product details pages." We should then edit the skin template file. Quote Link to comment Share on other sites More sharing options...
matchattaxoutlet Posted September 10, 2013 Author Share Posted September 10, 2013 I just restored the original and the images didn't reappear, so maybe i already edited the template file. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.