many ���� appears

[mc12345678]

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?

[jsarwar]

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

Thank you.

[mc12345678]

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);

[mc12345678]

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.

[jsarwar]

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.

[jsarwar]

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.

[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?

[mc12345678]

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. :)

[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

[jsarwar]

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.