php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
Bug #38191 i lost my database
Submitted: 2006-07-23 15:47 UTC Modified: 2006-07-23 16:25 UTC
From: femmefotog at cox dot net Assigned:
Status: Not a bug Package: Unknown/Other Function
PHP Version: 5.1.4 OS: apache
Private report: No CVE-ID: None
 [2006-07-23 15:47 UTC] femmefotog at cox dot net
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


Patches

Add a Patch

Pull Requests

Add a Pull Request

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2006-07-23 15:59 UTC] helly@php.net
Sorry, but your problem does not imply a bug in PHP itself.  For a
list of more appropriate places to ask for help using PHP, please
visit http://www.php.net/support.php as this bug system is not the
appropriate forum for asking support questions.  Due to the volume
of reports we can not explain in detail here why your report is not
a bug.  The support channels will be able to provide an explanation
for you.

Thank you for your interest in PHP.

I don\'t see any php code here and we cannot solve your database problems.
 [2006-07-23 16:25 UTC] femmefotog at cox dot net
i need serious help  619-934-6547
 
PHP Copyright © 2001-2024 The PHP Group
All rights reserved.
Last updated: Sat May 18 10:01:32 2024 UTC