keat Posted March 1, 2016 Share Posted March 1, 2016 On my V3 site, a large number of products have addirional iamges. When I've upgraded to V6, these additional images do not show. I'm assuming something in the database migration. My v3 is still live, so I still have the data, and I assume its image_idx, (on V3) and possibly image_index (on V6). However, on V3 it shows the image name and on V6 a file_id Any thoughts on how I fix this. Quote Link to comment Share on other sites More sharing options...
Al Brookbanks Posted March 1, 2016 Share Posted March 1, 2016 It's far from straightforward. You are best off doing the upgrade again on a special hosting configuration with the following php.ini values increased as much as possible: max_execution_time = 30 ; Maximum execution time of each script, in seconds max_input_time = 60 ; Maximum amount of time each script may spend parsing request data memory_limit = 128M ; Maximum amount of memory a script may consume (8MB) Unfortunately on upgrade CubeCart attempts to do a lot of work on the images at once and as a result it can time out and error. When that happens commonly your situation arises. When I upgrade a client's store I do it on my Macbook Pro (which has 16GB RAM) with the following resource allocation. max_execution_time = 900 ; Maximum execution time of each script, in seconds max_input_time = 900 ; Maximum amount of time each script may spend parsing request data memory_limit = 4G ; Maximum amount of memory a script may consume (8MB) Quote Link to comment Share on other sites More sharing options...
keat Posted March 1, 2016 Author Share Posted March 1, 2016 in which case maybe i'll try another dummy run later this evening and I'll change those php settings Quote Link to comment Share on other sites More sharing options...
keat Posted March 1, 2016 Author Share Posted March 1, 2016 I performed another upgrade only this time doing so locally, and it appears to have made no difference. It seems the site is not running well locally, I'll have to figure out why. However, the two tables FileManager and images_index, still contain the same number of entries as my original site (all bar a few subtle changes) Certainly not an extra few hundred entries I was hoping to see. I was hoping to go live this weekend, any more pointers ? Quote Link to comment Share on other sites More sharing options...
keat Posted March 1, 2016 Author Share Posted March 1, 2016 This is what I found, taking product_id 2787, we can see that there's an entry in v3 image_idx. We can also see that there is an entry in V6 image_index. however, it has no file_id assigned. Yet look in the filemanager table and it has a file_id assigned. Quote Link to comment Share on other sites More sharing options...
keat Posted March 1, 2016 Author Share Posted March 1, 2016 It looks like I may have circumvented this exporting the tables and manipulating with access and excell. However, I'd still be intigued to know what this fails. 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.