Quote Originally Posted by dealbyethan.com View Post
Hi,

I ran your sql code but received the following error. What went wrong? Please advise. Thanks.

1146 Table 'dealbyet_zc2.configuration_group' doesn't exist
in:
[SELECT @configuration_group_id:=configuration_group_id FROM configuration_group WHERE configuration_group_title= 'Google Froogle Configuration' LIMIT 1;]
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.
Note your TABLE Names have a prefix:

dealbyet_zc2.configuration_group'

Prefix is:

dealbyet_zc2

You can edit the SQL to append your prefix (wherever a TABLE name is observed).

But if you copy the existing SQL from a text editor and then paste into Tools >Install SQL patches it should work, without first editing SQL. But do NOT upload. (Install SQL Patches is suppose to auto append you DB table prefix but some issues with different server configurations).

Much previous discussion about this common issue in this thread (and same discussion in Google Sitemap and User Tracking support threads in this forum).

Good luck,
Woody