Jump to content

Nelly111s

Member
  • Content Count

    42
  • Joined

  • Last visited

Everything posted by Nelly111s

  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?
  15. I've tried clearing the caches, leaving the site for a day and trying again. The social media sites in Store settings > general aren't storing. When I click "Save", I get the usual message to say that the settings have been updated, but actually, they haven't. There is no text in the boxes (eg Facebook) that I filled in and after clearing the cache, if I open my homepage, there's only the original Instagram link there, not any new ones. Has anyone got any thoughts on how I can diagnose the problem? I've noticed a few errors in the Maintenance > Database tab. These may or may not be related to the problem The errors are CubeCart_admin_users.admin_id has a key type KEY but expecting PRIMARY. CubeCart_inventory.popularity has no key set. Expecting KEY. CubeCart_order_summary.cart_order_id has a key type KEY but expecting UNIQUE KEY. CubeCart_order_summary.custom_oid has a key type KEY but expecting UNIQUE KEY. 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.
  16. I've been doing a few updates of my site, which included a new template and links to the social media sites I have. I've managed to update the template and css and everything on that side seems to work OK. However, when I try to load the old template or even the default foundation one, neither of them now work - when I click save, it reloads the page but with the new template selected. I'm having the same problem with the social media sites. I put in the Instagram one and that worked. Now if I try any of the others, it won't save the text I put in. Very strange!
  17. Many Thanks. I had customised a couple of the templates, so I made copies of the edits first. Now all sorted.
  18. Hi, somehow, I've screwed up. I can't access the payment received template and the screenshot below would appear to be the cause or symptom of this. I've just re-loaded V6.2.6, but that's not changed anything. Anyone know how to fix it?
  19. Hi, I've been using my store for a while to sell physical products, but I want to give people the option to download some free digital resources. I've uploaded the file to the correct place and everything seems to be OK. When I use a dummy account to place an order, the email template that goes out to the customer is the product one, rather than the one with a link to the digital file. If I go into the order in the admin section of the website, the download link is showing OK, so it's processed the right product, just not given the user the option of downloading it. Any thoughts on where I may be going wrong? I'm using v6.2.5
  20. It does seem to work. If I order two or three, the postage is still zero. If I add a single item that needs a shipping cost, only that cost is shown. I’m not sure why it wouldn’t rhough. The weight of the item is always zero and the packaging weight is a one off in the shipping module, no matter how many items are shipped.
  21. Figured it out! I had a packaging weight of 0.5Kg and this automatically put everything into the next weight up. I created a weight of 0.55 with a cost of zero, which should fix it.
  22. I've tried the zero weight option, but I must be doing something wrong. The string from the shipping module is 0:0.0,0.2:0.10,0.75:3.50, but it keeps coming up with £3.50 as if it weighed >0.75Kg. Have I got the syntax wrong? I've tried the zero weight option, but I must be doing something wrong. The string from the shipping module is 0:0.0,0.2:0.10,0.75:3.50, but it keeps coming up with £3.50 as if it weighed >0.75Kg. Have I got the syntax wrong?
  23. Hi, I have a Cubecart V6.2.x site running very happily, but I now want to offer a single product where the price includes shipping (i.e. free shipping to the customer). All my other products use weight-based shipping with the normal "By weight" shipping module. If the customer orders just this item, then the shipping cost should be zero. If they order other products, then those should attract the shipping costs that they currently do. I've looked around the forum and can't find anything that answers my question. Does one of the other modules (tried the All-in-One, couldn't see it working) have this facility? Thanks Neil
  24. (How) Can I create a product that is an assembly of other products? I would like to be able to do a "multi-buy" where you can select one product and it automatically populates this with individual stock items, thus decrementing the stock level for each item. I hope this makes sense, not sure what to call it! Neil
×
×
  • Create New...