Jump to content

BrightSoul

Members
  • Posts

    2
  • Joined

  • Last visited

Profile Information

  • Activity
    Web development agency

BrightSoul's Achievements

Newbie

Newbie (1/14)

2

Reputation

  1. I think what you've done so far is correct, but still not enough. If you look at the schema of the ps_product table that's in your database, you'll notice that the condition field is of ENUM type which will allow just the new, used and refurbished values. If you try to update the field with any other value, MySql will use the default instead, which is new. So, try to ALTER that table to allow the exhibitioned value as well. Try this locally and then, only if it solves your problem, execute it on the live database. ALTER TABLE `ps_product` CHANGE COLUMN `condition` `condition` ENUM('new','used','refurbished','exhibitioned') NOT NULL DEFAULT 'new' AFTER `available_date`; Also, do the same to the ps_product_shop table. ALTER TABLE `ps_product_shop` CHANGE COLUMN `condition` `condition` ENUM('new','used','refurbished','exhibitioned') NOT NULL DEFAULT 'new' AFTER `available_date`;
×
×
  • Create New...