Jump to content


  • Content Count

  • Joined

  • Last visited

Community Reputation

0 Neutral

Profile Information

  • Gender
  • Location
    Preston, UK

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. All the early entries (pre-March of this year, probably pre v6.1.14) have nothing (zls) in the column, Post that, they're all "NULL". I ran the query (with my prefix), the whole column had "NULL" in it. I then deleted the custom_oid index and recreated it with a UNIQUE key. Which worked. Hurrah - the database shows no errors/warnings now! Thank you so much for your help in resolving this. You've been very patient and helpful.
  2. These are the only indices listed for that table. I also tried to delete the custom_oid index (which worked) and then recreate it as Unique (which didn't work)
  3. I'm not sure if I've found something else that may or may not contribute to the issue. The image file manager is reporting the wrong values for filesizes. I updated all the images to make them smaller, but the file manager is still listing the old sizes, not the ones that my FTP client reports (which are the same as my cPanel filemanager.) Could this have contributed to the warnings in the error log (and do you know how to fix it)?
  4. As far as I can see, there are 51 entires in the CubeCart_order_summary table. There is only the custom_oid index and no entries with a numeric suffix. All names are listed on one page, with no option to scroll to another page.
  5. I deleted the custom_oid_2 originally (and 3 and 4), but it's not listed in the table at all now, so I don't know how to delete it!
  6. The admin_users table is now fine. Thank you. I deleted the cart_order_id_x indices and that worked fine. When I try and change the custom_oid index, I get this error #1062 - Duplicate entry 'NULL' for key 'custom_oid_2' The picture below shows that the index is already set at NULL (I think)
  7. Thanks. I’ll try in the morning. Any thoughts on why there are duplicate indices? I’m a little concerned my database isn’t in tip top condition.
  8. I've noticed a few errors in the Maintenance > Database tab. The errors are CubeCart_admin_users.admin_id has a key type KEY but expecting PRIMARY. This is listed in phpMyAdmin as both Primary and Index (Key). Should this just be Primary? CubeCart_order_summary.cart_order_id has a key type KEY but expecting UNIQUE KEY. When I try and change the index from key to unique, I get these warnings The indexes cart_order_id_2 and cart_order_id seem to be equal and one of them could possibly be removed. The indexes cart_order_id_2 and cart_order_id_4 seem to be equal and one of them could possibly be removed. The indexes cart_order_id_2 and cart_order_id_3 seem to be equal and one of them could possibly be removed. CubeCart_order_summary.custom_oid has a key type KEY but expecting UNIQUE KEY. When I try and change this, I get an error "#1062 - Duplicate entry "NULL" for key custom_old". I googled the error, but I'm none the wiser! The three below I fixed in phpMyAdmin CubeCart_reviews.approved has no key set. Expecting KEY. CubeCart_seo_urls.type has no key set. Expecting KEY. CubeCart_seo_urls.item_id has no key set. Expecting KEY.
  9. I've deleted all of the content and just left a couple of lines. I've not used that since July, so not sure how it's been corrupted. Do you know how it could have happened? The only thing I can think of is that I use Grammarly and they have recently altered their mode of operation within Safari and there was definitely a reference to them in the source code - bit of a long shot though But, the great news is that the settings now work OK. I can save both the new skin as a default and the social media links. Sorry if I shouldn't have posted the contents of the table - I assume if you could decode it that there was "sensitive" data in there? Thanks for your help - I've been at work (trying to make some products to put on the site!) I've still got a database problem though - I'll start a new thread for that, though.
  10. In the table the row with name "config" .(as per attached) has a large amount of text in the array. Here is the text in the array, when I use phpMyAdmin Thanks for confirming about the image sizes, but I needed to fix them anyway (and I've now got peace of mind that one problem has gone)
  11. I can't find any store setting that is big. I've only got a couple of sentences in the Search Engines and it's not been changed recently. Nor the Offline and Copyright tabs, both are very small. Is the config info written to the dB? Can I erase it and start again to see if it errors straight away? I looked in phpMyAdmin and in the Cubecart_Config table, the Config variable has masses of text in it. Other variables are small by comparison. Not sure if this is relevant. The config.xml for the foundation skin doesn't have the image reference line. I created my own skin (a copy of foundation with some colours changed, that's all) and that doesn't have the line either. The site is currently using foundation, but the site settings problem is preventing me from changing the skin anyway. I'll fix the folder names over the next day or so, but they've been like that for a year or more. I've just resized all my images (gulp!) to be 350Kb, 800px, but that doesn't seem to have fixed it either. Thanks for your continued help
  12. Error log is now more populated. See attached error_log
  13. I created the file and the error log was created contents are [10-Sep-2019 23:15:54 Europe/London] PHP Notice: No image mode set in /home/sites/olivewoodturning.co.uk/public_html/classes/catalogue.class.php on line 1487
  14. Thanks for the help. The only change recently has been to update the version of PHP to 7.2, but I doubt that's caused it. I'll ask my hosting provider. Do you have any idea why the tables may have lost their indices?
  • Create New...