Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: fatal error  (Read 7920 times)

0 Members and 1 Guest are viewing this topic.

Philcomputing

  • Coppermine newbie
  • Offline Offline
  • Posts: 19
    • Phil - Tales from the Geekside
fatal error
« on: September 18, 2006, 12:37:53 pm »

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
« Last Edit: September 18, 2006, 04:09:36 pm by Stramm »
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: fatal error
« Reply #1 on: September 18, 2006, 12:42:40 pm »

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

Quote
Installation:
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

Philcomputing

  • Coppermine newbie
  • Offline Offline
  • Posts: 19
    • Phil - Tales from the Geekside
Re: fatal error
« Reply #2 on: September 18, 2006, 01:24:57 pm »

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/
« Last Edit: September 18, 2006, 01:34:26 pm by Philcomputing »
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: fatal error
« Reply #3 on: September 18, 2006, 02:16:11 pm »

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)
 

Philcomputing

  • Coppermine newbie
  • Offline Offline
  • Posts: 19
    • Phil - Tales from the Geekside
Re: fatal error
« Reply #4 on: September 18, 2006, 02:24:32 pm »

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?
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: fatal error
« Reply #5 on: September 18, 2006, 03:04:44 pm »

yes, please

Philcomputing

  • Coppermine newbie
  • Offline Offline
  • Posts: 19
    • Phil - Tales from the Geekside
Re: fatal error
« Reply #6 on: September 18, 2006, 03:28:57 pm »

Dear Stramm,

I created a user for you (pm)
The gallery is located here http://www.sassen.org/log/shots/index.php

Thanks, Phil
Logged

Stramm

  • Moderator
  • Coppermine addict
  • ****
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 6006
    • Bettis Wollwelt
Re: fatal error
« Reply #7 on: September 18, 2006, 03:40:28 pm »

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

Philcomputing

  • Coppermine newbie
  • Offline Offline
  • Posts: 19
    • Phil - Tales from the Geekside
Re: fatal error
« Reply #8 on: September 18, 2006, 04:05:50 pm »

SmartFTP played me for a sucker  >:(
Thanks a bomb! I owe you a favor!

Best regards from Berlin (Germany), Phil


Logged
Pages: [1]   Go Up
 

Page created in 0.025 seconds with 20 queries.