mySQL error: Table .cpg149_config doesn't exist

[Fabricio]

Please i need somebody's help:

Code Select Expand

While executing query "SELECT * FROM cpg149_config" on 0

mySQL error: Table 'evanesce_new.cpg149_config' doesn't exist



evanescence-fan.com/galeria

[Joachim Müller]

Well, obviously the table in question doesn't exist. Restore it from a backup if you have one, or re-create it: run the following queries in phpMyAdmin or similar

Code Select Expand

INSERT INTO cpg149_config VALUES ('albums_per_page', '12');
INSERT INTO cpg149_config VALUES ('album_list_cols', '2');
INSERT INTO cpg149_config VALUES ('display_pic_info', '0');
INSERT INTO cpg149_config VALUES ('alb_list_thumb_size', '50');

#INSERT INTO cpg149_config VALUES ('allowed_file_extensions', 'GIF/PNG/JPG/JPEG/TIF/TIFF');


# FOR USE WITH VIDEO MOD
INSERT INTO cpg149_config VALUES ('allowed_mov_types', 'ALL');
INSERT INTO cpg149_config VALUES ('allowed_doc_types', 'doc/txt/rtf/pdf/xls/pps/ppt/zip/gz/mdb');
INSERT INTO cpg149_config VALUES ('allowed_snd_types', 'mp3/midi/mid/wma/wav/ogg');
INSERT INTO cpg149_config VALUES ('allowed_img_types', 'ALL');


INSERT INTO cpg149_config VALUES ('allow_private_albums', '1');
INSERT INTO cpg149_config VALUES ('allow_user_registration', '0');
INSERT INTO cpg149_config VALUES ('allow_unlogged_access', '1');
INSERT INTO cpg149_config VALUES ('allow_duplicate_emails_addr', '0');
INSERT INTO cpg149_config VALUES ('caption_in_thumbview', '1');
INSERT INTO cpg149_config VALUES ('views_in_thumbview', '1');
INSERT INTO cpg149_config VALUES ('charset', 'utf-8');
INSERT INTO cpg149_config VALUES ('cookie_name', 'cpg143');
INSERT INTO cpg149_config VALUES ('cookie_path', '/');
INSERT INTO cpg149_config VALUES ('debug_mode', '0');
INSERT INTO cpg149_config VALUES ('debug_notice', '0');
INSERT INTO cpg149_config VALUES ('default_dir_mode', '0755');
INSERT INTO cpg149_config VALUES ('default_file_mode', '0644');
INSERT INTO cpg149_config VALUES ('default_sort_order', 'na');
INSERT INTO cpg149_config VALUES ('ecards_more_pic_target', 'http://coppermine.sourceforge.net/');
INSERT INTO cpg149_config VALUES ('home_target', 'index.php');
INSERT INTO cpg149_config VALUES ('custom_lnk_name', '');
INSERT INTO cpg149_config VALUES ('custom_lnk_url', '');
INSERT INTO cpg149_config VALUES ('enable_smilies', '1');
INSERT INTO cpg149_config VALUES ('filter_bad_words', '0');
INSERT INTO cpg149_config VALUES ('forbiden_fname_char', '$/\\\\:*?"\'<>|` &');
INSERT INTO cpg149_config VALUES ('fullpath', 'albums/');
INSERT INTO cpg149_config VALUES ('gallery_admin_email', 'you@somewhere.com');
INSERT INTO cpg149_config VALUES ('gallery_description', 'Your online photo album');
INSERT INTO cpg149_config VALUES ('gallery_name', 'Coppermine Photo Gallery');
INSERT INTO cpg149_config VALUES ('im_options', '-antialias');
INSERT INTO cpg149_config VALUES ('impath', '');
INSERT INTO cpg149_config VALUES ('jpeg_qual', '80');
INSERT INTO cpg149_config VALUES ('keep_votes_time', '30');
INSERT INTO cpg149_config VALUES ('lang', 'english');
INSERT INTO cpg149_config VALUES ('main_page_layout', 'breadcrumb/catlist/alblist/random,2/lastup,2');
INSERT INTO cpg149_config VALUES ('main_table_width', '100%');
INSERT INTO cpg149_config VALUES ('make_intermediate', '1');
INSERT INTO cpg149_config VALUES ('max_com_lines', '10');
INSERT INTO cpg149_config VALUES ('max_com_size', '512');
INSERT INTO cpg149_config VALUES ('max_com_wlength', '38');
INSERT INTO cpg149_config VALUES ('max_img_desc_length', '512');
INSERT INTO cpg149_config VALUES ('max_tabs', '12');
INSERT INTO cpg149_config VALUES ('max_upl_size', '1024');
INSERT INTO cpg149_config VALUES ('max_upl_width_height', '2048');
INSERT INTO cpg149_config VALUES ('auto_resize', '0');
INSERT INTO cpg149_config VALUES ('min_votes_for_rating', '1');
INSERT INTO cpg149_config VALUES ('normal_pfx', 'normal_');
INSERT INTO cpg149_config VALUES ('offline', '0');
INSERT INTO cpg149_config VALUES ('picture_table_width', '600');
INSERT INTO cpg149_config VALUES ('picture_width', '400');
# INSERT INTO cpg149_config VALUES ('randpos_interval', '1063623637');
INSERT INTO cpg149_config VALUES ('read_exif_data', '0');
INSERT INTO cpg149_config VALUES ('reg_requires_valid_email', '1');
INSERT INTO cpg149_config VALUES ('subcat_level', '2');
INSERT INTO cpg149_config VALUES ('theme', 'core');
INSERT INTO cpg149_config VALUES ('thumbcols', '4');
INSERT INTO cpg149_config VALUES ('thumbrows', '3');
INSERT INTO cpg149_config VALUES ('thumb_method', 'im');
INSERT INTO cpg149_config VALUES ('thumb_pfx', 'thumb_');
INSERT INTO cpg149_config VALUES ('thumb_width', '100');
INSERT INTO cpg149_config VALUES ('userpics', 'userpics/');
INSERT INTO cpg149_config VALUES ('vanity_block','1');
#
# added custom profile
#
INSERT INTO cpg149_config VALUES ('user_profile1_name', 'Location');
INSERT INTO cpg149_config VALUES ('user_profile2_name', 'Interests');
INSERT INTO cpg149_config VALUES ('user_profile3_name', 'Website');
INSERT INTO cpg149_config VALUES ('user_profile4_name', 'Occupation');
INSERT INTO cpg149_config VALUES ('user_profile5_name', '');
INSERT INTO cpg149_config VALUES ('user_profile6_name', 'Biography');
INSERT INTO cpg149_config VALUES ('user_field1_name', '');
INSERT INTO cpg149_config VALUES ('user_field2_name', '');
INSERT INTO cpg149_config VALUES ('user_field3_name', '');
INSERT INTO cpg149_config VALUES ('user_field4_name', '');
INSERT INTO cpg149_config VALUES ('display_comment_count', '0');
INSERT INTO cpg149_config VALUES ('show_private', '0');
INSERT INTO cpg149_config VALUES ('first_level', '1');
INSERT INTO cpg149_config VALUES ('display_film_strip', '1');
INSERT INTO cpg149_config VALUES ('display_film_strip_filename', '0');
INSERT INTO cpg149_config VALUES ('max_film_strip_items', '5');
INSERT INTO cpg149_config VALUES ('thumb_use', 'any');
#INSERT INTO cpg149_config VALUES ('comment_email_notification', '0');
#INSERT INTO cpg149_config VALUES ('disable_popup_rightclick', '0');
#INSERT INTO cpg149_config VALUES ('disable_gallery_rightclick', '0');
INSERT INTO cpg149_config VALUES ('read_iptc_data', '0');
INSERT INTO cpg149_config VALUES ('reg_notify_admin_email', '0');
INSERT INTO cpg149_config VALUES ('disable_comment_flood_protect', '0');
INSERT INTO cpg149_config VALUES ('upl_notify_admin_email', '0');
INSERT INTO cpg149_config VALUES ('display_uploader', '0');
# INSERT INTO cpg149_config VALUES ('display_admin_uploader','0');
INSERT INTO cpg149_config VALUES ('display_filename','0');

INSERT INTO cpg149_config VALUES ('language_list', '0');
INSERT INTO cpg149_config VALUES ('language_flags', '0');
INSERT INTO cpg149_config VALUES ('theme_list', '0');
INSERT INTO cpg149_config VALUES ('language_reset', '1');
INSERT INTO cpg149_config VALUES ('theme_reset', '1');

INSERT INTO cpg149_config VALUES ('allow_memberlist', '0');
INSERT INTO cpg149_config VALUES ('display_faq', '0');
INSERT INTO cpg149_config VALUES ('show_bbcode_help', '1');
INSERT INTO cpg149_config VALUES ('log_ecards', '0');
INSERT INTO cpg149_config VALUES ('email_comment_notification', '0');
INSERT INTO cpg149_config VALUES ('enable_zipdownload', '1');
INSERT INTO cpg149_config VALUES ('slideshow_interval', '5000');

INSERT INTO cpg149_config VALUES ('log_mode', '0');
INSERT INTO cpg149_config VALUES ('media_autostart', '1');

INSERT INTO cpg149_config VALUES ('enable_encrypted_passwords','1');

INSERT INTO cpg149_config VALUES ('time_offset', '0');

INSERT INTO cpg149_config VALUES ('ban_private_ip', '0');

INSERT INTO cpg149_config VALUES ('smtp_host', '');
INSERT INTO cpg149_config VALUES ('smtp_username', '');
INSERT INTO cpg149_config VALUES ('smtp_password', '');

INSERT INTO cpg149_config VALUES ('enable_plugins', '1');

INSERT INTO cpg149_config VALUES ('enable_help', '2');

INSERT INTO cpg149_config VALUES ('categories_alpha_sort', '0');

INSERT INTO cpg149_config VALUES ('login_threshold', '5');
INSERT INTO cpg149_config VALUES ('login_expiry', '10');


INSERT INTO cpg149_config VALUES ('allow_email_change', '0');

INSERT INTO cpg149_config VALUES ('clickable_keyword_search', '1');
INSERT INTO cpg149_config VALUES ('users_can_edit_pics', '0');
INSERT INTO cpg149_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');
INSERT INTO cpg149_config VALUES ('alb_desc_thumb', '1');
INSERT INTO cpg149_config VALUES ('link_pic_count', '0');

INSERT INTO cpg149_config VALUES ('bridge_enable', '0');
INSERT INTO cpg149_config VALUES ('language_fallback', '1');
INSERT INTO cpg149_config VALUES ('vote_details', '0');
INSERT INTO cpg149_config VALUES ('hit_details', '0');
INSERT INTO cpg149_config VALUES ('browse_batch_add', '1');
INSERT INTO cpg149_config VALUES ('custom_header_path', '');
INSERT INTO cpg149_config VALUES ('custom_footer_path', '');
INSERT INTO cpg149_config VALUES ('comments_sort_descending', '0');
INSERT INTO cpg149_config VALUES ('report_post', '0');
INSERT INTO cpg149_config VALUES ('comments_anon_pfx', 'Guest_');
INSERT INTO cpg149_config VALUES ('admin_activation', '0');
, assuming that your table prefix is actually cpg149.

For a more detailed answer, post more details (fresh install or upgrade? Happened suddenly or after you did what?).

[Fabricio]

the truth is that i installed php-nuke in the same database than the gallery and know this is what happens

[Fabricio]

the truth is that i installed php-nuke in the same database than the gallery and now this is what happens

[Joachim Müller]

This doesn't help me in determining what you did wrong.

Read the instructions I posted: restore a backup or re-create the table, performing a query like

Code Select Expand

CREATE TABLE cpg149_config (
  name varchar(40) NOT NULL default '',
  value varchar(255) NOT NULL default '',
  PRIMARY KEY  (name)
) TYPE=MyISAM COMMENT='Used to store the configuration options';and then re-populate the config table as suggested above.

[Fabricio]

i don't have a backup and the only options i can press are structure, sql, import and operations, i can't press query

[Fabricio]

i think i got it but how do i re-populate the config table? thanks for your help

[Fabricio]

if you want to i can give you my password, please would you fix it for me? i can't do it