Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

AJAX Attribute Manager support


Guest

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)

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

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

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

Link to comment
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');

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

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

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

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

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

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

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

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

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

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

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

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

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

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