[Solved]: Probleme with my gallery (database) !!!

[kitebabe]

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!

[Casper]

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.

[kitebabe]

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 :

[Casper]

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.

[kitebabe]

Casper,
thanks !
i've used the repair tool !
it works fine !

have a nice day !