Big problem! How do I solve it?!

[pcny2la]

I've just started installing ZenCart however after the installation begins I get:

1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'd dault NULL, products_options_sort_order text NOT NULL, PRIMAR
in:
[CREATE TABLE zen_customers_basket_attributes ( customers_basket_attributes_id int(11) NOT NULL auto_increment, customers_id int(11) NOT NULL default '0', products_id tinytext NOT NULL, products_options_id varchar(64) NOT NULL default '0', products_options_value_id int(11) NOT NULL default '0', products_options_value_text BLOB NULL d dault NULL, products_options_sort_order text NOT NULL, PRIMARY KEY (customers_basket_attributes_id), KEY idx_cust_id_prod_id_zen (customers_id,products_id(36)) ) TYPE=MyISAM;]

And on the frontpage of the site I get the following:

1146 Table 'merchsto_merchsto.zen_product_type_layout' doesn't exist
in:
[select configuration_key as cfgkey, configuration_value as cfgvalue from zen_product_type_layout]

What do I do?!

Many thanks if advance for your help.

[Merlinpa1969]

What version og mysql are you using

[pcny2la]

I'm using 4.0.27-standard

[Vger]

It looks like you have a duff install sql file. This is what should be in that file for that table:

products_options_value_text BLOB NULL default NULL,

the error is showing it as:

products_options_value_text BLOB NULL d dault NULL,

If you are using Smart or Cute FTP to upload your files I'd recommend using a decent FTP programme like FileZilla or WS FTP Home or Pro.

Vger

[pcny2la]

I'm completely new to this; how do I resolve the query? Is there a file I can manually edit?

[Vger]

I would recommend uploading the full file set again making sure to use a decent ftp programme.

Vger

[pcny2la]

Many thanks, that seems to have sorted the problem.