Dear CPG users,
upgradet my gallery today to the latest version of CPG and uploaded the modpack by Stramm.
Unfortunately I do receive a "
Fatal error":
Quote
While executing query "SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.avatar_url AS avatar_url, u.enable_admin_email AS notify, u.auto_subscribe_post AS auto_subscribe_post, u.auto_subscribe_comment AS auto_subscribe_comment, u.user_group+100 AS group_id FROM `db34341`.shoots_users AS u INNER JOIN `db34341`.shoots_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1'" on Resource id #5
mySQL error: Unknown column 'u.avatar_url' in 'field list'
What did I do wrong?
What do I have to change?
Thank you in advance, Phil
you didn't run update.php.. has been asked here in this forum and it's in the install howto
http://forum.coppermine-gallery.net/index.php?topic=35214.0
http://forum.coppermine-gallery.net/index.php?topic=28367.0
QuoteInstallation:
Before you do anything make a backup of your files and your database!!!!!!
Unpack and upload the files in the archive. Keep the folder structure intact. Then run update.php .... done (you'll get a fatal error if you open the index without running update.php)
If you have a bridged Coppermine rerun the bridgemanager
Thank you for your reply!
I did run update.php and searched the forum for a solution befor I asked for help:
Quote
CREATE TABLE IF NOT EXISTS shoots_sessions ( session_id varchar(40) NOT NULL default '', user_id int(11) default '0', time int(11) default NULL, remember int(1) default '0', PRIMARY KEY (session_id) ) TYPE=MyISAM COMMENT='Used to store sessions' OK
CREATE TABLE IF NOT EXISTS shoots_filetypes ( extension char(7) NOT NULL default '', mime char(30) default NULL, content char(15) default NULL, KEY extension (extension) ) TYPE=MyISAM COMMENT='Used to store the file extensions' OK
ALTER TABLE `shoots_filetypes` DROP INDEX `EXTENSION`, ADD PRIMARY KEY ( `extension` ) Already Done
ALTER TABLE `shoots_filetypes` ADD `player` VARCHAR( 5 ) Already Done
INSERT INTO shoots_filetypes VALUES ('jpg', 'image/jpg', 'image', '') Already Done
INSERT INTO shoots_filetypes VALUES ('jpeg', 'image/jpeg', 'image', '') Already Done
INSERT INTO shoots_filetypes VALUES ('jpe', 'image/jpe', 'image', '') Already Done
INSERT INTO shoots_filetypes VALUES ('gif', 'image/gif', 'image', '') Already Done
INSERT INTO shoots_filetypes VALUES ('png', 'image/png', 'image', '') Already Done
INSERT INTO shoots_filetypes VALUES ('psd', 'image/psd', 'image', '') Already Done
INSERT INTO shoots_filetypes VALUES ('bmp', 'image/bmp', 'image', '') Already Done
INSERT INTO shoots_filetypes VALUES ('jpc', 'image/jpc', 'image', '') Already Done
INSERT INTO shoots_filetypes VALUES ('jp2', 'image/jp2', 'image', '') Already Done
INSERT INTO shoots_filetypes VALUES ('jpx', 'image/jpx', 'image', '') Already Done
INSERT INTO shoots_filetypes VALUES ('jb2', 'image/jb2', 'image', '') Already Done
INSERT INTO shoots_filetypes VALUES ('swc', 'image/swc', 'image', '') Already Done
INSERT INTO shoots_filetypes VALUES ('iff', 'image/iff', 'image', '') Already Done
UPDATE shoots_config SET value='ALL' WHERE name='allowed_img_types' OK
INSERT INTO shoots_filetypes VALUES ('asf', 'video/x-ms-asf', 'movie', 'WMP') Already Done
INSERT INTO shoots_filetypes VALUES ('asx', 'video/x-ms-asx', 'movie', 'WMP') Already Done
INSERT INTO shoots_filetypes VALUES ('mpg', 'video/mpeg', 'movie', 'WMP') Already Done
INSERT INTO shoots_filetypes VALUES ('mpeg', 'video/mpeg', 'movie', 'WMP') Already Done
INSERT INTO shoots_filetypes VALUES ('wmv', 'video/x-ms-wmv', 'movie', 'WMP') Already Done
INSERT INTO shoots_filetypes VALUES ('swf', 'application/x-shockwave-flash', 'movie', 'SWF') Already Done
INSERT INTO shoots_filetypes VALUES ('avi', 'video/avi', 'movie', 'WMP') Already Done
INSERT INTO shoots_filetypes VALUES ('mov', 'video/quicktime', 'movie', 'QT') Already Done
INSERT INTO shoots_config VALUES ('allowed_mov_types', 'ALL') Already Done
INSERT INTO shoots_filetypes VALUES ('mp3', 'audio/mpeg3', 'audio', 'WMP') Already Done
INSERT INTO shoots_filetypes VALUES ('midi', 'audio/midi', 'audio', 'WMP') Already Done
INSERT INTO shoots_filetypes VALUES ('mid', 'audio/midi', 'audio', 'WMP') Already Done
INSERT INTO shoots_filetypes VALUES ('wma', 'audio/x-ms-wma', 'audio', 'WMP') Already Done
INSERT INTO shoots_filetypes VALUES ('wav', 'audio/wav', 'audio', 'WMP') Already Done
INSERT INTO shoots_filetypes VALUES ('ogg', 'audio/ogg', 'audio', '') Already Done
INSERT INTO shoots_config VALUES ('allowed_snd_types', 'ALL') Already Done
INSERT INTO shoots_filetypes VALUES ('ram', 'audio/x-pn-realaudio', 'document', 'RMP') Already Done
INSERT INTO shoots_filetypes VALUES ('ra', 'audio/x-realaudio', 'document', 'RMP') Already Done
INSERT INTO shoots_filetypes VALUES ('rm', 'audio/x-realmedia', 'document', 'RMP') Already Done
INSERT INTO shoots_filetypes VALUES ('tiff', 'image/tiff', 'document', '') Already Done
INSERT INTO shoots_filetypes VALUES ('tif', 'image/tif', 'document', '') Already Done
INSERT INTO shoots_filetypes VALUES ('doc', 'application/msword', 'document', '') Already Done
INSERT INTO shoots_filetypes VALUES ('txt', 'text/plain', 'document', '') Already Done
INSERT INTO shoots_filetypes VALUES ('rtf', 'text/richtext', 'document', '') Already Done
INSERT INTO shoots_filetypes VALUES ('pdf', 'application/pdf', 'document', '') Already Done
INSERT INTO shoots_filetypes VALUES ('xls', 'application/excel', 'document', '') Already Done
INSERT INTO shoots_filetypes VALUES ('pps', 'application/powerpoint', 'document', '') Already Done
INSERT INTO shoots_filetypes VALUES ('ppt', 'application/powerpoint', 'document', '') Already Done
INSERT INTO shoots_filetypes VALUES ('zip', 'application/zip', 'document', '') Already Done
INSERT INTO shoots_filetypes VALUES ('rar', 'application/rar', 'document', '') Already Done
INSERT INTO shoots_filetypes VALUES ('gz', 'application/gz', 'document', '') Already Done
INSERT INTO shoots_filetypes VALUES ('mdb', 'application/msaccess', 'document', '') Already Done
INSERT INTO shoots_config VALUES ('allowed_doc_types', 'ALL') Already Done
UPDATE shoots_filetypes SET player='WMP' WHERE extension IN ('asf','asx','mpg','mpeg','wmv','avi','mp3','midi','mid','wma','wav') OK
UPDATE shoots_filetypes SET player='QT' WHERE extension IN ('mov') OK
UPDATE shoots_filetypes SET player='RMP' WHERE extension IN ('ra','ram','rm') OK
UPDATE shoots_filetypes SET player='SWF' WHERE extension IN ('swc','swf') OK
ALTER TABLE shoots_comments add msg_raw_ip tinytext Already Done
ALTER TABLE shoots_comments add msg_hdr_ip tinytext Already Done
ALTER TABLE shoots_pictures add pic_raw_ip tinytext Already Done
ALTER TABLE shoots_pictures add pic_hdr_ip tinytext Already Done
INSERT INTO shoots_config VALUES ('thumb_use', 'any') Already Done
INSERT INTO shoots_config VALUES ('show_private', '0') Already Done
INSERT INTO shoots_config VALUES ('first_level', '1') Already Done
INSERT INTO shoots_config VALUES ('display_film_strip', '1') Already Done
INSERT INTO shoots_config VALUES ('display_film_strip_filename', '0') Already Done
INSERT INTO shoots_config VALUES ('max_film_strip_items', '5') Already Done
INSERT INTO shoots_config VALUES ('read_iptc_data', '0') Already Done
INSERT INTO shoots_config VALUES ('display_uploader', '0') Already Done
INSERT INTO shoots_config VALUES ('display_filename','0') Already Done
INSERT INTO shoots_config VALUES ('reg_notify_admin_email', '0') Already Done
INSERT INTO shoots_config VALUES ('disable_comment_flood_protect', '0') Already Done
INSERT INTO shoots_config VALUES ('upl_notify_admin_email', '0') Already Done
INSERT INTO shoots_config VALUES ('language_list', '0') Already Done
INSERT INTO shoots_config VALUES ('language_flags', '0') Already Done
INSERT INTO shoots_config VALUES ('theme_list', '0') Already Done
INSERT INTO shoots_config VALUES ('language_reset', '1') Already Done
INSERT INTO shoots_config VALUES ('theme_reset', '1') Already Done
INSERT INTO shoots_config VALUES ('offline', '0') Already Done
INSERT INTO shoots_config VALUES ('vanity_block','1') Already Done
INSERT INTO shoots_config VALUES ('allow_memberlist', '0') Already Done
INSERT INTO shoots_config VALUES ('display_faq', '0') Already Done
INSERT INTO shoots_config VALUES ('views_in_thumbview', '1') Already Done
INSERT INTO shoots_config VALUES ('show_bbcode_help', '1') Already Done
INSERT INTO shoots_config VALUES ('log_ecards', '0') Already Done
INSERT INTO shoots_config VALUES ('email_comment_notification', '0') Already Done
INSERT INTO shoots_config VALUES ('enable_zipdownload', '1') Already Done
INSERT INTO shoots_config VALUES ('debug_notice', '0') Already Done
INSERT INTO shoots_config VALUES ('slideshow_interval', '5000') Already Done
INSERT INTO shoots_config VALUES ('log_mode', '0') Already Done
INSERT INTO shoots_config VALUES ('media_autostart', '1') Already Done
INSERT INTO shoots_config VALUES ('enable_encrypted_passwords','0') Already Done
ALTER TABLE `shoots_categories` ADD `thumb` INT NOT NULL AFTER `parent` Already Done
ALTER TABLE `shoots_albums` ADD `keyword` VARCHAR( 50 ) NOT NULL Already Done
CREATE TABLE shoots_banned ( ban_id int(11) NOT NULL auto_increment, user_id int(11) DEFAULT NULL, ip_addr tinytext DEFAULT NULL, expiry datetime DEFAULT NULL, PRIMARY KEY (ban_id) ) TYPE=MyISAM Already Done
CREATE TABLE shoots_exif ( `filename` varchar(255) NOT NULL default '', `exifData` text NOT NULL, UNIQUE KEY `filename` (`filename`) ) TYPE=MyISAM Already Done
CREATE TABLE shoots_ecards ( eid int(11) NOT NULL auto_increment, sender_name varchar(50) NOT NULL default '', sender_email text NOT NULL, recipient_name varchar(50) NOT NULL default '', recipient_email text NOT NULL, link text NOT NULL, date tinytext NOT NULL, sender_ip tinytext NOT NULL, PRIMARY KEY (eid) ) TYPE=MyISAM COMMENT='Used to log ecards' Already Done
ALTER TABLE `shoots_usergroups` ADD `upload_form_config` TINYINT(4) DEFAULT '3' NOT NULL Already Done
ALTER TABLE `shoots_usergroups` ADD `custom_user_upload` TINYINT(4) DEFAULT '0' NOT NULL Already Done
ALTER TABLE `shoots_usergroups` ADD `num_file_upload` TINYINT(4) DEFAULT '5' NOT NULL Already Done
ALTER TABLE `shoots_usergroups` ADD `num_URI_upload` TINYINT(4) DEFAULT '3' NOT NULL Already Done
CREATE TABLE IF NOT EXISTS `shoots_temp_data` ( `unique_ID` CHAR( 8 ) NOT NULL , `encoded_string` BLOB NOT NULL , `timestamp` INT( 11 ) UNSIGNED NOT NULL , PRIMARY KEY ( `unique_ID` ) ) TYPE = MYISAM COMMENT = 'Holds temporary file data for multiple file uploads' OK
UPDATE `shoots_config` SET value='classic' WHERE (name='theme' AND value='default') OK
DELETE FROM `shoots_filetypes` WHERE mime='text/html' OK
UPDATE `shoots_config` SET value='$/\\\\:*?"\'<>|` &' WHERE name='forbiden_fname_char' OK
ALTER TABLE `shoots_users` CHANGE user_lang user_group_list varchar(255) NOT NULL default '' Already Done
ALTER TABLE shoots_pictures DROP INDEX `owner_id` OK
ALTER TABLE shoots_pictures DROP INDEX `owner_id_2` Already Done
ALTER TABLE shoots_pictures ADD INDEX owner_id( `owner_id` ) OK
ALTER TABLE shoots_pictures ADD `galleryicon` INT UNSIGNED DEFAULT '0' NOT NULL AFTER `approved` Already Done
ALTER TABLE `shoots_pictures` ADD `lasthit_ip` TINYTEXT Already Done
CREATE TABLE `shoots_favpics` ( `user_id` INT( 11 ) NOT NULL , `user_favpics` TEXT NOT NULL , PRIMARY KEY ( `user_id` ) ) COMMENT = 'Stores the server side favourites' Already Done
CREATE TABLE shoots_dict ( keyId bigint(20) NOT NULL auto_increment, keyword varchar(60) NOT NULL default '', PRIMARY KEY (keyId) ) TYPE=MyISAM COMMENT = 'Holds the keyword dictionary' Already Done
ALTER TABLE `shoots_users` CHANGE `user_location` `user_profile1` VARCHAR(255) Already Done
ALTER TABLE `shoots_users` CHANGE `user_interests` `user_profile2` VARCHAR(255) Already Done
ALTER TABLE `shoots_users` CHANGE `user_website` `user_profile3` VARCHAR(255) Already Done
ALTER TABLE `shoots_users` CHANGE `user_occupation` `user_profile4` VARCHAR(255) Already Done
ALTER TABLE `shoots_users` ADD `user_profile5` varchar(255) default '' NOT NULL Already Done
ALTER TABLE `shoots_users` ADD `user_profile6` varchar(255) default '' NOT NULL Already Done
ALTER TABLE `shoots_users` CHANGE `user_password` `user_password` VARCHAR( 40 ) NOT NULL OK
INSERT INTO shoots_config VALUES ('user_profile1_name', 'Location') Already Done
INSERT INTO shoots_config VALUES ('user_profile2_name', 'Interests') Already Done
INSERT INTO shoots_config VALUES ('user_profile3_name', 'Website') Already Done
INSERT INTO shoots_config VALUES ('user_profile4_name', 'Occupation') Already Done
INSERT INTO shoots_config VALUES ('user_profile5_name', '') Already Done
INSERT INTO shoots_config VALUES ('user_profile6_name', 'Biography') Already Done
INSERT INTO shoots_config VALUES ('language_fallback', '0') Already Done
INSERT INTO shoots_config VALUES ('time_offset', '0') Already Done
ALTER TABLE `shoots_users` CHANGE `user_profile6` `user_profile6` TEXT NOT NULL OK
ALTER TABLE `shoots_albums` ADD `alb_password` varchar(32) default '' Already Done
INSERT INTO shoots_config VALUES ('ban_private_ip', '0') Already Done
INSERT INTO shoots_config VALUES ('smtp_host', '') Already Done
INSERT INTO shoots_config VALUES ('smtp_username', '') Already Done
INSERT INTO shoots_config VALUES ('smtp_password', '') Already Done
INSERT INTO shoots_config VALUES ('enable_plugins', '1') Already Done
CREATE TABLE shoots_plugins ( plugin_id int(10) unsigned NOT NULL auto_increment, name varchar(64) NOT NULL default '', path varchar(128) NOT NULL default '', priority int(10) unsigned NOT NULL default '0', PRIMARY KEY (plugin_id), UNIQUE KEY name (name), UNIQUE KEY path (path) ) TYPE=MyISAM COMMENT='Stores the plugins' Already Done
INSERT INTO shoots_config VALUES ('enable_help', '2') Already Done
INSERT INTO shoots_config VALUES ('allow_email_change', '0') Already Done
INSERT INTO shoots_config VALUES ('show_which_exif', '|0|0|0|0|0|0|0|0|1|0|1|1|0|0|0|0|0|0|0|0|0|0|0|1|0|0|0|1|0|0|0|1|1|0|0|0|0|1|0|0|0|1|0|0|1|1|0|0|0|0|0|1|0|1|1') Already Done
INSERT INTO shoots_config VALUES ('alb_desc_thumb', '1') Already Done
ALTER TABLE `shoots_albums` ADD `alb_password_hint` TEXT Already Done
INSERT INTO shoots_config VALUES ('categories_alpha_sort', '0') Already Done
ALTER TABLE `shoots_banned` ADD `brute_force` TINYINT( 5 ) DEFAULT '0' NOT NULL Already Done
INSERT INTO shoots_config VALUES ('login_threshold', '5') Already Done
INSERT INTO shoots_config VALUES ('login_expiry', '10') Already Done
INSERT INTO shoots_config VALUES ('clickable_keyword_search', '1') Already Done
INSERT INTO shoots_config VALUES ('link_pic_count', '0') Already Done
ALTER TABLE shoots_pictures ADD position INT(11) DEFAULT '0' NOT NULL Already Done
INSERT INTO shoots_config VALUES ('auto_resize', '0') Already Done
CREATE TABLE shoots_bridge ( name varchar(40) NOT NULL default '0', value varchar(255) NOT NULL default '', UNIQUE KEY name (name) ) TYPE=MyISAM Already Done
INSERT INTO shoots_bridge VALUES ('short_name', '') Already Done
INSERT INTO shoots_bridge VALUES ('license_number', '') Already Done
INSERT INTO shoots_bridge VALUES ('db_database_name', '') Already Done
INSERT INTO shoots_bridge VALUES ('db_hostname', '') Already Done
INSERT INTO shoots_bridge VALUES ('db_username', '') Already Done
INSERT INTO shoots_bridge VALUES ('db_password', '') Already Done
INSERT INTO shoots_bridge VALUES ('full_forum_url', '') Already Done
INSERT INTO shoots_bridge VALUES ('relative_path_of_forum_from_webroot', '') Already Done
INSERT INTO shoots_bridge VALUES ('relative_path_to_config_file', '') Already Done
INSERT INTO shoots_bridge VALUES ('logout_flag', '') Already Done
INSERT INTO shoots_bridge VALUES ('use_post_based_groups', '') Already Done
INSERT INTO shoots_bridge VALUES ('cookie_prefix', '') Already Done
INSERT INTO shoots_bridge VALUES ('table_prefix', '') Already Done
INSERT INTO shoots_bridge VALUES ('user_table', '') Already Done
INSERT INTO shoots_bridge VALUES ('session_table', '') Already Done
INSERT INTO shoots_bridge VALUES ('group_table', '') Already Done
INSERT INTO shoots_bridge VALUES ('group_relation_table', '') Already Done
INSERT INTO shoots_bridge VALUES ('group_mapping_table', '') Already Done
INSERT INTO shoots_bridge VALUES ('use_standard_groups', '1') Already Done
INSERT INTO shoots_bridge VALUES ('validating_group', '') Already Done
INSERT INTO shoots_bridge VALUES ('guest_group', '') Already Done
INSERT INTO shoots_bridge VALUES ('member_group', '') Already Done
INSERT INTO shoots_bridge VALUES ('admin_group', '') Already Done
INSERT INTO shoots_bridge VALUES ('banned_group', '') Already Done
INSERT INTO shoots_bridge VALUES ('global_moderators_group', '') Already Done
INSERT INTO shoots_bridge VALUES ('recovery_logon_failures', '0') Already Done
INSERT INTO shoots_bridge VALUES ('recovery_logon_timestamp', '') Already Done
INSERT INTO shoots_config VALUES ('bridge_enable', '0') Already Done
CREATE TABLE shoots_vote_stats ( `sid` int(11) NOT NULL auto_increment, `pid` varchar(100) NOT NULL default '', `rating` smallint(6) NOT NULL default '0', `ip` varchar(20) NOT NULL default '', `sdate` bigint(20) NOT NULL default '0', `referer` text NOT NULL, `browser` varchar(255) NOT NULL default '', `os` varchar(50) NOT NULL default '', PRIMARY KEY (`sid`) ) Already Done
INSERT INTO shoots_config VALUES ('vote_details', '0') Already Done
CREATE TABLE shoots_hit_stats ( `sid` int(11) NOT NULL auto_increment, `pid` varchar(100) NOT NULL default '', `ip` varchar(20) NOT NULL default '', `search_phrase` varchar(255) NOT NULL default '', `sdate` bigint(20) NOT NULL default '0', `referer` text NOT NULL, `browser` varchar(255) NOT NULL default '', `os` varchar(50) NOT NULL default '', PRIMARY KEY (`sid`) ) Already Done
INSERT INTO shoots_config VALUES ('hit_details', '0') Already Done
INSERT INTO shoots_config VALUES ('browse_batch_add', '1') Already Done
INSERT INTO shoots_config VALUES ('custom_header_path', '') Already Done
INSERT INTO shoots_config VALUES ('custom_footer_path', '') Already Done
INSERT INTO shoots_config VALUES ('comments_sort_descending', '0') Already Done
INSERT INTO shoots_config VALUES ('report_post', '0') Already Done
INSERT INTO shoots_config VALUES ('users_can_edit_pics', '0') Already Done
INSERT INTO shoots_config VALUES ('allow_unlogged_access', '1') Already Done
INSERT INTO shoots_config VALUES ('home_target', 'index.php') Already Done
DELETE FROM shoots_config WHERE `name` = 'comment_email_notification' OK
DELETE FROM shoots_config WHERE `name` = 'hide_admin_uploader' OK
INSERT INTO shoots_config VALUES ('custom_lnk_name', '') Already Done
INSERT INTO shoots_config VALUES ('custom_lnk_url', '') Already Done
INSERT INTO shoots_config VALUES ('comments_anon_pfx', 'Guest_') Already Done
DELETE FROM shoots_config WHERE `name` = 'admin_activate' OK
INSERT INTO shoots_config VALUES ('admin_activation', '0') Already Done
ALTER TABLE shoots_pictures CHANGE `mtime` `mtime` DATETIME OK
DELETE FROM shoots_exif OK
DELETE FROM shoots_config WHERE `name` = 'randpos_interval' OK
ALTER TABLE shoots_pictures DROP INDEX `randpos` Already Done
ALTER TABLE shoots_pictures DROP `randpos` Already Done
ALTER TABLE `shoots_pictures` CHANGE `mtime` `mtime` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' OK
ALTER TABLE `shoots_albums` CHANGE `description` `description` TEXT NOT NULL default '' OK
I am not able to run "
bridgemgr.php" and receive an error.
The gallery is located here: http://www.sassen.org/log/shots/ (http://www.sassen.org/log/shots/)
you should be more precise with your error descriptions. Where does the error occur (the page), what exact error message do you get. Bridging is important as well... with what forum you try to bridge coppermine. Is it supported by the modpack? <-- that atm seems to be the problem
Usually you supply supporters with a link to your gallery and a test account (no admin)
Hi Stramm,
the error only occurs when I try to log in. When the cookie is not set the gallery can be used. Strange!
I am using CPG stand-alone with a custom template. Currently I am not able to create a new user because I receive the error each time i try to log in.
Should I create a users for you via phpmyadmin?
yes, please
Dear Stramm,
I created a user for you (pm)
The gallery is located here http://www.sassen.org/log/shots/index.php (http://www.sassen.org/log/shots/index.php)
Thanks, Phil
sorry, I haven't looked closely enough when you posted your update.php output
not a single modpack related entry has been done -> most likely you haven't uploaded the necessary sql file which comes with the modpack ( sql/update.sql ). Please make sure you have uploaded all files, then run update.php again
SmartFTP played me for a sucker >:(
Thanks a bomb! I owe you a favor!
Best regards from Berlin (Germany), Phil