Database error message???

[A-1 Electronics]

I am trying to install Vendorzen on ZC v.1.3.7.

This is the SQL:

# VENDORZEN 1.2 --- compatible with Zen Cart v1.2
# TO INSTALL VENDORZEN, run the following SQL statement in your database.
# You may need to manually insert your "table prefix" in the ALTER TABLE command
# ie: ALTER TABLE zen_products
ALTER TABLE zen_products
ADD vendor1_name VARCHAR( 35 ) NOT NULL ,
ADD vendor1_price VARCHAR( 12 ) NOT NULL ,
ADD vendor1_sku VARCHAR( 25 ) NOT NULL ,
ADD vendor1_url VARCHAR( 25 ) NOT NULL ,
ADD vendor2_name VARCHAR( 35 ) NOT NULL ,
ADD vendor2_price VARCHAR( 12 ) NOT NULL ,
ADD vendor2_sku VARCHAR( 25 ) NOT NULL ,
ADD vendor2_url VARCHAR( 25 ) NOT NULL ,
ADD vendor3_name VARCHAR( 35 ) NOT NULL ,
ADD vendor3_price VARCHAR( 12 ) NOT NULL ,
ADD vendor3_sku VARCHAR( 25 ) NOT NULL ,
ADD vendor3_url VARCHAR( 25 ) NOT NULL ;


This is the error I am getting.

1146 Table 'prymlurg.zen_products' doesn't exist
in:
[ALTER TABLE prymlurg.zen_products ADD vendor1_name VARCHAR( 35 ) NOT NULL , ADD vendor1_price VARCHAR( 12 ) NOT NULL , ADD vendor1_sku VARCHAR( 25 ) NOT NULL , ADD vendor1_url VARCHAR( 25 ) NOT NULL , ADD vendor2_name VARCHAR( 35 ) NOT NULL , ADD vendor2_price VARCHAR( 12 ) NOT NULL , ADD vendor2_sku VARCHAR( 25 ) NOT NULL , ADD vendor2_url VARCHAR( 25 ) NOT NULL , ADD vendor3_name VARCHAR( 35 ) NOT NULL , ADD vendor3_price VARCHAR( 12 ) NOT NULL , ADD vendor3_sku VARCHAR( 25 ) NOT NULL , ADD vendor3_url VARCHAR( 25 ) NOT NULL ;]

[birdoasis]

Did you try updating the mysql within the admin or via phpmyadmin?

[A-1 Electronics]

I could not locate the area in the admin panel to update MySQL. Where would I find that option? And I am not real comfortable working with phpmyadmin from my control panel through my server. However, I did try and apply the patch through phpmyadmin with no luck. I was getting a simular error message. When I look at the structure of the db it shows Server: xx.x.xxx.xx --> Database name: my_db_name.

[A-1 Electronics]

Ok, I think I'm on to something. I opened up phpmyadmin and looked through all the tables. I could not find one called zen_products. I did find one called products and several others labeled products_xxx. I'm assuming that I need to change zen_products to just products correct??

[A-1 Electronics]

Sorry for wasting everyones time. I figured it out.

[Ajeh]

What was the magic?

[A-1 Electronics]

I changed the table name from 'zen_products' in the SQL patch to 'products'.

[Ajeh]

That will get you every time ... to prefix or not to prefix ... that is the question ...

Thanks for the update!