Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Critical error  (Read 5177 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.026 seconds with 21 queries.