artfulweb Posted February 5, 2021 Share Posted February 5, 2021 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 Quote Link to comment Share on other sites More sharing options...
♥raiwa Posted February 5, 2021 Share Posted February 5, 2021 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? Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
artfulweb Posted February 5, 2021 Share Posted February 5, 2021 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 raiwa 1 Quote Link to comment Share on other sites More sharing options...
Patrick_R Posted February 5, 2021 Share Posted February 5, 2021 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 Quote Link to comment Share on other sites More sharing options...
♥raiwa Posted February 5, 2021 Share Posted February 5, 2021 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. Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
♥raiwa Posted February 5, 2021 Share Posted February 5, 2021 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. Heatherbell 1 Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
Patrick_R Posted February 7, 2021 Share Posted February 7, 2021 (edited) 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 Quote Link to comment Share on other sites More sharing options...
zeeshop Posted February 7, 2021 Share Posted February 7, 2021 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? Quote Link to comment Share on other sites More sharing options...
♥raiwa Posted February 8, 2021 Share Posted February 8, 2021 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. zeeshop 1 Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
villameschik Posted February 11, 2021 Share Posted February 11, 2021 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? Quote Link to comment Share on other sites More sharing options...
♥raiwa Posted February 11, 2021 Share Posted February 11, 2021 Which version did you use? Blank page doesn’t help. please check your error log and post the error. Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
villameschik Posted February 11, 2021 Share Posted February 11, 2021 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 Quote Link to comment Share on other sites More sharing options...
Denzel Posted February 11, 2021 Share Posted February 11, 2021 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. Quote Link to comment Share on other sites More sharing options...
♥raiwa Posted February 11, 2021 Share Posted February 11, 2021 (edited) 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 villameschik 1 Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
♥raiwa Posted February 11, 2021 Share Posted February 11, 2021 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 Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
villameschik Posted February 11, 2021 Share Posted February 11, 2021 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 Quote Link to comment Share on other sites More sharing options...
♥raiwa Posted February 11, 2021 Share Posted February 11, 2021 Then please try 3.3.2. villameschik 1 Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
villameschik Posted February 12, 2021 Share Posted February 12, 2021 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. Quote Link to comment Share on other sites More sharing options...
♥raiwa Posted February 12, 2021 Share Posted February 12, 2021 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 1 Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
villameschik Posted February 12, 2021 Share Posted February 12, 2021 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 Quote Link to comment Share on other sites More sharing options...
♥raiwa Posted February 12, 2021 Share Posted February 12, 2021 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. villameschik 1 Quote About Me: http://www.oscommerce.com/forums/user/249059-raiwa/ Need help? How To Get The Help You Need Is your version of osC up to date? You'll find the latest osC community version CE Phoenix here. Public Phoenix Change Log Cheat Set on Google Sheets Link to comment Share on other sites More sharing options...
♥Heatherbell Posted February 12, 2021 Share Posted February 12, 2021 32 minutes ago, villameschik said: he sees everything Change your admin directory to a different secure name - now! villameschik 1 Quote Link to comment Share on other sites More sharing options...
villameschik Posted February 12, 2021 Share Posted February 12, 2021 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 Quote Link to comment Share on other sites More sharing options...
villameschik Posted February 12, 2021 Share Posted February 12, 2021 1 hour ago, Heatherbell said: Change your admin directory to a different secure name - now! done, thanks Quote Link to comment Share on other sites More sharing options...
Fredi Posted February 14, 2021 Share Posted February 14, 2021 Hello @raiwa, New updated russian file for AJAX Attribute Manager v3.3.5 attributeManager.zip raiwa 1 Quote Support forum for osCommerce in russian language - from Ashkelon. Support since 2002.Best regards, Fredi Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.