Jump to content
Nimmit

AJAX Attribute Manager support

Recommended Posts

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)

Share this post


Link to post
Share on other sites

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 by Frank Heinen

Share this post


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

Share this post


Link to post
Share on other sites

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

Share this post


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

Share this post


Link to post
Share on other sites
Hi,

Does any one faced the following problem or know how to solve it?

Please refer to the screen shot

 

pic-1.gif

 

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');

Share this post


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

Share this post


Link to post
Share on other sites

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

Share this post


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


What? Yeah, I can do that.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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....

Share this post


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

Share this post


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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

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?

Share this post


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

Share this post


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

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

×