From: femmefotog at cox dot net
Operating system: apache
PHP version: 5.1.4
PHP Bug Type: Unknown/Other Function
Bug description: i lost my database
Description:
------------
i want it to look like it did 2 days a go
Reproduce code:
---------------
USER:
------------------
Array
(
[ID] => 3aa301dee36d6013126ae869cd3824c7
[am] => 1
[liv] => Array
(
[0] => 564
[1] => 563
[2] => 562
[3] => 376
[4] => 392
)
[search] => ###zipped files
)
==========================
USER DATA:
------------------
Array
(
[user_id] => 1
[user_group] => 1
[user_active] => YES
[user_name] => yvette
[user_password] => ********
[user_lastvisit] => 2006-07-23 11:22:23
[user_regdate] => 2005-08-04 17:48:26
[user_group_list] =>
[user_email] =>
[user_website] => http://images4sale.com/store/2847
[user_location] => san diego
[user_interests] =>
[user_occupation] =>
[user_actkey] =>
[disk_max] => 0
[disk_min] => 0
[can_rate_pictures] => 1
[can_send_ecards] => 1
[ufc_max] => 1
[ufc_min] => 1
[custom_user_upload] => 1
[num_file_upload] => 10
[num_URI_upload] => 10
[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] => 1
[group_quota] => 0
[can_see_all_albums] => 1
[group_id] => 1
[groups] => Array
(
[1] => 1
)
)
==========================
Queries:
------------------
Array
(
[0] => SELECT extension, mime, content FROM cp_filetypes;
[1] => SELECT * FROM cp_users WHERE user_id='1'AND user_active = 'YES'
AND user_password != '' AND BINARY MD5(user_password) =
'dadcf30382afe893f31f1a4db7dc4f38'
[2] => 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 cp_usergroups
WHERE group_id in (1)
[3] => SELECT group_name FROM cp_usergroups WHERE group_id= 1
[4] => DELETE FROM cp_banned WHERE expiry < '2006-07-23 11:35:53'
[5] => SELECT * FROM cp_banned WHERE ip_addr='72.199.9.150' OR
ip_addr='72.199.9.150' OR user_id=1
[6] => SELECT cid, name, description, thumb FROM cp_categories WHERE
parent = '' ORDER BY pos
[7] => SELECT aid FROM cp_albums WHERE category = 5
[8] => SELECT count(*) FROM cp_pictures as p, cp_albums as a WHERE
p.aid = a.aid AND category = 5
[9] => SELECT cid, name, description, thumb FROM cp_categories WHERE
parent = '5' ORDER BY pos
[10] => SELECT aid FROM cp_albums as a WHERE category>=10000
[11] => SELECT count(*) FROM cp_pictures as p, cp_albums as a WHERE
p.aid = a.aid AND category >= 10000
[12] => SELECT aid FROM cp_albums as a WHERE category = '0'
[13] => SELECT count(*) FROM cp_albums as a WHERE 1
[14] => SELECT count(*) FROM cp_pictures as p LEFT JOIN cp_albums as a
ON a.aid=p.aid WHERE 1
[15] => SELECT count(*) FROM cp_comments as c LEFT JOIN cp_pictures as
p ON c.pid=p.pid LEFT JOIN cp_albums as a ON a.aid=p.aid WHERE 1
[16] => SELECT count(*) FROM cp_categories WHERE 1
[17] => SELECT sum(hits) FROM cp_pictures as p LEFT JOIN cp_albums as
a ON p.aid=a.aid WHERE 1
[18] => SELECT count(*) FROM cp_albums as a WHERE category = '0'
[19] => SELECT a.aid, a.title, a.description, visibility, filepath,
filename, url_prefix, pwidth, pheight FROM cp_albums as a LEFT JOIN
cp_pictures as p ON a.thumb=p.pid WHERE category=0 ORDER BY a.pos LIMIT
0,1
[20] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid,
max(ctime) as last_upload FROM cp_pictures WHERE aid IN (11) AND approved
= 'YES' GROUP BY aid
[21] => SELECT COUNT(*) from cp_pictures WHERE approved = 'YES'
[22] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth,
pheight, ctime, aid, aid FROM cp_pictures WHERE approved = 'YES' ORDER BY
RAND() LIMIT 8
[23] => SELECT COUNT(*) from cp_pictures WHERE approved = 'YES'
[24] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth,
pheight, ctime, aid,title, caption, owner_id, owner_name, aid FROM
cp_pictures WHERE approved = 'YES' ORDER BY pid DESC LIMIT 0 ,8
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 4.4.2 - OK
------------------
mySQL version: 4.1.19-standard
------------------
Coppermine version: 1.3.3
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.28 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
GIF Create 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 4.1.19
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -lmysqlclient
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.1.4
Linked Version 1.1.4
==========================
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 |
system,system_exec,passthru,popen,dlopen,ini_alter,show_source,escapeshellcmd,proc_close,proc_open
|
system,system_exec,passthru,popen,dlopen,ini_alter,show_source,escapeshellcmd,proc_close,proc_open
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 | 30 | 30
max_input_time | -1 | -1
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.026 seconds - 25 queries in 0.004 seconds - Album set
:
Expected result:
----------------
to upload more pics
--
Edit bug report at http://bugs.php.net/?id=38191&edit=1
--
Try a CVS snapshot (PHP 4.4):
http://bugs.php.net/fix.php?id=38191&r=trysnapshot44
Try a CVS snapshot (PHP 5.2):
http://bugs.php.net/fix.php?id=38191&r=trysnapshot52
Try a CVS snapshot (PHP 6.0):
http://bugs.php.net/fix.php?id=38191&r=trysnapshot60
Fixed in CVS: http://bugs.php.net/fix.php?id=38191&r=fixedcvs
Fixed in release:
http://bugs.php.net/fix.php?id=38191&r=alreadyfixed
Need backtrace: http://bugs.php.net/fix.php?id=38191&r=needtrace
Need Reproduce Script: http://bugs.php.net/fix.php?id=38191&r=needscript
Try newer version: http://bugs.php.net/fix.php?id=38191&r=oldversion
Not developer issue: http://bugs.php.net/fix.php?id=38191&r=support
Expected behavior: http://bugs.php.net/fix.php?id=38191&r=notwrong
Not enough info:
http://bugs.php.net/fix.php?id=38191&r=notenoughinfo
Submitted twice:
http://bugs.php.net/fix.php?id=38191&r=submittedtwice
register_globals: http://bugs.php.net/fix.php?id=38191&r=globals
PHP 3 support discontinued: http://bugs.php.net/fix.php?id=38191&r=php3
Daylight Savings: http://bugs.php.net/fix.php?id=38191&r=dst
IIS Stability: http://bugs.php.net/fix.php?id=38191&r=isapi
Install GNU Sed: http://bugs.php.net/fix.php?id=38191&r=gnused
Floating point limitations: http://bugs.php.net/fix.php?id=38191&r=float
No Zend Extensions: http://bugs.php.net/fix.php?id=38191&r=nozend
MySQL Configuration Error: http://bugs.php.net/fix.php?id=38191&r=mysqlcfg
