Jump to content


Photo

Upgrader non fatal error


Board 322 to 334
Gallery 411 to 5B1

I can continue past this error however. :)

Step 1/14
This Module: 5.0.0 Beta 1

Error: ALTER TABLE ibf_gallery_comments CHANGE pid comment_id INT NOT NULL,
CHANGE edit_time comment_edit_time INT NOT NULL DEFAULT 0,
CHANGE author_id comment_author_id INT NOT NULL DEFAULT 0,
CHANGE author_name comment_author_name VARCHAR(255) NULL DEFAULT NULL,
CHANGE ip_address comment_ip_address VARCHAR(46) NULL DEFAULT NULL,
CHANGE post_date comment_post_date INT NOT NULL DEFAULT 0,
CHANGE comment comment_text TEXT NULL DEFAULT NULL,
CHANGE approved comment_approved TINYINT NOT NULL DEFAULT 0,
CHANGE img_id comment_img_id BIGINT NOT NULL DEFAULT 0,
ADD INDEX (comment_ip_address);

Data truncated for column 'comment_edit_time' at row 1


Status: Fixed
Version: 5.0.0 Beta 1
Fixed In: 5.0.0 Beta 1


2 Comments

Your strict mysql mode kills me sometimes lol. Really that isn't an issue and there's almost nothing I can find that we can do about it. I've changed the query to this to try to suppress the warning.

ALTER IGNORE TABLE gallery_comments CHANGE pid comment_id INT NOT NULL,
            CHANGE edit_time comment_edit_time INT NOT NULL DEFAULT 0,
            CHANGE author_id comment_author_id INT NOT NULL DEFAULT 0,
            CHANGE author_name comment_author_name VARCHAR(255) NULL DEFAULT NULL,
            CHANGE ip_address comment_ip_address VARCHAR(46) NULL DEFAULT NULL,
            CHANGE post_date comment_post_date INT NOT NULL DEFAULT 0,
            CHANGE comment comment_text TEXT NULL DEFAULT NULL,
            CHANGE approved comment_approved TINYINT NOT NULL DEFAULT 0,
            CHANGE img_id comment_img_id BIGINT NOT NULL DEFAULT 0,
            ADD INDEX (comment_ip_address);
Updating Fixed In to: 5.0.0 Beta 1
Updating Status to: Fixed

-