forum.coppermine-gallery.net
Support => Older/other versions => cpg1.3.x Support => Topic started by: kitebabe on June 18, 2004, 03:52:21 pm
-
Hello,
i have a big problem with my gallery here: http://flysurfing.free.fr/kitebabefinal/
you have the message: There was an error while processing a database query
I have change nothing to the databse !
Please, can you help me !
thanks in advance!
-
Try browsing directly to http://flysurfing.free.fr/kitebabefinal/config.php and if you can, turn on debug mode, near the bottom of the page.
If you cannot get to config, you will have to use your database tool to change it there. In the config table, browse to 'debug_mode', and change the setting to 1.
Post here what the debug info says.
-
Try browsing directly to http://flysurfing.free.fr/kitebabefinal/config.php and if you can, turn on debug mode, near the bottom of the page.
If you cannot get to config, you will have to use your database tool to change it there. In the config table, browse to 'debug_mode', and change the setting to 1.
Post here what the debug info says.
Hello Casper!
thanks for the answer !
I have this message: While executing query "SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category >= 10000" on 0
mySQL error: Can't open file: 'cpg11d_pictures.MYI'. (errno: 145)
USER:
------------------
Array
(
[ID] => 0d9ccccc5a110f868537dda3a6187d65
[am] => 1
[liv] => Array
(
- => 302
[1] => 15
[2] => 358
[3] => 393
[4] => 415
)
)
==========================
USER DATA:
------------------
Array
(
- => 1
[user_id] => 1
[1] => 1
[user_group] => 1
[2] => YES
[user_active] => YES
[3] => flysurfing
[user_name] => flysurfing
[4] => *********
[user_password] => ********
[5] => 2004-05-29 11:58:50
[user_lastvisit] => 2004-05-29 11:58:50
[6] => 2003-05-29 16:28:21
[user_regdate] => 2003-05-29 16:28:21
[7] =>
[user_lang] =>
[8] =>
[user_email] =>
[9] => www.kitebabe.fr.fm
[user_website] => www.kitebabe.fr.fm
[10] => Paris, France
[user_location] => Paris, France
[11] =>
[user_interests] =>
[12] =>
[user_occupation] =>
[13] =>
[user_actkey] =>
[14] => 1
[group_id] => 1
[15] => Administrators
[group_name] => Administrators
[16] => 0
[group_quota] => 0
[17] => 1
[has_admin_access] => 1
[18] => 1
[can_rate_pictures] => 1
[19] => 1
[can_send_ecards] => 1
[20] => 1
[can_post_comments] => 1
[21] => 1
[can_upload_pictures] => 1
[22] => 1
[can_create_albums] => 1
[23] => 0
[pub_upl_need_approval] => 0
[24] => 0
[priv_upl_need_approval] => 0
[25] => 3
[upload_form_config] => 3
[26] => 0
[custom_user_upload] => 0
[27] => 5
[num_file_upload] => 5
[28] => 3
[num_URI_upload] => 3
)
==========================
Queries:
------------------
Array
(
- => SELECT extension, mime, content FROM cpg11d_filetypes;
[1] => SELECT * FROM cpg11d_users, cpg11d_usergroups WHERE user_group = group_id AND user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '*******'
[2] => DELETE FROM cpg11d_banned WHERE expiry < 1087646378
[3] => SELECT * FROM cpg11d_banned WHERE ip_addr='81.256.****' OR ip_addr='81.56.********' OR user_id=1
[4] => SELECT cid, name, description, thumb FROM cpg11d_categories WHERE parent = '' ORDER BY pos
[5] => SELECT aid FROM cpg11d_albums WHERE category >= 10000
[6] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category >= 10000
)
==========================
GET :
------------------
Array
(
)
==========================
POST :
------------------
Array
(
)
==========================
VERSION INFO :
------------------
PHP version: 4.3.4 - OK
------------------
mySQL version: 4.0.20
==========================
Module: gd
------------------
GD Support enabled
GD Version 2.0 or higher
FreeType Support enabled
FreeType Linkage with freetype
T1Lib Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
==========================
Module: mysql
------------------
Active Persistent Links 0
Active Links 1
Client API version 4.0.20
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /tmp/mysql.sock
MYSQL_INCLUDE -I/usr/mysql/include/mysql
MYSQL_LIBS -L/usr/mysql/lib/mysql -lmysqlclient
==========================
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_exec_dir | /usr/local/php/bin | /usr/local/php/bin
safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
safe_mode_gid | On | On
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | /usr/local/php/bin | /usr/local/php/bin
sql.safe_mode | On | On | |
file_uploads | On | On
include_path | /var/www/free.fr/4/2/flysurfing/include:. | .:
open_basedir | no value | no value
==========================
email
------------------
Directive | Local Value | Master Value | | | |
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 15 | 15
max_input_time | 30 | 30
upload_max_filesize | 2M | 2M
post_max_size | 3M | 3M
==========================
Page generated in 0.052 seconds - 7 queries in 0.004 seconds - Album set :
-
It looks like your pictures table is broken. This is the same as reported on this thread, http://forum.coppermine-gallery.net/index.php?topic=5560.0
Use your database tool to repair the table, and let us know what happens.
-
Casper,
thanks !
i've used the repair tool !
it works fine !
have a nice day !