many ���� appears

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.

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?

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.

DrByte:

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?313-should-i-convert-my-store-from-iso-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?

jsarwar:

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.

mc12345678:

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.

mc12345678:

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?

jsarwar:

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.

jsarwar:

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?313-should-i-convert-my-store-from-iso-8859-1-to-utf8
You set CHARSET to 'utf8' without the hyphen, when only DB_CHARSET should drop the hyphen.

DrByte:

Go back and re-read the instructions on using utf8: https://www.zen-cart.com/content.php?313-should-i-convert-my-store-from-iso-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'); ?

mc12345678:

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.

I have following two numinix

<?php if (!defined('IS_ADMIN_FLAG')) { die('Illegal Access'); } // add upgrade script $fec_version = (defined('FAST_AND_EASY_CHECKOUT_VERSION') ? FAST_AND_EASY_CHECKOUT_VERSION : 'new'); $current_version = '1.14.6'; // change this each time a new version is ready to release while ($fec_version != $current_version) { switch ($fec_version) { // add case for each previous version case 'new': // perform upgrade if (file_exists(DIR_WS_INCLUDES . 'installers/fec/new.php')) { include_once(DIR_WS_INCLUDES . 'installers/fec/new.php'); $fec_version = '1.12.0'; break; } else { break 2; } case '1.11.2': // perform upgrade if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_12_0.php')) { include_once(DIR_WS_INCLUDES . 'installers/fec/1_12_0.php'); $fec_version = '1.12.0'; break; } else { break 2; } case '1.12.0': // perform upgrade if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_12_1.php')) { include_once(DIR_WS_INCLUDES . 'installers/fec/1_12_1.php'); $fec_version = '1.12.1'; break; } else { break 2; } case '1.12.1': // perform upgrade if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_12_2.php')) { include_once(DIR_WS_INCLUDES . 'installers/fec/1_12_2.php'); $fec_version = '1.12.2'; break; } else { break 2; } case '1.12.2': // perform upgrade if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_12_3.php')) { include_once(DIR_WS_INCLUDES . 'installers/fec/1_12_3.php'); $fec_version = '1.12.3'; break; } else { break 2; } case '1.12.3': // perform upgrade if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_13_0.php')) { include_once(DIR_WS_INCLUDES . 'installers/fec/1_13_0.php'); $fec_version = '1.13.0'; break; } else { break 2; } case '1.13.0': // perform upgrade if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_13_1.php')) { include_once(DIR_WS_INCLUDES . 'installers/fec/1_13_1.php'); $fec_version = '1.13.1'; break; } else { break 2; } case '1.13.1': // perform upgrade if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_13_2.php')) { include_once(DIR_WS_INCLUDES . 'installers/fec/1_13_2.php'); $fec_version = '1.13.2'; break; } else { break 2; } case '1.13.2': // perform upgrade if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_14_0.php')) { include_once(DIR_WS_INCLUDES . 'installers/fec/1_14_0.php'); $fec_version = '1.14.0'; break; } else { break 2; } case '1.14.0': // perform upgrade if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_14_1.php')) { include_once(DIR_WS_INCLUDES . 'installers/fec/1_14_1.php'); $fec_version = '1.14.1'; break; } else { break 2; } case '1.14.1': // perform upgrade if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_14_2.php')) { include_once(DIR_WS_INCLUDES . 'installers/fec/1_14_2.php'); $fec_version = '1.14.2'; break; } else { break 2; } case '1.14.2': // perform upgrade if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_14_3.php')) { include_once(DIR_WS_INCLUDES . 'installers/fec/1_14_3.php'); $fec_version = '1.14.3'; break; } else { break 2; } case '1.14.3': // perform upgrade if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_14_4.php')) { include_once(DIR_WS_INCLUDES . 'installers/fec/1_14_4.php'); $fec_version = '1.14.4'; break; } else { break 2; } case '1.14.4': // perform upgrade if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_14_5.php')) { include_once(DIR_WS_INCLUDES . 'installers/fec/1_14_5.php'); $fec_version = '1.14.5'; break; } else { break 2; } case '1.14.5': // perform upgrade if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_14_6.php')) { include_once(DIR_WS_INCLUDES . 'installers/fec/1_14_6.php'); $fec_version = '1.14.6'; break; } else { break 2; } case '1.14.6': // perform upgrade if (file_exists(DIR_WS_INCLUDES . 'installers/fec/1_14_7.php')) { include_once(DIR_WS_INCLUDES . 'installers/fec/1_14_7.php'); $fec_version = '1.14.7'; break; } else { break 2; } default: $fec_version = $current_version; // break all the loops break 2; } } 2nd ALTER TABLE products ADD products_condition varchar(32) NULL default NULL; INSERT INTO product_type_layout (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, product_type_id, sort_order, last_modified, date_added, use_function, set_function) VALUES (NULL, 'Show Condition', 'SHOW_PRODUCT_INFO_CONDITION', '0', 'Show product condition on product info page (requires Numinix Product Fields)?', 1, 17, NULL, NOW(), NULL, 'zen_cfg_select_option(array(\'1\', \'0\'),'); Current file need to modify is <?php //$messageStack->add('Ty Package Tracker v3.1.3 install started','success'); $typt_menu_title = 'Ty Package Tracker'; $typt_menu_text = 'Settings for Ty Package Tracker Features'; /* find if Ty Package Tracker Configuration Group Exists */ $sql = "SELECT * FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title = '".$typt_menu_title."'"; $original_config = $db->Execute($sql); if($original_config->RecordCount()) { // if exists updating the existing Ty Package Tracker configuration group entry $sql = "UPDATE ".TABLE_CONFIGURATION_GROUP." SET configuration_group_description = '".$typt_menu_text."' WHERE configuration_group_title = '".typt_menu_title."'"; $db->Execute($sql); $sort = $original_config->fields['sort_order']; }else{ /* Find max sort order in the configuation group table -- add 2 to this value to create the Ty Package Tracker configuration group ID */ $sql = "SELECT (MAX(sort_order)+2) as sort FROM ".TABLE_CONFIGURATION_GROUP; $result = $db->Execute($sql); $sort = $result->fields['sort']; /* Create Ty Package Tracker configuration group */ $sql = "INSERT INTO ".TABLE_CONFIGURATION_GROUP." (configuration_group_id, configuration_group_title, configuration_group_description, sort_order, visible) VALUES (NULL, '".$typt_menu_title."', '".$typt_menu_text."', ".$sort.", '1')"; $db->Execute($sql); } /* Find configuation group ID of Ty Package Tracker */ $sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title='".$typt_menu_title."' LIMIT 1"; $result = $db->Execute($sql); $typt_configuration_id = $result->fields['configuration_group_id']; /* Remove Ty Package Tracker items from the configuration table */ $sql = "DELETE FROM ".DB_PREFIX."configuration WHERE configuration_group_id ='".$typt_configuration_id."'"; $db->Execute($sql); //-- ADD VALUES TO EDIT ORDERS CONFIGURATION GROUP (Admin > Configuration > Ty Package Tracker) -- $sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 1 Status', 'CARRIER_STATUS_1', 'True', 'Enable Tracking for Carrier 1<br /><br />Set to false if you do NOT want Carrier 1 to be displayed on Admin and Customer page.', '".$typt_configuration_id."', 90, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ')"; $db->Execute($sql); $sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 1 Name', 'CARRIER_NAME_1', 'FedEx', 'Enter name of Carrier 1 <br /> <br /><strong>Example:</strong> FedEx, UPS, Canada Post, etc...<br />(default: FedEx)', '".$typt_configuration_id."', 95, now(), now(), NULL, NULL)"; $db->Execute($sql); $sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 1 Tracking Link', 'CARRIER_LINK_1', 'http://www.fedex.com/Tracking?action=track&tracknumbers=', 'Enter the tracking link of Carrier 1<br /> <br /><strong>Example:</strong> <http://www.fedex.com/Tracking?action=track&tracknumbers=>', '".$typt_configuration_id."', 100, now(), now(), NULL, NULL)"; $db->Execute($sql); $sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 2 Status', 'CARRIER_STATUS_2', 'True', 'Enable Tracking for Carrier 2<br /><br />Set to false if you do NOT want Carrier 2 to be displayed on Admin and Customer page.', '".$typt_configuration_id."', 105, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ')"; $db->Execute($sql); $sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 2 Name', 'CARRIER_NAME_2', 'UPS', 'Enter name of Carrier 2 <br /> <br /><strong>Example:</strong> FedEx, UPS, Canada Post, etc...<br />(default: UPS)', '".$typt_configuration_id."', 110, now(), now(), NULL, NULL)"; $db->Execute($sql); $sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 2 Tracking Link', 'CARRIER_LINK_2', 'http://wwwapps.ups.com/WebTracking/processInputRequest?sort_by=status&tracknums_displayed=1&TypeOfInquiryNumber=T&loc=en_US&InquiryNumber1=', 'Enter the tracking link of Carrier 2<br /> <br /><strong>Example:</strong> <http://www.fedex.com/Tracking?action=track&tracknumbers=>', '".$typt_configuration_id."', 115, now(), now(), NULL, NULL)"; $db->Execute($sql); $sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 3 Status', 'CARRIER_STATUS_3', 'True', 'Enable Tracking for Carrier 3<br /><br />Set to false if you do NOT want Carrier 3 to be displayed on Admin and Customer page.', '".$typt_configuration_id."', 120, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ')"; $db->Execute($sql); $sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 3 Name', 'CARRIER_NAME_3', 'USPS', 'Enter name of Carrier 3 <br /> <br /><strong>Example:</strong> FedEx, UPS, Canada Post, etc...<br />(default: USPS)', '".$typt_configuration_id."', 125, now(), now(), NULL, NULL)"; $db->Execute($sql); $sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 3 Tracking Link', 'CARRIER_LINK_3', 'https://tools.usps.com/go/TrackConfirmAction!input.action?tLabels=', 'Enter the tracking link of Carrier 3<br /> <br /><strong>Example:</strong> <http://www.fedex.com/Tracking?action=track&tracknumbers=>', '".$typt_configuration_id."', 130, now(), now(), NULL, NULL)"; $db->Execute($sql); $sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 4 Status', 'CARRIER_STATUS_4', 'False', 'Enable Tracking for Carrier 4<br /><br />Set to false if you do NOT want Carrier 4 to be displayed on Admin and Customer page.', '".$typt_configuration_id."', 140, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ')"; $db->Execute($sql); $sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 4 Name', 'CARRIER_NAME_4', '', 'Enter name of Carrier 4 <br /> <br /><strong>Example:</strong> FedEx, UPS, Canada Post, etc...<br />(default: blank)', '".$typt_configuration_id."', 145, now(), now(), NULL, NULL)"; $db->Execute($sql); $sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 4 Tracking Link', 'CARRIER_LINK_4', '', 'Enter the tracking link of Carrier 4<br /> <br /><strong>Example:</strong> <http://www.fedex.com/Tracking?action=track&tracknumbers=>', '".$typt_configuration_id."', 150, now(), now(), NULL, NULL)"; $db->Execute($sql); $sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 5 Status', 'CARRIER_STATUS_5', 'False', 'Enable Tracking for Carrier 5<br /><br />Set to false if you do NOT want Carrier 5 to be displayed on Admin and Customer page.', '".$typt_configuration_id."', 155, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ')"; $db->Execute($sql); $sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 5 Name', 'CARRIER_NAME_5', '', 'Enter name of Carrier 5 <br /> <br /><strong>Example:</strong> FedEx, UPS, Canada Post, etc...<br />(default: blank)', '".$typt_configuration_id."', 160, now(), now(), NULL, NULL)"; $db->Execute($sql); $sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Package Tracking - Carrier 5 Tracking Link', 'CARRIER_LINK_5', '', 'Enter the tracking link of Carrier 5<br /> <br /><strong>Example:</strong> <http://www.fedex.com/Tracking?action=track&tracknumbers=>', '".$typt_configuration_id."', 165, now(), now(), NULL, NULL)"; $db->Execute($sql); $sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Max display for Track Order sidebox', 'MAX_DISPLAY_PRODUCTS_IN_TRACK_ORDERS_BOX', '3', 'The maximum number of orders to display on the Track Order sidebox ', '".$typt_configuration_id."', '170', now(), now(), NULL, NULL)"; $db->Execute($sql); $sql = "INSERT INTO ".DB_PREFIX."configuration VALUES (NULL, 'Ty Package Tracker Module Switch', 'TY_TRACKER', 'False', 'If you have the either Edit Orders v4.x or Super Orders v4.x installed, set this option to TRUE so that the Ty Package Tracker fields will display in Edit Orders or Super Orders<br><br><strong><font color=red>YOU MUST HAVE EDIT ORDERS v4.x OR SUPER ORDERS v4.x INSTALLED TO USE THIS FEATURE!!</font></strong><br><br>\(Activating this flag without the required mod\(s\) installed <strong>WILL CAUSE ERRORS IN YOUR STORE!!!!</strong>\)', '".$typt_configuration_id."', 175, now(), now(), NULL, 'zen_cfg_select_option(array(\'True\', \'False\'), ')"; $db->Execute($sql); // add columns to order table //check if track_id1 column exists $sql ="SHOW COLUMNS FROM ".DB_PREFIX."orders_status_history LIKE '%track_id1%'"; $result = $db->Execute($sql); if(!$result->RecordCount()) { $sql = "ALTER TABLE ".TABLE_ORDERS_STATUS_HISTORY." ADD track_id1 TEXT default NULL"; $db->Execute($sql); } //check if track_id2 column exists $sql ="SHOW COLUMNS FROM ".DB_PREFIX."orders_status_history LIKE '%track_id2%'"; $result = $db->Execute($sql); if(!$result->RecordCount()) { $sql = "ALTER TABLE ".TABLE_ORDERS_STATUS_HISTORY." ADD track_id2 TEXT default NULL"; $db->Execute($sql); } //check if track_id3 column exists $sql ="SHOW COLUMNS FROM ".DB_PREFIX."orders_status_history LIKE '%track_id3%'"; $result = $db->Execute($sql); if(!$result->RecordCount()) { $sql = "ALTER TABLE ".TABLE_ORDERS_STATUS_HISTORY." ADD track_id3 TEXT default NULL"; $db->Execute($sql); } //check if track_id4 column exists $sql ="SHOW COLUMNS FROM ".DB_PREFIX."orders_status_history LIKE '%track_id4%'"; $result = $db->Execute($sql); if(!$result->RecordCount()) { $sql = "ALTER TABLE ".TABLE_ORDERS_STATUS_HISTORY." ADD track_id4 TEXT default NULL"; $db->Execute($sql); } //check if track_id5 column exists $sql ="SHOW COLUMNS FROM ".DB_PREFIX."orders_status_history LIKE '%track_id5%'"; $result = $db->Execute($sql); if(!$result->RecordCount()) { $sql = "ALTER TABLE ".TABLE_ORDERS_STATUS_HISTORY." ADD track_id5 TEXT default NULL"; $db->Execute($sql); } if(file_exists(DIR_FS_ADMIN . DIR_WS_INCLUDES . 'auto_loaders/config.typt.php')) { if(!unlink(DIR_FS_ADMIN . DIR_WS_INCLUDES . 'auto_loaders/config.typt.php')) { $messageStack->add('The auto-loader '.DIR_FS_ADMIN.'includes/auto_loaders/config.typt.php has not been deleted. For this module to work you must delete this file manually.','error'); }; } $messageStack->add('Ty Package Tracker v3.1.3 install completed!','success'); // find next sort order in admin_pages table $sql = "SELECT (MAX(sort_order)+2) as sort FROM ".TABLE_ADMIN_PAGES; $result = $db->Execute($sql); $admin_page_sort = $result->fields['sort']; // now register the admin pages // Admin Menu for Ty Package Tracker Configuration Menu zen_deregister_admin_pages('configTyPackageTracker'); zen_register_admin_page('configTyPackageTracker', 'BOX_CONFIGURATION_TY_PACKAGE_TRACKER', 'FILENAME_CONFIGURATION', 'gID=' . $typt_configuration_id, 'configuration', 'Y', $admin_page_sort); Honestly, I went over two modifications you made yesterday for me but they are totally different so did not make sense to me.

I guess you didn't read the article. I'll copy and paste it here for you:

2. Edit /admin/includes/languages/english.php (and all other language_name.php files in that folder) and set the define for CHARSET to 'utf-8'.

Do the same with the non-admin /includes/languages/english.php (and other language_name.php files in that folder)
... AND ...

3. Also edit your two configure.php files to set DB_CHARSET to 'utf8':

define('DB_CHARSET', 'utf8');
(Remember, the configure.php files are most likely set to read-only on your server, so you'll need to change their permissions on the server to be writable before you can save the changes you're making.)
(Remember, you must do this for both your /your_admin_folder/includes/configure.php and /includes/configure.php )

DrByte:

I guess you didn't read the article. I'll copy and paste it here for you:

I think I have already done this as I have

define('DB_CHARSET', 'utf8'); in both admin/non admin configure files.

and I have also edit admin/non admin english files and include

define('CHARSET', 'utf8');

as mentioned in instructions.

and I just ran the converted and got following at bottom of page

Total processing tables 125, converted tables 0. Execution time 0.0232
DB statistic: show: 2 0.0121;

all tables have skip in action column.

jsarwar:

I think I have already done this as I have

define('DB_CHARSET', 'utf8'); in both admin/non admin configure files.

and I have also edit admin/non admin english files and include

define('CHARSET', 'utf8');

as mentioned in instructions.

and I just ran the converted and got following at bottom of page

Total processing tables 125, converted tables 0. Execution time 0.0232
DB statistic: show: 2 0.0121;

all tables have skip in action column.

I just have my hosting company check logs and recent log does not show following error anymore. So I think it is resolved. PHP Warning: htmlspecialchars() [<a href='function.htmlspecialchars'>function.htmlspecialchars</a>]: charset `utf8' not supported, assuming iso-8859-1 in

Thank you DrByte :)

jsarwar:

and I have also edit admin/non admin english files and include

define('CHARSET', 'utf8');

as mentioned in instructions.
No, the instructions for CHARSET say to use utf-8, not utf8.

DrByte:

No, the instructions for CHARSET say to use utf-8, not utf8.

Thank you for pointing my mistake. I have changed utf8 to utf-8.

Do I need to upload and re run coverter file again?
Right now all fonts appearing ok on site and in admin.

jsarwar:

Thank you for pointing my mistake. I have changed utf8 to utf-8.

Do I need to upload and re run coverter file again?
No, the converter script wasn't based on those settings. Should be fine.

DrByte:

No, the converter script wasn't based on those settings. Should be fine.

Thank you. Can you please rearrange sql for me I posted above for TY track as I can't understand sql and how to put them together.

Stock Icons in Zencart

How I can increase the size of in stock image (Green light)?
When inspect element is shows 10"x10" but no where in css its mentioned. How I can increase it?
Thank you

jsarwar:

Stock Icons in Zencart

How I can increase the size of in stock image (Green light)?
When inspect element is shows 10"x10" but no where in css its mentioned. How I can increase it?
Thank you

Is this admin or catalog side? And are you speaking of the addon for stock icons?

Either way, the zen_image function is what pulls the relevant image. You will have to modify the width and height parameters from 10 and 10 to something else you want. But also keep in mind that if you go much bigger you will have to redo and upload the icon status images to avoid them being blury on the catalog side.