CE Phoenix Cart Forum

[Omar_one]

Hello Raiwa,
I just install the last version of ajax_attribute_manager on 1.0.8.7 and the attribute manage tab not shown when editing product, and all the tabs now they don't work example if I press on Product Images tab it will go to admin/index.php

thank you in advance
Omar

[raiwa]

I just checked again in a clean 1.0.8.7 and 1.0.8.8 shop and everything works like expected.

Does the Attribute Manager group show in the configuration menu?
Do you get any error message shown or logged?
"last version" is 4.3.1?
Is it a new Phoenix installation or has it been updated?
Do you have any other addon/modification added which may interfere on the catalog page?

[Omar_one]

Does the Attribute Manager group show in the configuration menu?

yes, Attribute Manager group show in the configuration

Do you get any error message shown or logged?
"last version" is 4.3.1?

yes it is 4.3.1 , there is one error

Code: Select all

PHP Fatal error:  DB: [1060] Duplicate column name 'sort_order' 
in /home/xxxx/public_html/xxxxx/includes/system/versioned/1.0.8.1/database_core.php on line 44

Is it a new Phoenix installation or has it been updated?
Do you have any other addon/modification added which may interfere on the catalog page?

updated , the main addon they are the supporters code
,, when I visit the admin->catalog-> editing products ..(its shown two header there )
the tabs what's comes with Phoenix installation(Product specific,Language specific and Product Images) they shown but when press on it it go the main admin page .. and the another tabs not show

[raiwa]

It seems there is a glitch for new installations in:
admin/attributeManager/classes/attributeManagerConfig.class.php line 180 change to:

Code: Select all

       if (mysqli_num_rows($db->query("SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='". DB_DATABASE . "' AND TABLE_NAME='products_attributes' AND COLUMN_NAME LIKE 'sort_order'")) != 1 ) {

Note: "!mysqli_num_rows" changed to "mysqli_num_rows" at the beginning and "== 1" changed to "!= 1" at the end
Although the original version works in my test store, it may be more stable for other DBs like this.

Please report back and I'll update the package with the fix.

[Omar_one]

It seems there is a glitch for new installations in:
admin/attributeManager/classes/attributeManagerConfig.class.php line 180 change to:

Code: Select all

       if (mysqli_num_rows($db->query("SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA='". DB_DATABASE . "' AND TABLE_NAME='products_attributes' AND COLUMN_NAME LIKE 'sort_order'")) != 1 ) {

Note: "!mysqli_num_rows" changed to "mysqli_num_rows" at the beginning and "== 1" changed to "!= 1" at the end
Although the original version works in my test store, it may be more stable for other DBs like this.

Please report back and I'll update the package with the fix.

The tabs not working still and there is on the error log file new error

Code: Select all

Duplicate column name 'sort_order' from <ALTER TABLE `am_attributes_to_templates` CHANGE `products_options_sort_order` `sort_order` INT(11) NULL DEFAULT '0';> 
in /home/xxxx/public_html/xxxxx/includes/system/versioned/1.0.8.1/database_core.php on line 44

when I press on any tab the url become like this

Code: Select all

/admin/#section_images_content

[raiwa]

A: Delete the column "products_options_sort_order" in the "am_attributes_to_templates" table
OR
B: Run the uninstall script and load again the Admin: Categories: Edit Product page

[Omar_one]

A: Delete the column "products_options_sort_order" in the "am_attributes_to_templates" table
OR
B: Run the uninstall script and load again the Admin: Categories: Edit Product page

Thank you, this fix the issue and now the tab show, but if I press save ,, the option saved but I get the blank page also if I press on the language flags as I have Multilanguage shop
I get blank page

Code: Select all

This page isn’t working xxxxx is currently unable to handle this request.
HTTP ERROR 500

and here is the error log file

Code: Select all

PHP Notice:  Undefined offset: 5 in /home/test/public_html/shop/admin/attributeManager/classes/attributeManager.class.php on line 238
Uncaught Error: Call to undefined method hook_admin_catalog_ajaxAttribManager::listen_productActionSave() 
in /home/test/public_html/shop/includes/hooks/admin/catalog/ajaxAttribManager.php:39
Stack trace:
#0 /home/test/public_html/shop/includes/system/versioned/1.0.8.1/hooks.php(150): hook_admin_catalog_ajaxAttribManager->listen_updateProductAction(Array)
#1 /home/test/public_html/shop/admin/includes/segments/process_action.php(19): hooks->cat('updateProductAc...')
#2 /home/test/public_html/shop/admin/catalog.php(32): require('/home/test/p...')
#3 {main}
  thrown in /home/test/public_html/shop/includes/hooks/admin/catalog/ajaxAttribManager.php on line 39

there is many Undefined offset errors just different offset no. like 5,8,4,3 but on same line 238

thank you in advance for your help
Omar

[Omar_one]

deleting the

Code: Select all

?>

in /home/test/public_html/shop/includes/hooks/admin/catalog/ajaxAttribManager.php on line 39

now I can save, and there is no any more the blank page, but still the errors

Code: Select all

PHP Notice:  Undefined offset: 5 in /home/test/public_html/shop/admin/attributeManager/classes/attributeManager.class.php 
on line 238

there is many Undefined offset errors just different offset no. like 5,8,4,3 but on same line 238

[raiwa]

A: Delete the column "products_options_sort_order" in the "am_attributes_to_templates" table
OR
B: Run the uninstall script and load again the Admin: Categories: Edit Product page

Thank you, this fix the issue and now the tab show, but if I press save ,, the option saved but I get the blank page also if I press on the language flags as I have Multilanguage shop
I get blank page

Code: Select all

This page isn’t working xxxxx is currently unable to handle this request.
HTTP ERROR 500

and here is the error log file

Code: Select all

PHP Notice:  Undefined offset: 5 in /home/test/public_html/shop/admin/attributeManager/classes/attributeManager.class.php on line 238
Uncaught Error: Call to undefined method hook_admin_catalog_ajaxAttribManager::listen_productActionSave() 
in /home/test/public_html/shop/includes/hooks/admin/catalog/ajaxAttribManager.php:39
Stack trace:
#0 /home/test/public_html/shop/includes/system/versioned/1.0.8.1/hooks.php(150): hook_admin_catalog_ajaxAttribManager->listen_updateProductAction(Array)
#1 /home/test/public_html/shop/admin/includes/segments/process_action.php(19): hooks->cat('updateProductAc...')
#2 /home/test/public_html/shop/admin/catalog.php(32): require('/home/test/p...')
#3 {main}
  thrown in /home/test/public_html/shop/includes/hooks/admin/catalog/ajaxAttribManager.php on line 39

there is many Undefined offset errors just different offset no. like 5,8,4,3 but on same line 238

thank you in advance for your help
Omar

This error:

hook_admin_catalog_ajaxAttribManager->listen_updateProductAction(Array)

shows that you are using version 3.4.0.
Please update to 3.4.2.

The notice errors are produced if you have no option/attribute value name entered. Check this and make sure all options/attributes values have a name.

[raiwa]

deleting the

Code: Select all

?>

in /home/test/public_html/shop/includes/hooks/admin/catalog/ajaxAttribManager.php on line 39

now I can save, and there is no any more the blank page, but still the errors

It's better to remove the ending "?>" but if it produces problems, you may have a blank line or blank space at the beginning of another file, maybe a language file. Check this.

On my test installation I have no problem with it.

but I get the blank page also if I press on the language flags as I have Multilanguage shop

Just checked and yes, the language buttons push back to the product listing. I'll have a look tomorrow.