Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Increasing the size of attributes


jpweber

Recommended Posts

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

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

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...