Table Prefix question

[High Octane]

I'm attempting to use DealGates PHP file downloaded from this site, however I have run into a problem, When I surf to the file "dealgates_pipeline.php" I get this error

": SQL error Table 'MyDatabase_zc1.categories' doesn't exist| catInfo = SELECT categories.categories_id AS curCatID, categories.parent_id AS parentCatID, categories_description.categories_name AS catName FROM categories, categories_description WHERE categories.categories_id = categories_description.categories_id:"

now in the PHP file it calls the database which is " wagnert_zc1" but then it looks for a table " categories" but its looking for the prefix of _zc1, when it actually have the prefix of "zen_".

So how do I tell it to look for/or use the correct prefix to load the program??

Here is a bit of the code:
$home = "locohost" ;
$user="MyUserName_zc1";
$pass="XxXxXxXxXx";
$base="MyDatabase_zc1";

Then there is the actual call for the catorories table:
if (!($link=mysql_connect($home,$user,$pass)))
{
echo "Error when connecting itself to the data base";
exit();
}
if (!mysql_select_db( $base , $link ))
{
echo "Error the data base does not exist";
exit();
}

Any SQL/PHP experts out there that can help?

[kobra]

Module originally written for oscommerce, adapted for Zen Cart.
Module does NOT support sites with table-prefixes. If you use them, you'll have to modify the code to use your table-prefixes properly.

Did you read the prefix caveat?
Just downloaded it but have to look at it.

[High Octane]

BUSTED!

No I didn't read that, but I'm hoping there is a way around it.
I would think you could call a database and tell it to use a prefix other than the databases.
Second option: Removing all my prefixes on my tables. how involved would that be without loosing everything?
I noticed that some of my tables don't have the zen_ prefix.

[kobra]

I noticed that some of my tables don't have the zen_ prefix.

This sounds problematic!!

I do not use prefixes so you need to check your records inside the tables to see if they are also prefixed.

In the dealgates.php file find the sql and this is part of it and I am only altering the table(first part) and not the record designation.
How it is:

$sql = "
SELECT concat( '" . $productURL . "' ,products.products_id) AS product_url,
products_model AS prodModel, products_weight,
manufacturers.manufacturers_name AS mfgName,

Change all to:

$sql = "
SELECT concat( '" . $productURL . "' ,zen_products.products_id) AS product_url,
products_model AS prodModel, products_weight,
zen_manufacturers.manufacturers_name AS mfgName,

And so forth for all table references and record references if you find that they also have been prefixed

And/or square away your ZC DB and remove the prefixes.

[High Octane]

Thank You Very much!

I'll start editing. and check into those non prefixed tables.
Its probably all the updates and some failed mods. Definitely need to be cleaned out or repaired.

[High Octane]

How difficult is it to remove the Table Prefixes?
I do have access to MYSQL, but not sure how to go about renaming my tables.
and I guess that on line 73 in the configure.php file
" define('DB_PREFIX', 'zen_');" should be changes to
" define('DB_PREFIX', '');
Is there any other files to change?