Adding Options to item Page Error

Store Builder Questions
1

I sell apparel on my current site and while trying to add my products to my cs-cart to get ready for opening the store, I decided to add my options. These being shirt size and shirt color.



When I add one (lets say “Size”) and click “create” it just gives me a blank page that says “Error_occurred”.



I can hit back and go back to the product. Refresh the product page and look at options. And whichever I just created (“Size”) is now there on the options page, and if I click it, it has random variants assigned.



First time I did it it said “White” as a variant. The second time I tried, I got “Red” and “Green”.



Really confused as to what it could possibly be doing. Help is much appreciated.

2

Tried clearing everything in var/cache/



Also optimized the database.



Issue still exists.

3

Migrated to a new host and vps account instead of shared host…same issue…

4

Have you checked the database in phpmyadmin in case one f the product_options tables is corrupt, do a check and repair see if that helps



John

5

[quote name='johnbol1' timestamp='1345884793' post='143603']

Have you checked the database in phpmyadmin in case one f the product_options tables is corrupt, do a check and repair see if that helps



John

[/quote]



Thanks for the possible help but unfortunately it was no solution.



I submitted it to the help desk simply because Ive tried several things to no avail.

6

I am pretty sure this is a bug in the bug tracker. There was also a fix for it.

7

[quote name='The Tool' timestamp='1345904309' post='143620']

I am pretty sure this is a bug in the bug tracker. There was also a fix for it.

[/quote]



Thanks for letting me know.



Went hunting and there is a fix…but apparently the fix posted is only “if you installed without demo products and before you add any of your own products”.



Well, I already have products added and need a fix.



But Im getting somewhere.



Link for anyone else with this issue: [url=“http://forum.cs-cart.com/tracker/issue-3389-global-options-cannot-save/”]http://forum.cs-cart.com/tracker/issue-3389-global-options-cannot-save/[/url]

8

So, in the bug section, the fix they created is this sql query



DELETE FROM cscart_category_descriptions;
DELETE FROM cscart_product_descriptions;
DELETE FROM cscart_product_feature_variant_descriptions;
DELETE FROM cscart_product_features_descriptions;
DELETE FROM cscart_product_features_values;
DELETE FROM cscart_product_filter_descriptions;
DELETE FROM cscart_product_filter_ranges_descriptions;
DELETE FROM cscart_product_option_variants_descriptions;
DELETE FROM cscart_product_options_descriptions;
DELETE FROM cscart_promotion_descriptions;




but they said dont do it if you've added stuff to your catalog…I get that it will erase product data.



But if I delete those products first, then run this, will it cause me any new issues when I go to add product back in?



Id really like to get this figured out since Ive not been able to do anything with getting my site ready to go live for almost 48 hours.

9

i might just have to friggin reinstall…ugh, not looking forward to that

10

[color=#282828][font=arial, verdana, tahoma, sans-serif][size=3]Alright, deleted my 3 products.[/size][/font][/color]



[color=#282828][font=arial, verdana, tahoma, sans-serif][size=3]Ran the clear script.[/size][/font][/color]



[color=#282828][font=arial, verdana, tahoma, sans-serif][size=3]It deleted my category titles but left the hierarchy. Deleted the hierarchy. Ran script again.[/size][/font][/color]



[color=#282828][font=arial, verdana, tahoma, sans-serif][size=3]Added category back in, added 1 product.[/size][/font][/color]



[color=#282828][font=arial, verdana, tahoma, sans-serif][size=3]Added options.[/size][/font][/color]



[color=#282828][font=arial, verdana, tahoma, sans-serif][size=3]SUCCESS![/size][/font][/color]



[color=#282828][font=arial, verdana, tahoma, sans-serif][size=3]Now onto the next problem…no shipping options ugh.[/size][/font][/color]