Originally Posted by
Ajeh
You would need to customize your database, in phpMyAdmin, and change the field length in the tables:
products
orders_products
on the field:
products_name
There is a products_name field under: orders_products and I was able to change that field. However, the data looks like it is holding orders that were already taken.
As far as the "products" field there is no "products_name" in the structure. Here is the structure of the "products" field:
Code:
products_id int(11) No None auto_increment
products_type int(11) No 1
products_quantity float No 0
products_model varchar(32) latin1_swedish_ci Yes NULL
products_image varchar(64) latin1_swedish_ci Yes NULL
products_price decimal(15,4) No 0.0000
products_virtual tinyint(1) No 0
products_date_added datetime No 0001-01-01 00:00:00
products_last_modified datetime Yes NULL
products_date_available datetime Yes NULL
products_weight float No 0
products_status tinyint(1) No 0
products_tax_class_id int(11) No 0
manufacturers_id int(11) Yes NULL
products_ordered float No 0
products_quantity_order_min float No 1
products_quantity_order_units float No 1
products_priced_by_attribute tinyint(1) No 0
product_is_free tinyint(1) No 0
product_is_call tinyint(1) No 0
products_quantity_mixed tinyint(1) No 0
product_is_always_free_shipping tinyint(1) No 0
products_qty_box_status tinyint(1) No 1
products_quantity_order_max float No 0
products_sort_order int(11) No 0
products_discount_type tinyint(1) No 0
products_discount_type_from tinyint(1) No 0
products_price_sorter decimal(15,4) No 0.0000
master_categories_id int(11) No 0
products_mixed_discount_quantity tinyint(1) No 1
metatags_title_status tinyint(1) No 0
metatags_products_name_status tinyint(1) No 0
metatags_model_status tinyint(1) No 0
metatags_price_status tinyint(1) No 0
metatags_title_tagline_status
Which field would I edit to lengthen? As of now it seems that I still have 64 characters and need it to be around 125.
I cannot find the "products_name" field under "products" and the "products_name" field under: "orders_products" seems to only change the previous orders that were taken (not the current products name field in the catalog). Please help!
Bookmarks