Thanks for your reply.
I hope I'm advanced enough to do that mysql manually, i will give it a try
This is a little log the output, it's not allowed to place more then 25000 characters:
CREATE TABLE IF NOT EXISTS `cpg14x_categorymap` ( cid int(11) NOT NULL, group_id int(11) NOT NULL, PRIMARY KEY (cid,group_id) ) COMMENT='Holds the categories where groups can create albums'
--------------------------------------------------------------------------------
Debug output:
Rows Affected: 0. MySQL said: Note (1050) Table 'cpg14x_categorymap' already exists
Already Done
CREATE TABLE cpg14x_temp_messages ( message_id varchar(80) NOT NULL default '', user_id int(11) default '0', time int(11) default NULL, message text NOT NULL, PRIMARY KEY (message_id) ) COMMENT='Used to store messages from one page to the other'
--------------------------------------------------------------------------------
Debug output:
MySQL said: Error (1050) Table 'cpg14x_temp_messages' already exists
Already Done
ALTER TABLE cpg14x_filetypes DROP INDEX `EXTENSION`, ADD PRIMARY KEY ( `extension` )
--------------------------------------------------------------------------------
Debug output:
Rows Affected: 0. MySQL said: Error (1142) ALTER command denied to user 'coppermine'@'localhost' for table 'cpg14x_filetypes'
Already Done
ALTER TABLE cpg14x_filetypes ADD `player` VARCHAR( 5 )
--------------------------------------------------------------------------------
Debug output:
Rows Affected: 0. MySQL said: Error (1142) ALTER command denied to user 'coppermine'@'localhost' for table 'cpg14x_filetypes'
Already Done
ALTER TABLE cpg14x_filetypes CHANGE `mime` `mime` CHAR(254) default NULL
--------------------------------------------------------------------------------
Debug output:
Rows Affected: 0. MySQL said: Error (1142) ALTER command denied to user 'coppermine'@'localhost' for table 'cpg14x_filetypes'
Already Done
INSERT INTO cpg14x_filetypes VALUES ('001', 'application/001', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Error (1062) Duplicate entry '001' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('7z', 'application/7z', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Error (1062) Duplicate entry '7z' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('arj', 'application/arj', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Error (1062) Duplicate entry 'arj' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('bz2', 'application/bz2', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Error (1062) Duplicate entry 'bz2' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('cab', 'application/cab', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Error (1062) Duplicate entry 'cab' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('lzh', 'application/lzh', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Error (1062) Duplicate entry 'lzh' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('rpm', 'application/rpm', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Error (1062) Duplicate entry 'rpm' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('tar', 'application/tar', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Error (1062) Duplicate entry 'tar' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('z', 'application/z', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Error (1062) Duplicate entry 'z' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('odb', 'application/vnd.oasis.opendocument.database', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'odb' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('odt', 'application/vnd.oasis.opendocument.text', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'odt' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('ods', 'application/vnd.oasis.opendocument.spreadsheet', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'ods' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('odp', 'application/vnd.oasis.opendocument.presentation', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'odp' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('odg', 'application/vnd.oasis.opendocument.graphics', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'odg' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('odc', 'application/vnd.oasis.opendocument.chart', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'odc' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('odf', 'application/vnd.oasis.opendocument.formula', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'odf' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('odi', 'application/vnd.oasis.opendocument.image', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'odi' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('odm', 'application/vnd.oasis.opendocument.text-master', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'odm' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('ott', 'application/vnd.oasis.opendocument.text-template', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'ott' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('ots', 'application/vnd.oasis.opendocument.spreadsheet-template', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'ots' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('otp', 'application/vnd.oasis.opendocument.presentation-template', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'otp' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('otg', 'application/vnd.oasis.opendocument.graphics-template', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'otg' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('otc', 'application/vnd.oasis.opendocument.chart-template', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'otc' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('otf', 'application/vnd.oasis.opendocument.formula-template', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'otf' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('oti', 'application/vnd.oasis.opendocument.image-template', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'oti' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('oth', 'application/vnd.oasis.opendocument.text-web', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'oth' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('sxw', 'application/vnd.sun.xml.writer', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Error (1062) Duplicate entry 'sxw' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('stw', 'application/vnd.sun.xml.writer.template', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'stw' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('sxc', 'application/vnd.sun.xml.calc', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Error (1062) Duplicate entry 'sxc' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('stc', 'application/vnd.sun.xml.calc.template', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'stc' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('sxd', 'application/vnd.sun.xml.draw', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Error (1062) Duplicate entry 'sxd' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('std', 'application/vnd.sun.xml.draw.template', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'std' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('sxi', 'application/vnd.sun.xml.impress', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'sxi' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('sti', 'application/vnd.sun.xml.impress.template', 'document', '')
--------------------------------------------------------------------------------
Debug output:
MySQL said: Warning (1265) Data truncated for column 'mime' at row 1
MySQL said: Error (1062) Duplicate entry 'sti' for key 1
Already Done
INSERT INTO cpg14x_filetypes VALUES ('sxg', 'application/vnd.sun.xml.writer.global', 'document', '')
--------------------------------------------------------------------------------