Upload error help

[ohfishing]

Hello Again Guys, phpbb2, cpg132 , windows xp

USER:
------------------
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 ( 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...

There was an error while processing a database query

Code Select Expand

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]

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 ....

There 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]

Code Select Expand

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]

is it possible that thhe upload function works for some people and does not work for others?

[Joachim Müller]

posting a test user account is a good idea, but where's the link?

Joachim

[Casper]

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.