Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

AJAX Attribute Manager support


Guest

Recommended Posts

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?

Link to comment
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 

Link to comment
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.

 

Link to comment
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.

Link to comment
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.

Link to comment
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
Link to comment
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?

 

 

Link to comment
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.

Link to comment
Share on other sites

Which version did you use?

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

Link to comment
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

Link to comment
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.

Link to comment
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
Link to comment
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

Link to comment
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

Link to comment
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.

Link to comment
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

Link to comment
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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...