sql error

[BeerCan]

Hi
I just installed the new zencart at www.nitrousoxidechargers.com and imported users from and older osc cart. Now on login I get the following error:

1054 Unknown column 'products_options_value_text' in 'field list'
in:
[select products_options_id, products_options_value_id, products_options_value_text from customers_basket_attributes where customers_id = '2' and products_id = '5' order by LPAD(products_options_sort_order,11,"0")]


Can someone point me in the right direction on how to fix this?

Thanks

[DrByte]

When you imported your data, you didn't update the table-structure for the customers_basket_attributes table.

Check to be sure your Zen Cart tables have all the normal Zen Cart fields/columns in them. You can review this info by editing the zc_install/mysql_zencart.sql file in a text editor, or you can install Zen Cart into another folder+database for comparison.


NOTE: When importing data, you need to make sure you keep all the same destination structure, rather than just copy the old software's data to the new.

[TheOracle]

Make a backup of your customers_basket_attributes table from your phpmyadmin.

Then, in your Zen Cart's admin section - > tools - > SQL Patches.

Execute the following SQL statement:

ALTER TABLE customers_basket_attributes
ADD products_options_value_text BLOB NULL default NULL

This should restore your missing field.

[BeerCan]

Thank you very much. That solved my error.