Jump to content
Nimmit

AJAX Attribute Manager support

Recommended Posts

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

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites
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 

Share this post


Link to post
Share on other sites

 

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.

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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 by Patrick_R

Share this post


Link to post
Share on other sites

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?

 

 

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

Which version did you use?

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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 by raiwa

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

Share this post


Link to post
Share on other sites
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.

editing.png

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×