Jump to content

TDLWebs

Member
  • Content Count

    58
  • Joined

  • Last visited

Community Reputation

0 Neutral

Profile Information

  • Gender
    Male
  • Location
    Wirral, UK

Recent Profile Visitors

5,645 profile views
  1. That's very helpful, thanks. I am aware of the separate function to clear the image cache but still get time outs. I guess this is because of the huge number of images. Perhaps I should increase the max_execution_time ??? I have contacted my hosting provider regarding https://support.cubecart.com/hc/en-gb/articles/360003831737-How-do-I-enable-APC-Memcached-Redis-or-xCache- so they can advise the best setup. Is there an .htaccess in the image cache folder too? If so, I think if I was using SSH then I should enter something like $ rm -v !(".htaccess")
  2. This might be a silly question, but I thought I would ask before doing any damage Anyway... My client has a site which has thousands of products, all with associated images. Clearing the cache in admin can often take a long time and very often will time out before it has finished. My question is: Will it do any harm if I log into the server with SSH and manually delete everything in the 'cache' folder? Or is there anything in there that needs to be kept? It seems to me that this would be a lot quicker.
  3. Yes, that's it. My stupid error. I was concerned at losing the latest product details which had been added since and tried to be clever but failed miserably. Thanks again for your expert advice bsmither!
  4. Further investigation of the table shows: #1062 - Duplicate entry '17942' for key 'PRIMARY'
  5. After my issues with missing images I had to restore the CubeCart_filemanager table in the database by merging two backup files. However, this has created duplicate entries with the result that there is no primary key etc. Images can no longer be allocated to products in admin. I have located the duplicates using the query: SELECT filename, COUNT(filename) FROM CubeCart_filemanager GROUP BY filename HAVING COUNT(filename) > 1; But some images are used twice; once by a product and once by a category - as seen when I search for a particular image filename which is duplicated (see db-image1.jpg below) They also have identical md5hash entries. The phpmyadmin screenshot taken from a healthy CubeCart_filemanager table should have the structure seen in db-image2.jpg below: Any idea how can I remove the unnecessary duplicates and restore the integrity of the CubeCart_filemanager table????
  6. Fantastic! That appears to have fixed it Thank you VERY MUCH!!!!!
  7. Ok, done that. The only file_id number shown in the result was 15725 . When I tried to find 15725 in Cubecart_filemanager there was nothing:
  8. Ok, thanks. Here is what I found for one of the listings: And this for a newly added product with the image showing up ok: They look the same to me, but maybe I'm looking at the wrong thing????
  9. I have cleared the cache and reloaded admin so believe that the latest version of Javascript is being used. The absence of the scrollbar is due to the Mac OS - it appears when I start to scroll. CubeCart_filemanager in the database shows 14256 rows I'm not sure that I'm looking at the right thing in Chrome developer tools: The code is from the view product template and the skin is Galaxy X
  10. cubecart_image_index = 12387 rows Yes, most of the records have a non-zero value although there are some zeros
  11. When I inspect the source code it says (unknown) in the img src ????
  12. No, it's clear now. I read the thread on Github but no clues there either. I'm totally flummoxed.
  13. Yes, they all appear to be there on the server. But for some reason, don't seem to be associated with the categories or products any more.
  14. No, unfortunately not. Nothing I've tried works. I really need an expert to take a look behind the scenes to confirm whether it can be recovered or not. Any offers?
×
×
  • Create New...