joeyjgarcia

You might want to take a look at the code to see where it displays the options and see what field it is keying on to order the options, then all you have to do is change the "ORDER BY ..." clause to order by a different field. Joey

You need to give more information. Your link didn't show anything. You may have a database issue because when I click on a car it can't show anything. If you think it is my code, comment it out to see exactly which line causes the error. Joey

There must be a problem with the names of the Attribute Sets you created. I wonder if you entered a special character (such as an apostrophe) in the Set's name that wiped away the rest of the data in that line ( much like a SQL Injection Attack works). I would check your site's database for a table that is called "products_attributes_sets". Show all records in this table to see if the "products_attributes_sets_name" fields is blank in any record. If so, you might as well remove those Sets and re-add them without any special characters if possible. Joey

If it doesn't delete any set info then you're going to have duplicates where attributes already exist. Please be careful, what one person needs may not be what everyone needs. If you get it working and you want to offer it as an add-on to the Attribute Sets contribution make sure you make a separate contribution. The last person who made changes was never heard from again and introduced a lot of errors. Joey

Please try to give more information. Exactly which page did this happen on? What did you click on? Did you just install it and that's it? Did you add an Attribute Set at all? Was it ever working? Thanks. Joey

See previous post for a solution. Joey

see previous post for a solution. Joey

Ooops!!! That line was not supposed to make it in this contribution! That was added to my own web store for convenience. I guess this error was all on me, sorry. You can either choose one of the two options to get rid of the error. 1) Get rid of that piece of code that displays the Product Model next to the name of the product in the Product Attributes area (note I didn't say Attribute Sets area). 2) Add in the missing function that displays the Product Model next to hte name. To do Option 1 do this: o) Remove line 703 and change the following line 800 from this: <td class="smallText"> <?php echo $products_name_only; ?> [<?php echo $products_model_only; ?>] </td> to this: <td class="smallText"> <?php echo $products_name_only; ?>;</td> This should remove the error. To do Option 2 do this: In admin\includes\functions\general.php(line 508) add this function. function tep_get_products_model($product_id) { $product_query = tep_db_query("select products_model from " . TABLE_PRODUCTS . " where products_id = '" . (int)$product_id . "' "); $product = tep_db_fetch_array($product_query); return $product['products_model']; } This also should take care of this problem.

I saw your error and it looks like you've adopted sporkfu function. I don't believe I forgot function as sporkfu has suggested (but I may be wrong), I think sporkfu's function may be causing this error, and there may still be another error over and above his. Let me fix Dacotah's problem then that would make sporkfu's fix obsolete. I appreciate sporkfu's help; I have to look into this problem and report the cause. Thanks for the patience. Joey

I'm back to help everyone. I see there have been a few problems. I will have to discern whether there was truely a bug in my code or an installation error. If different people are installing it from scratch and are getting the same problem then I feel the problem is in my code somewhere. Either way, I want to help but just not tonight - it's too late now. I'll be checking back very soon. Joey

I don't know if osCOmmerce already works that way with a percent sign, if not it could be added in but I don't want to venture to add it in, mainly because it doesn't help me out (it's hard enough keeping up with this thread). I bet someone else has already created this though. Worst case, you could pay someone to add it in? Good Luck Joey

Can't see an obvious error, try identifying the exact line with a comment at the END of the line to show which is line 446. Joey

Not that I know of, but if you can send me more details (if possible) I'll look into it. Joey

Do you have the following variable set in the specified file? admin\includes\languages\english.php(240): define('IMAGE_CREATE_ATTRIBUTE_SET', 'Create Attribute Set'); Whenever you get a variable name in ALL CAPS it is the same problem, the variable was not defined or correctly defined. Joey

I know you fixed this problem by now, but it is easy to see the problem on line 58. Fresh eyes always make a difference. :-) Joey

You had me worried there for a second, but my install instructions were off my a couple of line number, instead of line 132 it should be line 134. I did a search for "$products_options_query" and found it. I have a freshly extracted version of osCommerce that I use strictly to get line numbers from an original copy of osCommerce 2.2 MS2, I don't use this copy at all and I don't install any contributions to it so line number 134 should be pretty close. I hope this helps. Joey

Yes, you are correct on your guess. I see that that can be a problem and I'll work on a fix for that. Unfortunately, I am strapped for time on a side project but I'll make it a priority to get this fixed. Thanks for posting this overlooked symptom of the feature. Joey

I'm sorry aalishan, I can't help you. Joey

I hope you aren't updating from version 3, because it can't be done without a lot of pain. I suggestion you totally uninstall version, reverting the way things were before you installed my contribution. If you have version 2.1 installed, then version 4 will installl fine. Did you look at the Table using a tool like phpMyAdmin? If you can find that table, then browse the contents of the table and you should be able to see the difference between an incorrect Attribute Set and a correct one by making sure they all look the same except the values, that is the format should look the same. Joey BTW, I created a version 4.1 but I haven't uploaded it yet. I changed it so that when you edit a product it displays the attribute set the product is using as text instead of in a drop-down list, this prevents accidentally unsetting the attribute set. There is still 1 drop-down list for adding a new attribute set. What is keeping me from uploading these changes is that I want to make it so that a user can add a bunch of attribute sets in one edit, instead of a bunch of edits. I'll try to get it done soon because I have a large project that fell into my lap that will keep me busy for months. Joey

Sorry for the delay, my power supply died and I just received my new one tonight. It is hard to picture what you want to do. I picture a product displayed on the product_info.php page with five options (which are drop-down lists), each list consists of a all the movie titles in that category ( can't see how this would be useful, but then again I don't understand a lot of things :)). You said: When you said "which take the attribute value from the above record" does that mean the selected item in the option list? I'll assume this is what you mean. next, you also said "and update all other records in that category - INSERT STATEMENT" . Are you going to update all the records or insert new records? You mention both actions in the same sentence. If you meant UPDATE what would you be changing for all the records in that category? Would you be using the selected item in the option? If so how? I assume you didn't mean INSERT, because that would really confuse me. Joey

I am assuming that db117028926 is your database. This is one of two possible causes: 1) You haven't created the TABLE_PRODUCTS_ATTRIBUTES_SETS table. or 2) You haven't correctly added the /catalog/admin/includes/database_tables.php Whenever you see text that is in all uppercase it is "constant variable" which should be translated to the actual table name. Hope this helps. Joey

This error was documented a page or 2 ago and also on page 6. When you fix this can you post the answer here because this comes up every once and a while. Thanks, Joey

When in doubt look at the values you have in the Attribute Set you have assigned to the products. Look in the products_attributes_sets table and look at the products_attributes_sets_values field for the problem set. This will tell the story. Joey

This was a good catch! I will release the change in my next release, but in the mean time here is the fix. Line 216 from products_attributes_sets.php if( $i == 0 ){ changed to this for the bug fix if( strlen($update_value) == 0 ){

Page 6 of this thread shows the same error and a solution. Joey