After I installed 1x Membership Fee..

Hi, Everyone!

After I installed 1x Membership Fee.

When customer registered, Going to..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 ('','6', ###, '1', '20100319')]

Could somebody tell me what is the problems? Thank you very much.:smile:

your tables have prefix ? this sql statement tries to alter table called zen_customers_basket .. however , your table might not have the zen_prefix or might be different ..

Hi, Thank you for your reply.

Yes, you are right, I searched this table from Msql, don't have this.

How can I create this table? Thank you.

:smile: please help.

Instead of manually adding a prefix to your tables, you can edit both your configure.php files to not use the prefix 'zen_' when accessing your current tables.

Just look for the following line in both your configure.php files:

define('DB_PREFIX', 'zen_');
```and change it to:

```php
define('DB_PREFIX', '');