Debug log please help

[RodG]

The install script (the one giving the errors) is telling us that your DB tables have a prefix "zen_"
The uninstall script has no such prefix which means it isn't uninstalling what it needs to.
The zencart sqlpatch code normally takes care of this (I think) but if you are running it via phpmyadmin (or similar) you'll need to edit the uninstall script by adding the prefix.
Not difficult. Where the script reads
FROM xxxxxxxx
Change them to read
FROM zen_xxxxxxx
There are five lines that you'll need to change.
The 500 error is another story. Although it can be caused by many things one of the most common causes is folder or file permission. Only your host will be able to tell you the exact cause.

[Dashizna]

The install script (the one giving the errors) is telling us that your DB tables have a prefix "zen_"
The uninstall script has no such prefix which means it isn't uninstalling what it needs to.
The zencart sqlpatch code normally takes care of this (I think) but if you are running it via phpmyadmin (or similar) you'll need to edit the uninstall script by adding the prefix.
Not difficult. Where the script reads
FROM xxxxxxxx
Change them to read
FROM zen_xxxxxxx
There are five lines that you'll need to change.
The 500 error is another story. Although it can be caused by many things one of the most common causes is folder or file permission. Only your host will be able to tell you the exact cause.

do you mean like this ?

SET @configuration_group_id=0;
SELECT @configuration_group_id:=configuration_group_id
FROM configuration_group
WHERE configuration_group_title= 'Google Merchant Center Feeder Configuration'
LIMIT 1;
DELETE FROM zen_ configuration WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;
DELETE FROM zen_ configuration_group WHERE configuration_group_id = @configuration_group_id AND configuration_group_id != 0;

#Zen Cart v1.5.0+ only Below! Skip if using an older version!
DELETE FROM zen_ admin_pages WHERE page_key = 'configGoogleMerchantFeed' LIMIT 1;
DELETE FROM zen_ admin_pages WHERE page_key = 'toolsGoogleMerchantFeed' LIMIT 1;

[Dashizna]

when I run the install SQL in myphpadmin it gives me this error. I think this is why im getting a http500 error in the zen admin

Error

SQL query:

#Google Merchant Center FEEDER
#
ALTER TABLE products_options_values MODIFY products_options_values_name varchar( 150 ) ;



MySQL said: Documentation
#1146 - Table '*********.products_options_values' doesn't exist

[RodG]

when I run the install SQL in myphpadmin it gives me this error. I think this is why im getting a http500 error in the zen admin

Error

SQL query:

#Google Merchant Center FEEDER
#
ALTER TABLE products_options_values MODIFY products_options_values_name varchar( 150 ) ;



MySQL said: Documentation
#1146 - Table '*********.products_options_values' doesn't exist

This is similar to the uninstall problem. The table name is missing the zen_ prefix.
The http 500 error is still another matter that is unrelated to the SQL issues.

[RodG]

[QUOTE=Dashizna;1225605]do you mean like this ? [/QUOTE ]

Yes, exactly like that, but you have missed one (line #3)