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: CpmFetch error  (Read 16488 times)

0 Members and 1 Guest are viewing this topic.

Sandrina

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 45
CpmFetch error
« on: June 09, 2010, 08:57:22 pm »

Hi.
I have this error
Code: [Select]
Unknown column 'p.owner_name' in 'field list'

SELECT p.filepath AS pFilepath, p.filename AS pFilename, p.aid AS pAid, p.filesize AS pFilesize, p.title AS pTitle, p.caption AS pCaption, p.owner_name AS pOwner_name, p.owner_id as pOwnerId, p.ctime AS pCtime, p.hits AS pHits, p.pid AS pPid, p.pic_rating AS pPic_Rating, p.votes AS pVotes, p.pwidth AS pWidth, p.pheight AS pHeight, p.user1 as pUser1, p.user2 as pUser2, p.user3 as pUser3, p.user4 as pUser4, c.cid as cCid, c.name as cName, c.description as cDescription, c.pos as cPos, c.parent as cParent, c.thumb as cThumb, u.user_lastvisit AS uUser_lastvisit,u.user_regdate AS uUser_regdate,u.user_email AS uUser_email,u.user_profile1 AS uUser_profile1,u.user_profile2 AS uUser_profile2,u.user_profile3 AS uUser_profile3,u.user_profile4 AS uUser_profile4,u.user_profile5 AS uUser_profile5,u.user_profile6 AS uUser_profile6, a.aid AS aAid, a.title AS aTitle, a.description AS aDescription, a.visibility as aVisibility, a.pos as aPos, a.category as aCategory, a.thumb as aThumb, a.keyword as aKeyword FROM cpg14x_pictures AS p LEFT JOIN cpg14x_users AS u ON p.owner_id = u.user_id LEFT JOIN cpg14x_albums AS a ON p.aid = a.aid LEFT JOIN cpg14x_categories AS c ON a.category = c.cid WHERE 1 AND p.approved='YES' AND ((a.visibility = 0 OR a.visibility IS NULL) AND (a.alb_password IS NULL OR a.alb_password = "")) ORDER BY p.ctime DESC LIMIT 0,4

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/savtreyn/emmy-rossum.info/gallery/cpmfetch/cpmfetch_dao.php on line 1349

Warning: mysql_free_result(): supplied argument is not a valid MySQL result resource in /home/savtreyn/emmy-rossum.info/gallery/cpmfetch/cpmfetch_dao.php on line 1353

coppermain gallery version Coppermine Photo Gallery 1.4.25 (stable)
cpmFetch version 2.1.1
also installed stramm_mod1.4.24.bridge

thank you for any help!))
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: CpmFetch error
« Reply #1 on: June 09, 2010, 10:02:21 pm »

Stop behaving like a jerk: respect board rules and common sense! Read up the stickies, especially About this sub-board (read first!)
Logged

Sandrina

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 45
Re: CpmFetch error
« Reply #2 on: June 09, 2010, 10:34:17 pm »

i read rules and use search and didn't find normal answer to my question!
Logged

phill104

  • Administrator
  • Coppermine addict
  • *****
  • Country: gb
  • Offline Offline
  • Gender: Male
  • Posts: 4885
    • Windsurf.me
Re: CpmFetch error
« Reply #3 on: June 09, 2010, 11:06:00 pm »

If you read the rules you would have noticed that we require a link you your gallery. Instead of argueing please do that and everything outlined in Joachim's second link. We are not asking for our benefit but for yours. If you want help then do as asked. We are not mind readers nor do we have crystal balls so we need to see the problems for ourselves.

You really don't want to know how many times we've had to write that. It is no wonder we get frustrated.
Logged
It is a mistake to think you can solve any major problems just with potatoes.

Sandrina

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 45
Re: CpmFetch error
« Reply #4 on: June 10, 2010, 11:36:09 am »

Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: CpmFetch error
« Reply #5 on: June 10, 2010, 12:51:13 pm »

Great! Excellent. So you have done as suggested in
Stop behaving like a jerk: respect board rules and common sense!
Now would you mind to read up the second sentence in my posting
Read up the stickies, especially About this sub-board (read first!)
and do as suggested there? Phill already told you that we're out of crystal balls. Your next posting that shows you're lazy will result in you getting ignored permanently.
Logged

Sandrina

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 45
Re: CpmFetch error
« Reply #6 on: June 10, 2010, 01:59:05 pm »

1. i search in this forum about the same problems, but it didn't help me, for example this and this posts
http://forum.coppermine-gallery.net/index.php/topic,65375.0.html
http://forum.coppermine-gallery.net/index.php/topic,65302.0.html
in google i didn't find any useful info

2. i don't want to install Coppermine 1.5.6, because thiere isn't right plugins for this version yet and cpmFetch work well until yeasterday

3. gallery work well, it didn't have any errors, only 1 problem with this plugin

Logged

Sandrina

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 45
Re: CpmFetch error
« Reply #7 on: June 10, 2010, 02:02:52 pm »

Debug Information:

Code: [Select]
CpmFetch Install Script version 2.0.0
do=install
path=
force=true
Command install issued to script
* * BEGIN SERVER SETTINGS * *
SERVER PATH: /usr/local/bin:/usr/bin:/bin
SERVER REDIRECT_HANDLER: application/x-httpd-php5
SERVER REDIRECT_STATUS: 200
SERVER HTTP_USER_AGENT: Opera/9.27 (Windows NT 5.1; U; ru)
SERVER HTTP_HOST: emmy-rossum.info
SERVER HTTP_ACCEPT: text/html, application/xml;q=0.9, application/xhtml+xml, ima
ge/png, image/jpeg, image/gif, image/x-xbitmap, */*;q=0.1
SERVER HTTP_ACCEPT_LANGUAGE: ru,en;q=0.9,ru-RU;q=0.8
SERVER HTTP_ACCEPT_CHARSET: iso-8859-1, utf-8, utf-16, *;q=0.1
SERVER HTTP_ACCEPT_ENCODING: gzip, deflate
SERVER HTTP_REFERER: http://emmy-rossum.info/gallery/cpmfetch/install.php
SERVER HTTP_COOKIE: c3f62345a85519d01df95a899010baff=5231db542f0580a7d8f05f404a1
c0465; coppermine_data=YTozOntzOjI6IklEIjtzOjMyOiJhNGZlZjEwZDQ0NTVhMDc4OTk1ZDBiZ
TE3M2NkZWU0MyI7czoyOiJhbSI7aToxO3M6NDoibGFuZyI7czo3OiJydXNzaWFuIjt9
SERVER HTTP_COOKIE2: $Version=1
SERVER HTTP_CONNECTION: Keep-Alive
SERVER SERVER_SIGNATURE:
SERVER SERVER_SOFTWARE: Apache
SERVER SERVER_NAME: emmy-rossum.info
SERVER SERVER_ADDR: 91.149.157.37
SERVER SERVER_PORT: 80
SERVER REMOTE_ADDR: 212.98.187.154
SERVER DOCUMENT_ROOT: /home/savtreyn/emmy-rossum.info
SERVER SERVER_ADMIN: webmaster@emmy-rossum.savtrey.net
SERVER SCRIPT_FILENAME: /home/savtreyn/emmy-rossum.info/gallery/cpmfetch/install
.php
SERVER REMOTE_PORT: 1925
SERVER REDIRECT_QUERY_STRING: do=install&force=true
SERVER REDIRECT_URL: /gallery/cpmfetch/install.php
SERVER GATEWAY_INTERFACE: CGI/1.1
SERVER SERVER_PROTOCOL: HTTP/1.1
SERVER REQUEST_METHOD: GET
SERVER QUERY_STRING: do=install&force=true
SERVER REQUEST_URI: /gallery/cpmfetch/install.php?do=install&force=true
SERVER SCRIPT_NAME: /gallery/cpmfetch/install.php
SERVER ORIG_SCRIPT_FILENAME: /usr/local/cpanel/cgi-sys/php5
SERVER ORIG_PATH_INFO: /gallery/cpmfetch/install.php
SERVER ORIG_PATH_TRANSLATED: /home/savtreyn/emmy-rossum.info/gallery/cpmfetch/in
stall.php
SERVER ORIG_SCRIPT_NAME: /cgi-sys/php5
SERVER PHP_SELF: /gallery/cpmfetch/install.php
SERVER REQUEST_TIME: 1276171327
SERVER argv: Array
SERVER argc: 1
* * END SERVER SETTINGS * *
Found config file at ../include/config.inc.php
Found init file at ../include/init.inc.php
force set, skipping version checks
Opening config file at ../include/config.inc.php
Retrieving config from database
* * BEGIN CPG CONFIG TABLE * *
CONFIG: albums_per_page: 12
CONFIG: album_list_cols: 2
CONFIG: display_pic_info: 0
CONFIG: alb_list_thumb_size: 80
CONFIG: allowed_mov_types: asf/asx/mpg/mpeg/wmv/swf/avi/mov
CONFIG: allowed_doc_types: doc/txt/rtf/pdf/xls/pps/ppt/zip/gz/mdb
CONFIG: allowed_snd_types: mp3/midi/mid/wma/wav/ogg
CONFIG: allowed_img_types: ALL
CONFIG: allow_private_albums: 1
CONFIG: allow_user_registration: 0
CONFIG: allow_unlogged_access: 1
CONFIG: allow_duplicate_emails_addr: 0
CONFIG: caption_in_thumbview: 1
CONFIG: views_in_thumbview: 1
CONFIG: charset: utf-8
CONFIG: cookie_name: coppermine
CONFIG: cookie_path: /
CONFIG: debug_mode: 0
CONFIG: debug_notice: 0
CONFIG: default_dir_mode: 0755
CONFIG: default_file_mode: 0644
CONFIG: default_sort_order: na
CONFIG: ecards_more_pic_target: http://emmy-rossum.info/gallery/
CONFIG: home_target: index.php
CONFIG: custom_lnk_name: Back to site
CONFIG: custom_lnk_url: http://emmy-rossum.info/
CONFIG: enable_smilies: 1
CONFIG: filter_bad_words: 0
CONFIG: forbiden_fname_char: $/\\:*?"'<>|` &
CONFIG: fullpath: albums/
CONFIG: gallery_admin_email: sania15@tut.by
CONFIG: gallery_description: your best russian photo gallery
CONFIG: gallery_name: Emmy Rossum INFO
CONFIG: im_options: -antialias
CONFIG: impath:
CONFIG: jpeg_qual: 100
CONFIG: keep_votes_time: 30
CONFIG: lang: english
CONFIG: main_page_layout: breadcrumb/catlist/alblist/random,1/lastup,1
CONFIG: main_table_width: 100%
CONFIG: make_intermediate: 1
CONFIG: max_com_lines: 10
CONFIG: max_com_size: 512
CONFIG: max_com_wlength: 38
CONFIG: max_img_desc_length: 512
CONFIG: max_tabs: 12
CONFIG: max_upl_size: 1000024
CONFIG: max_upl_width_height: 100000
CONFIG: auto_resize: 0
CONFIG: min_votes_for_rating: 1
CONFIG: normal_pfx: normal_
CONFIG: offline: 0
CONFIG: picture_table_width: 100%
CONFIG: picture_width: 400
CONFIG: read_exif_data: 0
CONFIG: reg_requires_valid_email: 1
CONFIG: subcat_level: 1
CONFIG: theme: v7
CONFIG: thumbcols: 4
CONFIG: thumbrows: 3
CONFIG: thumb_method: gd2
CONFIG: thumb_pfx: thumb_
CONFIG: thumb_width: 80
CONFIG: userpics: userpics/
CONFIG: fullsize_padding_x: 5
CONFIG: user_profile1_name: Location
CONFIG: user_profile2_name: Interests
CONFIG: user_profile3_name: Website
CONFIG: user_profile4_name: Occupation
CONFIG: user_profile5_name:
CONFIG: user_profile6_name: Biography
CONFIG: user_field1_name:
CONFIG: user_field2_name:
CONFIG: user_field3_name:
CONFIG: user_field4_name:
CONFIG: display_comment_count: 0
CONFIG: show_private: 0
CONFIG: first_level: 0
CONFIG: display_film_strip: 1
CONFIG: comments_per_page: 20
CONFIG: max_film_strip_items: 5
CONFIG: thumb_use: ht
CONFIG: read_iptc_data: 0
CONFIG: reg_notify_admin_email: 0
CONFIG: disable_comment_flood_protect: 0
CONFIG: upl_notify_admin_email: 0
CONFIG: display_uploader: 0
CONFIG: display_filename: 0
CONFIG: user_registration_disclaimer: 1
CONFIG: display_thumbnail_rating: 0
CONFIG: allow_memberlist: 0
CONFIG: show_bbcode_help: 1
CONFIG: log_ecards: 0
CONFIG: email_comment_notification: 0
CONFIG: enable_zipdownload: 1
CONFIG: slideshow_interval: 5000
CONFIG: log_mode: 0
CONFIG: media_autostart: 1
CONFIG: enable_encrypted_passwords: 1
CONFIG: time_offset: 0
CONFIG: thumbnail_to_fullsize: 0
CONFIG: smtp_host:
CONFIG: smtp_username:
CONFIG: smtp_password:
CONFIG: enable_plugins: 1
CONFIG: enable_help: 2
CONFIG: categories_alpha_sort: 0
CONFIG: login_threshold: 5
CONFIG: login_expiry: 10
CONFIG: allow_email_change: 0
CONFIG: clickable_keyword_search: 1
CONFIG: users_can_edit_pics: 0
CONFIG: 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
CONFIG: link_pic_count: 0
CONFIG: bridge_enable: 0
CONFIG: vote_details: 0
CONFIG: hit_details: 0
CONFIG: browse_batch_add: 1
CONFIG: custom_header_path:
CONFIG: custom_footer_path:
CONFIG: comments_sort_descending: 0
CONFIG: report_post: 0
CONFIG: comments_anon_pfx: Guest_
CONFIG: admin_activation: 0
CONFIG: enable_unsharp: 0
CONFIG: unsharp_amount: 120
CONFIG: unsharp_radius: 0.5
CONFIG: unsharp_threshold: 3
CONFIG: thumb_height: 140
CONFIG: enable_watermark: 0
CONFIG: where_put_watermark: southeast
CONFIG: watermark_file: images/watermark.png
CONFIG: which_files_to_watermark: both
CONFIG: orig_pfx: orig_
CONFIG: watermark_transparency: 40
CONFIG: reduce_watermark: 0
CONFIG: watermark_transparency_featherx: 0
CONFIG: watermark_transparency_feathery: 0
CONFIG: enable_mini_thumbs: 0
CONFIG: mini_thumb_width: 60
CONFIG: mini_thumb_height: 60
CONFIG: mini_pfx: mini_
CONFIG: mini_as_category_lead: 0
CONFIG: enable_user_notification: 0
CONFIG: enable_avatar: 0
CONFIG: pms_enabled: 0
CONFIG: pms_messages: 200
CONFIG: pms_enable_email: 1
CONFIG: pms_make_links: 1
CONFIG: pms_date_format: l dS of F Y
CONFIG: pms_time_format: h:i:s
CONFIG: pms_smilies: 1
CONFIG: pms_post_flood: 30
CONFIG: pms_message_bbcode: 1
CONFIG: pms_message_img_tag: 1
CONFIG: display_buddy_status: 1
CONFIG: display_pms_status: 1
CONFIG: enable_custom_thumbs: 1
CONFIG: enable_thumb_watermark: 1
CONFIG: enable_buddy: 0
CONFIG: enable_buddy_email: 1
CONFIG: enable_buddy_private_view: 1
CONFIG: buddy_enhanced_display: 1
CONFIG: fast_stats: 0
CONFIG: enable_stats: 1
CONFIG: enable_loginform: 0
CONFIG: info_block_align: 0
CONFIG: display_pic_voting: 0
CONFIG: display_pic_rating: 0
CONFIG: lang_autodetect: 1
CONFIG: language_fallback: 0
CONFIG: global_registration_pw:
CONFIG: picinfo_movie_download_link: 1
CONFIG: site_token: ba65b5ccd938393c35c054c4e62f4777
CONFIG: form_token_lifetime: 900
CONFIG: rating_stars_amount: 5
CONFIG: old_style_rating: 0
CONFIG: login_method: username
CONFIG: fullsize_padding_y: 3
CONFIG: comment_approval: 0
CONFIG: display_comment_approval_only: 0
CONFIG: comment_placeholder: 1
CONFIG: comment_user_edit: 1
CONFIG: comment_captcha: 1
CONFIG: silly_safe_mode: 0
CONFIG: registration_captcha: 0
CONFIG: ecard_flash: 0
CONFIG: personal_album_on_registration: 0
CONFIG: slideshow_hits: 1
CONFIG: transparent_overlay: 0
CONFIG: comment_promote_registration: 0
CONFIG: allow_user_account_delete: 0
CONFIG: display_stats_on_index: 1
CONFIG: browse_by_date: 0
CONFIG: allow_user_move_album: 0
CONFIG: allow_user_edit_after_cat_close: 0
CONFIG: display_redirection_page: 0
CONFIG: display_thumbs_batch_add: 1
CONFIG: display_film_strip_filename: 0
CONFIG: display_coppermine_news: 1
CONFIG: contact_form_guest_enable: 0
CONFIG: contact_form_guest_name_field: 2
CONFIG: contact_form_guest_email_field: 2
CONFIG: contact_form_registered_enable: 0
CONFIG: contact_form_subject_content: Coppermine gallery contact form
CONFIG: contact_form_subject_field: 0
CONFIG: contact_form_sender_email: 1
CONFIG: display_sidebar_user: 0
CONFIG: display_sidebar_guest: 0
CONFIG: allow_user_album_keyword: 1
CONFIG: count_file_hits: 1
CONFIG: count_album_hits: 1
CONFIG: enable_menu_icons: 0
CONFIG: display_xp_publish_link: 0
CONFIG: purge_expired_bans: 1
CONFIG: comment_akismet_enable: 0
CONFIG: comment_akismet_api_key:
CONFIG: comment_akismet_counter: 0
CONFIG: comment_akismet_group: 0
CONFIG: language_autodetect: 1
CONFIG: upload_mechanism: swfupload
CONFIG: allow_user_upload_choice: 1
CONFIG: tabs_dropdown: 1
CONFIG: keyword_separator: 
CONFIG: batch_proc_limit: 2
CONFIG: display_reset_boxes_in_config: 0
CONFIG: performance_timestamp: 0
CONFIG: performance_page_generation_time: 0
CONFIG: performance_page_query_time: 0
CONFIG: performance_page_query_count: 0
CONFIG: rate_own_files: 0
CONFIG: count_admin_hits: 0
CONFIG: picture_use: thumb
CONFIG: session_cleanup: 1276100288
CONFIG: guest_token_cleanup: 0
CONFIG: enable_encrypted_alb_passwords: 1
CONFIG: language_list: 0
CONFIG: language_flags: 0
CONFIG: theme_list: 0
CONFIG: language_reset: 1
CONFIG: theme_reset: 1
CONFIG: vanity_block: 1
CONFIG: display_faq: 0
CONFIG: ban_private_ip: 0
* * END CPG CONFIG TABLE * *
* * BEGIN CPG BRIDGE TABLE * *
BRIDGE: short_name:
BRIDGE: license_number:
BRIDGE: db_database_name:
BRIDGE: db_hostname:
BRIDGE: db_username:
BRIDGE: db_password:
BRIDGE: full_forum_url:
BRIDGE: relative_path_of_forum_from_webroot:
BRIDGE: relative_path_to_config_file:
BRIDGE: logout_flag:
BRIDGE: use_post_based_groups:
BRIDGE: cookie_prefix:
BRIDGE: table_prefix:
BRIDGE: user_table:
BRIDGE: session_table:
BRIDGE: group_table:
BRIDGE: group_relation_table:
BRIDGE: group_mapping_table:
BRIDGE: use_standard_groups: 1
BRIDGE: validating_group:
BRIDGE: guest_group:
BRIDGE: member_group:
BRIDGE: admin_group:
BRIDGE: banned_group:
BRIDGE: global_moderators_group:
BRIDGE: recovery_logon_failures: 0
BRIDGE: recovery_logon_timestamp:
BRIDGE: avatar_path:
* * END CPG BRIDGE TABLE * *
Closed database connection
Opening init file at ../include/init.inc.php
Reading init file at ../include/init.inc.php
InitFile: CPG Version 1.4.25
Closing init file
* * Generating Dynamic Defaults * *
filesystem_path_to_cpg:/home/savtreyn/emmy-rossum.info/gallery/
domain_name:emmy-rossum.info
cpg_album_url:http://emmy-rossum.info/gallery/albums/
cpg_url:http://emmy-rossum.info/gallery/
* * Assigning bridged settings * *
Bridge_enable: 0
Bridge_short_name:
Bridging is not enabled in CPG
Opening cpmfetch config file: cpmfetch_config.php
Writing cpmfetch config file cpmfetch_config.php
Completed writing config file
Producing output screen and exiting
Logged

Sandrina

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 45
Re: CpmFetch error
« Reply #8 on: June 10, 2010, 02:16:19 pm »

i checked gallery again and find 1 problem with adding files
Critical error There was an error while processing a database query

so, as i understand, all my problems related with database
But i don't understand, why this appeared and how can i fix it?
Logged

Sandrina

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 45
Re: CpmFetch error
« Reply #9 on: June 10, 2010, 02:24:44 pm »

Debug Info
Code: [Select]
USER:
------------------
Array
(
    [ID] => 7d5331987f0621c042f67861e56e9591
    [am] => 1
    [lang] => russian
    [liv] => Array
        (
        )

    [lap] => 4
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => Sandrina
    [groups] => Array
        (
            [0] => 1
        )

    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg14x_filetypes; (0s)
    [1] => select * from cpg14x_plugins order by priority asc; (0s)
    [2] => delete from `savtreyn_emmygal`.cpg14x_sessions where time<1276168985 and remember=0; (0s)
    [3] => delete from `savtreyn_emmygal`.cpg14x_sessions where time<1274962985; (0s)
    [4] => select user_id from `savtreyn_emmygal`.cpg14x_sessions where session_id = '02f986108c8161e615693dde5fbf3a77' (0s)
    [5] => select user_id as id, user_password as password from `savtreyn_emmygal`.cpg14x_users where user_id=1 (0.011s)
    [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `savtreyn_emmygal`.cpg14x_users AS u INNER JOIN `savtreyn_emmygal`.cpg14x_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0s)
    [7] => SELECT user_group_list FROM `savtreyn_emmygal`.cpg14x_users AS u WHERE user_id='1' and user_group_list <> ''; (0s)
    [8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg14x_usergroups WHERE group_id in (1) (0s)
    [9] => SELECT group_name FROM  cpg14x_usergroups WHERE group_id= 1 (0s)
    [10] => update `savtreyn_emmygal`.cpg14x_sessions set time='1276172585' where session_id = '02f986108c8161e615693dde5fbf3a77' (0s)
    [11] => SELECT user_favpics FROM cpg14x_favpics WHERE user_id = 1 (0s)
    [12] => DELETE FROM cpg14x_banned WHERE expiry < '2010-06-10 15:23:05' (0s)
    [13] => SELECT * FROM cpg14x_banned WHERE (ip_addr='212.98.187.154' OR ip_addr='212.98.187.154' OR user_id=1) AND brute_force=0 (0s)
    [14] => SELECT cid, name, description, thumb FROM cpg14x_categories WHERE parent = ''  ORDER BY pos (0s)
    [15] => SELECT aid FROM cpg14x_albums as a WHERE category>=10000 (0s)
    [16] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category >= 10000 (0s)
    [17] => SELECT aid FROM cpg14x_albums WHERE category = 2 (0s)
    [18] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 2 (0s)
    [19] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '2' (0s)
    [20] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=2 ORDER BY a.pos LIMIT 0,12 (0s)
    [21] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (279, 280, 281, 282, 283, 284, 285, 286, 287, 288, 289, 290)GROUP BY a.aid (0s)
    [22] => SELECT aid FROM cpg14x_albums WHERE category = 3 (0.001s)
    [23] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 3 (0s)
    [24] => SELECT aid FROM cpg14x_albums WHERE category = 13 (0s)
    [25] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 13 (0s)
    [26] => SELECT aid FROM cpg14x_albums WHERE category = 25 (0s)
    [27] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 25 (0s)
    [28] => SELECT aid FROM cpg14x_albums WHERE category = 54 (0s)
    [29] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 54 (0s)
    [30] => SELECT aid FROM cpg14x_albums WHERE category = 52 (0s)
    [31] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 52 (0s)
    [32] => SELECT aid FROM cpg14x_albums WHERE category = 65 (0s)
    [33] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 65 (0s)
    [34] => SELECT aid FROM cpg14x_albums WHERE category = 66 (0s)
    [35] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 66 (0s)
    [36] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '66' (0s)
    [37] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_albums as a LEFT JOIN cpg14x_pictures as p ON a.thumb=p.pid WHERE category=66 ORDER BY a.pos LIMIT 0,8 (0s)
    [38] => SELECT a.aid, count( p.pid )  AS pic_count, max( p.pid )  AS last_pid, max( p.ctime )  AS last_upload, a.keyword FROM cpg14x_albums AS a  LEFT JOIN cpg14x_pictures AS p ON a.aid = p.aid AND p.approved =  'YES' WHERE a.aid IN (934, 935, 936, 937, 938, 939, 940, 941)GROUP BY a.aid (0s)
    [39] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='18291' (0s)
    [40] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='5249' (0s)
    [41] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='5431' (0s)
    [42] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='5222' (0s)
    [43] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg14x_pictures WHERE pid='5410' (0s)
    [44] => SELECT aid FROM cpg14x_albums WHERE category = 67 (0s)
    [45] => SELECT count(*) FROM cpg14x_pictures as p, cpg14x_albums as a WHERE p.aid = a.aid AND approved='YES' AND category = 67 (0s)
    [46] => SELECT aid FROM cpg14x_albums as a WHERE category = '0' (0s)
    [47] => SELECT count(*) FROM cpg14x_albums as a WHERE 1 (0s)
    [48] => SELECT count(*) FROM cpg14x_pictures as p LEFT JOIN cpg14x_albums as a ON a.aid=p.aid WHERE 1 AND approved='YES' (0s)
    [49] => SELECT count(*) FROM cpg14x_comments as c LEFT JOIN cpg14x_pictures as p ON c.pid=p.pid LEFT JOIN cpg14x_albums as a ON a.aid=p.aid WHERE 1 (0s)
    [50] => SELECT count(*) FROM cpg14x_categories WHERE 1 (0s)
    [51] => SELECT sum(hits) FROM cpg14x_pictures as p LEFT JOIN cpg14x_albums as a ON p.aid=a.aid WHERE 1 (0s)
    [52] => SELECT COUNT(*) FROM cpg14x_pictures WHERE approved = 'NO' (0s)
    [53] => SELECT count(*) FROM cpg14x_albums as a WHERE category = '0' (0s)
    [54] => SELECT * FROM cpg14x_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 4 (0.099s)
    [55] => SELECT COUNT(*) from cpg14x_pictures WHERE approved = 'YES'  (0s)
    [56] => SELECT * FROM cpg14x_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,4 (0.001s)
)

==========================
GET :
------------------
Array
(
)

==========================
POST :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version: 5.2.13 - OK
------------------
mySQL version: 5.0.86-percona-highperf-b19
------------------
Coppermine version: 1.4.25(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.34 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support:
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XPM Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 5.0.86
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib64 -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Stream Wrapper support compress.zlib://
Stream Filter support zlib.inflate, zlib.deflate
Compiled Version 1.2.3
Linked Version 1.2.3
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 70 | 70
max_input_time | 70 | 70
upload_max_filesize | 20M | 20M
post_max_size | 20M | 20M
==========================
Page generated in 0.622 seconds - 57 queries in 0.112 seconds - Album set : ; Meta set: ;
Logged

Sandrina

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 45
Re: CpmFetch error
« Reply #10 on: June 10, 2010, 05:14:54 pm »

tell me please if you need some other info to help me with this problem!)
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: CpmFetch error
« Reply #11 on: June 10, 2010, 05:30:07 pm »

Let me check: from Vuud's suggestions
Things to include in a cry for help:

    * The Exact error message.  "I get an error about something..." - Copy and paste
    * What version of coppermine you are using
    * What version of CoppermineFetch you are using
    * A link to your website and gallery
    * A link to an example of the problem (if possible)
    * How computer savvy you are (newbie, intermediate, damn good)
    * What kind of web server you are running on (if known)
    * Include the code you are using.
, let's run through what Vuud has asked for and what you have provided:
* The Exact error message.  "I get an error about something..." - Copy and paste
Yes, you have done that, in your initial posting
* What version of coppermine you are using
Yes, you have done that, again in your initial posting
* What version of CoppermineFetch you are using
Done that as well in the initail posting
* A link to your website and gallery
Partially done: we had to ask for it, but finally we got the link to your gallery. You haven't posted a link to your overall site, but probably it's http://www.emmy-rossum.info/, so that should be fine as well.
* A link to an example of the problem (if possible)
You failed though to post a link to the page where you are trying to run cpmFetch on.
* How computer savvy you are (newbie, intermediate, damn good)
Well, it's not that dramatic to skip this recommendation, but if I were in your shoes I would have posted it as well for completeness
* What kind of web server you are running on (if known)
You haven't posted that, but the output from cpmFetch's installer, which is OK as well.
* Include the code you are using.
Well, that's really a mistake/omission here. We can only guess (if at all).

Additionally, you have posted debug_output although nobody asked for it, and you're speed-posting... Hm...
Logged
Pages: [1]   Go Up
 

Page created in 0.031 seconds with 19 queries.