Hi there ! Thanks ! I've installed the latest version of Coppermine. Then i've uploaded my databse. I'm going to admin menu and clicking "Update databse". Please, see the following list:
CREATE TABLE IF NOT EXISTS `cpg15x_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' Already Done
CREATE TABLE cpg15x_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' Already Done
ALTER TABLE cpg15x_filetypes DROP INDEX `EXTENSION`, ADD PRIMARY KEY ( `extension` ) Already Done
ALTER TABLE cpg15x_filetypes ADD `player` VARCHAR( 5 ) Already Done
ALTER TABLE cpg15x_filetypes CHANGE `mime` `mime` CHAR(254) default NULL Already Done
INSERT INTO cpg15x_filetypes VALUES ('001', 'application/001', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('7z', 'application/7z', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('arj', 'application/arj', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('bz2', 'application/bz2', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('cab', 'application/cab', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('lzh', 'application/lzh', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('rpm', 'application/rpm', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('tar', 'application/tar', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('z', 'application/z', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('odb', 'application/vnd.oasis.opendocument.database', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('odt', 'application/vnd.oasis.opendocument.text', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('ods', 'application/vnd.oasis.opendocument.spreadsheet', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('odp', 'application/vnd.oasis.opendocument.presentation', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('odg', 'application/vnd.oasis.opendocument.graphics', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('odc', 'application/vnd.oasis.opendocument.chart', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('odf', 'application/vnd.oasis.opendocument.formula', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('odi', 'application/vnd.oasis.opendocument.image', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('odm', 'application/vnd.oasis.opendocument.text-master', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('ott', 'application/vnd.oasis.opendocument.text-template', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('ots', 'application/vnd.oasis.opendocument.spreadsheet-template', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('otp', 'application/vnd.oasis.opendocument.presentation-template', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('otg', 'application/vnd.oasis.opendocument.graphics-template', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('otc', 'application/vnd.oasis.opendocument.chart-template', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('otf', 'application/vnd.oasis.opendocument.formula-template', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('oti', 'application/vnd.oasis.opendocument.image-template', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('oth', 'application/vnd.oasis.opendocument.text-web', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('sxw', 'application/vnd.sun.xml.writer', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('stw', 'application/vnd.sun.xml.writer.template', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('sxc', 'application/vnd.sun.xml.calc', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('stc', 'application/vnd.sun.xml.calc.template', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('sxd', 'application/vnd.sun.xml.draw', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('std', 'application/vnd.sun.xml.draw.template', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('sxi', 'application/vnd.sun.xml.impress', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('sti', 'application/vnd.sun.xml.impress.template', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('sxg', 'application/vnd.sun.xml.writer.global', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('sxm', 'application/vnd.sun.xml.math', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('docx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.document', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('docm', 'application/vnd.ms-word.document.macroEnabled.12', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('dotx', 'application/vnd.openxmlformats-officedocument.wordprocessingml.template', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('dotm', 'application/vnd.ms-word.template.macroEnabled.12', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('xlsx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('xlsm', 'application/vnd.ms-excel.sheet.macroEnabled.12', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('xltx', 'application/vnd.openxmlformats-officedocument.spreadsheetml.template', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('xltm', 'application/vnd.ms-excel.template.macroEnabled.12', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('xlsb', 'application/vnd.ms-excel.sheet.binary.macroEnabled.12', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('xlam', 'application/vnd.ms-excel.addin.macroEnabled.12', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('pptx', 'application/vnd.openxmlformats-officedocument.presentationml.presentation', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('pptm', 'application/vnd.ms-powerpoint.presentation.macroEnabled.12', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('ppsx', 'application/vnd.openxmlformats-officedocument.presentationml.slideshow', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('ppsm', 'application/vnd.ms-powerpoint.slideshow.macroEnabled.12', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('potx', 'application/vnd.openxmlformats-officedocument.presentationml.template', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('potm', 'application/vnd.ms-powerpoint.template.macroEnabled.12', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('ppam', 'application/vnd.ms-powerpoint.addin.macroEnabled.12', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('sldx', 'application/vnd.openxmlformats-officedocument.presentationml.slide', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('sldm', 'application/vnd.ms-powerpoint.slide.macroEnabled.12', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('thmx', 'application/vnd.ms-officetheme', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('onetoc', 'application/onenote', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('onetoc2', 'application/onenote', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('onetmp', 'application/onenote', 'document', '') Already Done
INSERT INTO cpg15x_filetypes VALUES ('onepkg', 'application/onenote', 'document', '') Already Done
INSERT INTO cpg15x_config VALUES ('global_registration_pw','') Already Done
INSERT INTO cpg15x_config VALUES ('picinfo_movie_download_link', '1') Already Done
INSERT INTO cpg15x_config VALUES ('site_token', MD5(RAND())) Already Done
INSERT INTO cpg15x_config VALUES ('form_token_lifetime', '900') Already Done
INSERT INTO cpg15x_config VALUES ('rating_stars_amount', '5') Already Done
INSERT INTO cpg15x_config VALUES ('old_style_rating', '0') Already Done
INSERT INTO cpg15x_config VALUES ('enable_watermark', '0') Already Done
INSERT INTO cpg15x_config VALUES ('where_put_watermark', 'southeast') Already Done
INSERT INTO cpg15x_config VALUES ('watermark_file', 'images/watermark.png') Already Done
INSERT INTO cpg15x_config VALUES ('which_files_to_watermark', 'both') Already Done
INSERT INTO cpg15x_config VALUES ('orig_pfx', 'orig_') Already Done
INSERT INTO cpg15x_config VALUES ('watermark_transparency', '40') Already Done
INSERT INTO cpg15x_config VALUES ('reduce_watermark', '0') Already Done
INSERT INTO cpg15x_config VALUES ('watermark_transparency_featherx', '0') Already Done
INSERT INTO cpg15x_config VALUES ('watermark_transparency_feathery', '0') Already Done
INSERT INTO cpg15x_config VALUES ('enable_thumb_watermark', '1') Already Done
INSERT INTO cpg15x_config VALUES ('enable_unsharp', '0') Already Done
INSERT INTO cpg15x_config VALUES ('unsharp_amount', '120') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('italian', 'Italian','Italiano','it','it', 'YES', 'YES') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('japanese', 'Japanese','日本語','jp','jp', 'YES', 'YES') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('kazakh', 'Kazakh','','kz','', 'NO', 'NO') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('korean', 'Korean','한국어','kr','', 'NO', 'NO') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('kurdish', 'Kurdish','كوردی','kurdish','', 'NO', 'NO') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('kyrgyz', 'Kyrgyz','','kg','', 'NO', 'NO') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('laothian', 'Laothian ','','la','', 'NO', 'NO') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('latvian', 'Latvian','Latvian','lv','', 'NO', 'NO') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('lithuanian', 'Lithuanian','Letzeburgisch','lu','', 'NO', 'NO') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('luxembourgish', 'Luxembourgish','Lietuvikai','lt','', 'YES', 'NO') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('macedonian', 'Macedonian','Македонски','mk','', 'NO', 'NO') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('malay', 'Malay','Bahasa Melayu','my','', 'NO', 'NO') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('maltese', 'Maltese','','mt','', 'NO', 'NO') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('mongolian', 'Mongolian','','mn','', 'NO', 'NO') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('nepali', 'Nepali','','np','', 'NO', 'NO') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('norwegian', 'Norwegian','Norsk','no','no', 'YES', 'NO') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('persian', 'Persian','فارسی','ir','', 'NO', 'NO') Already Done
INSERT INTO cpg15x_languages (lang_id, english_name, native_name, flag, abbr, available, complete) VALUES ('polish',
Update completed
It's recommended to check your file versions if you just upgraded from an older version of Coppermine. If you didn't (or you don't want to check), you can go to your gallery's start page.
... and more info, but there is limit 25 000 symbols...
I've places the old files at albums/userpics.
But there is still nothing on gallery - it's empty. Not a photos, user names etc.
Also, what file i need to edit and where it is placed (TYPE=MyISAM) ?