AJAX Attribute Manager support

[artfulweb 26]

Just now, raiwa said:

You may analize what's wrong in your data and fix it in your database.

All worked well in 1.0.7.12 so hopefully I can recover

[♥raiwa 1,472]

You should be more precise analysing things:

1 make sure to know if it's a problem with your attributes data

2 that it affects also core attributes page

3 or only the attributes manager

If 2: you should report in the Phoenix 1.0.7.14 thread

And: Did you check in attributes manager if the error persists with the applied  fix?

[artfulweb 26]

2 minutes ago, raiwa said:

You should be more precise analysing things:

1 make sure to know if it's a problem with your attributes data

2 that it affects also core attributes page

3 or only the attributes manager

If 2: you should report in the Phoenix 1.0.7.14 thread

And: Did you check in attributes manager if the error persists with the applied  fix?

Yes it does persist with the fix so I will take your advice and try to target my database as I did make multiple backups 

[Patrick_R 1]

 

On 2/4/2021 at 3:29 AM, raiwa said:

It’s missing in the products_attributes table, not products_options

Hello Rainer,

This is from the install  phoenix 1.0.7.14

DROP TABLE IF EXISTS products_attributes;
CREATE TABLE products_attributes (
  products_attributes_id int NOT NULL auto_increment,
  products_id int NOT NULL,
  options_id int NOT NULL,
  options_values_id int NOT NULL,
  options_values_price decimal(15,4) NOT NULL,
  price_prefix char(1) NOT NULL,
  PRIMARY KEY (products_attributes_id),
  KEY idx_products_attributes_products_id (products_id)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;

and

DROP TABLE IF EXISTS products_options;
CREATE TABLE products_options (
  products_options_id int NOT NULL default '0',
  language_id int NOT NULL default '1',
  products_options_name varchar(255) NOT NULL default '',
  sort_order int(3),
  PRIMARY KEY  (products_options_id,language_id)
) CHARACTER SET utf8 COLLATE utf8_unicode_ci;

the sort order appears to not be on the right table.

 

[♥raiwa 1,472]

Hello @Patrick_R

You are right. There got something messed up in the migration to core sort order support.

The old sort order addons and the attributes manager used the products_attributes table to give a product based sort order support.

The core sort order uses the products_options_values table instead.

I'll have a look and fix it.

[♥raiwa 1,472]

Uploaded with the sort order fix:

Ajax Attribute Manager 3.3.5

Compatibility:
Phoenix 1.0.7.14+
Tested with Phoenix 1.0.7.14
PHP 7.0 to 7.4

+ added install script for sort_order column in products_attributes table if missing. Thanks to @radhavallabh and @Patrick_R for the report
+ Added instructions to modify product info options attributes module's query to use product based attributes values sort order.

[Patrick_R 1]

Hey everyone,

Phoenix 1.0.7.14

prevent adding out of stock is set to false but no javascript pop up.

Does not matter if  qtpro in PI or content or with buy button in PI or content or combinations of both.

Double checked and PI_QTPRO_OPTIONS_NO_ADD_OUT_OF_STOCK in database is set to true.

Shopping_cart.php does show the stock warning and allows checkout.

Probably something about enabling javascript in my configurations but I can not find anything.

Also looking where to translate Out of stock in Mark Out of Stock Attributes

Thanks

Edited February 7, 2021 by Patrick_R

[zeeshop 5]

Phoenix: 1.0.7.14

PhP version : 7.4.14

@raiwa I installed and tested  AJAX Attribute Manager Phoenix  on test shop, and on its own it worked without any issue, then I uploaded and tried to install 

Options Images BS and get page with below error 

1060 - Duplicate column name 'sort_order'

ALTER TABLE products_attributes ADD sort_order int(11) NOT NULL default 0

[TEP STOP]

Attribute Manager is still working fine from Attribute manager, but image Options Images BS is not available.

 

<Catalog>  <product Attribute page> (http://site.com/admin/products_attributes.php) is showing below error:

Warning: Use of undefined constant TABLE_PRODUCTS_OPTIONS - assumed 'TABLE_PRODUCTS_OPTIONS' (this will throw an Error in a future version of PHP) in /homepages/31/d854685020/htdocs/Inaam/admin/products_attributes.php on line 290
1146 - Table 'dbs1248247.TABLE_PRODUCTS_OPTIONS' doesn't exist

SELECT COUNT(*) AS total from TABLE_PRODUCTS_OPTIONS where language_id = '1'

[TEP STOP]

1. Do I still need /admin/products_attributes.php) to use when ajax attribute manager seems to be working fine, if no how can I disable it.

2. How can I sort out Options Images BS  and use it?

 

 

[♥raiwa 1,472]

Hello @Patrick_R, hello @zeeshop,

First of all, your questions should be posted in the support threads of QtPro and Options Images. Even Attributes Manager includes support for them, the errors are primary in these Apps, not in Attributes Manager.

Second, both Apps are not updated yet for Phoenix 1.0.7.14. They are on my update list. Please be patient.

[villameschik 0]

Hi Rainer, I have installed AJAX Attribute Manager on Phoenix 1.0.7.12 but when I go to the products I only get a blank page, sorry but where am I wrong?

[♥raiwa 1,472]

Which version did you use?

Blank page doesn’t help. please check your error log and post the error.

[villameschik 0]

Hi, version: AJAX-AttributeManager-V3.3.5_CE_Phoenix

log error:

[error] [client 188.20.3.2] - www.meschikshop.com - AH01215: PHP Fatal error: Uncaught Error: Class 'Text' not found in /web/htdocs/www.meschikshop.com/home/admin/attributeManager/includes/attributeManagerHeader.inc.php:27: /web/htdocs/www.meschikshop.com/home/admin/categories.php, referer https://www.meschikshop.com/admin/categories.php?cPath=1_3

[Denzel 127]

Got:

1060 - Duplicate column name 'sort_order'

ALTER TABLE `am_attributes_to_templates` ADD(`sort_order` int default 0)

[TEP STOP]

on first product edit after update am from 3.3.2 to 3.3.5 on Phoenix 1.0.7.15. After reopen product edit it works as expected.

[♥raiwa 1,472]

25 minutes ago, villameschik said:

Hi, version: AJAX-AttributeManager-V3.3.5_CE_Phoenix

On 2/5/2021 at 12:19 PM, raiwa said:

Ajax Attribute Manager 3.3.5

Compatibility:
Phoenix 1.0.7.14+

Please use the correct version 3.3.3 for your store

Edited February 11, 2021 by raiwa

[♥raiwa 1,472]

9 minutes ago, Denzel said:

Got:

1060 - Duplicate column name 'sort_order'

ALTER TABLE `am_attributes_to_templates` ADD(`sort_order` int default 0)

[TEP STOP]

on first product edit after update am from 3.3.2 to 3.3.5 on Phoenix 1.0.7.15. After reopen product edit it works as expected.

Thanks. I’ll have a look on this

[villameschik 0]

44 minutes ago, raiwa said:

Please use the correct version 3.3.3 for your store

Hi, I'm sorry for the inconvenience, I have installed version 3.3.3 but the problem remains

[error] [client 188.20.3.2] - www.meschikshop.com - AH01215: PHP Fatal error: Uncaught Error: Class 'Text' not found in /web/htdocs/www.meschikshop.com/home/admin/attributeManager/includes/attributeManagerHeader.inc.php:30: /web/htdocs/www.meschikshop.com/home/admin/categories.php, referer https://www.meschikshop.com/admin/categories.php?cPath=1_3&pID=3

[♥raiwa 1,472]

Then please try 3.3.2.

[villameschik 0]

12 hours ago, raiwa said:

Then please try 3.3.2.

Good morning Rainer, I installed version 3.3.2, now I see the product page to edit again but I don't see "Attribute Manager, I can't understand my mistake, thank you for your patience.

[♥raiwa 1,472]

Make sure you have both admin hooks copied/uploaded to the right place.

You could also temporary remove the specifications addition to be sure it does not interfere.

[villameschik 0]

2 hours ago, raiwa said:

Make sure you have both admin hooks copied/uploaded to the right place.

You could also temporary remove the specifications addition to be sure it does not interfere.

Hi Rainer, he did specification interference, now he sees everything but I get this error:

Notice: Undefined offset: 1 in /web/htdocs/www.meschikshop.com/home/admin/attributeManager/classes/attributeManager.class.php on line 234
Notice: Undefined offset: 2 in /web/htdocs/www.meschikshop.com/home/admin/attributeManager/classes/attributeManager.class.php on line 234

[♥raiwa 1,472]

I believe this should be already fixed in the newer versions, It's anyway only a notice error which will not prevent it to work correct.

[♥Heatherbell 335]

32 minutes ago, villameschik said:

he sees everything

Change your admin directory to a different secure name - now!

[villameschik 0]

20 minutes ago, raiwa said:

Credo che questo dovrebbe essere già corretto nelle versioni più recenti, è comunque solo un errore di avviso che non gli impedirà di funzionare correttamente.

Thanks Rainer

[villameschik 0]

1 hour ago, Heatherbell said:

Change your admin directory to a different secure name - now!

done, thanks

[Fredi 104]

Hello @raiwa,

New updated russian file for AJAX Attribute Manager v3.3.5

attributeManager.zip