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: Critical error  (Read 5060 times)

0 Members and 1 Guest are viewing this topic.

svash

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
Critical error
« on: January 27, 2014, 01:38:47 pm »

Hello,

could you please tell me, what is wron g wit´h my gallery www.star.planet.ee/gallery?

Error message:
While executing query 'SELECT name, description, cid, thumb, depth, lft
        FROM cpg15x_categories AS c
        WHERE depth BETWEEN 0 + 1 AND 0 +
ORDER BY c.lft' in index.php on line 318

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY c.lft' at line 4

Thank you,

Andrei
Logged

svash

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
Critical error
« Reply #1 on: January 27, 2014, 01:40:28 pm »

Hello,

could you please tell me, what is wrong with my gallery www.star.planet.ee/gallery ?
Error message:

While executing query 'SELECT name, description, cid, thumb, depth, lft
        FROM cpg15x_categories AS c
        WHERE depth BETWEEN 0 + 1 AND 0 +
ORDER BY c.lft' in index.php on line 318

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY c.lft' at line 4

Thank you,
Andrei
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical error
« Reply #2 on: January 27, 2014, 01:49:36 pm »

For some reason $CONFIG['subcat_level'] isn't set in your gallery. Please login as admin and set a value for the config option Number of levels of categories to display.

Have you upgraded your gallery recently? If so, which version did you used before the upgrade?
Logged

svash

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
Re: Critical error
« Reply #3 on: January 27, 2014, 09:11:59 pm »

Hello Andre,

Coppermine version: 1.5.8
I can't log in and set a value for the config option.

andrei
Logged

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 785
    • GMC Design Photo Gallery
Re: Critical error
« Reply #4 on: January 27, 2014, 09:40:16 pm »

Using a tool like phpMyAdmin, issue the following SQL: (change cpg_ to your table prefix as appropriate)
Code: [Select]
INSERT INTO `cpg_config` (`name`, `value`) VALUES ('subcat_level', '2');
This will set the value to the provided default - and hopefully get you to a point where you can access the gallery...
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

svash

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
Re: Critical error
« Reply #5 on: January 27, 2014, 11:44:01 pm »

Hello Gerg,

I did like you say. But the error measage appeared:
#1054 - Unknown column 'sucat_level' in 'field list' (pl. look at the picture)

Thank you,
Andrei
Logged

svash

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
Re: Critical error
« Reply #6 on: January 27, 2014, 11:46:54 pm »

I made an update to 1.5.26.
without any results.
Problem is still the same.

Andrei
Logged

gmc

  • Dev Team member
  • Coppermine addict
  • ****
  • Country: us
  • Offline Offline
  • Gender: Male
  • Posts: 785
    • GMC Design Photo Gallery
Re: Critical error
« Reply #7 on: January 28, 2014, 12:49:10 am »

Hello Gerg,

I did like you say. But the error measage appeared:
#1054 - Unknown column 'sucat_level' in 'field list' (pl. look at the picture)

Thank you,
Andrei
A small but important difference between my post and your query...
Change the ` to ' around the values only (subcat_level and 2)

The ` is used around database, table, and field names, and ' or " is used around values.
The ` around names is optional as long as no special characters or MySQL keywords. PhpMyAdmin adds them when constructing a query, and that is where I copied the SQL from.
Logged
Thanks!
Greg
My Coppermine Gallery
Need a web hosting account? See my gallery for an offer for CPG Forum users.
Send me money

svash

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
Re: Critical error
« Reply #8 on: January 28, 2014, 09:39:30 am »

A small but important difference between my post and your query...
Change the ` to ' around the values only (subcat_level and 2)

The ` is used around database, table, and field names, and ' or " is used around values.
The ` around names is optional as long as no special characters or MySQL keywords. PhpMyAdmin adds them when constructing a query, and that is where I copied the SQL from.

Results:
I have added subcat_level, 2 to congig fail.
But trying to login I get a new error message.

Please look at the screenshots.
Andrei
Logged

svash

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
Re: Critical error
« Reply #9 on: January 28, 2014, 09:55:45 am »

A small but important difference between my post and your query...
Change the ` to ' around the values only (subcat_level and 2)

The ` is used around database, table, and field names, and ' or " is used around values.
The ` around names is optional as long as no special characters or MySQL keywords. PhpMyAdmin adds them when constructing a query, and that is where I copied the SQL from.

Database printscreen added
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764
Re: Critical error
« Reply #10 on: January 28, 2014, 09:57:40 am »

There's obviously something wrong with your config table, as another mandatory row is missing: login_threshold.

Please execute the following query with phpMyAdmin:
Code: [Select]
INSERT INTO cpg15x_config VALUES ('admin_activation', '0');
INSERT INTO cpg15x_config VALUES ('alb_desc_thumb', '1');
INSERT INTO cpg15x_config VALUES ('alb_list_thumb_size', '50');
INSERT INTO cpg15x_config VALUES ('album_list_cols', '2');
INSERT INTO cpg15x_config VALUES ('album_sort_order', 'pa');
INSERT INTO cpg15x_config VALUES ('albums_per_page', '12');
INSERT INTO cpg15x_config VALUES ('allow_duplicate_emails_addr', '0');
INSERT INTO cpg15x_config VALUES ('allow_guests_enter_file_details', '0');
INSERT INTO cpg15x_config VALUES ('allowed_doc_types', 'doc/txt/rtf/pdf/xls/pps/ppt/zip/gz/mdb');
INSERT INTO cpg15x_config VALUES ('allowed_img_types', 'jpeg/jpg/png/gif');
INSERT INTO cpg15x_config VALUES ('allowed_mov_types', 'asf/asx/mpg/mpeg/wmv/swf/avi/mov');
INSERT INTO cpg15x_config VALUES ('allowed_snd_types', 'mp3/midi/mid/wma/wav/ogg');
INSERT INTO cpg15x_config VALUES ('allow_email_change', '0');
INSERT INTO cpg15x_config VALUES ('allow_memberlist', '0');
INSERT INTO cpg15x_config VALUES ('allow_private_albums', '1');
INSERT INTO cpg15x_config VALUES ('allow_unlogged_access', '3');
INSERT INTO cpg15x_config VALUES ('allow_user_account_delete', '0');
INSERT INTO cpg15x_config VALUES ('allow_user_album_keyword', '0');
INSERT INTO cpg15x_config VALUES ('allow_user_edit_after_cat_close', '0');
INSERT INTO cpg15x_config VALUES ('allow_user_move_album', '0');
INSERT INTO cpg15x_config VALUES ('allow_user_registration', '0');
INSERT INTO cpg15x_config VALUES ('allow_user_upload_choice', '1');
INSERT INTO cpg15x_config VALUES ('auto_resize', '1');
INSERT INTO cpg15x_config VALUES ('batch_proc_limit', '2');
INSERT INTO cpg15x_config VALUES ('bridge_enable', '0');
INSERT INTO cpg15x_config VALUES ('browse_batch_add', '1');
INSERT INTO cpg15x_config VALUES ('browse_by_date', '0');
INSERT INTO cpg15x_config VALUES ('caption_in_thumbview', '1');
INSERT INTO cpg15x_config VALUES ('categories_alpha_sort', '0');
INSERT INTO cpg15x_config VALUES ('charset', 'utf-8');
INSERT INTO cpg15x_config VALUES ('clickable_keyword_search', '1');
INSERT INTO cpg15x_config VALUES ('comment_akismet_api_key', '');
INSERT INTO cpg15x_config VALUES ('comment_akismet_counter', '0');
INSERT INTO cpg15x_config VALUES ('comment_akismet_enable', '0');
INSERT INTO cpg15x_config VALUES ('comment_akismet_group', '0');
INSERT INTO cpg15x_config VALUES ('comment_approval', '0');
INSERT INTO cpg15x_config VALUES ('comment_captcha', '1');
#INSERT INTO cpg15x_config VALUES ('comment_email_notification', '0');
INSERT INTO cpg15x_config VALUES ('comment_placeholder', '1');
INSERT INTO cpg15x_config VALUES ('comment_promote_registration', '0');
INSERT INTO cpg15x_config VALUES ('comments_anon_pfx', 'Guest_');
INSERT INTO cpg15x_config VALUES ('comments_per_page', '20');
INSERT INTO cpg15x_config VALUES ('comments_sort_descending', '0');
INSERT INTO cpg15x_config VALUES ('comment_user_edit', '1');
INSERT INTO cpg15x_config VALUES ('contact_form_guest_email_field', '2');
INSERT INTO cpg15x_config VALUES ('contact_form_guest_enable', '0');
INSERT INTO cpg15x_config VALUES ('contact_form_guest_name_field', '2');
INSERT INTO cpg15x_config VALUES ('contact_form_registered_enable', '1');
INSERT INTO cpg15x_config VALUES ('contact_form_sender_email', '1');
INSERT INTO cpg15x_config VALUES ('contact_form_subject_content', 'Coppermine gallery contact form');
INSERT INTO cpg15x_config VALUES ('contact_form_subject_field', '0');
INSERT INTO cpg15x_config VALUES ('cookie_name', 'cpg15x');
INSERT INTO cpg15x_config VALUES ('cookie_path', '/');
INSERT INTO cpg15x_config VALUES ('cookies_need_consent', '0');
INSERT INTO cpg15x_config VALUES ('count_admin_hits', '0');
INSERT INTO cpg15x_config VALUES ('count_album_hits', '1');
INSERT INTO cpg15x_config VALUES ('count_file_hits', '1');
INSERT INTO cpg15x_config VALUES ('custom_footer_path', '');
INSERT INTO cpg15x_config VALUES ('custom_header_path', '');
INSERT INTO cpg15x_config VALUES ('custom_lnk_name', '');
INSERT INTO cpg15x_config VALUES ('custom_lnk_url', '');
INSERT INTO cpg15x_config VALUES ('custom_sortorder_thumbs', '1');
INSERT INTO cpg15x_config VALUES ('debug_mode', '0');
INSERT INTO cpg15x_config VALUES ('debug_notice', '0');
INSERT INTO cpg15x_config VALUES ('default_dir_mode', '0755');
INSERT INTO cpg15x_config VALUES ('default_file_mode', '0644');
INSERT INTO cpg15x_config VALUES ('default_sort_order', 'na');
INSERT INTO cpg15x_config VALUES ('disable_comment_flood_protect', '0');
# INSERT INTO cpg15x_config VALUES ('display_admin_uploader','0');
INSERT INTO cpg15x_config VALUES ('display_comment_approval_only', '0');
INSERT INTO cpg15x_config VALUES ('display_comment_count', '0');
INSERT INTO cpg15x_config VALUES ('display_coppermine_news', '1');
INSERT INTO cpg15x_config VALUES ('display_filename','0');
INSERT INTO cpg15x_config VALUES ('display_film_strip', '1');
INSERT INTO cpg15x_config VALUES ('display_pic_info', '0');
INSERT INTO cpg15x_config VALUES ('display_redirection_page', '0');
INSERT INTO cpg15x_config VALUES ('display_reset_boxes_in_config', '0');
INSERT INTO cpg15x_config VALUES ('display_sidebar_guest', '1');
INSERT INTO cpg15x_config VALUES ('display_sidebar_user', '1');
INSERT INTO cpg15x_config VALUES ('display_stats_on_index', '1');
INSERT INTO cpg15x_config VALUES ('display_thumbnail_rating', '0');
INSERT INTO cpg15x_config VALUES ('display_thumbs_batch_add', '1');
INSERT INTO cpg15x_config VALUES ('display_uploader', '0');
INSERT INTO cpg15x_config VALUES ('display_xp_publish_link', '0');
INSERT INTO cpg15x_config VALUES ('ecard_flash', '0');
INSERT INTO cpg15x_config VALUES ('ecards_more_pic_target', 'http://yoursite.tld/your_coppermine_folder/');
INSERT INTO cpg15x_config VALUES ('editpics_ignore_newer_than', '0');
INSERT INTO cpg15x_config VALUES ('email_comment_notification', '0');
INSERT INTO cpg15x_config VALUES ('enable_encrypted_passwords', '1'); # Do not remove - this record IS needed to make sure that there is no double-encryption when updating
INSERT INTO cpg15x_config VALUES ('enable_help', '1');
INSERT INTO cpg15x_config VALUES ('enable_menu_icons', '2');
INSERT INTO cpg15x_config VALUES ('enable_plugins', '1');
INSERT INTO cpg15x_config VALUES ('enable_smilies', '1');
INSERT INTO cpg15x_config VALUES ('enable_thumb_watermark', '1');
INSERT INTO cpg15x_config VALUES ('enable_unsharp', '0');
INSERT INTO cpg15x_config VALUES ('enable_watermark', '0');
INSERT INTO cpg15x_config VALUES ('enable_zipdownload', '0');
INSERT INTO cpg15x_config VALUES ('filter_bad_words', '0');
INSERT INTO cpg15x_config VALUES ('first_level', '1');
INSERT INTO cpg15x_config VALUES ('forbiden_fname_char', '$/\\\\:*?"'<>|` &#@');
INSERT INTO cpg15x_config VALUES ('fullpath', 'albums/');
INSERT INTO cpg15x_config VALUES ('fullsize_padding_x', '5');
INSERT INTO cpg15x_config VALUES ('fullsize_padding_y', '3');
INSERT INTO cpg15x_config VALUES ('gallery_admin_email', 'you@somewhere.com');
INSERT INTO cpg15x_config VALUES ('gallery_description', 'Your gallery description here');
INSERT INTO cpg15x_config VALUES ('gallery_name', 'Your gallery name here');
INSERT INTO cpg15x_config VALUES ('global_registration_pw', '');
INSERT INTO cpg15x_config VALUES ('guest_token_cleanup', '0');
INSERT INTO cpg15x_config VALUES ('hit_details', '0');
INSERT INTO cpg15x_config VALUES ('home_target', 'index.php');
INSERT INTO cpg15x_config VALUES ('im_options', '-antialias');
INSERT INTO cpg15x_config VALUES ('impath', '/usr/bin/');
INSERT INTO cpg15x_config VALUES ('jpeg_qual', '80');
INSERT INTO cpg15x_config VALUES ('keep_votes_time', '30');
INSERT INTO cpg15x_config VALUES ('keyword_separator', ';');
INSERT INTO cpg15x_config VALUES ('lang', 'english');
INSERT INTO cpg15x_config VALUES ('language_autodetect', '1');
INSERT INTO cpg15x_config VALUES ('link_pic_count', '1');
INSERT INTO cpg15x_config VALUES ('link_last_upload', '0');
INSERT INTO cpg15x_config VALUES ('log_ecards', '0');
INSERT INTO cpg15x_config VALUES ('login_expiry', '10');
INSERT INTO cpg15x_config VALUES ('login_method', 'username');
INSERT INTO cpg15x_config VALUES ('login_threshold', '5');
INSERT INTO cpg15x_config VALUES ('log_mode', '0');
INSERT INTO cpg15x_config VALUES ('main_page_layout', 'breadcrumb/catlist/alblist/random,2/lastup,2');
INSERT INTO cpg15x_config VALUES ('main_table_width', '100%');
INSERT INTO cpg15x_config VALUES ('make_intermediate', '1');
INSERT INTO cpg15x_config VALUES ('max_com_lines', '10');
INSERT INTO cpg15x_config VALUES ('max_com_size', '512');
INSERT INTO cpg15x_config VALUES ('max_com_wlength', '38');
INSERT INTO cpg15x_config VALUES ('max_film_strip_items', '5');
INSERT INTO cpg15x_config VALUES ('max_img_desc_length', '512');
INSERT INTO cpg15x_config VALUES ('max_tabs', '12');
INSERT INTO cpg15x_config VALUES ('max_upl_size', '1024');
INSERT INTO cpg15x_config VALUES ('max_upl_width_height', '2048');
INSERT INTO cpg15x_config VALUES ('media_autostart', '1');
INSERT INTO cpg15x_config VALUES ('min_votes_for_rating', '1');
INSERT INTO cpg15x_config VALUES ('normal_pfx', 'normal_');
INSERT INTO cpg15x_config VALUES ('offline', '0');
INSERT INTO cpg15x_config VALUES ('old_style_rating', '0');
INSERT INTO cpg15x_config VALUES ('orig_pfx', 'orig_');
INSERT INTO cpg15x_config VALUES ('performance_page_generation_time', '0');
INSERT INTO cpg15x_config VALUES ('performance_page_query_count', '0');
INSERT INTO cpg15x_config VALUES ('performance_page_query_time', '0');
INSERT INTO cpg15x_config VALUES ('performance_timestamp', '0');
INSERT INTO cpg15x_config VALUES ('personal_album_on_registration', '0');
INSERT INTO cpg15x_config VALUES ('picinfo_movie_download_link', '1');
INSERT INTO cpg15x_config VALUES ('picture_table_width', '100%');
INSERT INTO cpg15x_config VALUES ('picture_use', 'thumb');
INSERT INTO cpg15x_config VALUES ('picture_width', '400');
INSERT INTO cpg15x_config VALUES ('purge_expired_bans', '1');
# INSERT INTO cpg15x_config VALUES ('randpos_interval', '1063623637');
INSERT INTO cpg15x_config VALUES ('rate_own_files', '0');
INSERT INTO cpg15x_config VALUES ('rating_stars_amount', '5');
INSERT INTO cpg15x_config VALUES ('read_exif_data', '0');
INSERT INTO cpg15x_config VALUES ('read_iptc_data', '0');
INSERT INTO cpg15x_config VALUES ('reduce_watermark', '0');
INSERT INTO cpg15x_config VALUES ('registration_captcha', '0');
INSERT INTO cpg15x_config VALUES ('reg_notify_admin_email', '0');
INSERT INTO cpg15x_config VALUES ('reg_requires_valid_email', '1');
INSERT INTO cpg15x_config VALUES ('report_post', '0');
INSERT INTO cpg15x_config VALUES ('session_cleanup', '0');
INSERT INTO cpg15x_config VALUES ('show_bbcode_help', '1');
INSERT INTO cpg15x_config VALUES ('show_private', '0');
INSERT INTO cpg15x_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 cpg15x_config VALUES ('silly_safe_mode', '0');
INSERT INTO cpg15x_config VALUES ('site_token', MD5(RAND()));
INSERT INTO cpg15x_config VALUES ('form_token_lifetime', '900');
INSERT INTO cpg15x_config VALUES ('slideshow_hits', '1');
INSERT INTO cpg15x_config VALUES ('slideshow_interval', '5000');
INSERT INTO cpg15x_config VALUES ('smtp_host', '');
INSERT INTO cpg15x_config VALUES ('smtp_password', '');
INSERT INTO cpg15x_config VALUES ('smtp_username', '');
INSERT INTO cpg15x_config VALUES ('subcat_level', '2');
INSERT INTO cpg15x_config VALUES ('tabs_dropdown', '1');
INSERT INTO cpg15x_config VALUES ('theme', 'curve');
INSERT INTO cpg15x_config VALUES ('theme_list', '0');
INSERT INTO cpg15x_config VALUES ('thumbcols', '4');
INSERT INTO cpg15x_config VALUES ('thumb_height', '128');
INSERT INTO cpg15x_config VALUES ('thumb_method', 'im');
INSERT INTO cpg15x_config VALUES ('thumbnail_to_fullsize', '0');
INSERT INTO cpg15x_config VALUES ('thumb_pfx', 'thumb_');
INSERT INTO cpg15x_config VALUES ('thumbrows', '3');
INSERT INTO cpg15x_config VALUES ('thumb_use', 'any');
INSERT INTO cpg15x_config VALUES ('thumb_width', '128');
INSERT INTO cpg15x_config VALUES ('time_offset', '0');
INSERT INTO cpg15x_config VALUES ('transparent_overlay', '0');
INSERT INTO cpg15x_config VALUES ('unsharp_amount', '120');
INSERT INTO cpg15x_config VALUES ('unsharp_radius', '0.5');
INSERT INTO cpg15x_config VALUES ('unsharp_threshold', '3');
INSERT INTO cpg15x_config VALUES ('upl_notify_admin_email', '0');
INSERT INTO cpg15x_config VALUES ('upload_create_album_directory', '0');
INSERT INTO cpg15x_config VALUES ('upload_mechanism', 'swfupload');
INSERT INTO cpg15x_config VALUES ('user_field1_name', '');
INSERT INTO cpg15x_config VALUES ('user_field2_name', '');
INSERT INTO cpg15x_config VALUES ('user_field3_name', '');
INSERT INTO cpg15x_config VALUES ('user_field4_name', '');
INSERT INTO cpg15x_config VALUES ('userpics', 'userpics/');
INSERT INTO cpg15x_config VALUES ('user_profile1_name', 'Location');
INSERT INTO cpg15x_config VALUES ('user_profile2_name', 'Interests');
INSERT INTO cpg15x_config VALUES ('user_profile3_name', 'Website');
INSERT INTO cpg15x_config VALUES ('user_profile4_name', 'Occupation');
INSERT INTO cpg15x_config VALUES ('user_profile5_name', '');
INSERT INTO cpg15x_config VALUES ('user_profile6_name', 'Biography');
INSERT INTO cpg15x_config VALUES ('user_registration_disclaimer', '1');
INSERT INTO cpg15x_config VALUES ('users_can_edit_pics', '0');
INSERT INTO cpg15x_config VALUES ('views_in_thumbview', '1');
INSERT INTO cpg15x_config VALUES ('vote_details', '0');
INSERT INTO cpg15x_config VALUES ('watermark_file', 'images/watermark.png');
INSERT INTO cpg15x_config VALUES ('watermark_transparency', '40');
INSERT INTO cpg15x_config VALUES ('watermark_transparency_featherx', '0');
INSERT INTO cpg15x_config VALUES ('watermark_transparency_feathery', '0');
INSERT INTO cpg15x_config VALUES ('where_put_watermark', 'southeast');
INSERT INTO cpg15x_config VALUES ('which_files_to_watermark', 'both');
Logged

svash

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
Re: Critical error
« Reply #11 on: January 28, 2014, 10:21:43 am »

There's obviously something wrong with your config table, as another mandatory row is missing: login_threshold.

Please execute the following query with phpMyAdmin:
Code: [Select]
INSERT INTO cpg15x_config VALUES ('admin_activation', '0');
INSERT INTO cpg15x_config VALUES ('alb_desc_thumb', '1');
INSERT INTO cpg15x_config VALUES ('alb_list_thumb_size', '50');
INSERT INTO cpg15x_config VALUES ('album_list_cols', '2');
INSERT INTO cpg15x_config VALUES ('album_sort_order', 'pa');
INSERT INTO cpg15x_config VALUES ('albums_per_page', '12');
INSERT INTO cpg15x_config VALUES ('allow_duplicate_emails_addr', '0');
INSERT INTO cpg15x_config VALUES ('allow_guests_enter_file_details', '0');
INSERT INTO cpg15x_config VALUES ('allowed_doc_types', 'doc/txt/rtf/pdf/xls/pps/ppt/zip/gz/mdb');
INSERT INTO cpg15x_config VALUES ('allowed_img_types', 'jpeg/jpg/png/gif');
INSERT INTO cpg15x_config VALUES ('allowed_mov_types', 'asf/asx/mpg/mpeg/wmv/swf/avi/mov');
INSERT INTO cpg15x_config VALUES ('allowed_snd_types', 'mp3/midi/mid/wma/wav/ogg');
INSERT INTO cpg15x_config VALUES ('allow_email_change', '0');
INSERT INTO cpg15x_config VALUES ('allow_memberlist', '0');
INSERT INTO cpg15x_config VALUES ('allow_private_albums', '1');
INSERT INTO cpg15x_config VALUES ('allow_unlogged_access', '3');
INSERT INTO cpg15x_config VALUES ('allow_user_account_delete', '0');
INSERT INTO cpg15x_config VALUES ('allow_user_album_keyword', '0');
INSERT INTO cpg15x_config VALUES ('allow_user_edit_after_cat_close', '0');
INSERT INTO cpg15x_config VALUES ('allow_user_move_album', '0');
INSERT INTO cpg15x_config VALUES ('allow_user_registration', '0');
INSERT INTO cpg15x_config VALUES ('allow_user_upload_choice', '1');
INSERT INTO cpg15x_config VALUES ('auto_resize', '1');
INSERT INTO cpg15x_config VALUES ('batch_proc_limit', '2');
INSERT INTO cpg15x_config VALUES ('bridge_enable', '0');
INSERT INTO cpg15x_config VALUES ('browse_batch_add', '1');
INSERT INTO cpg15x_config VALUES ('browse_by_date', '0');
INSERT INTO cpg15x_config VALUES ('caption_in_thumbview', '1');
INSERT INTO cpg15x_config VALUES ('categories_alpha_sort', '0');
INSERT INTO cpg15x_config VALUES ('charset', 'utf-8');
INSERT INTO cpg15x_config VALUES ('clickable_keyword_search', '1');
INSERT INTO cpg15x_config VALUES ('comment_akismet_api_key', '');
INSERT INTO cpg15x_config VALUES ('comment_akismet_counter', '0');
INSERT INTO cpg15x_config VALUES ('comment_akismet_enable', '0');
INSERT INTO cpg15x_config VALUES ('comment_akismet_group', '0');
INSERT INTO cpg15x_config VALUES ('comment_approval', '0');
INSERT INTO cpg15x_config VALUES ('comment_captcha', '1');
#INSERT INTO cpg15x_config VALUES ('comment_email_notification', '0');
INSERT INTO cpg15x_config VALUES ('comment_placeholder', '1');
INSERT INTO cpg15x_config VALUES ('comment_promote_registration', '0');
INSERT INTO cpg15x_config VALUES ('comments_anon_pfx', 'Guest_');
INSERT INTO cpg15x_config VALUES ('comments_per_page', '20');
INSERT INTO cpg15x_config VALUES ('comments_sort_descending', '0');
INSERT INTO cpg15x_config VALUES ('comment_user_edit', '1');
INSERT INTO cpg15x_config VALUES ('contact_form_guest_email_field', '2');
INSERT INTO cpg15x_config VALUES ('contact_form_guest_enable', '0');
INSERT INTO cpg15x_config VALUES ('contact_form_guest_name_field', '2');
INSERT INTO cpg15x_config VALUES ('contact_form_registered_enable', '1');
INSERT INTO cpg15x_config VALUES ('contact_form_sender_email', '1');
INSERT INTO cpg15x_config VALUES ('contact_form_subject_content', 'Coppermine gallery contact form');
INSERT INTO cpg15x_config VALUES ('contact_form_subject_field', '0');
INSERT INTO cpg15x_config VALUES ('cookie_name', 'cpg15x');
INSERT INTO cpg15x_config VALUES ('cookie_path', '/');
INSERT INTO cpg15x_config VALUES ('cookies_need_consent', '0');
INSERT INTO cpg15x_config VALUES ('count_admin_hits', '0');
INSERT INTO cpg15x_config VALUES ('count_album_hits', '1');
INSERT INTO cpg15x_config VALUES ('count_file_hits', '1');
INSERT INTO cpg15x_config VALUES ('custom_footer_path', '');
INSERT INTO cpg15x_config VALUES ('custom_header_path', '');
INSERT INTO cpg15x_config VALUES ('custom_lnk_name', '');
INSERT INTO cpg15x_config VALUES ('custom_lnk_url', '');
INSERT INTO cpg15x_config VALUES ('custom_sortorder_thumbs', '1');
INSERT INTO cpg15x_config VALUES ('debug_mode', '0');
INSERT INTO cpg15x_config VALUES ('debug_notice', '0');
INSERT INTO cpg15x_config VALUES ('default_dir_mode', '0755');
INSERT INTO cpg15x_config VALUES ('default_file_mode', '0644');
INSERT INTO cpg15x_config VALUES ('default_sort_order', 'na');
INSERT INTO cpg15x_config VALUES ('disable_comment_flood_protect', '0');
# INSERT INTO cpg15x_config VALUES ('display_admin_uploader','0');
INSERT INTO cpg15x_config VALUES ('display_comment_approval_only', '0');
INSERT INTO cpg15x_config VALUES ('display_comment_count', '0');
INSERT INTO cpg15x_config VALUES ('display_coppermine_news', '1');
INSERT INTO cpg15x_config VALUES ('display_filename','0');
INSERT INTO cpg15x_config VALUES ('display_film_strip', '1');
INSERT INTO cpg15x_config VALUES ('display_pic_info', '0');
INSERT INTO cpg15x_config VALUES ('display_redirection_page', '0');
INSERT INTO cpg15x_config VALUES ('display_reset_boxes_in_config', '0');
INSERT INTO cpg15x_config VALUES ('display_sidebar_guest', '1');
INSERT INTO cpg15x_config VALUES ('display_sidebar_user', '1');
INSERT INTO cpg15x_config VALUES ('display_stats_on_index', '1');
INSERT INTO cpg15x_config VALUES ('display_thumbnail_rating', '0');
INSERT INTO cpg15x_config VALUES ('display_thumbs_batch_add', '1');
INSERT INTO cpg15x_config VALUES ('display_uploader', '0');
INSERT INTO cpg15x_config VALUES ('display_xp_publish_link', '0');
INSERT INTO cpg15x_config VALUES ('ecard_flash', '0');
INSERT INTO cpg15x_config VALUES ('ecards_more_pic_target', 'http://yoursite.tld/your_coppermine_folder/');
INSERT INTO cpg15x_config VALUES ('editpics_ignore_newer_than', '0');
INSERT INTO cpg15x_config VALUES ('email_comment_notification', '0');
INSERT INTO cpg15x_config VALUES ('enable_encrypted_passwords', '1'); # Do not remove - this record IS needed to make sure that there is no double-encryption when updating
INSERT INTO cpg15x_config VALUES ('enable_help', '1');
INSERT INTO cpg15x_config VALUES ('enable_menu_icons', '2');
INSERT INTO cpg15x_config VALUES ('enable_plugins', '1');
INSERT INTO cpg15x_config VALUES ('enable_smilies', '1');
INSERT INTO cpg15x_config VALUES ('enable_thumb_watermark', '1');
INSERT INTO cpg15x_config VALUES ('enable_unsharp', '0');
INSERT INTO cpg15x_config VALUES ('enable_watermark', '0');
INSERT INTO cpg15x_config VALUES ('enable_zipdownload', '0');
INSERT INTO cpg15x_config VALUES ('filter_bad_words', '0');
INSERT INTO cpg15x_config VALUES ('first_level', '1');
INSERT INTO cpg15x_config VALUES ('forbiden_fname_char', '$/\\\\:*?"'<>|` &#@');
INSERT INTO cpg15x_config VALUES ('fullpath', 'albums/');
INSERT INTO cpg15x_config VALUES ('fullsize_padding_x', '5');
INSERT INTO cpg15x_config VALUES ('fullsize_padding_y', '3');
INSERT INTO cpg15x_config VALUES ('gallery_admin_email', 'you@somewhere.com');
INSERT INTO cpg15x_config VALUES ('gallery_description', 'Your gallery description here');
INSERT INTO cpg15x_config VALUES ('gallery_name', 'Your gallery name here');
INSERT INTO cpg15x_config VALUES ('global_registration_pw', '');
INSERT INTO cpg15x_config VALUES ('guest_token_cleanup', '0');
INSERT INTO cpg15x_config VALUES ('hit_details', '0');
INSERT INTO cpg15x_config VALUES ('home_target', 'index.php');
INSERT INTO cpg15x_config VALUES ('im_options', '-antialias');
INSERT INTO cpg15x_config VALUES ('impath', '/usr/bin/');
INSERT INTO cpg15x_config VALUES ('jpeg_qual', '80');
INSERT INTO cpg15x_config VALUES ('keep_votes_time', '30');
INSERT INTO cpg15x_config VALUES ('keyword_separator', ';');
INSERT INTO cpg15x_config VALUES ('lang', 'english');
INSERT INTO cpg15x_config VALUES ('language_autodetect', '1');
INSERT INTO cpg15x_config VALUES ('link_pic_count', '1');
INSERT INTO cpg15x_config VALUES ('link_last_upload', '0');
INSERT INTO cpg15x_config VALUES ('log_ecards', '0');
INSERT INTO cpg15x_config VALUES ('login_expiry', '10');
INSERT INTO cpg15x_config VALUES ('login_method', 'username');
INSERT INTO cpg15x_config VALUES ('login_threshold', '5');
INSERT INTO cpg15x_config VALUES ('log_mode', '0');
INSERT INTO cpg15x_config VALUES ('main_page_layout', 'breadcrumb/catlist/alblist/random,2/lastup,2');
INSERT INTO cpg15x_config VALUES ('main_table_width', '100%');
INSERT INTO cpg15x_config VALUES ('make_intermediate', '1');
INSERT INTO cpg15x_config VALUES ('max_com_lines', '10');
INSERT INTO cpg15x_config VALUES ('max_com_size', '512');
INSERT INTO cpg15x_config VALUES ('max_com_wlength', '38');
INSERT INTO cpg15x_config VALUES ('max_film_strip_items', '5');
INSERT INTO cpg15x_config VALUES ('max_img_desc_length', '512');
INSERT INTO cpg15x_config VALUES ('max_tabs', '12');
INSERT INTO cpg15x_config VALUES ('max_upl_size', '1024');
INSERT INTO cpg15x_config VALUES ('max_upl_width_height', '2048');
INSERT INTO cpg15x_config VALUES ('media_autostart', '1');
INSERT INTO cpg15x_config VALUES ('min_votes_for_rating', '1');
INSERT INTO cpg15x_config VALUES ('normal_pfx', 'normal_');
INSERT INTO cpg15x_config VALUES ('offline', '0');
INSERT INTO cpg15x_config VALUES ('old_style_rating', '0');
INSERT INTO cpg15x_config VALUES ('orig_pfx', 'orig_');
INSERT INTO cpg15x_config VALUES ('performance_page_generation_time', '0');
INSERT INTO cpg15x_config VALUES ('performance_page_query_count', '0');
INSERT INTO cpg15x_config VALUES ('performance_page_query_time', '0');
INSERT INTO cpg15x_config VALUES ('performance_timestamp', '0');
INSERT INTO cpg15x_config VALUES ('personal_album_on_registration', '0');
INSERT INTO cpg15x_config VALUES ('picinfo_movie_download_link', '1');
INSERT INTO cpg15x_config VALUES ('picture_table_width', '100%');
INSERT INTO cpg15x_config VALUES ('picture_use', 'thumb');
INSERT INTO cpg15x_config VALUES ('picture_width', '400');
INSERT INTO cpg15x_config VALUES ('purge_expired_bans', '1');
# INSERT INTO cpg15x_config VALUES ('randpos_interval', '1063623637');
INSERT INTO cpg15x_config VALUES ('rate_own_files', '0');
INSERT INTO cpg15x_config VALUES ('rating_stars_amount', '5');
INSERT INTO cpg15x_config VALUES ('read_exif_data', '0');
INSERT INTO cpg15x_config VALUES ('read_iptc_data', '0');
INSERT INTO cpg15x_config VALUES ('reduce_watermark', '0');
INSERT INTO cpg15x_config VALUES ('registration_captcha', '0');
INSERT INTO cpg15x_config VALUES ('reg_notify_admin_email', '0');
INSERT INTO cpg15x_config VALUES ('reg_requires_valid_email', '1');
INSERT INTO cpg15x_config VALUES ('report_post', '0');
INSERT INTO cpg15x_config VALUES ('session_cleanup', '0');
INSERT INTO cpg15x_config VALUES ('show_bbcode_help', '1');
INSERT INTO cpg15x_config VALUES ('show_private', '0');
INSERT INTO cpg15x_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 cpg15x_config VALUES ('silly_safe_mode', '0');
INSERT INTO cpg15x_config VALUES ('site_token', MD5(RAND()));
INSERT INTO cpg15x_config VALUES ('form_token_lifetime', '900');
INSERT INTO cpg15x_config VALUES ('slideshow_hits', '1');
INSERT INTO cpg15x_config VALUES ('slideshow_interval', '5000');
INSERT INTO cpg15x_config VALUES ('smtp_host', '');
INSERT INTO cpg15x_config VALUES ('smtp_password', '');
INSERT INTO cpg15x_config VALUES ('smtp_username', '');
INSERT INTO cpg15x_config VALUES ('subcat_level', '2');
INSERT INTO cpg15x_config VALUES ('tabs_dropdown', '1');
INSERT INTO cpg15x_config VALUES ('theme', 'curve');
INSERT INTO cpg15x_config VALUES ('theme_list', '0');
INSERT INTO cpg15x_config VALUES ('thumbcols', '4');
INSERT INTO cpg15x_config VALUES ('thumb_height', '128');
INSERT INTO cpg15x_config VALUES ('thumb_method', 'im');
INSERT INTO cpg15x_config VALUES ('thumbnail_to_fullsize', '0');
INSERT INTO cpg15x_config VALUES ('thumb_pfx', 'thumb_');
INSERT INTO cpg15x_config VALUES ('thumbrows', '3');
INSERT INTO cpg15x_config VALUES ('thumb_use', 'any');
INSERT INTO cpg15x_config VALUES ('thumb_width', '128');
INSERT INTO cpg15x_config VALUES ('time_offset', '0');
INSERT INTO cpg15x_config VALUES ('transparent_overlay', '0');
INSERT INTO cpg15x_config VALUES ('unsharp_amount', '120');
INSERT INTO cpg15x_config VALUES ('unsharp_radius', '0.5');
INSERT INTO cpg15x_config VALUES ('unsharp_threshold', '3');
INSERT INTO cpg15x_config VALUES ('upl_notify_admin_email', '0');
INSERT INTO cpg15x_config VALUES ('upload_create_album_directory', '0');
INSERT INTO cpg15x_config VALUES ('upload_mechanism', 'swfupload');
INSERT INTO cpg15x_config VALUES ('user_field1_name', '');
INSERT INTO cpg15x_config VALUES ('user_field2_name', '');
INSERT INTO cpg15x_config VALUES ('user_field3_name', '');
INSERT INTO cpg15x_config VALUES ('user_field4_name', '');
INSERT INTO cpg15x_config VALUES ('userpics', 'userpics/');
INSERT INTO cpg15x_config VALUES ('user_profile1_name', 'Location');
INSERT INTO cpg15x_config VALUES ('user_profile2_name', 'Interests');
INSERT INTO cpg15x_config VALUES ('user_profile3_name', 'Website');
INSERT INTO cpg15x_config VALUES ('user_profile4_name', 'Occupation');
INSERT INTO cpg15x_config VALUES ('user_profile5_name', '');
INSERT INTO cpg15x_config VALUES ('user_profile6_name', 'Biography');
INSERT INTO cpg15x_config VALUES ('user_registration_disclaimer', '1');
INSERT INTO cpg15x_config VALUES ('users_can_edit_pics', '0');
INSERT INTO cpg15x_config VALUES ('views_in_thumbview', '1');
INSERT INTO cpg15x_config VALUES ('vote_details', '0');
INSERT INTO cpg15x_config VALUES ('watermark_file', 'images/watermark.png');
INSERT INTO cpg15x_config VALUES ('watermark_transparency', '40');
INSERT INTO cpg15x_config VALUES ('watermark_transparency_featherx', '0');
INSERT INTO cpg15x_config VALUES ('watermark_transparency_feathery', '0');
INSERT INTO cpg15x_config VALUES ('where_put_watermark', 'southeast');
INSERT INTO cpg15x_config VALUES ('which_files_to_watermark', 'both');

dear Andre,
thank you very  mach. Now i see my gallery and it's running well! :)
Andrei

Logged
Pages: [1]   Go Up
 

Page created in 0.064 seconds with 20 queries.