There was an error while processing a database query There was an error while processing a database query
 

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

There was an error while processing a database query

Started by marcelof, October 15, 2005, 08:40:18 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

marcelof

When I want to create albun leaves east error!!!  Pleace.

USER:
------------------
Array
(
    [ID] => 00c19d1f18c505b3827c788e3390005a
    [am] => 1
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_group] => 1
    [user_active] => YES
    [user_name] => marcelo
    [user_password] => ********
    [user_lastvisit] => 2005-10-15 12:13:52
    [user_regdate] => 2005-10-14 22:59:35
    [user_group_list] =>
    [user_email] =>
    [user_website] =>
    [user_location] =>
    [user_interests] =>
    [user_occupation] =>
    [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] => 1
    [priv_upl_need_approval] => 1
    [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 cpg135_filetypes;
        [1] => SELECT * FROM cpg135_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = 'a5e8d3dd617579fe2803869cede005f5'
        [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 cpg135_usergroups WHERE group_id in (1)
        [3] => SELECT group_name FROM  cpg135_usergroups WHERE group_id= 1
        [4] => DELETE FROM cpg135_banned WHERE expiry < '2005-10-15 15:30:43'
        [5] => SELECT * FROM cpg135_banned WHERE ip_addr='128.1.3.62' OR ip_addr='128.1.3.62' OR user_id=1
        [6] => INSERT INTO cpg135_albums (category, title, uploads, pos) VALUES ('0', 'Nuevo álbum', 'NO',  '1')
    )

    ==========================
    GET :
    ------------------
    Array
    (
        [what] => albmgr
    )

    ==========================
    POST :
    ------------------
    Array
    (
        [delete_album] =>
        [sort_order] =>
        [cat] => 0
        [to] => Array
            (
               
  • => album_no=0,album_nm=\'Nuevo álbum\',album_sort=1,action=1
            )

        [album_nm] => Nuevo álbum
    )

    ==========================
    VERSION INFO :
    ------------------
    PHP version: 5.0.5 - OK
    ------------------
    mySQL version: 5.0.13-rc-nt
    ------------------
    Coppermine version: 1.3.5
    ==========================
    Module: gd
    ------------------
    module doesn't exist
    ==========================
    Module: mysql
    ------------------
    Active Persistent Links 0
    Active Links 1
    Client API version 4.1.7
    ==========================
    Module: zlib
    ------------------
    ZLib Support enabled
    Compiled Version 1.2.3
    Linked Version 1.2.3
    ==========================
    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 | .;C:\php5\pear | .;C:\php5\pear
    open_basedir | no value | no value
    ==========================
    email
    ------------------
    Directive | Local Value | Master Value
    sendmail_from | no value | no value
    sendmail_path | no value | no value
    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.219 seconds - 7 queries in 0.009 seconds - Album set :

Nibbler

Why do you ask for help on a board named 'no support' ? => moved.

Enable debug mode in config and post the actual mysql error you get when you repeat the error (NOT the full debug output).