AJAX Attribute Manager

v4.4 - error_log - AJAX Attribute Manager

v4.4 - error_log

by PiLLaO » Fri Nov 13, 2026 11:19 am

Hi Rainer,

I just install on a fresh v1.1.0.8 and get this on error_log

Code: Select all

[13-Nov-2026 12:15:59 Europe/Madrid] PHP Fatal error:  Uncaught mysqli_sql_exception: 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 '' at line 2 in catalog/includes/system/versioned/1.0.8.1/database_core.php:63
Stack trace:
#0 catalog/includes/system/versioned/1.0.8.1/database_core.php(63): mysqli->query()
#1 catalog/admin/attributeManager/classes/attributeManagerConfig.class.php(248): database_core->query()
#2 catalog/admin/attributeManager/classes/attributeManagerConfig.class.php(70): attributeManagerConfig->updateAttributeManager()
#3 catalog/admin/attributeManager/classes/attributeManagerConfig.class.php(270): attributeManagerConfig->__construct()
#4 catalog/admin/attributeManager/includes/attributeManagerPlaceHolder.inc.php(26): require_once('/home/...')
#5 catalog/includes/hooks/admin/catalog/ajaxAttribManager.php(32): include('/home/...')
#6 catalog/includes/system/versioned/1.0.8.1/hooks.php(150): hook_admin_catalog_ajaxAttribManager->listen_productTab()
#7 catalog/admin/includes/actions/catalog/views/new_product.php(474): hooks->cat()
#8 catalog/admin/catalog.php(48): require('/home/...')
#9 {main}
  thrown in catalog/includes/system/versioned/1.0.8.1/database_core.php on line 63
[13-Nov-2026 12:16:05 Europe/Madrid] PHP Warning:  Undefined array key "products_options_track_stock" in catalog/admin/attributeManager/classes/attributeManager.class.php on line 209
[13-Nov-2026 12:16:05 Europe/Madrid] PHP Warning:  Undefined array key "products_options_track_stock" in catalog/admin/attributeManager/classes/attributeManager.class.php on line 209
PiLLaO
100+
Posts: 151
Joined: Thu Nov 05, 2020 9:28 pm
Phoenix Version: v1.1.0.6
Contact:

Re: v4.4 - error_log

by raiwa » Fri Nov 13, 2026 11:42 am

Hi Gustavo,

I checked and can't reproduce the error.
It seems you have in the configuration support for QtPro enabled. Make sure you have QtPro installed or switch off the QtPro support setting in the Attribute Manager configuration.

Best wishes
Rainer
Public Phoenix Change Log Cheat Set on Google Sheets
https://docs.google.com/spreadsheets/d/ ... sp=sharing
raiwa
Certified Developer
Posts: 1686
Joined: Sat Dec 21, 2019 8:08 am
Phoenix Version: 1.1.0.6
Contact:

Re: v4.4 - error_log

by PiLLaO » Fri Nov 13, 2026 12:21 pm

Hi Rainer, fresh v1.1.0.8 and only installed Ajax Attribute Manager
PiLLaO
100+
Posts: 151
Joined: Thu Nov 05, 2020 9:28 pm
Phoenix Version: v1.1.0.6
Contact:

Re: v4.4 - error_log

by PiLLaO » Fri Nov 13, 2026 12:39 pm

On catalog/admin/attributeManager/classes/attributeManagerConfig.class.php

Replacing:

Code: Select all

    if ( !defined('AM_USE_ATR_STOCK') ) {
      $db->query("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
									('Use Attributes Stock', 'AM_USE_ATR_STOCK', 'false', 'Use Attributes Stock plugin?', '" . $group_id . "', '1', now(), null, '" . $db->escape("Config::select_one(array('true', 'false'), ") . "'),
                 ");
    }
By this:

Code: Select all

    if ( !defined('AM_USE_ATR_STOCK') ) {
      $db->query("INSERT INTO configuration (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, date_added, use_function, set_function) VALUES
									('Use Attributes Stock', 'AM_USE_ATR_STOCK', 'false', 'Use Attributes Stock plugin?', '" . $group_id . "', '1', now(), null, '" . $db->escape("Config::select_one(array('true', 'false'), ") . "');
                 ");
    }
Change ',' for ';' remove the mysqli error, warnings still
PiLLaO
100+
Posts: 151
Joined: Thu Nov 05, 2020 9:28 pm
Phoenix Version: v1.1.0.6
Contact:

Re: v4.4 - error_log

by raiwa » Sat Nov 14, 2026 9:40 am

Thanks Gustavo,

Applied on the 4.5 version update together with more fixes.
Public Phoenix Change Log Cheat Set on Google Sheets
https://docs.google.com/spreadsheets/d/ ... sp=sharing
raiwa
Certified Developer
Posts: 1686
Joined: Sat Dec 21, 2019 8:08 am
Phoenix Version: 1.1.0.6
Contact: