many ���� appears

[mc12345678]

I have posted the update to the manufacturers all plugin and am working through the testimonials manager to update it. Unfortunately I am away from my computer at the moment to finish that update, trying to get some food. :) but I have incorporated the changes discussed in the forum and what we modified.

[mc12345678]

Question, before trying to install the plugins into the upgraded system, had you upgraded the database using zc_install? Or was the database transferred, these plugins attempted to be installed and then database updated using zc_install?

[mc12345678]

On another thought, you may want to double check that the database referenced in both configure.php files of your new store that they point to the same database. Just in case.

[jsarwar]

Your database is based on latin1, but ZC 1.5.x+ expects utf8, and you didn't tell it to go back and use latin1+iso-8859-1 instead.

So, either change your ZC config to use the old way of reading the data, or upgrade your data: https://www.zen-cart.com/content.php...8859-1-to-utf8

everything is ok now except this error appear in log

[13-Jul-2014 09:30:40] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset `utf8' not supported, assuming iso-8859-1 in /home/suppgeek/public_html/geeks/developers_tool_kit.php on line 190

How I can correct this?

[mc12345678]

everything is ok now except this error appear in log

[13-Jul-2014 09:30:40] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset `utf8' not supported, assuming iso-8859-1 in /home/suppgeek/public_html/geeks/developers_tool_kit.php on line 190

How I can correct this?

So, first of all, need to change your admin directory and not post it again for the public to see.

Then because this was an upgrade from 1.3.9 that didn't use utf-8, either need to assign the applicable latin language or use the utf8 converter available in the downloads section. I don't recall the details, but I know Dr. Byte posted something about it in the last day or two for someone else that had done an upgrade.

[jsarwar]

So, first of all, need to change your admin directory and not post it again for the public to see.

Then because this was an upgrade from 1.3.9 that didn't use utf-8, either need to assign the applicable latin language or use the utf8 converter available in the downloads section. I don't recall the details, but I know Dr. Byte posted something about it in the last day or two for someone else that had done an upgrade.

Thank you. This is test site so that's why shared full message. Will to conversion and let you know.

[jsarwar]

I would aver that unless you specifically checked the database before running those queries to verify that the data was present, that actually they were deleted in the earlier efforts to get this to work.A select query does not modify the database.

Diva Vocals posted following in TM thread today
"The issue is you have a Numinix module installed which adds an additional column to the configuration table. The Testimonials module uses a shortcut in the install SQL and does not explicitly name the table column names because it assumes the table structure has not changed.. hence the "missing column" error.."

That may answer question we had in discussion yesterday.

I tried to run another sql today and got same error "1136 Column count doesn't match value count at row 1"

Do you know what is column by numinix and how I can add to all sql I am / will be running on this template?

[mc12345678]

Diva Vocals posted following in TM thread today
"The issue is you have a Numinix module installed which adds an additional column to the configuration table. The Testimonials module uses a shortcut in the install SQL and does not explicitly name the table column names because it assumes the table structure has not changed.. hence the "missing column" error.."

That may answer question we had in discussion yesterday.

I tried to run another sql today and got same error "1136 Column count doesn't match value count at row 1"

Do you know what is column by numinix and how I can add to all sql I am / will be running on this template?

So, the readme associated with Numinix' plugin should provide some indication of what to do. Personally, I would/would have installed everything except for the one by numinix, (or in this caase uninstall it) add all the things I needed, and then install that plugin, or rewrite the sql statements like I did for the other two mods.

I do not at this time know what was added by numinix' mod and would have to see the SQL associated to be able to answer the question.

[DrByte]

everything is ok now except this error appear in log

[13-Jul-2014 09:30:40] PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset `utf8' not supported, assuming iso-8859-1 in /home/suppgeek/public_html/geeks/developers_tool_kit.php on line 190

How I can correct this?

Go back and re-read the instructions on using utf8: https://www.zen-cart.com/content.php...8859-1-to-utf8
You set CHARSET to 'utf8' without the hyphen, when only DB_CHARSET should drop the hyphen.

[jsarwar]

Go back and re-read the instructions on using utf8: https://www.zen-cart.com/content.php...8859-1-to-utf8
You set CHARSET to 'utf8' without the hyphen, when only DB_CHARSET should drop the hyphen.

I have define('CHARSET', 'utf8'); in language and config files

If I do define('DB_CHARSET', 'utf8'); it remove all those ????? from product description
but if I do define('DBCHARSET', 'utf8'); they still appear. But per your message I should use define('DBCHARSET', 'utf8'); ?