Snaf

[DrByte]

I wonder if that's a bug in the SNAF init_snaf.php installer, where it's trying to rename/renumber old configuration groups, and now when you're running the installer again it can't find the things it was originally renaming/renumbering.

It looks for "All listing" (not "All Listing", notice the caps).

BTW, the "upgrade" from v1.2 to v1.3 didn't require re-running the init_snaf installer, so bypassing the config.snaf.php file as you suggested, would be fine.

[carlwhat]

It looks for "All listing" (not "All Listing", notice the caps).

definitely looks like a bug....

i was unaware of this extension, despite having ranted at 1 point about having to maintain 4 different pages for what is essentially a different sql selection.

great idea for an extension and hopefully the ideas contained are part of base v1.6 (i have not looked at it of late...)

best.

[keneso]

Thank you carlwhat and DrByte

Being ignorant I would say it is a language problem during installation, as mentioned in my post https://www.zen-cart.com/showthread....naf/page28#276

Following is the result for the search as suggested.

Configuration Listino Generale Tutti i Prodotti - ID Gruppo di Default Attenzione: Modifica questo valore solamente se l'ID Gruppo Tutti i Prodotti è stato modificato dal valore default di 23
Qual è il configuration_group_id per la visualizzazione di Tutti i Prodotti ? PRODUCT_ALL_LIST_GROUP_ID 23

I Guess you know what it says (or supposed to say), anyhow following is the translation

Configuration General Lis/Index All Products - ID of Default Group Attention: Change this value only if the Group ID All Products has been changed from default value of 23
Which is the configuration_group_id for viewing All Products? PRODUCT_ALL_LIST_GROUP_ID 23

[carlwhat]

ok... small mistake on my part in:

https://www.zen-cart.com/showthread....57#post1339757

apologies...

change admin/includes/init_includes/init_snaf.php

line 95

//from
$sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title='All listing' LIMIT 1";
//to
$sql = "SELECT configuration_group_id FROM ".TABLE_CONFIGURATION_GROUP." WHERE configuration_group_title='All Listing' LIMIT 1"; 

should work...

let us know.

best.

[keneso]

Thank you.

No joy, getting same error when trying to login.

This is the error log:

[01-Jan-2018 18:35:45 Europe/London] Request URI: /shop/admin/login.php?camefrom=index.php
#1 trigger_error() called at [/public_html/shop/includes/classes/db/mysql/query_factory.php:167]
#2 queryFactory->show_error() called at [/public_html/shop/includes/classes/db/mysql/query_factory.php:139]
#3 queryFactory->set_error() called at [/public_html/shop/includes/classes/db/mysql/query_factory.php:266]
#4 queryFactory->Execute() called at [/public_html/shop/admin/includes/init_includes/init_snaf.php:111]
#5 require(/public_html/shop/admin/includes/init_includes/init_snaf.php) called at [/public_html/shop/includes/autoload_func.php:48]
#6 require(/public_html/shop/includes/autoload_func.php) called at [/public_html/shop/admin/includes/application_top.php:171]
#7 require(/public_html/shop/admin/includes/application_top.php) called at [/public_html/shop/admin/login.php:9]

[01-Jan-2018 18:35:45 Europe/London] PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ' 900, now(), now(), NULL, 'zen_cfg_select_option(array(''True'',''False''),')' at line 2 :: 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
(NULL, 'Use Product Listing Format for All Products', 'USE_PRODUCT_LISTING_FOR_ALL_PRODUCTS', 'False', 'Use Product Listing Format instead of the Default All Product Format <br/><br/>

[carlwhat]

my mistake... it does look like it is there...

give me a second...

[carlwhat]

ok... as you previously stated, this looks to be a language problem and specifically with the configuration_group table. i have no idea what ZC does with various language packs.

if you have phpMyadmin or some other access, we can look at the following sql commands and post the results:

SELECT * FROM `configuration_group` WHERE `configuration_group_title` = 'All listing';

SELECT * FROM `configuration_group` WHERE `configuration_group_id` = 23;

my sql command did NOT fail on the caps problem previously mentioned.

(if you make use of a db_prefix you would need to add that in from of the table name...)

alternatively, if you want to get past this problem, you can change:

admin/includes/init_includes/init_snaf.php

line 97:

//from
    $all_configuration_id = $result->fields['configuration_group_id'];
//to
    $all_configuration_id = 23; 

best.

[keneso]

These are the results



Will try the line 97 edit, and report.

[carlwhat]

the 0 results in the first query is the problem....

it's curious how it worked for the specials config... unless the italian is the same as the english.

the question is whether it will now work for new, featured and product_listing.

best.

[DrByte]

The Configuration and Configuration_Groups tables DO NOT SUPPORT MULTIPLE LANGUAGES directly*.

So, if you've renamed the titles then any script that's looking for the original english titles will fail. In the case of this SNAF plugin, it was built to lookup based on titles, and therefore only works on sites whose configuration titles and configuration_group titles haven't been altered.




* - there is a way to add custom language defines which will be used to replace the english titles for-display-purposes-only, but will NOT assist if the titles in the database have been altered.