Text only | Text with Images

coppermine-gallery.com/forum

Support => Older/other versions => cpg1.1d PHPnuke Support (deprecated) => Topic started by: cherub64 on October 12, 2003, 07:38:53 PM

Title: Error message
Post by: cherub64 on October 12, 2003, 07:38:53 PM
HI
I am trying to install coppermine to Nuke7 but on running the SQL i get this error any Ideas?

Error

SQL-query :  

ALTER TABLE `nuke_users` ADD `user_group_cp` INT( 11 ) DEFAULT '2' NOT NULL ,
ADD `user_active_cp` ENUM( 'YES', 'NO' ) DEFAULT 'YES' NOT NULL

MySQL said:


Duplicate column name 'user_active_cp'
Back

Please can someone help
Tracey
Title: You already have the column
Post by: yrret on October 12, 2003, 07:53:22 PM
MySQL is saying you already have the column in your table, so you cant add it. You must have installed a version of Coppermine before.

You can just delete the ALTER TABLE line for the nuke install and it should be ok. Please note that the line should end with a ";" (no quotes)
Text only | Text with Images