Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: [Solved]: Probleme with my gallery (database) !!!  (Read 4416 times)

0 Members and 1 Guest are viewing this topic.

kitebabe

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
[Solved]: Probleme with my gallery (database) !!!
« 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!
« Last Edit: June 20, 2004, 12:12:51 am by GauGau »
Logged

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: Probleme with my gallery (database) !!!
« Reply #1 on: June 18, 2004, 11:49:30 pm »

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.
Logged
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

kitebabe

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
Re: Probleme with my gallery (database) !!!
« Reply #2 on: June 19, 2004, 02:02:01 pm »

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 :
Logged

Casper

  • VIP
  • Coppermine addict
  • ***
  • Country: 00
  • Offline Offline
  • Gender: Male
  • Posts: 5231
Re: Probleme with my gallery (database) !!!
« Reply #3 on: June 19, 2004, 02:35:04 pm »

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.
Logged
It has been a long time now since I did my little bit here, and have done no coding or any other such stuff since. I'm back to being a noob here

kitebabe

  • Coppermine newbie
  • Offline Offline
  • Posts: 16
Re: Probleme with my gallery (database) !!!
« Reply #4 on: June 19, 2004, 03:23:24 pm »

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

have a nice day !
Logged
Pages: [1]   Go Up
 

Page created in 0.027 seconds with 19 queries.