i have tons of debug logs

lat9:

If you are going to keep your database as a latin1 collation, you'll need to change your /includes/configure.php and /YOUR_ADMIN/includes/configure.php files'

define('DB_CHARSET', 'latin1');

> and your /includes/languages/YOUR_TEMPLATE/english.php and /YOUR_ADMIN/includes/languages/english.php files'
> ```
// charset for web pages and emails
  define('CHARSET', 'iso-8859-1');

The first two of your "new" errors imply that you've somehow removed the file /includes/languages/english.php (the default english-language phrase file).

ok so do i need to add that line to the config files becuase that is nowhere in those files?? also should i change it over or leave it latin1 it doesn't matter to me i just want to be free of all these errors

Thanks

i added that line to both config files and now im getting this

[14-Oct-2012 16:44:59] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset latin1' not supported, assuming iso-8859-1 in /home2/pwcforum/public_html/AandD-6955778-309/includes/functions/general.php on line 39 [14-Oct-2012 16:44:59] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset latin1' not supported, assuming iso-8859-1 in /home2/pwcforum/public_html/AandD-6955778-309/includes/functions/general.php on line 39
[14-Oct-2012 16:44:59] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset latin1' not supported, assuming iso-8859-1 in /home2/pwcforum/public_html/AandD-6955778-309/includes/functions/general.php on line 39 [14-Oct-2012 16:44:59] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset latin1' not supported, assuming iso-8859-1 in /home2/pwcforum/public_html/AandD-6955778-309/includes/functions/general.php on line 39
[14-Oct-2012 16:44:59] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset `latin1' not supported, assuming iso-8859-1 in /home2/pwcforum/public_html/AandD-6955778-309/includes/functions/general.php on line 39

[14-Oct-2012 16:44:53] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset latin1' not supported, assuming iso-8859-1 in /home2/pwcforum/public_html/AandD-6955778-309/includes/functions/general.php on line 39 [14-Oct-2012 16:44:53] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset latin1' not supported, assuming iso-8859-1 in /home2/pwcforum/public_html/AandD-6955778-309/includes/functions/general.php on line 39
[14-Oct-2012 16:44:53] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset latin1' not supported, assuming iso-8859-1 in /home2/pwcforum/public_html/AandD-6955778-309/includes/functions/general.php on line 39 [14-Oct-2012 16:44:53] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset latin1' not supported, assuming iso-8859-1 in /home2/pwcforum/public_html/AandD-6955778-309/includes/functions/general.php on line 39
[14-Oct-2012 16:44:53] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset latin1' not supported, assuming iso-8859-1 in /home2/pwcforum/public_html/AandD-6955778-309/includes/functions/general.php on line 39 [14-Oct-2012 16:44:53] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset latin1' not supported, assuming iso-8859-1 in /home2/pwcforum/public_html/AandD-6955778-309/includes/functions/general.php on line 39
[14-Oct-2012 16:44:53] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset latin1' not supported, assuming iso-8859-1 in /home2/pwcforum/public_html/AandD-6955778-309/includes/functions/general.php on line 39 [14-Oct-2012 16:44:55] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset latin1' not supported, assuming iso-8859-1 in /home2/pwcforum/public_html/AandD-6955778-309/includes/functions/general.php on line 39

Maybe those 2 codes are old im not sure im going to keep checking to see if anymore come ill keep you updated

Thanks

Nope there new and its flooding the server now

i think i might have found the one problem the includes english file did have the latin1 instead of the 'iso-8859-1' so i changed it now ill see how that works out.

i did the restore on the database and everything is now back. But when i click attributes controller it goes to a http 500 error ???

debug log has

[14-Oct-2012 17:49:03] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, 1, 'TEXT')' at line 1 :: INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES ((int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, 1, 'TEXT') in /home2/pwcforum/public_html/includes/classes/db/mysql/query_factory.php on line 120

now i got a new one

[14-Oct-2012 17:49:03] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, 1, 'TEXT')' at line 1 :: INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES ((int)PRODUCTS_OPTIONS_VALUES_TEXT_ID, 1, 'TEXT') in /home2/pwcforum/public_html/includes/classes/db/mysql/query_factory.php on line 120

http://www.zen-cart.com/showthread.php?200688-Known-Bugs-%28and-fixes%29-with-v1-5-1

Thanks i just did it but i still get a Http 500 error when i click on atributes controller in the admin

and now i got this error

[14-Oct-2012 18:23:34] PHP Fatal error: 1062:Duplicate entry '0-1' for key 'PRIMARY' :: INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES (0, 1, 'TEXT') in /home2/pwcforum/public_html/includes/classes/db/mysql/query_factory.php on line 120

well now google is gone. and i get this error now

[14-Oct-2012 19:35:42] PHP Warning: opendir(/home2/pwcforum/public_html/GOOGLE_PRODUCTS_DIRECTORY) [<a href='function.opendir'>function.opendir</a>]: failed to open dir: No such file or directory in /home2/pwcforum/public_html/myadmin/googlefroogle.php on line 185

i just reinstalled all the files and ran the Sql file still nothing. it was working just fine before i did the database restore to fix the attributes

ok i think i got this one done. man i just can't get a break.

Dashizna:

[14-Oct-2012 19:35:42] PHP Warning: opendir(/home2/pwcforum/public_html**/GOOGLE_PRODUCTS_DIRECTORY**) [<a href='function.opendir'>function.opendir</a>]: failed to open dir: No such file or directory in /home2/pwcforum/public_html/myadmin/googlefroogle.php on line 185
Apparently your googlefroogle script is expecting that you've got a defined value for GOOGLE_PRODUCTS_DIRECTORY.

As with any plugin, that's usually in a define() statement, contained in one of the plugin's files, or in the database as a result of following the plugin's installation procedure.

yea i reinstalled it and used this http://www.zen-cart.com/showthread.php?187534-The-NEW-Google-Merchant-Thread-Version-1-12-0/page32&highlight=google+feeder+sql+patch

i think that one is done

how do you uninstall and reinstall easy populate cause the screen is just blank and i have done everything a few times but when you click the easy populate in configuration in the admin it is just blank

Thanks

http://www.zen-cart.com/content.php?124-blank-page

RodG:

Dashizna,

"[12-Oct-2012 21:36:13] PHP Fatal error: 1062:Duplicate entry 'zc_01816214277b5bb819a08194522eb8b9' for key 'PRIMARY' :: insert into zen_db_cache set cache_entry_name = 'zc_01816214277b5bb819a08194522eb8b9',"

An easy one to fix. Using phpmyadmin (or similar tool) drop all the entries zen_db_cache table... it appears you may have a corrupt table.

I did this and even deleted the one that is causing the problem manually and it is just recreating this issue.

Ok here is this attrbutes one still haunting me

[15-Oct-2012 09:56:19] PHP Fatal error: 1062:Duplicate entry '0-1' for key 'PRIMARY' :: INSERT INTO products_options_values (products_options_values_id, language_id, products_options_values_name) VALUES (0, 1, 'TEXT') in /home2/********/public_html/includes/classes/db/mysql/query_factory.php on line 120

so right now it looks like i got all of them but these last 2 taken care of so far....

Do both of your configure.php files have the same DB_XXXXXXX settings? (other parts of the file may differ, but the DB_XXXXXX settings must always be the same in both files)

yes they are both the same

also i just tried to redo easy populate with all the files and everything when i try to run both SQL files i get a Failed on ._install_sql and a http 500 error on install_sql

im not sure if its cause i did have older versions of easy populate in the 1.3.8a

this is the version of easy populate im trying to use. http://www.zen-cart.com/downloads.php?do=file&id=868