Results 1 to 10 of 69

Hybrid View

  1. #1
    Join Date
    Jul 2012
    Posts
    347
    Plugin Contributions
    0

    Default Re: many ���� appears

    Quote Originally Posted by mc12345678 View Post
    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.

  2. #2
    Join Date
    Jul 2012
    Posts
    16,817
    Plugin Contributions
    17

    Default Re: many ���� appears

    Quote Originally Posted by jsarwar View Post
    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.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  3. #3
    Join Date
    Jul 2012
    Posts
    347
    Plugin Contributions
    0

    Default Re: many ���� 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.

  4. #4
    Join Date
    Jul 2012
    Posts
    16,817
    Plugin Contributions
    17

    Default Re: many ���� 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?...lity-with-v15x to see what is involved.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  5. #5
    Join Date
    Jul 2012
    Posts
    347
    Plugin Contributions
    0

    Default Re: many ���� appears

    Quote Originally Posted by mc12345678 View Post
    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?...lity-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.

  6. #6
    Join Date
    Jul 2012
    Posts
    16,817
    Plugin Contributions
    17

    Default Re: many ���� appears

    Quote Originally Posted by jsarwar View Post
    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?
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  7. #7
    Join Date
    Jul 2012
    Posts
    347
    Plugin Contributions
    0

    Default Re: many ���� appears

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

    Thank you.

  8. #8
    Join Date
    Jul 2012
    Posts
    16,817
    Plugin Contributions
    17

    Default Re: many ���� 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.)

    Code:
    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);
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

  9. #9
    Join Date
    Jul 2012
    Posts
    347
    Plugin Contributions
    0

    Default Re: many ���� 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.

  10. #10
    Join Date
    Jul 2012
    Posts
    16,817
    Plugin Contributions
    17

    Default Re: many ���� 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.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...

 

 

Similar Threads

  1. category longer than 16 characters �
    By satyros in forum Addon Language Packs
    Replies: 2
    Last Post: 17 Jan 2012, 05:10 PM
  2. how do I get rid of �
    By melmeier01 in forum General Questions
    Replies: 1
    Last Post: 27 Oct 2010, 04:07 AM
  3. � - Can't figure out how to remove
    By thehiprose in forum Upgrading from 1.3.x to 1.3.9
    Replies: 2
    Last Post: 24 Oct 2010, 08:25 AM
  4. spanish accents show up as �
    By stromboli in forum Upgrading from 1.3.x to 1.3.9
    Replies: 10
    Last Post: 31 Jul 2010, 11:16 PM
  5. what is this? �
    By hello in forum Templates, Stylesheets, Page Layout
    Replies: 4
    Last Post: 29 Jul 2010, 04:56 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg