alex12 Posted March 20, 2007 Share Posted March 20, 2007 Hello, I installed Ajax Attribute manager 2.4 beta. It works very well except when i create a new product and put at the same time options; when i save for the first time this new product, these fields of the table products_attributes become 0: option_id options_value_id options_values_price. I must return in the product edition and put options one more time to the product. It's same with templates. Could you help me? Thank you. (sorry for the faults, my english is not so good) Quote Link to comment Share on other sites More sharing options...
Frank Heinen Posted March 22, 2007 Share Posted March 22, 2007 please install the update (V2.5 beta!) Quote Link to comment Share on other sites More sharing options...
Frank Heinen Posted March 22, 2007 Share Posted March 22, 2007 (edited) Someone should really really update all varnames. Options_id and option_id, options_values_id and options_value_id etc etc etc are easy to look over problems and where mostly the problems in V2.3 beta!!! Edited March 22, 2007 by Frank Heinen Quote Link to comment Share on other sites More sharing options...
Guest Posted March 23, 2007 Share Posted March 23, 2007 Someone should really really update all varnames. Options_id and option_id, options_values_id and options_value_id etc etc etc are easy to look over problems and where mostly the problems in V2.3 beta!!! Hello, I need some basic help with this contribution. I am running CRE-Loaded pro and I figured Id give this install a shot. I can go through the install sheet and find all of the parts of code in categories where I need to "add below" except for the one "onload="SetFocus();" so I left it out. My product details open up ok in admin but the Ajax attribute manager does not show up at all, no errors or anything. Anyone know how to set this up or what tweaks need to be made to get it to work with CRE loaded...after all, all Cre loaded is is oscommerce with a bunch of contributions installed....It should work with it. Quote Link to comment Share on other sites More sharing options...
roodbaard Posted March 23, 2007 Share Posted March 23, 2007 Hello, This is a realy good contrib! But I have 2 problems: 1. The first maked option is not useble due to a problem with the ID, the first ID = 0 and thats not ok. In the standard osc attribute manager the first option has always ID = 1 and tha't works fine. Anyone knows a (good) solution for this without the use of the standard manager? 2. Installing V2.4 Beta works OK but after installing the new 2.5 I've got this error: 1054 - Unknown column 'products_options_sort_order' in 'order clause' I think it's a problem with PHP 5 (runs on my server) But when I got back to V2.4 it works OK... Thanks in advance! Roodbaard Quote Link to comment Share on other sites More sharing options...
whodah Posted March 25, 2007 Share Posted March 25, 2007 2. Installing V2.4 Beta works OK but after installing the new 2.5 I've got this error: 1054 - Unknown column 'products_options_sort_order' in 'order clause' I think it's a problem with PHP 5 (runs on my server) But when I got back to V2.4 it works OK... I forget which table... But when I got this message, it told me which table it was barking at. I then added 'by hand' the column 'products_options_sort_order' as an INT of size 10. It kinda looks like it's looking for that table whether or not one has the sort option enabled or not... Quote Link to comment Share on other sites More sharing options...
whodah Posted March 25, 2007 Share Posted March 25, 2007 Hi,Does any one faced the following problem or know how to solve it? Please refer to the screen shot The characters should be in Cyrillic Alex Issue solved - just change in attributeManager.php header('Content-type: text/html; charset=ISO-8859-1'); to what coding you need Alex Thx for the tip, Alex! Thought I'd add: United States english, this should work as your header type: header('Content-type: text/html; charset=utf-8'); Quote Link to comment Share on other sites More sharing options...
alex_rus Posted March 25, 2007 Share Posted March 25, 2007 Hello, This is a realy good contrib! But I have 2 problems: 1. The first maked option is not useble due to a problem with the ID, the first ID = 0 and thats not ok. In the standard osc attribute manager the first option has always ID = 1 and tha't works fine. Anyone knows a (good) solution for this without the use of the standard manager? 2. Installing V2.4 Beta works OK but after installing the new 2.5 I've got this error: 1054 - Unknown column 'products_options_sort_order' in 'order clause' I think it's a problem with PHP 5 (runs on my server) But when I got back to V2.4 it works OK... Thanks in advance! Roodbaard In file attributeManagerConfig.class.php just find line $this->add('AM_USE_SORT_ORDER' - that is around line 59 In 2.5 it reads as $this->add('AM_USE_SORT_ORDER' , true); , and in 2.4 by default it is set to false, so just change it in 2.5 to $this->add('AM_USE_SORT_ORDER' , false); and there won't be any errors regarding Unknown column 'products_options_sort_order' in 'order clause' Alex Quote Link to comment Share on other sites More sharing options...
roodbaard Posted March 25, 2007 Share Posted March 25, 2007 OK! Thanx Alex! This soved the problem with the unknown column. The problem with the ID=0 is not solved with V2.5 :'( But we keep going on... Arjan Quote Link to comment Share on other sites More sharing options...
Brooke Posted March 25, 2007 Share Posted March 25, 2007 Hello, I need some basic help with this contribution. I am running CRE-Loaded pro and I figured Id give this install a shot. I can go through the install sheet and find all of the parts of code in categories where I need to "add below" except for the one "onload="SetFocus();" so I left it out. My product details open up ok in admin but the Ajax attribute manager does not show up at all, no errors or anything. Anyone know how to set this up or what tweaks need to be made to get it to work with CRE loaded...after all, all Cre loaded is is oscommerce with a bunch of contributions installed....It should work with it. check your 'attributeManager' folder for a .htaccess file. i tried out two versions of this contrib and both times i had to delete a .htaccess file that was in that folder. after i deleted it, everything showed up fine. the .htaccess format is a hidden file, so you will have to make sure your ftp program is set to show hidden files. Quote What? Yeah, I can do that. Link to comment Share on other sites More sharing options...
Guest Posted March 26, 2007 Share Posted March 26, 2007 I also am having the problem: 1054 - Unknown column 'products_options_sort_order' in 'order clause' but I am using the attribute sort feature. Neither 2.4 or 2.5 work for me. Had to go back to 2.3b. I would love to save the attribute sort order. Anybody have a solution? Quote Link to comment Share on other sites More sharing options...
slopface Posted March 27, 2007 Share Posted March 27, 2007 Hi Folks, I wondered if any of you guys have used the sort option in this awesome contrib in the product_info.php file? What I'm thinking of is that the attibutes are listed in the sequence/order that is entered in the catalog. Any advice? Thanks in advance, Thomas Quote Link to comment Share on other sites More sharing options...
Frank Heinen Posted March 27, 2007 Share Posted March 27, 2007 Sorry that I left the sort option on ON.... The sort option now works. Although that there are still problems in this module. I'm working on an update.... Quote Link to comment Share on other sites More sharing options...
slopface Posted March 27, 2007 Share Posted March 27, 2007 Hi Folks, I wondered if any of you guys have used the sort option in this awesome contrib in the product_info.php file? What I'm thinking of is that the attibutes are listed in the sequence/order that is entered in the catalog. Any advice? Thanks in advance, Thomas Soted out the problem myself :) In the QT Pro file pad_base.php in catalog->includes->classes Change the line around 317 from $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$this->products_id . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "'"); to $products_options_query = tep_db_query("select pov.products_options_values_id, pov.products_options_values_name, pa.options_values_price, pa.price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " pa, " . TABLE_PRODUCTS_OPTIONS_VALUES . " pov where pa.products_id = '" . (int)$this->products_id . "' and pa.options_id = '" . (int)$products_options_name['products_options_id'] . "' and pa.options_values_id = pov.products_options_values_id and pov.language_id = '" . (int)$languages_id . "' order by pa.products_options_sort_order"); /Thomas Quote Link to comment Share on other sites More sharing options...
roodbaard Posted March 28, 2007 Share Posted March 28, 2007 Sorry that I left the sort option on ON.... The sort option now works. Although that there are still problems in this module. I'm working on an update.... Thanks for that! This is such a good contrib!! I don't know if it's possible but it should be very usefull if there's a possibillity to enforce a customer to make a choice from the optionslist. I know there are a few contibs (actually little tricks..) that can do the job but none of them is a friendly solution for clients... they always need the help of a OsCommerce specialist to do it. If this is nice en good to implement it in this contrib it defintly is the BEST CONTRIB EVER!! Keep on the good work! Arjan Quote Link to comment Share on other sites More sharing options...
ThunderRoad Posted March 29, 2007 Share Posted March 29, 2007 First, I want to excuse me for my poor english. I tried to install this contribution three ways, and always had different errors. The last one is as follows: 1146 - Table 'mk.am_templates' doesn't exist select * from am_templates at left join am_attributes_to_templates aa2t using(template_id) order by at.template_id, aa2t.options_id, aa2t.option_values_id [TEP STOP] I don't know what I have to do, I'm going crazy....... :'( Thanks for your help Quote Link to comment Share on other sites More sharing options...
marcus76 Posted March 30, 2007 Share Posted March 30, 2007 hi, I Installed the latest version of this today and get this message when I edit an Item: 'Session not registered - You cant access this page directly' Brand spanking new install of OSC... Any ideas what this could be? Thanks Marcus Quote Link to comment Share on other sites More sharing options...
marcus76 Posted March 30, 2007 Share Posted March 30, 2007 wondering if it has anything to do with register globals ? Quote Link to comment Share on other sites More sharing options...
shlomoweb1 Posted April 3, 2007 Share Posted April 3, 2007 wondering if it has anything to do with register globals ? I downloaded from scratch oscommerce and have it register global off (PHP 5 don't allowed it on my server) the error I get is the following Warning: array_key_exists() [function.array-key-exists]: The first argument should be either a string or an integer in C:\Program Files\xampp\htdocs\catalog\admin\includes\functions\sessions.php on line 99 Warning: array_key_exists() [function.array-key-exists]: The first argument should be either a string or an integer in C:\Program Files\xampp\htdocs\catalog\admin\includes\functions\sessions.php on line 99 Warning: array_key_exists() [function.array-key-exists]: The first argument should be either a string or an integer in C:\Program Files\xampp\htdocs\catalog\admin\includes\functions\sessions.php on line 99 Warning: array_key_exists() [function.array-key-exists]: The first argument should be either a string or an integer in C:\Program Files\xampp\htdocs\catalog\admin\includes\functions\sessions.php on line 138 Warning: array_key_exists() [function.array-key-exists]: The first argument should be either a string or an integer in C:\Program Files\xampp\htdocs\catalog\admin\includes\functions\sessions.php on line 99 Warning: array_key_exists() [function.array-key-exists]: The first argument should be either a string or an integer in C:\Program Files\xampp\htdocs\catalog\admin\includes\functions\sessions.php on line 99 Warning: array_key_exists() [function.array-key-exists]: The first argument should be either a string or an integer in C:\Program Files\xampp\htdocs\catalog\admin\includes\functions\sessions.php on line 99 Warning: array_key_exists() [function.array-key-exists]: The first argument should be either a string or an integer in C:\Program Files\xampp\htdocs\catalog\admin\includes\functions\sessions.php on line 138 1054 - Unknown column 'products_options_sort_order' in 'order clause' select * from products_options where language_id='1' order by products_options_sort_order [TEP STOP] Quote Link to comment Share on other sites More sharing options...
Guest Posted April 4, 2007 Share Posted April 4, 2007 First off I want to compliment you on what appears to be a fabulous looking contribution :) That being said, I feel like a bit of a moron as I cannot get it to work. I have it all isntalled just fine, it displays fine with no errors, and at first glance appears to function. However I have set up an attribute with three different options, I add their prices: + 0.00 + 25.00 + 75.00 +475.00 To the base price, I save my object and it enters the attributes fine but it does not save the price changes. Do I need to save something or hit a button after entering this data? I had saved the template, but even when I recall that the fact is it recalls the attributes with no value attached to them. Thanks for your help, I do appreciate it. Regards, Billy Quote Link to comment Share on other sites More sharing options...
tigershark Posted April 4, 2007 Share Posted April 4, 2007 There is any option to make a sort order to the drop down Products Attributes ? it is very important to me. thanks, tigershark. P.S: if you know other Contribution that make it done, please post. Quote Link to comment Share on other sites More sharing options...
exspecto Posted April 4, 2007 Share Posted April 4, 2007 First off, just wanted to thank you for your efforts to make attributes not as much of a nightmare. My problem is this, I have the latest AJAX manager installed (2.5beta), and I have sorting turned on (or else attributes don't work). The bug I've found is that if you use the gray box below the manager to add a new Option>Value>Prefix>Price>Sort line, and you try to add a new "Option" by hitting the green + image, and put in a name like "Test Option" and leave the sort order dropdown as the default of "1", it adds the option with a name of "1". In other words, it somehow confuses the name of the option with the value in the sort order dropdown. I have to manually go to the attributes page and edit the name back to what it should be. I would think this is a bug. Any suggestions? Quote Link to comment Share on other sites More sharing options...
comsport Posted April 9, 2007 Share Posted April 9, 2007 Version 2.5 works for me only with firefox. With IE6 and Opera, doesn't work. I can see only a completely blank page. Does anyone has this problem? Quote Link to comment Share on other sites More sharing options...
Guest Posted April 13, 2007 Share Posted April 13, 2007 I forget which table... But when I got this message, it told me which table it was barking at. I then added 'by hand' the column 'products_options_sort_order' as an INT of size 10. It kinda looks like it's looking for that table whether or not one has the sort option enabled or not... holy crap! that worked!!! :D thanks Quote Link to comment Share on other sites More sharing options...
lieven Posted April 18, 2007 Share Posted April 18, 2007 Help needed. I installed version 2.3b and everything seems to work fine besides the fact that when you click the arrow to add the attribute to the list for the item it does nothing. I can the Option and the Value, but when I click the arrow icon to add, it does nothing. I have installed on another shop and it worked fine straight away. But this time it doesn't and it is a fresh install of the latest version of osCommerce with no other addons. Can someone help, please. I have exactly the same problem. I've got the contribution running on 2 shops. But in this instalation it doesn't work. Well, the contribution works, only the add button doesn't work. Quote Link to comment Share on other sites More sharing options...
New 
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.
Note: Your post will require moderator approval before it will be visible.