many ���� 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?

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

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]

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.

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

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

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

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