many ���� appears

[jsarwar]

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

PHP Version 5.2.17

The Above SQL is for Manufacturers All plug in. I typed TM in error that's why I mentioned in next message to ignore first message.


Testimonial Manager sql is giving same error and even TM side box is also showing this message now on live site

"1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES' at line 1
in:
[select testimonials_id, testimonials_image, testimonials_title, testimonials_html_text, date_added from zen_testimonials_manager where status = 1 and language_id = 1 order by rand(), testimonials_title limit MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES]
"

with no site footer at bottom. If I turn off TM sidebox it will make footer to appear. Can you please rearrange TM SQL file so I can get this work ok?


IN TM init.config.php file author mentioned :

$messageStack->add('The auto-loader file '.DIR_FS_ADMIN.'includes/auto_loaders/config.tm.php has not been deleted. For this module to work you must delete the '.DIR_FS_ADMIN.'includes/auto_loaders/config.tm.php file manually. Before you post on the Zen Cart forum to ask, YES you are REALLY supposed to follow these instructions and delete the '.DIR_FS_ADMIN.'includes/auto_loaders/config.tm.php file.','error');
};

If we delete autoloader it will not load TM to admin and if we keep it it gives column counts vs row count error.

Thank you.

[mc12345678]

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.

Thank you for so complete of a description. I apologize that I should have been clearer. I was only asking/needing the last part regarding what action was taken after the rewritten script was provided. I almost hate to ask if part of the process could be repeated to make this work one time rather than having to go back into the database.Supposedly the first two statements in the script should have cleared all "necessary" data.

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;

But as ee at the end of those two lines is the statement LIMIT and some number. That means it will only do the delete action on the first two records that come back (whatever they may be) I guess I need to know that if the 1.3.x script is compared to the 1.5.x script will there be a different number of entries. If they are the same number of entries, does the program generate new database entries that should be removed?My guess is that the script for 1.5 didn't include everything that was in 1.3 and only covered what needed to change between the two using the system that worked for the author. You said that you tried to contact the author(s), which of the two authors did you talk with about this manufacturer's all module?

[jsarwar]

Thank you for so complete of a description. I apologize that I should have been clearer. I was only asking/needing the last part regarding what action was taken after the rewritten script was provided. I almost hate to ask if part of the process could be repeated to make this work one time rather than having to go back into the database.Supposedly the first two statements in the script should have cleared all "necessary" data.

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;

But as ee at the end of those two lines is the statement LIMIT and some number. That means it will only do the delete action on the first two records that come back (whatever they may be) I guess I need to know that if the 1.3.x script is compared to the 1.5.x script will there be a different number of entries. If they are the same number of entries, does the program generate new database entries that should be removed?My guess is that the script for 1.5 didn't include everything that was in 1.3 and only covered what needed to change between the two using the system that worked for the author. You said that you tried to contact the author(s), which of the two authors did you talk with about this manufacturer's all module?

I talked with Alex Clarke but he said he is no longer working with zencart but he tried to assist me after I sent him DB details and last message I received was
"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.

You will need to compare the new structure with the SQL code and see where the discrepancies lie.
"

Since then I have not heard from him.


May be we can remove limit in first two lines as LIKE 'Manufacturers All Listing is mentioned so it will delete only these or may be increase limit to test.


If you can please let me know the compatible sql for 1.5 for TM so I can finish this today as I want to start working next on a module where customer can store their payment information for future like amazon etc. I am sourcing information on it but want to start after done with current because working on more than 1 is always confusing and cause issued of mixing files like I did in 1 post above.



Thank you.

[mc12345678]

PHP Version 5.2.17The Above SQL is for Manufacturers All plug in. I typed TM in error that's why I mentioned in next message to ignore first message. Testimonial Manager sql is giving same error and even TM side box is also showing this message now on live site"1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES' at line 1in:[select testimonials_id, testimonials_image, testimonials_title, testimonials_html_text, date_added from zen_testimonials_manager where status = 1 and language_id = 1 order by rand(), testimonials_title limit MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES]"with no site footer at bottom. If I turn off TM sidebox it will make footer to appear. Can you please rearrange TM SQL file so I can get this work ok?IN TM init.config.php file author mentioned :$messageStack->add('The auto-loader file '.DIR_FS_ADMIN.'includes/auto_loaders/config.tm.php has not been deleted. For this module to work you must delete the '.DIR_FS_ADMIN.'includes/auto_loaders/config.tm.php file manually. Before you post on the Zen Cart forum to ask, YES you are REALLY supposed to follow these instructions and delete the '.DIR_FS_ADMIN.'includes/auto_loaders/config.tm.php file.','error'); };If we delete autoloader it will not load TM to admin and if we keep it it gives column counts vs row count error. Thank you.

Hmm, so what version of SQL server is that? Because there is nothing special about the php version that would make these statements not work. I'll have to have a chat with the recent author. :) I think your system falls into what has been described the "rare" few, though the changes I made to the manufacturer's all module are the same that I have been coding recently because even though it is "more work" it seems to be the method that has to be used by more and more servers. As for the error message, at least one language define file has not been uploaded to your system or it can not be found. Perhaps try to upload the files again? (Sometimes a file doesn't actually make it to the server or errors part wy in transfer.) The define for MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES isn't present so that is why everything else after that doesn't work.

[mc12345678]

I talked with Alex Clarke but he said he is no longer working with zencart but he tried to assist me after I sent him DB details and last message I received was "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. You will need to compare the new structure with the SQL code and see where the discrepancies lie. "Since then I have not heard from him. May be we can remove limit in first two lines as LIKE 'Manufacturers All Listing is mentioned so it will delete only these or may be increase limit to test.If you can please let me know the compatible sql for 1.5 for TM so I can finish this today as I want to start working next on a module where customer can store their payment information for future like amazon etc. I am sourcing information on it but want to start after done with current because working on more than 1 is always confusing and cause issued of mixing files like I did in 1 post above. Thank you.

Is the needed fix a "one time" thing or is it something you need to be able to reproduce again?If I am not mistaken, the typical action for when the autoinstaller does not work as designed/corrected by Diva Vocals is to perform each action manually. I'll take a look again, but want to be sure that I understand all of the issues.As for the limit issue, right now only you would be able to tell me. If you were to drop all the tables in your database, reload your 1.3.9 data, then perform a database upgrade using zc_install, then look at the entries in those two tables related to this plugin and be able to tell what is "special" about them. I think we would find that there are options installed under 1.3 that are not shown in the 1.5 sql and that actually right now you probably have less options available on 1.5 than you do under 1.3. (Can you confirm this with your current setups?)

[jsarwar]

Hmm, so what version of SQL server is that? Because there is nothing special about the php version that would make these statements not work. I'll have to have a chat with the recent author. :) I think your system falls into what has been described the "rare" few, though the changes I made to the manufacturer's all module are the same that I have been coding recently because even though it is "more work" it seems to be the method that has to be used by more and more servers. As for the error message, at least one language define file has not been uploaded to your system or it can not be found. Perhaps try to upload the files again? (Sometimes a file doesn't actually make it to the server or errors part wy in transfer.) The define for MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES isn't present so that is why everything else after that doesn't work.

Software: MySQL
mysql Ver 14.12 Distrib 5.0.92, for pc-linux-gnu (i686) using readline 5.1


I have uploaded all TM files few times and just make sure again and all language files are uploaded correctly. But when try to access admin following error still exists.

""1136 Column count doesn't match value count at row 1
in:
[INSERT INTO zen_configuration VALUES (NULL, 'Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', '82', 1, NULL, now(), NULL, NULL)]
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 disappear if I delete auto_loader file in admin for testimonial manager but then also no Testimonial Manager module in admin.

[jsarwar]

Is the needed fix a "one time" thing or is it something you need to be able to reproduce again?If I am not mistaken, the typical action for when the autoinstaller does not work as designed/corrected by Diva Vocals is to perform each action manually. I'll take a look again, but want to be sure that I understand all of the issues.As for the limit issue, right now only you would be able to tell me. If you were to drop all the tables in your database, reload your 1.3.9 data, then perform a database upgrade using zc_install, then look at the entries in those two tables related to this plugin and be able to tell what is "special" about them. I think we would find that there are options installed under 1.3 that are not shown in the 1.5 sql and that actually right now you probably have less options available on 1.5 than you do under 1.3. (Can you confirm this with your current setups?)

After you sent me revised sql "Manufacturer all" Plugin is installed on ZC 1.5.0 and working ok now. The only difference I see is in sort order of rows. For example"

Zencart 1.3.9

Title Value Action
Display Empty Manufacturers 0
Display Manufacturer Image 1 Info
Display Manufacturer URL 0 Info
Manufacturers Per Row 4 Info
Manufacturer Image Width 100px Info
Manufacturer Image Height 100px Info


Zencart 1.5.0

Title Value Action
Manufacturer Image Width 100px
Manufacturer Image Height 100px Info
Display Manufacturer URL 1 Info
Manufacturers Per Row 4 Info
Display Empty Manufacturers 0 Info
Display Manufacturer Image 1 Info


So all options are still same for ZC 1.5 as you can see above.

I just need 1 time fix to have modules on my website ZC 1.5. And SQL you sent me here on forum can also help others to solve similar problems.

[mc12345678]

Software: MySQLmysql Ver 14.12 Distrib 5.0.92, for pc-linux-gnu (i686) using readline 5.1I have uploaded all TM files few times and just make sure again and all language files are uploaded correctly. But when try to access admin following error still exists. ""1136 Column count doesn't match value count at row 1in:[INSERT INTO zen_configuration VALUES (NULL, 'Number Of Testimonials to display in Testimonials Sidebox', 'MAX_DISPLAY_TESTIMONIALS_MANAGER_TITLES', '5', 'Set the number of testimonials to display in the Latest Testimonials box.', '82', 1, NULL, now(), NULL, NULL)]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 disappear if I delete auto_loader file in admin for testimonial manager but then also no Testimonial Manager module in admin.

Thank you for clearing this up in the above summary. Sorry I just recently awoke so memory is not fully engaged. :)

[mc12345678]

After you sent me revised sql "Manufacturer all" Plugin is installed on ZC 1.5.0 and working ok now. The only difference I see is in sort order of rows. For example"Zencart 1.3.9 Title Value Action Display Empty Manufacturers 0 Display Manufacturer Image 1 Info Display Manufacturer URL 0 Info Manufacturers Per Row 4 Info Manufacturer Image Width 100px Info Manufacturer Image Height 100px InfoZencart 1.5.0 Title Value Action Manufacturer Image Width 100px Manufacturer Image Height 100px Info Display Manufacturer URL 1 Info Manufacturers Per Row 4 Info Display Empty Manufacturers 0 Info Display Manufacturer Image 1 InfoSo all options are still same for ZC 1.5 as you can see above. I just need 1 time fix to have modules on my website ZC 1.5. And SQL you sent me here on forum can also help others to solve similar problems.

So, there is still the question of what specific entries did you have to manually delete to make this work? Can you compare the entries in the databases between the two versions? (Post the configuration and configuration_group table entries for this plugin?) I understand that there will be some things that are completely different, but looking to see what was wrong about the delete statements that didn't clear the settings expected.

[jsarwar]

So, there is still the question of what specific entries did you have to manually delete to make this work? Can you compare the entries in the databases between the two versions? (Post the configuration and configuration_group table entries for this plugin?) I understand that there will be some things that are completely different, but looking to see what was wrong about the delete statements that didn't clear the settings expected.

See attached. The only difference I can see in sort order and ids I think. Attachment 14275