processing database problem processing database problem
 

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

Main Menu

processing database problem

Started by gaz0r, July 25, 2005, 12:45:43 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Print
Go Down Pages1
User actions

gaz0r

July 25, 2005, 12:45:43 PM
Whenever I click on my profile in admin or try to edit a member i get

error processing database query

does anyone have a idea of what it is ?

Nibbler

#1
July 25, 2005, 05:37:25 PM
Nope. Enable debug mode, reroduce the error, and post the sql error message.

gaz0r

#2
July 26, 2005, 02:17:59 PM
USER:
------------------
Array
(
    [ID] => 7bc426f6953d8118c962557807613068
    [am] => 1
    [liv] => Array
        (
           
  • => 1811
                [1] => 1570
                [2] => 1891
                [3] => 1798
                [4] => 1887
            )

    )

    ==========================
    USER DATA:
    ------------------
    Array
    (
        [user_id] => 1
        [user_group] => 1
        [user_active] => YES
        [user_name] => gaz
        [user_password] => ********
        [user_lastvisit] => 2004-05-27 20:57:21
        [user_regdate] => 2004-05-27 20:57:21
        [user_group_list] =>
        [user_email] =>
        [user_website] =>
        [user_location] => Carlisle
        [user_interests] => motocross, cars, women
        [user_occupation] => college student
        [user_actkey] =>
        [disk_max] => 0
        [disk_min] => 0
        [can_rate_pictures] => 1
        [can_send_ecards] => 1
        [ufc_max] => 3
        [ufc_min] => 3
        [custom_user_upload] => 0
        [num_file_upload] => 5
        [num_URI_upload] => 3
        [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] => 3
        [group_quota] => 0
        [can_see_all_albums] => 1
        [group_id] => 1
        [groups] => Array
            (
                [1] => 1
            )

    )

    ==========================
    Queries:
    ------------------
    Array
    (
       
  • => SELECT extension, mime, content FROM cpg11d_filetypes;
        [1] => SELECT * FROM cpg11d_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = 'ab838c443618651cdcdd10b56b41527a'
        [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 cpg11d_usergroups WHERE group_id in (1)
        [3] => SELECT group_name FROM  cpg11d_usergroups WHERE group_id= 1
        [4] => DELETE FROM cpg11d_banned WHERE expiry < '2005-07-26 13:24:14'
        [5] => SELECT * FROM cpg11d_banned WHERE ip_addr='217.41.55.34' OR ip_addr='217.41.55.34' OR user_id=1
        [6] => DELETE FROM cpg11d_online WHERE last_action < NOW() - INTERVAL 5 MINUTE
        [7] => SELECT * FROM cpg11d_online WHERE user_id='1'
        [8] => UPDATE cpg11d_online SET last_action = NOW() WHERE user_id = '1' LIMIT 1
        [9] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = ''  ORDER BY pos
        [10] => SELECT aid FROM cpg11d_albums WHERE category >= 10000
        [11] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category >= 10000
        [12] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '1'  ORDER BY pos
        [13] => SELECT aid FROM cpg11d_albums WHERE category = 2
        [14] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 2
        [15] => SELECT count(*) FROM cpg11d_albums WHERE category = '2'
        [16] => SELECT a.aid, a.title, a.description, visibility, filepath,                 filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '2' ORDER BY pos LIMIT 0,16
        [17] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (1, 2, 3, 4, 5, 6, 7, 8, 25, 29, 34, 52, 55, 58, 41, 43) AND approved = 'YES' GROUP BY aid
        [18] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='47'
        [19] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1018'
        [20] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1795'
        [21] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1797'
        [22] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1898'
        [23] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1890'
        [24] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1894'
        [25] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '2'  ORDER BY pos
        [26] => SELECT aid FROM cpg11d_albums WHERE category = 3
        [27] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 3
        [28] => SELECT count(*) FROM cpg11d_albums WHERE category = '3'
        [29] => SELECT a.aid, a.title, a.description, visibility, filepath,                 filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '3' ORDER BY pos LIMIT 0,4
        [30] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (9, 10, 12, 14) AND approved = 'YES' GROUP BY aid
        [31] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='974'
        [32] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='551'
        [33] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='977'
        [34] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '3'  ORDER BY pos
        [35] => SELECT aid FROM cpg11d_albums WHERE category = 4
        [36] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 4
        [37] => SELECT count(*) FROM cpg11d_albums WHERE category = '4'
        [38] => SELECT a.aid, a.title, a.description, visibility, filepath,                 filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '4' ORDER BY pos LIMIT 0,12
        [39] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (15, 16, 17, 19, 21, 26, 28, 39, 40, 48, 51, 57) AND approved = 'YES' GROUP BY aid
        [40] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1562'
        [41] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1255'
        [42] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1288'
        [43] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1551'
        [44] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='869'
        [45] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1513'
        [46] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1548'
        [47] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1887'
        [48] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '4'  ORDER BY pos
        [49] => SELECT aid FROM cpg11d_albums WHERE category = 5
        [50] => SELECT count(*) FROM cpg11d_pictures, cpg11d_albums WHERE cpg11d_pictures.aid = cpg11d_albums.aid AND category = 5
        [51] => SELECT count(*) FROM cpg11d_albums WHERE category = '5'
        [52] => SELECT a.aid, a.title, a.description, visibility, filepath,                 filename, url_prefix, pwidth, pheight FROM cpg11d_albums as a LEFT JOIN cpg11d_pictures as p ON thumb=pid WHERE category = '5' ORDER BY pos LIMIT 0,19
        [53] => SELECT aid, count(pid) as pic_count, max(pid) as last_pid, max(ctime) as last_upload FROM cpg11d_pictures WHERE aid IN (27, 32, 23, 30, 35, 37, 45, 38, 46, 24, 54, 31, 47, 33, 42, 49, 50, 53, 56) AND approved = 'YES' GROUP BY aid
        [54] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='440'
        [55] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='688'
        [56] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='589'
        [57] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='757'
        [58] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='784'
        [59] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1011'
        [60] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='814'
        [61] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1165'
        [62] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='275'
        [63] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1736'
        [64] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1196'
        [65] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='732'
        [66] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='928'
        [67] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1374'
        [68] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1478'
        [69] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1612'
        [70] => SELECT filepath, filename, url_prefix, pwidth, pheight FROM cpg11d_pictures WHERE pid='1886'
        [71] => SELECT cid, name, description FROM cpg11d_categories WHERE parent = '5'  ORDER BY pos
        [72] => SELECT count(*) FROM cpg11d_albums WHERE 1
        [73] => SELECT count(*) FROM cpg11d_pictures WHERE 1
        [74] => SELECT count(*) FROM cpg11d_comments WHERE 1
        [75] => SELECT count(*) FROM cpg11d_categories WHERE 1
        [76] => SELECT sum(hits) FROM cpg11d_pictures WHERE 1
        [77] => SELECT count(*) FROM cpg11d_albums WHERE category = ''
        [78] => SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES'
        [79] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid, aid FROM cpg11d_pictures WHERE approved = 'YES'  ORDER BY RAND() LIMIT 8
        [80] => SELECT COUNT(*) from cpg11d_pictures WHERE approved = 'YES'
        [81] => SELECT pid, filepath, filename, url_prefix, filesize, pwidth, pheight, ctime, aid,title, caption, owner_id, owner_name, aid FROM cpg11d_pictures WHERE approved = 'YES'  ORDER BY pid DESC  LIMIT 0 ,8
        [82] => SELECT COUNT(*) FROM cpg11d_users
        [83] => SELECT COUNT(*) FROM cpg11d_online
        [84] => SELECT COUNT(*) FROM cpg11d_online WHERE user_id <> 0
        [85] => SELECT user_id, user_name FROM cpg11d_users ORDER BY user_id DESC LIMIT 1
        [86] => SELECT user_id FROM cpg11d_online WHERE user_id <> 0
        [87] => SELECT user_name FROM cpg11d_users WHERE user_id = '1'
        [88] => SELECT user_name FROM cpg11d_users WHERE user_id = '70'
    )

    ==========================
    GET :
    ------------------
    Array
    (
    )

    ==========================
    POST :
    ------------------
    Array
    (
    )

    ==========================
    VERSION INFO :
    ------------------
    PHP version: 4.3.11 - OK
    ------------------
    mySQL version: 4.1.10a-standard
    ------------------
    Coppermine version: 1.3.3
    ==========================
    Module: gd
    ------------------
    GD Support enabled
    GD Version bundled (2.0.28 compatible)
    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.10a
    MYSQL_MODULE_TYPE external
    MYSQL_SOCKET /var/lib/mysql/mysql.sock
    MYSQL_INCLUDE -I/usr/include/mysql
    MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient 
    ==========================
    Module: zlib
    ------------------
    ZLib Support enabled
    Compiled Version 1.2.2
    Linked Version 1.2.2
    ==========================
    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 | no value | no value
    file_uploads | On | On
    include_path | .:/usr/local/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 -f batcars@batcars.co.uk | /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 | 60 | 60
    upload_max_filesize | 2M | 2M
    post_max_size | 8M | 8M
    ==========================
    Page generated in 0.54 seconds - 89 queries in 0.179 seconds - Album set :

kegobeer

#3
July 26, 2005, 04:25:28 PM
That is debug output.  We need the error message.
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

gaz0r

#4
July 27, 2005, 01:05:23 PM
the error message was

There was an error while processing a database query

as stated above.

kegobeer

#5
July 27, 2005, 03:25:32 PM
When you enable debug mode, an actual error message is displayed, not "There was an error while processing a database query".
Do not send me a private message unless I ask for one.  Make your post public so everyone can benefit.

There are no stupid questions
But there are a LOT of inquisitive idiots

gaz0r

#6
July 28, 2005, 10:29:50 AM
ok done

heres the error output

Code Select
While executing query "UPDATE cpg11d_users SET user_name   = 'cesfusion', user_email   = 'cesfusion@yahoo.com.mx', user_active    = 'YES', user_group   = '2', user_location  = 'mexico', user_interests = 'student', user_website   = 'yahoo', user_occupation= 'student', user_lang      = '' WHERE user_id = '85'" on 0

mySQL error: Unknown column 'user_lang' in 'field list'

Nibbler

#7
July 28, 2005, 04:24:44 PM
You have outdated files in your Coppermine, use the versioncheck.php to ensure you have the 1.3 version of all your files.
Print
Go Up Pages1
User actions