Jump to content

Mikepo

Members
  • Content count

    564
  • Joined

  • Last visited

  • Days Won

    7

Mikepo last won the day on May 8 2019

Mikepo had the most liked content!

Profile Information

  • Real Name
    Mike
  • Gender
    Male
  • Location
    GB

Recent Profile Visitors

12,678 profile views

Single Status Update

See all updates by Mikepo

  1. Hi Mike

    The database changes in 1.0.4.4 were increasing the varchars to 255. I created an update script for Gary but he's not included it in the package. You can use the following SQL.

    /* Update to existing installations adjusting VARCHARs to 255 in length */

    ALTER TABLE categories
    CHANGE COLUMN categories_image categories_image VARCHAR(255) NOT NULL;

    ALTER TABLE categories_description
    CHANGE COLUMN categories_name categories_name  VARCHAR(255) NOT NULL,
    CHANGE COLUMN categories_seo_keywords categories_seo_keywords VARCHAR(255) NOT NULL,
    CHANGE COLUMN categories_seo_title categories_seo_title  VARCHAR(255) NOT NULL;

    ALTER TABLE manufacturers
    CHANGE COLUMN manufacturers_name manufacturers_name VARCHAR(255) NOT NULL,
    CHANGE COLUMN manufacturers_image manufacturers_image VARCHAR(255);

    ALTER TABLE manufacturers_info
    CHANGE COLUMN manufacturers_seo_keywords manufacturers_seo_keywords VARCHAR(255)  NULL,
    CHANGE COLUMN manufacturers_seo_title manufacturers_seo_title VARCHAR(255) NULL;

    ALTER TABLE orders_products
    CHANGE COLUMN products_model products_model VARCHAR(255),
    CHANGE COLUMN products_name products_name VARCHAR(255) NOT NULL;

    ALTER TABLE orders_products_attributes
    CHANGE COLUMN products_options products_options VARCHAR(255) NOT NULL,
    CHANGE COLUMN products_options_values products_options_values VARCHAR(255) NOT NULL;

    ALTER TABLE products
    CHANGE COLUMN products_model products_model VARCHAR(255),
    CHANGE COLUMN products_image products_image VARCHAR(255);

    ALTER TABLE products_description
    CHANGE COLUMN products_name products_name VARCHAR(255) NOT NULL DEFAULT '',
    CHANGE COLUMN products_seo_keywords products_seo_keywords VARCHAR(255) NULL ,
    CHANGE COLUMN products_seo_title products_seo_title VARCHAR(255) NULL ;

    ALTER TABLE products_images
    CHANGE COLUMN image image VARCHAR(255);

    ALTER TABLE products_options
    CHANGE COLUMN products_options_name products_options_name VARCHAR(255) NOT NULL DEFAULT '';

    ALTER TABLE products_options_values
    CHANGE COLUMN products_options_values_name products_options_values_name VARCHAR(255) NOT NULL DEFAULT '';


    cheers

    Mark

    1. Mikepo

      Mikepo

      Thanks Mark, that saved be time!

      cheers

    2. mfleeson

      mfleeson

      No worries. The original git update to Gary had this script in but he didn't include it in the update.

    3. ecartz

      ecartz

      1.0.4.4 is available on GitHub, but for updates, the SQL is here. 

×