Getting error when installing Auction Product Type plugin

[lnsenterprises]

Unzipped the files etc. Copied the auctions sql file thru notepad to the "install sql patches" portion under tools. When I run this script I get the following error....
WARNING: An Error occurred, please refresh the page and try again...

This is the first step so I have not gone any further...I am using version 1.51..

[DrByte]

I just pasted your error message into the FAQs search box and it brought up this article which addresses your question:
http://www.zen-cart.com/content.php?...-and-try-again

[lnsenterprises]

I have run the sql file from the ZEN-Auctions, direct through phpadmin...When I run the script thru the appropriate dbase, it gives me this error...

Error

SQL query: Documentation

SELECT @t3 := type_id
FROM product_types
WHERE type_name = 'Product - Auction'
LIMIT 1 ;

MySQL said: Documentation
#1146 - Table 'linger89_zenc795.product_types' doesn't exist

I understand the table not existing, so do I need to create this table first? This would be in direct contrast to the install directions would it not be?

Tanx so much

[lnsenterprises]

UPDATE

I do have the following tables within this dbase

products_auctions
product_auction_extra

as well as

zen_products_auctions
zen_product_auction_extra

When I run the uninstall sql, it does remove the

zen_products_auctions
zen_product_auction_extra

[DrByte]

Evidently your store is configured to use a "prefix" of "zen_" on all tablenames.

Install scripts for mods only know about official Zen Cart tablenames, without prefixes.

So, you have two options:
a) If you're going to use phpMyAdmin to run the SQL script, then you must manually insert your "zen_" prefix in front of EVERY tablename in your SQL scripts before running them there.

or
b) Use the Admin->Tools->Install SQL Patch tool in your Zen Cart admin to run the SQL, since it will automatically insert the prefix ... as long as the SQL is written in the correct format that Zen Cart can process and correctly identify the tablenames.

[lnsenterprises]

and hence back to my original issue....can I change the sql file to reflect the zen_ and if so where?

When i run the sql script, I show this....yet same error.

[DrByte]

To run it via phpMyAdmin, the line saying "FROM product_types" would need to have the prefix added to the tablename, thus making it be "FROM zen_product_types".

[lnsenterprises]

I would prefer to run it though tools section of my site...

TRY 1:
I have added the zen_ to all instances "FROM product_types"....auctions.sql file
Ran the sql file from tools.....install sql patches section of my website...the same error message appears
checked phpmyadmin and added the zen_ to the following 2 tables running the sql created....zen_products_auctions and zen_product_auction_extra
Still have the error msg....

Will try another couple of ways when I have more time etc....for now still using webid and works great