Language/Currency Links in Header

[NWCE]

Hi,

I am installing this addon into a fresh v.1.5.8 test site. I have uploaded all files and when running the SQLpatch from Admin, I get a white screen error and this in my Error Logs....

#1 trigger_error() called at [C:\wamp64\www\158\includes\classes\db\mysql\query_factory.php:667]
#2 queryFactory->show_error() called at [C:\wamp64\www\158\includes\classes\db\mysql\query_factory.php:634]
#3 queryFactory->set_error() called at [C:\wamp64\www\158\includes\classes\db\mysql\query_factory.php:275]
#4 queryFactory->Execute() called at [C:\wamp64\www\158\ADMIN\sqlpatch.php:297]
#5 executeSql() called at [C:\wamp64\www\158\ADMIN\sqlpatch.php:744]
#6 require(C:\wamp64\www\158\ADMIN\sqlpatch.php) called at [C:\wamp64\www\158\ADMIN\index.php:11]
--> PHP Fatal error: 1366:Incorrect integer value: '' for column 'configuration_id' at row 1 :: INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Show Languages in Header?', 'HEADER_LANGUAGES_DISPLAY', 'true', 'Display the Languages flags/links in Header?', 19, 170, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '); ==> (as called by) C:\wamp64\www\158\ADMIN\sqlpatch.php on line 297 <== in C:\wamp64\www\158\includes\classes\db\mysql\query_factory.php on line 667.

Can you point me the right direction to correct this to finish the install of this mod??

Thank you for your help,

Jeff

[lat9]

Hi,

I am installing this addon into a fresh v.1.5.8 test site. I have uploaded all files and when running the SQLpatch from Admin, I get a white screen error and this in my Error Logs....

#1 trigger_error() called at [C:\wamp64\www\158\includes\classes\db\mysql\query_factory.php:667]
#2 queryFactory->show_error() called at [C:\wamp64\www\158\includes\classes\db\mysql\query_factory.php:634]
#3 queryFactory->set_error() called at [C:\wamp64\www\158\includes\classes\db\mysql\query_factory.php:275]
#4 queryFactory->Execute() called at [C:\wamp64\www\158\ADMIN\sqlpatch.php:297]
#5 executeSql() called at [C:\wamp64\www\158\ADMIN\sqlpatch.php:744]
#6 require(C:\wamp64\www\158\ADMIN\sqlpatch.php) called at [C:\wamp64\www\158\ADMIN\index.php:11]
--> PHP Fatal error: 1366:Incorrect integer value: '' for column 'configuration_id' at row 1 :: INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Show Languages in Header?', 'HEADER_LANGUAGES_DISPLAY', 'true', 'Display the Languages flags/links in Header?', 19, 170, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), '); ==> (as called by) C:\wamp64\www\158\ADMIN\sqlpatch.php on line 297 <== in C:\wamp64\www\158\includes\classes\db\mysql\query_factory.php on line 667.

Can you point me the right direction to correct this to finish the install of this mod??

Thank you for your help,

Jeff

Change that SQL patch from

 INSERT INTO configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) VALUES ('', 'Show Languages in Header?', 'HEADER_LANGUAGES_DISPLAY', 'true', 'Display the Languages flags/links in Header?', 19, 170, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');

to

 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 ('Show Languages in Header?', 'HEADER_LANGUAGES_DISPLAY', 'true', 'Display the Languages flags/links in Header?', 19, 170, NULL, now(), NULL, 'zen_cfg_select_option(array(''true'', ''false''), ');

... essentially removing that configuration_id value that's invalid (the SQL processing will automatically calculate the next available value).

[NWCE]

Thanks very much for your help with this lat 9....this worked perfectly!!

Appreciate it,

Jeff

[pilou2]

Hello,
I made a release of this module for Zen Cart v1.5.8. I removed css file which was not doing as expected and I prefer a thin bar at the top (styles make it thicker). Language flag for the actually used language is not displayed any more, only other available languages flags are, Same thing with currencies.
It works well but I made a mistake in the release with sql queries for install/uninstall. I stupidly did copy these queries from old version when making new release file. They must be corrected as stated above by lat9.
Remove

configuration_id,

and

'',

and everything should be fine. I already submitted a corrected version few days ago but for any reason it has not been approved yet. Until it is available please do the modification above on sql queries.
This small plugin is really a 'plus' in any multilingual Zen Cart, you should try it.

[pilou2]

I have just submitted a version4.0.2 in plugin section that add a file for template Bootstrap which structure is quite different than standard templates.

[Jeff_Mash]

Perhaps I'm doing something wrong, but I tried the latest on a test Bootstrap site, and there's nothing being displayed in the header.

It looks like the code is there, but no output is displayed because it's nothing but white-space.

I am attaching two screenshots. The first shows that nothing is displayed (I highlighted it with a blue box). The second shows the page source where you can see the output block is there but only white-space is noted where the content should be.




Any ideas why that's happening?

[pilou2]

Perhaps I'm doing something wrong, but I tried the latest on a test Bootstrap site, and there's nothing being displayed in the header.

It looks like the code is there, but no output is displayed because it's nothing but white-space.

I am attaching two screenshots. The first shows that nothing is displayed (I highlighted it with a blue box). The second shows the page source where you can see the output block is there but only white-space is noted where the content should be.




Any ideas why that's happening?

Just to check, you need at least two languages/currencies installed for this to work. Actually used language/currency is not displayed.
It looks like something is missing. Did you installed files in template_default, they are necessary.

The only problem I found that still need to be fixed is color diplay for currencies. Default is blue (link) and does not go well with dark background.

[Jeff_Mash]

Okay, thanks for the clarification. I was under the assumption that the plugin itself would offer a dropdown list of translations and currencies. I wasn't aware that it relied on what already preexisted from the store. Now it makes sense why nothing was displayed, because we currently only have one currency (USD) and one language file (English).

[pilou2]

I have just submitted version 4.0.3 in plugin section:
https://www.zen-cart.com/downloads.php?do=file&id=30
It will now display currencies links in Bootstrap template in a visible color and you can easily customize this by modifying css file.
Instruction/descrition have been updated too.

[zamzom]

Great work thanks.
Is is possible to make the currencies appear in a pull-down menu?
How to do this?