12 Character Max for Model Number!

[icx]

How can I change this. Any ideas???

[Guest]

edit that field in the db and increase the size to whatever you need it to be

[Guest]

You need to change it in the products table and the order_products table.

[Guest]

thank you for that pick up Luke :)

 

i forgot to mention the fields (sound of whacking the side of my head...)

[icx]

I see it now - didn't think about the DB

 

mysql> describe products;

+-------------------------+---------------+------+-----+---------------------+----------------+

| Field | Type | Null | Key | Default | Extra |

+-------------------------+---------------+------+-----+---------------------+----------------+

| products_id | int(11) | | PRI | NULL | auto_increment |

| products_quantity | int(4) | | | 0 | |

| products_model | varchar(12) | YES | | NULL | |

| products_image | varchar(64) | YES | | NULL | |

| products_price | decimal(15,4) | | | 0.0000 | |

| products_date_added | datetime | | MUL | 0000-00-00 00:00:00 | |

| products_last_modified | datetime | YES | | NULL | |

| products_date_available | datetime | YES | | NULL | |

| products_weight | decimal(5,2) | | | 0.00 | |

| products_status | tinyint(1) | | | 0 | |

| products_tax_class_id | int(11) | | | 0 | |

| manufacturers_id | int(11) | YES | | NULL | |

| products_ordered | int(11) | | | 0 | |

+-------------------------+---------------+------+-----+---------------------+----------------+

[Guest]

yes - and as Wayne mentioned and I overlooked, there are a couple of tables you need to edit this field in so the information carries across and does not get truncated