Order Sumary Basket no NULL

[keat]

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 ?

[ayz1]

Yep, mine is the same. You can try reducing the number of rows you export each time. That worked for me.

[Noodleman]

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.

 

 

[keat]

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;

 

[ayz1]

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

 

[Noodleman]

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

 

[keat]

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.