jpweber Posted September 15, 2006 Share Posted September 15, 2006 Hello all. I'm adding attributes, nothing overly fancy, but my attributes are like: 2.3"x 3.4" LED Low Profile Strobed Back/Frontlight; Self Cont; White; 50-425usec P/W This is 90 characters with spaces. What shows up on my site? 5" LED Strobed Ringlight; Self Cont; Near IR; 50-425usec P/W&nbs This is 64 characters with spaces. So I went into my phpmyadmin, backed up, and tinkered with customers_basket_attributes (products_options_values_text), as well as orders_products_attributes (products_options, and products_options_values). These were set to VARCHAR(32), and I changed them to VARCHAR(90) and eventually VARCHAR(255). My attributes are still being cut off, however, and are still showing up incomplete. Can anyone recommend anything I can possibly do in order to get the complete attribute listed in its entirety? Thanks a bunch, Jason Simple 1-2-3 Intructions on how to get, install and configure SSL The Google Sandbox explained Simple to follow instructions on how to change the look of your OSC How To Make A Horrible OSC Website my toolbox: All things WordPress-related - All things Adobe-related - PHP Designer 2007 - Codecanyon Junkie - Crimson Editor - Winmerge - phpMyAdmin - WS_FTP my installed contributions: Category Banners, File Upload feature-.77, Header Tags, Sort_Product_Attributes_1, XSellv2.3, Price Break 1.11.2, wishlist 3.5, rollover_category_images_v1.2, Short_Description_v2.1, UPSXML_v1_2_3, quickbooks qbi_v2_10, allprods v4.4, Mouseover-effect for image-buttons 1.0, Ultimate_SEO, AAP 1.41, Auto Select State Value, Fast Easy Checkout, Dynamic SiteMap v2.0, Image Magic, Links Manager 1.14, Featured Products, Customer Testimonials, Article Manager, FAQ System, and I'm sure more ... Link to comment Share on other sites More sharing options...
jpweber Posted September 15, 2006 Author Share Posted September 15, 2006 Figured it out just messing with phpmyadmin. The answer? Go into phpmyadmin, then to your products_options_values table. The products_options_values_name is default VARCHAR(64). I changed it to VARCHAR(100). Problem solved (or so it seems). Jason Simple 1-2-3 Intructions on how to get, install and configure SSL The Google Sandbox explained Simple to follow instructions on how to change the look of your OSC How To Make A Horrible OSC Website my toolbox: All things WordPress-related - All things Adobe-related - PHP Designer 2007 - Codecanyon Junkie - Crimson Editor - Winmerge - phpMyAdmin - WS_FTP my installed contributions: Category Banners, File Upload feature-.77, Header Tags, Sort_Product_Attributes_1, XSellv2.3, Price Break 1.11.2, wishlist 3.5, rollover_category_images_v1.2, Short_Description_v2.1, UPSXML_v1_2_3, quickbooks qbi_v2_10, allprods v4.4, Mouseover-effect for image-buttons 1.0, Ultimate_SEO, AAP 1.41, Auto Select State Value, Fast Easy Checkout, Dynamic SiteMap v2.0, Image Magic, Links Manager 1.14, Featured Products, Customer Testimonials, Article Manager, FAQ System, and I'm sure more ... Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.