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: "There was an error while processing a database query."  (Read 2652 times)

0 Members and 1 Guest are viewing this topic.

LightShow

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
"There was an error while processing a database query."
« on: September 03, 2006, 05:29:06 am »

I accidently click on 'restore defaults' in the admin menu but then got this error (There was an error while processing a database query.).  I can no longer access anything.  I turned on the debug and got the following:

'Critical Error
Code: [Select]
While executing query "DELETE FROM cpg149_mod_online WHERE last_action < NOW() - INTERVAL  MINUTE" on 0

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1


'Debug Info
Code: [Select]
USER:
------------------
Array
(
    [ID] => 2cfb2d8cdb52c3d5cd7aad1007ee06bf
    [am] => 1
    [lang] => english
    [liv] => Array
        (
            [0] => 2
        )

    [theme] => mac_ox_x
    [sort] => pd
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 0
    [user_name] => Guest
    [groups] => Array
        (
            [0] => 3
        )

    [group_quota] => 0
    [can_rate_pictures] => 0
    [can_send_ecards] => 0
    [can_post_comments] => 0
    [can_upload_pictures] => 0
    [can_create_albums] => 0
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [upload_form_config] => 0
    [num_file_upload] => 0
    [num_URI_upload] => 0
    [custom_user_upload] => 0
    [disk_max] => 0
    [disk_min] => 0
    [ufc_max] => 0
    [ufc_min] => 0
    [has_admin_access] => 0
    [group_name] => Guests
    [can_see_all_albums] => 0
    [group_id] => 3
)

==========================
Queries:
------------------
Array
(
    [0] => SELECT extension, mime, content, player FROM cpg149_filetypes; (0s)
    [1] => select * from cpg149_plugins order by priority asc; (0s)
    [2] => delete from `gallery2006`.cpg149_sessions where time<1157250225 and remember=0; (0s)
    [3] => delete from `gallery2006`.cpg149_sessions where time<1156044225; (0s)
    [4] => select user_id from `gallery2006`.cpg149_sessions where session_id=md5("86282e81e350314d5de6b563161ebd4a41b1e0ef92f37f418c5de5beb53af0e3"); (0s)
    [5] => SELECT session_id FROM `gallery2006`.cpg149_sessions WHERE session_id=MD5('137340fa7c9062c79ac4dadb33f36ab441b1e0ef92f37f418c5de5beb53af0e3') (0.002s)
    [6] => insert into `gallery2006`.cpg149_sessions (session_id, user_id, time, remember) values ("4dc37fa964650500ea3e602dd7b65f4c", 0, "1157253825", 0); (0.001s)
    [7] => 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 cpg149_usergroups WHERE group_id in (3) (0s)
    [8] => SELECT group_name FROM  cpg149_usergroups WHERE group_id= 3 (0s)
    [9] => update `gallery2006`.cpg149_sessions set time='1157253825' where session_id=md5('137340fa7c9062c79ac4dadb33f36ab441b1e0ef92f37f418c5de5beb53af0e3'); (0s)
    [10] => DELETE FROM cpg149_mod_online WHERE last_action < NOW() - INTERVAL  MINUTE (0s)
)

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

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

==========================
Page generated in 0.085 seconds - 11 queries in 0.003 seconds - Album set : ; Meta set: ;
« Last Edit: September 03, 2006, 10:23:52 am by GauGau »
Logged

LightShow

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: "There was an error while processing a database query."
« Reply #1 on: September 03, 2006, 05:32:10 am »

I forgot to add.  Im using 1.4.9, and only mod installed was 'onstats'.  Site: http://www.ImemoriesOnline.com/gallery/
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: "There was an error while processing a database query."
« Reply #2 on: September 03, 2006, 06:39:22 am »

Run this query under phpmyadmin:
Code: [Select]
INSERT IGNORE INTO cpg149_config (name, value) VALUES ('mod_updates_duration', '10')
10 is interval in Minutes for onlinestat plugin (Duration to keep users listed as online for before they are assumed to have gone )
Logged
‍I don't answer to PM with support question
Please post your issue to related board

LightShow

  • Coppermine newbie
  • Offline Offline
  • Posts: 6
Re: "There was an error while processing a database query."
« Reply #3 on: September 03, 2006, 06:49:26 am »

Thanks.  It worked
Logged
Pages: [1]   Go Up
 

Page created in 0.025 seconds with 19 queries.