Create table for perfix

[XiaoChin]

In Mysql don't have perfix, How can I create this table (zen_prefix) ?
Please help me.

[schoolboy]

You may not need a prefix.

You need a prefix ONLY if you want to use the database for other software.

If you have access to ONE database ONLY, and you want:

1. Zencart
2. Joomla (or other application)

Then you make the tables for zencart prefix zen_

... and the tables for joomla prefix joom_

But if your database is for Zencart ONLY, you do not need prefix.

[XiaoChin]

HI, Thanks for your reply.


But I still have a problem is when register a member, it didn't show welcome message, just show ...

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 '' at line 3
in:
[insert into zen_customers_basket (customers_basket_id, customers_id, products_id, customers_basket_quantity, customers_basket_date_added) values ('','4', ###, '1', '20100317')]


I just using Zencart.

[DrByte]

The query you posted is not compatible with MySQL 5.
Zen Cart v1.3.8a does NOT generate that query.

Therefore you must be using an older version of Zen Cart on a version of MySQL which is not compatible.

You have two options:
a) upgrade to newer version of Zen Cart
b) downgrade your MySQL to v4.x