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
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
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
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
is it possible that thhe upload function works for some people and does not work for others?
posting a test user account is a good idea, but where's the link?
Joachim
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.