Forums / Upgrading to 1.5.x / many ���� appears

many ���� appears

Results 1 to 20 of 69
11 Jul 2014, 16:56
#1
jsarwar avatar

jsarwar

Zen Follower

Join Date:
Jul 2012
Posts:
347
Plugin Contributions:
0

many ���� appears

I upgraded 1.3.9 to 1.5.
Product description content is appearing ok on live site but when I try to edit product description of existing product in admin many ���� appears on different places in description and table borders are very thick which were not there before when editing with html area. Now I try to edit with plain and ck editor and if I update or save product ���� also appear on live site.

How I can get rid of these otherwise I have to edit descriptions of all 3000 products which will be very time consuming.
11 Jul 2014, 18:27
#2
drbyte avatar

drbyte

Sensei

Join Date:
Jan 2004
Posts:
63,506
Plugin Contributions:
173

Re: many ���� appears

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
11 Jul 2014, 18:32
#3
jsarwar avatar

jsarwar

Zen Follower

Join Date:
Jul 2012
Posts:
347
Plugin Contributions:
0

Re: many ���� appears

database is utf8

language files also define('DB_CHARSET', 'utf8');

So I was able to fix it by adding following to both configure.php files

define('DB_CHARSET', 'utf8');
11 Jul 2014, 22:23
#4
jsarwar avatar

jsarwar

Zen Follower

Join Date:
Jul 2012
Posts:
347
Plugin Contributions:
0

Re: many ���� appears

I had Manufacturer All page on 1.3.9 which is appearing on 1.5 live site still. The only issues I don't see that in admin now in case if I want to make changes in to it.

Sorry for posting here but this module have no thread and developer said he is no longer working with ZC.

I tried to run same SQL which I did for 1.3.



DELETE FROM `configuration_group` WHERE `configuration_group_title` LIKE 'Manufacturers All Config' LIMIT 2;
DELETE FROM `configuration` WHERE `configuration_description` LIKE 'Manufacturers All Listing:%' LIMIT 7;

INSERT INTO configuration_group VALUES ('', 'Manufacturers All Config', 'Manufacturers All Config', '1', '1');
SELECT @gida := configuration_group_id FROM `configuration_group` where `configuration_group_title` LIKE 'Layout Settings';
SELECT @gid := configuration_group_id FROM `configuration_group` where `configuration_group_title` LIKE 'Manufacturers All Config';
UPDATE configuration_group SET sort_order = @gid WHERE configuration_group_id = @gid;

INSERT INTO configuration VALUES ('', 'Categories Box - Show Manufacturers All Link', 'SHOW_CATEGORIES_BOX_MANUFACTURERS_ALL', '1', 'Manufacturers All Listing: Set this to 1 if you want to show the All Manufacturers link to show in the Categories Box.', @gida, '0', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Display Empty Manufacturers', 'MANUFACTURERS_ALL_EMPTY_SHOW', '0', 'Manufacturers All Listing: Set this to 1 if you want manufacturers with no products to show on the list.', @gid, '7', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Display Manufacturer Image', 'MANUFACTURERS_ALL_IMAGE_SHOW', '1', 'Manufacturers All Listing: Set this to 1 if you want the manufacturers logo to appear with the listing.', @gid, '7', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Display Manufacturer URL', 'MANUFACTURERS_ALL_URL_SHOW', '1', 'Manufacturers All Listing: Set this to 1 if you want the manufacturers URL to appear with the listing.', @gid, '7', now(), now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration VALUES ('', 'Manufacturers Per Row', 'MANUFACTURERS_ALL_COLUMNS', '4', 'Manufacturers All Listing: Set the number of manufacturers per row to display.<br>(default 4)', @gid, '7', now(), now(), NULL, NULL);
INSERT INTO configuration VALUES ('', 'Manufacturer Image Width', 'MANUFACTURERS_ALL_WIDTH', '100px', 'Manufacturers All Listing: Set the maximum width of the manufacturers image.<br>(default 100px)', @gid, '7', now(), now(), NULL, NULL);
INSERT INTO configuration VALUES ('', 'Manufacturer Image Height', 'MANUFACTURERS_ALL_HEIGHT', '100px', 'Manufacturers All Listing: Set the maximum height of the manufacturers image<br>(default 100px)', @gid, '7', now(), now(), NULL, NULL);


/*
Admin page (Zen-cart 1.5.0)
*/
INSERT INTO `admin_pages` (`page_key` ,`language_key` ,`main_page` ,`page_params` ,`menu_key` ,`display_on_menu` ,`sort_order`)VALUES
('configManufacturersList', 'BOX_CONFIGURATION_MANUFACTURERS_LIST', 'FILENAME_CONFIGURATION', CONCAT('gID=',@gid), 'configuration', 'Y', @gid);





and getting error "1136 Column count doesn't match value count at row 1
in:
[INSERT INTO zen_configuration VALUES ('', 'Categories Box - Show Manufacturers All Link', 'SHOW_CATEGORIES_BOX_MANUFACTURERS_ALL', '1', 'Manufacturers All Listing: Set this to 1 if you want to show the All Manufacturers link to show in the Categories Box.', @gida, '0', now(), now(), NULL, "zen_cfg_select_option(array('0', '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."


Which is most likely because I already ran this sql on 1.3.9 site and still exists in data base.

Module does not have sql to install so I can run uninstall and install again like I did for other modules. Can someone please let me know how to uninstall sql for this?

Thank You.
12 Jul 2014, 01:25
#5
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,907
Plugin Contributions:
1

Re: many &#65533;&#65533;&#65533;&#65533; appears

No, you are incorrect. The error is not because of it being previously installed/run. It is as the error says, the value count (number of values that follow the insert into X values ( statement. The number of items in that list does not match the number of fields in the data table. Two ways to correct this, either go look at the table and identify which row(s) exist and if they can be matched up with the data in that order to identify which field exists. Or has been removed that is or is not in the list or use an assignment such that insert into X (fieldname1, fieldname2, etc...) Values ('', data_in_current_sql, etc...)That said, if the app was written for an older version of ZC, it may need a significant upgrade to function properly under the latest requirements of ZC 1.5.3. (Obviously including the sql statements.)
12 Jul 2014, 01:33
#6
jsarwar avatar

jsarwar

Zen Follower

Join Date:
Jul 2012
Posts:
347
Plugin Contributions:
0

Re: many &#65533;&#65533;&#65533;&#65533; appears

mc12345678:

No, you are incorrect. The error is not because of it being previously installed/run. It is as the error says, the value count (number of values that follow the insert into X values ( statement. The number of items in that list does not match the number of fields in the data table. Two ways to correct this, either go look at the table and identify which row(s) exist and if they can be matched up with the data in that order to identify which field exists. Or has been removed that is or is not in the list or use an assignment such that insert into X (fieldname1, fieldname2, etc...) Values ('', data_in_current_sql, etc...)That said, if the app was written for an older version of ZC, it may need a significant upgrade to function properly under the latest requirements of ZC 1.5.3. (Obviously including the sql statements.)


Thank you for information. I tried this on 1.5.3 few days ago and same error happened. I tried today on 1.5.0 and still same error. I am not good on sql so I am not sure how author use all those 0 - 7 numbers and how to change it. If you or any one can guide me or adjust this sql for 1.5 I would really appreciate that.
It is working fine on my live site but I just want it to be fixed in admin for future.

Thank you.
12 Jul 2014, 03:22
#7
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,907
Plugin Contributions:
1

Re: many &#65533;&#65533;&#65533;&#65533; appears

jsarwar:

Thank you for information. I tried this on 1.5.3 few days ago and same error happened. I tried today on 1.5.0 and still same error. I am not good on sql so I am not sure how author use all those 0 - 7 numbers and how to change it. If you or any one can guide me or adjust this sql for 1.5 I would really appreciate that. It is working fine on my live site but I just want it to be fixed in admin for future. Thank you.
I understand a little better now what it is that is not working and what you want. You are missing the admin option to use this plugin, correct? There is/was a file that did what now is done in the database. The contents of that file will give information necessary to create new SQL to add to the install script. The above install script will also need to be rewritten to prevent you getting this error, unless this issue trulyis more of a ZC 1.5.3 problem instead of just a problem with this install. I have seen several similar reported errors in what seems like just the last several hours.
12 Jul 2014, 03:28
#8
jsarwar avatar

jsarwar

Zen Follower

Join Date:
Jul 2012
Posts:
347
Plugin Contributions:
0

Re: many &#65533;&#65533;&#65533;&#65533; appears

Yes I am missing module plug in for admin. Even I tried another module and it giving same error column count does not......
All these modules have been working great on 1.3.9 but on 1.5.0 and 1.5.3 they are not because of some change in structure.

I am trying to read more about sql to understand but if you can assist me I would really appreciate that. I have already paste content of sql file in one of my post above. I can send you any other files you need to rearrange this sql so that we can continue enjoying these modules on zencart.

Thank you.
12 Jul 2014, 03:55
#9
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,907
Plugin Contributions:
1

Re: many &#65533;&#65533;&#65533;&#65533; appears

Would need the contents of the file(s) associated with this/these plugins that are stored in:/admin/includes/boxes/xxxxxx_dhtml.php files or /admin/includes/boxes/extra_boxes/*.phpThe xxxxxx and * represent the name(s) associated with the plugin. You can also look at the FAQ: http://www.zen-cart.com/content.php?309-upgrading-addons-for-compatibility-with-v15x to see what is involved.
12 Jul 2014, 04:08
#10
jsarwar avatar

jsarwar

Zen Follower

Join Date:
Jul 2012
Posts:
347
Plugin Contributions:
0

Re: many &#65533;&#65533;&#65533;&#65533; appears

mc12345678:

Would need the contents of the file(s) associated with this/these plugins that are stored in:/admin/includes/boxes/xxxxxx_dhtml.php files or /admin/includes/boxes/extra_boxes/*.phpThe xxxxxx and * represent the name(s) associated with the plugin. You can also look at the FAQ: http://www.zen-cart.com/content.php?309-upgrading-addons-for-compatibility-with-v15x to see what is involved.



I am still reading more to understand better.

You can download files from here
http://www.zen-cart.com/downloads.php?do=file&id=299

Author posted as compatible with 1.5 + but it is not so after you fix this, you may want to upload it again there so no one else have this issue.
Thank you.
12 Jul 2014, 04:29
#11
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,907
Plugin Contributions:
1

Re: many &#65533;&#65533;&#65533;&#65533; appears

jsarwar:

I am still reading more to understand better. You can download files from here http://www.zen-cart.com/downloads.php?do=file&id=299Author posted as compatible with 1.5 + but it is not so after you fix this, you may want to upload it again there so no one else have this issue. Thank you.
I appreciate the download location; however, I am currently on a cellphone that is unable to decompress the download files (zip files). The issue isn't covered in the forum?
12 Jul 2014, 04:32
#12
jsarwar avatar

jsarwar

Zen Follower

Join Date:
Jul 2012
Posts:
347
Plugin Contributions:
0

Re: many &#65533;&#65533;&#65533;&#65533; appears

No it is not. Please check this when you get to computer.

Thank you.
12 Jul 2014, 05:22
#13
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,907
Plugin Contributions:
1

Re: many &#65533;&#65533;&#65533;&#65533; appears

So, I haven't downloaded ZC 1.5.3 yet, nor tested the following; however, if it worked in 1.5.0 or 1.5.1, then it should work in 1.5.3 now... Let me know I guess. It still may not work as it has not been updated to 1.5.3 (there may be other files that need to be updated to work with the latest version.)

DELETE FROM `configuration_group` WHERE `configuration_group_title` LIKE 'Manufacturers All Config' LIMIT 2;
DELETE FROM `configuration` WHERE `configuration_description` LIKE 'Manufacturers All Listing:%' LIMIT 7;

INSERT INTO configuration_group (configuration_group_title, configuration_group_description, sort_order, visible) VALUES ('Manufacturers All Config', 'Manufacturers All Config', '1', '1');
SELECT @gida := configuration_group_id FROM `configuration_group` where `configuration_group_title` LIKE 'Layout Settings';
SELECT @gid := configuration_group_id FROM `configuration_group` where  `configuration_group_title` LIKE 'Manufacturers All Config';
UPDATE configuration_group SET sort_order = @gid WHERE configuration_group_id = @gid AND @gid !=0;

INSERT INTO configuration (configuration_title, configuration_key, configuration_value,  configuration_description, configuration_group_id, sort_order,  last_modified, date_added, use_function, set_function) VALUES ('Categories Box - Show  Manufacturers All Link', 'SHOW_CATEGORIES_BOX_MANUFACTURERS_ALL', '1',  'Manufacturers All Listing: Set this to 1 if you want to show the All  Manufacturers link to show in the Categories Box.', @gida, '0', now(),  now(), NULL, "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration (configuration_title, configuration_key, configuration_value,  configuration_description, configuration_group_id, sort_order,  last_modified, date_added, use_function, set_function) VALUES ('Display Empty Manufacturers',  'MANUFACTURERS_ALL_EMPTY_SHOW', '0', 'Manufacturers All Listing: Set  this to 1 if you want manufacturers with no products to show on the  list.', @gid, '7', now(), now(), NULL, "zen_cfg_select_option(array('0',  '1'),");
INSERT INTO configuration (configuration_title, configuration_key, configuration_value,  configuration_description, configuration_group_id, sort_order,  last_modified, date_added, use_function, set_function) VALUES ('Display Manufacturer Image',  'MANUFACTURERS_ALL_IMAGE_SHOW', '1', 'Manufacturers All Listing: Set  this to 1 if you want the manufacturers logo to appear with the  listing.', @gid, '7', now(), now(), NULL,  "zen_cfg_select_option(array('0', '1'),");
INSERT INTO configuration (configuration_title, configuration_key, configuration_value,  configuration_description, configuration_group_id, sort_order,  last_modified, date_added, use_function, set_function) VALUES ('Display Manufacturer URL',  'MANUFACTURERS_ALL_URL_SHOW', '1', 'Manufacturers All Listing: Set this  to 1 if you want the manufacturers URL to appear with the listing.',  @gid, '7', now(), now(), NULL, "zen_cfg_select_option(array('0',  '1'),");
INSERT INTO configuration (configuration_title, configuration_key, configuration_value,  configuration_description, configuration_group_id, sort_order,  last_modified, date_added, use_function, set_function) VALUES ('Manufacturers Per Row',  'MANUFACTURERS_ALL_COLUMNS', '4', 'Manufacturers All Listing: Set the  number of manufacturers per row to display.<br>(default 4)', @gid,  '7', now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value,  configuration_description, configuration_group_id, sort_order,  last_modified, date_added, use_function, set_function) VALUES ('Manufacturer Image Width',  'MANUFACTURERS_ALL_WIDTH', '100px', 'Manufacturers All Listing: Set the  maximum width of the manufacturers image.<br>(default 100px)',  @gid, '7', now(), now(), NULL, NULL);
INSERT INTO configuration (configuration_title, configuration_key, configuration_value,  configuration_description, configuration_group_id, sort_order,  last_modified, date_added, use_function, set_function) VALUES ('Manufacturer Image Height',  'MANUFACTURERS_ALL_HEIGHT', '100px', 'Manufacturers All Listing: Set the  maximum height of the manufacturers image<br>(default 100px)',  @gid, '7', now(), now(), NULL, NULL);


/*
Admin page (Zen-cart 1.5.0)
*/
INSERT INTO `admin_pages` (`page_key` ,`language_key` ,`main_page`  ,`page_params` ,`menu_key` ,`display_on_menu` ,`sort_order`) VALUES 
('configManufacturersList', 'BOX_CONFIGURATION_MANUFACTURERS_LIST',  'FILENAME_CONFIGURATION', CONCAT('gID=',@gid), 'configuration', 'Y',  @gid);
12 Jul 2014, 07:35
#14
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,907
Plugin Contributions:
1

Re: many &#65533;&#65533;&#65533;&#65533; appears

For clarity, although again I haven't downloaded/installed 1.5.3 yet, it appears that there is a change in the database structure for some tables (or perhaps the way that sql queries are handled) and so the plugins may or may not work during installation depending on theversion(s) of the software.
12 Jul 2014, 12:04
#15
jsarwar avatar

jsarwar

Zen Follower

Join Date:
Jul 2012
Posts:
347
Plugin Contributions:
0

Re: many &#65533;&#65533;&#65533;&#65533; appears

Thank you, it accepted this time on ZC 1.5.0 and shows 14 statements processed but there is no Tab "Testimonial Manager" below configuration tab.
12 Jul 2014, 12:27
#16
jsarwar avatar

jsarwar

Zen Follower

Join Date:
Jul 2012
Posts:
347
Plugin Contributions:
0

Re: many &#65533;&#65533;&#65533;&#65533; appears

Please ignore my first message.

Thank you, it accepted this time on ZC 1.5.0 and shows 14 statements processed I got the Manufacturer Listing Tab below Configuration but when click it shows table headings


Title Value Action
but no values or options to edit.
12 Jul 2014, 12:48
#17
jsarwar avatar

jsarwar

Zen Follower

Join Date:
Jul 2012
Posts:
347
Plugin Contributions:
0

Re: many &#65533;&#65533;&#65533;&#65533; appears

I got it my friend. I went to PHPmyadmin and delete all relatives for this module as I installed it on 1.3.9 before and after upgrade rows were still in there.
After deleting those I ran sql again and it worked.


Thank you so much. Can you please submit this to zencart plug in as you changed it so everyone can use this on ZC 1.5 version.



Can you please also change this http://www.zen-cart.com/downloads.php?do=file&id=299 to 1.5 compatible?
12 Jul 2014, 14:01
#18
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,907
Plugin Contributions:
1

Re: many &#65533;&#65533;&#65533;&#65533; appears

jsarwar:

I got it my friend. I went to PHPmyadmin and delete all relatives for this module as I installed it on 1.3.9 before and after upgrade rows were still in there. After deleting those I ran sql again and it worked. Thank you so much. Can you please submit this to zencart plug in as you changed it so everyone can use this on ZC 1.5 version. Can you please also change this http://www.zen-cart.com/downloads.php?do=file&id=299 to 1.5 compatible?
So what actions specifically were performed as part of your upgrade, as this last step you described I do not understand. You deleted all of the relatives? Is there. Some sort of common action to perform to make that happen? Ie, did all of the records have some common field? What table in myphpadmin? Etc. This information would be necessary to properly provide an update. Otherwise other users would get to the point you did and more than likely not know to go do what you did. :)
12 Jul 2014, 14:10
#19
mc12345678 avatar

mc12345678

Totally Zenned

Join Date:
Jul 2012
Posts:
16,907
Plugin Contributions:
1

Re: many &#65533;&#65533;&#65533;&#65533; appears

mc12345678:

So what actions specifically were performed as part of your upgrade, as this last step you described I do not understand. You deleted all of the relatives? Is there. Some sort of common action to perform to make that happen? Ie, did all of the records have some common field? What table in myphpadmin? Etc. This information would be necessary to properly provide an update. Otherwise other users would get to the point you did and more than likely not know to go do what you did. :)
Also, what version of PHP is your system using and same for your SQL server? Was the above SQL from testimonials manager or a different plugin? I know the rexent author of testimonials manager and it has worked on 1.5.0/.1 in most cases. There are some systems that do not like the method used by the auto installer, but a majority of them are okay. I have seen recently though that statements need to be rewritten like what I did above in order to be acceptedm
12 Jul 2014, 14:12
#20
jsarwar avatar

jsarwar

Zen Follower

Join Date:
Jul 2012
Posts:
347
Plugin Contributions:
0

Re: many &#65533;&#65533;&#65533;&#65533; appears

mc12345678:

So what actions specifically were performed as part of your upgrade, as this last step you described I do not understand. You deleted all of the relatives? Is there. Some sort of common action to perform to make that happen? Ie, did all of the records have some common field? What table in myphpadmin? Etc. This information would be necessary to properly provide an update. Otherwise other users would get to the point you did and more than likely not know to go do what you did. :)




I have been running website on ZC 1.3.9 and installed this module and it was working ok. Then I upload ZC 1.5 files to root and ran zc_install to upgrade to 1.5.0 which upgrade the data base to 1.5.0 and most of modules are still appearing on live site but not in admin including this one.

I try to install modules again but they did not work because zencart 1.5 structure is different then zencart 1.3
The MySQL error message thrown by phpMyAdmin ("#1136 - Column count doesn't match value count at row 1") tells us that the database structure has changed in this newer release of ZC.


Now you sent me sql so I ran it but it still did not show module in admin so I though let's check phpmyadmin and I found this module under configuration/configuration_group which was probably for the sql I ran on 1.3.9 so I deleted it and then ran sql you sent and it showed up module.

So what I think sql ran on 1.3.9 ZC tables/values were still in data base but as 1.5 structure is different so they were appearing in admin and nor letting sql generate/show new one.

That's exactly I did and may need to do for other modules too.