keat Posted November 18, 2016 Share Posted November 18, 2016 This morning I've exported the Order_Summary table to send to the boss and found that it's huge and I can no longer open it. After a bit of digging, it seems that the column 'Basket' was NULL right up until the day I upgrdaed to V6, however, now the column 'Basket' has basket contents. On V3 this information was always in Order_Inventory. Should these now actually be in the summary table ? Quote Link to comment Share on other sites More sharing options...
ayz1 Posted November 18, 2016 Share Posted November 18, 2016 Yep, mine is the same. You can try reducing the number of rows you export each time. That worked for me. Quote Link to comment Share on other sites More sharing options...
Noodleman Posted November 18, 2016 Share Posted November 18, 2016 The basket field holds an array (it's a PHP thing)... this allows the basket to be read again in the future by other processes. When you export your table, just exclude this column, I assume you are exporting via PHPMyAdmin. Quote Link to comment Share on other sites More sharing options...
keat Posted November 18, 2016 Author Share Posted November 18, 2016 I am exporting via PHP admin. I never thought to exclude that column, in fact, I didn't even know it was possible if i'm being honest. What I did do, was create a copy of the table, then run an sql query on the copy. Maybe the long way around, but the original table is still intact. UPDATE `cart_v6`.`CubeCart_order_summary-copy` SET `basket` = NULL WHERE `CubeCart_order_summary-copy`.`id` >1; Quote Link to comment Share on other sites More sharing options...
ayz1 Posted November 18, 2016 Share Posted November 18, 2016 2 minutes ago, keat said: I never thought to exclude that column, in fact, I didn't even know it was possible if i'm being honest. Me neither but I do now Quote Link to comment Share on other sites More sharing options...
Noodleman Posted November 18, 2016 Share Posted November 18, 2016 why are you duplicating it first? Just extract the data from the live table. try this. Simply add the columns you want to the list of fields. Then, when you run the query in phpmyadmin, "export results". SELECT id, cart_order_id -- more columns here, (Do not forget to add a comma after each apart from the very last field FROM CubeCart_order_summary ORDER BY id Quote Link to comment Share on other sites More sharing options...
keat Posted November 18, 2016 Author Share Posted November 18, 2016 To be honest, I always duplicate as I prefer not to start meddling with a live table. It's easy enough to do in PHPAdmin, and takes only a few seconds. 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.