Gidget Posted February 22, 2006 Posted February 22, 2006 I just don't get how the support works with osCommerce. I have posted a bug report, then created a post in this forum for the same problem on February 7th 2006. Not one has been addressed. (I did search the forums, before posting for simular problems. The ones that were close were not answered either.) I expected a moderator to at least point me in the right direction if another forum participant could not anwser my question. But that did not happen. This is what I don't get. It seems that there are not a lot of answers, but plenty of questions. Who is helping the people who need help? (or is THIS going to be another unanswered question?) Original post: http://www.oscommerce.com/forums/index.php?sho...78entry787378
digdug1 Posted February 22, 2006 Posted February 22, 2006 I've noticed the same thing. Not sure if anyone really understands some of these questions or if some are not interested in assisting others? Unsure which is the case. Our questions / problems are probably quite different, however I'm with you in spirit. DigDug1
OceanRanch Posted February 22, 2006 Posted February 22, 2006 Try this tutorial to make sure you set them up properly. http://www.demodemo.com/1/tutorials/osc_pr...tattributes.htm HTH Tom
Gidget Posted February 22, 2006 Author Posted February 22, 2006 OceanRanch thanks for the demo. I have set up everything properly. That is why I don't understand why the new option values are not showing up in the product attributes. Only about 12 option values out of the total 30 are showing up. About 11 old ones and 1 new one. It is strange and has no rhyme or reason. I can see all 30 option values in the option values area. Just not in the product attribute drop down.
myonlinegarage Posted February 22, 2006 Posted February 22, 2006 I just don't get how the support works with osCommerce. I have posted a bug report, then created a post in this forum for the same problem on February 7th 2006. Not one has been addressed. (I did search the forums, before posting for simular problems. The ones that were close were not answered either.) I expected a moderator to at least point me in the right direction if another forum participant could not anwser my question. But that did not happen. This is what I don't get. It seems that there are not a lot of answers, but plenty of questions. Who is helping the people who need help? (or is THIS going to be another unanswered question?) Original post: http://www.oscommerce.com/forums/index.php?sho...78entry787378 yea i get this too... i asked a question and 1 person answered but i needed alot more info but never got it.
Guest Posted February 22, 2006 Posted February 22, 2006 it may happen if your database got corrupted somehow. Can you export the broken products_options along with products_options_values_to_products_options tables with phpmyadmin and post them here? Or they are way too many? If so check the last products_options_id that was inserted. What's its value? (See the last page when you browse with phpmyadmin those tables)
Gidget Posted February 23, 2006 Author Posted February 23, 2006 it may happen if your database got corrupted somehow. Can you export the broken products_options along with products_options_values_to_products_options tables with phpmyadmin and post them here? Or they are way too many? If so check the last products_options_id that was inserted. What's its value? (See the last page when you browse with phpmyadmin those tables) I exported the tables associated with the product options. I included a column with a "y" for items that show up in the product attribute of the admin page. I am not sure why there are duplicates and only a few others that show up?? enigma1, do you have any ideas? products_options_values_to_products_options_id products_options_values_id products_options_values_name showing in list 159 159 gardenia y 162 162 aromatherapy ~ lavender y 164 164 macintosh apple 170 170 macadamia nut 176 176 aromatherapy ~ clarity (stress & headache relief) y 177 177 aromatherapy ~ joie de vivre (invigorating) y 178 178 aromatherapy ~ exhale (relaxing & soothing) y 219 158 cucumber melon y 220 159 gardenia y 221 160 green tea lemongrass y 222 161 juniper breeze y 223 162 aromatherapy ~ lavender y 224 163 lemon rosemary 225 164 macintosh apple 226 165 mango papaya 227 166 nag champa 228 167 orange lemongrass 229 168 orange vanilla 230 169 patchouli 231 170 macadamia nut 232 171 pomegranate 233 172 red currant 235 174 vanilla 236 175 vanilla grapefruit 237 176 aromatherapy ~ clarity (stress & headache relief) y 238 177 aromatherapy ~ joie de vivre (invigorating) y 239 178 aromatherapy ~ exhale (relaxing & soothing) y 240 179 magnolia 275 205 cilantro pineapple y 282 209 ginger & pear y 298 223 l'epice du coeur 311 236 tea & roses 319 244 white lily 327 252 unscented Thank you all for your help!!
Guest Posted February 23, 2006 Posted February 23, 2006 the identifiers seem ok but the tables aren't If you notice the options that show stop while following an alphabetical order. The last entry present is juniper breeze y And the next one is: l'epice du coeur Noticed the quote? When you retrieve the text it should add slashes to that. Well you can play with the script later. Delete that entry from all attributes related tables and see if it goes any further.
Gidget Posted February 23, 2006 Author Posted February 23, 2006 the identifiers seem ok but the tables aren't If you notice the options that show stop while following an alphabetical order. The last entry present is juniper breeze y And the next one is: l'epice du coeur Noticed the quote? When you retrieve the text it should add slashes to that. Well you can play with the script later. Delete that entry from all attributes related tables and see if it goes any further. OH MY GOD! THAT WORKED!!!! I LOVE YOU. LOL OK, I am getting a little carried away. But really, enigma1 Thank you so much! It was a simple mistake, but created a huge problem! Thank you again for replying and helping me all the way through my problem! Gidget
Guest Posted February 23, 2006 Posted February 23, 2006 so basically - when you type in anything into OsC, you can not use the ' mark? You should use // as a replacement? Is that why Gidget's attribute database messed up? Just making sure so I know what to look for - my products have a buttload of attributes (candle fragrances, essential oil fragrances, etc).
Guest Posted February 23, 2006 Posted February 23, 2006 so basically - when you type in anything into OsC, you can not use the ' mark? You should use // as a replacement? Is that why Gidget's attribute database messed up? Just making sure so I know what to look for - my products have a buttload of attributes (candle fragrances, essential oil fragrances, etc). no, you should be able to store whatever characters you want, there is probably no filtering in the products_attributes.php script somewhere, that needs to be fixed - haven't looked at it yet.
New 
Recommended Posts
Archived
This topic is now archived and is closed to further replies.