|
MaGraham
Senior Member
USA
1297 Posts |
 Posted - 15 May 2013 : 22:45:49
|
Are these errors below (when installing the Photo Gallery Mod) a real problem?
dbs's Photo Gallery MOD for 3.4
Dropping Table..
Table dropped successfully
Creating table(s)...
CREATE TABLE FORUM_ALBUM_REPLY( REPLY_ID INT (11) NOT NULL auto_increment , CAT_ID int NULL , FORUM_ID int NULL , PHOTO_ID int NULL , R_MAIL smallint NULL , R_AUTHOR int NULL , R_MESSAGE text NULL , R_DATE varchar(14) NULL , R_IP varchar(15) NULL , R_STATUS smallint NULL , R_LAST_EDIT varchar(14) NULL , R_LAST_EDITBY int NULL , R_SIG int NULL ,KEY FORUM_ALBUM_REPLY_REPLY_ID(REPLY_ID))
Table created successfully
Dropping Table..
Table dropped successfully
Creating table(s)...
CREATE TABLE FORUM_ALBUM_FAVORITES( MEMBER_ID int NULL , PHOTO_ID int NULL )
Table created successfully
Adding Column PHOTO_DESC...
ALTER TABLE FORUM_ALBUM ALTER COLUMN PHOTO_DESC text NULL
ALTER TABLE FORUM_ALBUM ALTER COLUMN PHOTO_DESC text NULL
-2147217900 | [MySQL][ODBC 5.1 Driver][mysqld-5.5.28]You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'text NULL' at line 1
Adding Column PHOTO_TITLE...
ALTER TABLE FORUM_ALBUM ADD PHOTO_TITLE varchar(50) NULL
Column added successfully
Adding Column PHOTO_LOC...
ALTER TABLE FORUM_ALBUM ADD PHOTO_LOC varchar(50) NULL
Column added successfully
Adding Column PHOTO_EQUIP...
ALTER TABLE FORUM_ALBUM ADD PHOTO_EQUIP varchar(50) NULL
Column added successfully
Adding Column PHOTO_EXP...
ALTER TABLE FORUM_ALBUM ADD PHOTO_EXP varchar(50) NULL
Column added successfully
Adding Column PHOTO_FILM...
ALTER TABLE FORUM_ALBUM ADD PHOTO_FILM varchar(50) NULL
Column added successfully
Adding Column PHOTO_PAPER...
ALTER TABLE FORUM_ALBUM ADD PHOTO_PAPER varchar(50) NULL
Column added successfully
Adding Column UL_DTTM...
ALTER TABLE FORUM_ALBUM ADD UL_DTTM date NULL DEFAULT now()
ALTER TABLE FORUM_ALBUM ADD UL_DTTM date NULL DEFAULT now()
-2147467259 | [MySQL][ODBC 5.1 Driver][mysqld-5.5.28]Invalid default value for 'UL_DTTM'
Adding Column VIEWS...
ALTER TABLE FORUM_ALBUM ADD VIEWS int NULL DEFAULT 0
Column added successfully
UPDATE FORUM_ALBUM SET VIEWS=0
Populating Current Records with new Default value
Table(s) updated
|
"Do all the good you can, by all the means you can, in all the ways you can, at all the times you can, to all the people you can, as long as ever you can." - John Wesley |
|
