Upload error help Upload error help
 

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]

Main Menu

Upload error help

Started by ohfishing, November 04, 2004, 03:16:16 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

ohfishing

November 04, 2004, 03:16:16 AM
Hello Again Guys, phpbb2, cpg132 , windows xp
QuoteUSER:
------------------
Array
(
   [ID] => 8bb41fffd56e5feb42bb25bb297046ac
   [am] => 1
   [liv] => Array
       (
           
  • => 140
               [1] => 174
               [2] => 1013
               [3] => 1019
               [4] => 1036
           )

       [theme] => rainy_day
    )

    ==========================
    USER DATA:
    ------------------
    Array
    (
       
  • => 2
       [user_id] => 2
       [1] => JV
       [user_name] => JV
       [2] => 1
       [user_level] => 1
       [groups] => Array
           (
               
  • => 1
               [1] => 2
           )

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

    ==========================
    Queries:
    ------------------
    Array
    (
       
  • => SELECT extension, mime, content FROM cpg132_filetypes;
       [1] => SELECT user_id, username as user_name, user_level FROM `ohfishin_p_bb1`.phpbb_sessions INNER JOIN `ohfishin_p_bb1`.phpbb_users ON session_user_id = user_id WHERE session_id='c6a368d7b7ebf41fa581089038dcae39' AND session_user_id ='2' AND user_active='1'
       [2] => SELECT (ug.group_id + 5) as group_id FROM `ohfishin_p_bb1`.phpbb_user_group as ug LEFT JOIN `ohfishin_p_bb1`.phpbb_groups as g ON ug.group_id = g.group_id WHERE user_id = 2 AND user_pending = 0 AND group_single_user = 0
       [3] => 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 cpg132_usergroups WHERE group_id in (1,2)
       [4] => SELECT group_name FROM  cpg132_usergroups WHERE group_id= 1
       [5] => DELETE FROM cpg132_banned WHERE expiry < 1099534673
       [6] => SELECT * FROM cpg132_banned WHERE ip_addr='24.239.90.141' OR ip_addr='24.239.90.141' OR user_id=2
       [7] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = ''  ORDER BY pos
       [8] => SELECT aid FROM cpg132_albums as a WHERE category>=10000
       [9] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND category >= 10000
       [10] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '1'  ORDER BY pos
       [11] => SELECT aid FROM cpg132_albums WHERE category = 4
       [12] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND category = 4
       [13] => SELECT count(*) FROM cpg132_albums as a WHERE category = '4'
       [14] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg132_albums as a LEFT JOIN cpg132_pictures as p ON a.thumb=p.pid WHERE category=4 ORDER BY a.pos LIMIT 0,1
       [15] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg132_pictures WHERE aid IN (2) AND approved = 'YES' GROUP BY aid
       [16] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '4'  ORDER BY pos
       [17] => SELECT aid FROM cpg132_albums WHERE category = 8
       [18] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND category = 8
       [19] => SELECT count(*) FROM cpg132_albums as a WHERE category = '8'
       [20] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg132_albums as a LEFT JOIN cpg132_pictures as p ON a.thumb=p.pid WHERE category=8 ORDER BY a.pos LIMIT 0,1
       [21] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg132_pictures WHERE aid IN (8) AND approved = 'YES' GROUP BY aid
       [22] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '8'  ORDER BY pos
       [23] => SELECT aid FROM cpg132_albums WHERE category = 6
       [24] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND category = 6
       [25] => SELECT count(*) FROM cpg132_albums as a WHERE category = '6'
       [26] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg132_albums as a LEFT JOIN cpg132_pictures as p ON a.thumb=p.pid WHERE category=6 ORDER BY a.pos LIMIT 0,1
       [27] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg132_pictures WHERE aid IN (6) AND approved = 'YES' GROUP BY aid
       [28] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '6'  ORDER BY pos
       [29] => SELECT aid FROM cpg132_albums WHERE category = 7
       [30] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND category = 7
       [31] => SELECT count(*) FROM cpg132_albums as a WHERE category = '7'
       [32] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg132_albums as a LEFT JOIN cpg132_pictures as p ON a.thumb=p.pid WHERE category=7 ORDER BY a.pos LIMIT 0,1
       [33] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg132_pictures WHERE aid IN (7) AND approved = 'YES' GROUP BY aid
       [34] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '7'  ORDER BY pos
       [35] => SELECT aid FROM cpg132_albums WHERE category = 9
       [36] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND category = 9
       [37] => SELECT count(*) FROM cpg132_albums as a WHERE category = '9'
       [38] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg132_albums as a LEFT JOIN cpg132_pictures as p ON a.thumb=p.pid WHERE category=9 ORDER BY a.pos LIMIT 0,1
       [39] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg132_pictures WHERE aid IN (9) AND approved = 'YES' GROUP BY aid
       [40] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '9'  ORDER BY pos
       [41] => SELECT aid FROM cpg132_albums WHERE category = 10
       [42] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND category = 10
       [43] => SELECT count(*) FROM cpg132_albums as a WHERE category = '10'
       [44] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg132_albums as a LEFT JOIN cpg132_pictures as p ON a.thumb=p.pid WHERE category=10 ORDER BY a.pos LIMIT 0,1
       [45] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg132_pictures WHERE aid IN (10) AND approved = 'YES' GROUP BY aid
       [46] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '10'  ORDER BY pos
       [47] => SELECT aid FROM cpg132_albums WHERE category = 11
       [48] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND category = 11
       [49] => SELECT count(*) FROM cpg132_albums as a WHERE category = '11'
       [50] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg132_albums as a LEFT JOIN cpg132_pictures as p ON a.thumb=p.pid WHERE category=11 ORDER BY a.pos LIMIT 0,1
       [51] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg132_pictures WHERE aid IN (11) AND approved = 'YES' GROUP BY aid
       [52] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '11'  ORDER BY pos
       [53] => SELECT aid FROM cpg132_albums WHERE category = 12
       [54] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND category = 12
       [55] => SELECT count(*) FROM cpg132_albums as a WHERE category = '12'
       [56] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg132_albums as a LEFT JOIN cpg132_pictures as p ON a.thumb=p.pid WHERE category=12 ORDER BY a.pos LIMIT 0,1
       [57] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg132_pictures WHERE aid IN (12) AND approved = 'YES' GROUP BY aid
       [58] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '12'  ORDER BY pos
       [59] => SELECT aid FROM cpg132_albums WHERE category = 13
       [60] => SELECT count(*) FROM cpg132_pictures as p, cpg132_albums as a WHERE p.aid = a.aid AND category = 13
       [61] => SELECT count(*) FROM cpg132_albums as a WHERE category = '13'
       [62] => SELECT a.aid, a.title, a.description, visibility, filepath, filename, url_prefix, pwidth, pheight FROM cpg132_albums as a LEFT JOIN cpg132_pictures as p ON a.thumb=p.pid WHERE category=13 ORDER BY a.pos LIMIT 0,1
       [63] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg132_pictures WHERE aid IN (13) AND approved = 'YES' GROUP BY aid
       [64] => SELECT cid, name, description, thumb FROM cpg132_categories WHERE parent = '13'  ORDER BY pos
       [65] => SELECT aid FROM cpg132_albums as a WHERE category = '0'
       [66] => SELECT count(*) FROM cpg132_albums as a WHERE 1
       [67] => SELECT count(*) FROM cpg132_pictures as p LEFT JOIN cpg132_albums as a ON a.aid=p.aid WHERE 1
       [68] => SELECT count(*) FROM cpg132_comments as c LEFT JOIN cpg132_pictures as p ON c.pid=p.pid LEFT JOIN cpg132_albums as a ON a.aid=p.aid WHERE 1
       [69] => SELECT count(*) FROM cpg132_categories WHERE 1
       [70] => SELECT sum(hits) FROM cpg132_pictures as p LEFT JOIN cpg132_albums as a ON p.aid=a.aid WHERE 1
       [71] => SELECT count(*) FROM cpg132_albums as a WHERE category = '0'
       [72] => SELECT COUNT(*) from cpg132_pictures WHERE approved = 'YES'
       [73] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, aid FROM cpg132_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 8
       [74] => SELECT COUNT(*) from cpg132_pictures WHERE approved = 'YES'
       [75] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid,title, caption, owner_id, owner_name, aid FROM cpg132_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,8
    )

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

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

    ==========================
    VERSION INFO :
    ------------------
    PHP version: 4.3.8 - OK
    ------------------
    mySQL version: 4.0.16
    ------------------
    Coppermine version: 1.3.2
    ==========================
    Module: gd
    ------------------
    GD Support enabled
    GD Version bundled (2.0.23 compatible)
    FreeType Support enabled
    FreeType Linkage with freetype
    GIF Read Support enabled
    JPG Support enabled
    PNG Support enabled
    WBMP Support enabled
    XBM Support enabled
    ==========================
    Module: mysql
    ------------------
    Active Persistent Links 0
    Active Links 1
    Client API version 3.23.49
    MYSQL_MODULE_TYPE builtin
    MYSQL_SOCKET /tmp/mysql.sock
    MYSQL_INCLUDE no value
    MYSQL_LIBS no value
    ==========================
    Module: zlib
    ------------------
    ZLib Support enabled
    Compiled Version 1.2.1
    Linked Version 1.2.1
    ==========================
    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/local/lib/php | .:/usr/local/lib/php
    open_basedir | no value | no value
    ==========================
    email
    ------------------
    Directive | Local Value | Master Value
    sendmail_from | me@localhost.com | me@localhost.com
    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 | 30 | 30
    max_input_time | -1 | -1
    upload_max_filesize | 2M | 2M
    post_max_size | 8M | 8M
    ==========================
    Page generated in 0.746 seconds - 76 queries in 0.633 seconds - Album set :
Out of the blue errors on upload as follows...
QuoteThere was an error while processing a database query
Code Select
While executing query "INSERT INTO cpg132_pictures (pid, aid, filepath, filename, filesize, total_filesize, pwidth, pheight, ctime, owner_id, owner_name, title, caption, keywords, approved, user1, user2, user3, user4, pic_raw_ip, pic_hdr_ip) VALUES ('', '11', 'userpics/', 'Catfish.jpg', '102920', '141236', '550', '412', '1099530591', '472', 'lil'v','test', 'test', '', 'NO', '', '', '', '', '24.239.90.141', '24.239.90.141')" on 0

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 'v','test', 'test', '', 'NO', '', '', '', '', '24.239.90.141', '
 I was reading your MUST READ thread and I discovered my album/edit folder needed to be set to chmod 777 , I made the change , still no luck. Please tell me this is an easy one. Thanks Again
OHfishing

ohfishing

#1
November 04, 2004, 03:54:30 AM
I can upload pics with the admin account , but nobody else can upload pics, I uploaded 3 pictures as admin, logged in with someone elses account and got this error ....
QuoteThere was an error while processing a database query
test account coppermine  test password - test  I will have the debug mode ON for you guys to have a look... Thank you guys
OHfishing

ohfishing

#2
November 04, 2004, 04:39:35 AM
Code Select
Notice: Undefined index: offline in /home/ohfishin/.panel/web/bulletin/phpBB2/cpg132/include/init.inc.php on line 381

Notice: Undefined index: user1 in /home/ohfishin/.panel/web/bulletin/phpBB2/cpg132/db_input.php on line 202

Notice: Undefined index: user2 in /home/ohfishin/.panel/web/bulletin/phpBB2/cpg132/db_input.php on line 203

Notice: Undefined index: user3 in /home/ohfishin/.panel/web/bulletin/phpBB2/cpg132/db_input.php on line 204

Notice: Undefined index: user4 in /home/ohfishin/.panel/web/bulletin/phpBB2/cpg132/db_input.php on line 205

Notice: Undefined index: width in /home/ohfishin/.panel/web/bulletin/phpBB2/cpg132/db_input.php on line 300

Notice: Undefined index: height in /home/ohfishin/.panel/web/bulletin/phpBB2/cpg132/db_input.php on line 300
OHfishing

ohfishing

#3
November 04, 2004, 04:55:18 AM
is it possible that thhe upload function works for some people and does not work for others?
OHfishing

Joachim Müller

#4
November 04, 2004, 10:18:58 AM
posting a test user account is a good idea, but where's the link?

Joachim

Casper

#5
November 04, 2004, 11:49:11 AM
This seems to be because the user name(lil'v) has an apostrophy in it.

I seem to remember we had problems with this some versions ago, but I thought it was fixed.

Try removing the ' from the username and see if uploads work for that user again.
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here
Print
Go Up Pages1
User actions