Froogle Merchant Center merged into GoogleBase

[Woodymon]

Woody,

Thanks for the offer to help. I had not tried from phpmyadmin, but just did and got a different error. This is the script I ran: {snipped}

and the error I got:

SQL query:
SELECT @configuration_group_id := configuration_group_id
FROM configuration_group
WHERE configuration_group_title = 'Google Froogle Configuration'
LIMIT 1 ;

MySQL said:
#1146 - Table 'dog_zc1.configuration_group' doesn't exist

So this last error report came from phpmyadmin?

I just have basic SQL knowledge but I suspect a db table prefix issue. However usually you will see an error like that from within Zen Cart's built-in SQL Executor (which will attempt to add the prefix your shop database is set up with), but not from phpmyadmin.

In phpmyadmin when you select your database do all the tables listed in the left column show a prefix of "dog_zc1." ? That is do you observe a table named "configuration_group" or is it named "dog_zc1.configuration_group"?

If the table is named "configuration_group" (without a prefix) then you should be able to run the SQL in phpmyadmin without that error. If you have a prefix on each table then you will need to either edit the SQL, or patch your database from within Zen Cart "Tools > Install SQL Patches" (do not upload, just paste in and the proper prefix should be auto applied).

Woody