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

0 Members and 1 Guest are viewing this topic.

flashwebb

  • Coppermine newbie
  • Offline Offline
  • Posts: 4

Hi
i get this error after installing windows  (Critical error - There was an error while processing a database query.)
this is what i have done
i make a backup of
wwwroot (Homepage and coppermine)
Mysql database

and then i install windows again (Fresh install)
install Mysql and Php (Same version as Before.. it's working..i can see phpinfo)
restore the backup of my homepage,coppermine files and coppermine database file

and this is what happening...i have NOT change anything in the files..So i know there is nothing wrong with file or the php code

This file exist in the database directory (cpg11d_mod_online.frm)


The Debug Windows #1

While executing query 'DELETE FROM cpg11d_mod_online WHERE last_action < NOW() - INTERVAL 2 MINUTE' in plugins\onlinestats\codebase.php on line 122

mySQL error: Table 'photo.cpg11d_mod_online' doesn't exist





Debug windows #2

File: C:\inetpub\wwwroot\flashwebb\vacation\include\functions.inc.php - Line: 272 

Debug Info 

Debug Output: show / hide 


USER:
------------------
Array
(
    [ID] => 26092cebe5e6fbab66cf43e6b0d4eceb
    [am] => 1
)

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

        )

    [group_quota] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [can_post_comments] => 0
    [can_upload_pictures] => 0
    [can_create_albums] => 0
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [access_level] => 3
    [disk_max] => 0
    [disk_min] => 0
    [has_admin_access] => 0
    [group_name] => Guests
    [can_create_public_albums] => 0
    [can_see_all_albums] => 0
    [group_id] => 3
    [allowed_albums] => Array
        (
        )

)

==========================
Queries:
------------------
Array
(
   
  • => SELECT name, value FROM cpg11d_config [include\init.inc.php:179] (1.74 ms)
  • [1] => SELECT * FROM cpg11d_plugins ORDER BY priority
[include\plugin_api.inc.php:52] (2.42 ms)
    [2] => DELETE FROM `photo`.cpg11d_sessions WHERE time < 1397713731 AND remember = 0 [bridge\coppermine.inc.php:251] (1.79 ms)
    [3] => DELETE FROM `photo`.cpg11d_sessions WHERE time < 1396507731 [bridge\coppermine.inc.php:255] (0.09 ms)
    [4] => UPDATE cpg11d_config SET value = 1397717331 WHERE name = 'session_cleanup' [bridge\coppermine.inc.php:259] (0.2 ms)
    [5] => 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(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, MAX(access_level) AS access_level, 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 (3) [bridge\udb_base.inc.php:323] (1.36 ms)
    [6] => SELECT group_name FROM cpg11d_usergroups WHERE group_id= 3 [bridge\udb_base.inc.php:327] (0.1 ms)
    [7] => SELECT COUNT(*) FROM cpg11d_categorymap WHERE group_id in (3) [bridge\udb_base.inc.php:340] (1.1 ms)
    [8] => SELECT aid FROM cpg11d_albums WHERE moderator_group IN (3) [include\init.inc.php:272] (0.96 ms)
    [9] => SELECT lang_id FROM cpg11d_languages WHERE enabled='YES' [include\init.inc.php:330] (2.1 ms)
    [10] => DELETE FROM cpg11d_mod_online WHERE last_action < NOW() - INTERVAL 2 MINUTE [plugins\onlinestats\codebase.php:122] (1.33 ms)
)

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

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

==========================
COOKIE :
------------------
Array
(
    [CNB_test1] => value1
    [CNB_test2] => value2
    [CNB_test3] => value3
    [CNB_test4] => value4
)

==========================
Logged

flashwebb

  • Coppermine newbie
  • Offline Offline
  • Posts: 4

Hi
i get this error after installing windows  (Critical error - There was an error while processing a database query.)
this is what i have done
i make a backup of
wwwroot (Homepage and coppermine)
Mysql database

and then i install windows again (Fresh install)
install Mysql and Php (Same version as Before.. it's working..i can see phpinfo)
restore the backup of my homepage,coppermine files and coppermine database file

and this is what happening...i have NOT change anything in the files..So i know there is nothing wrong with file or the php code

This file exist in the database directory (cpg11d_mod_online.frm)


The Debug Windows #1

While executing query 'DELETE FROM cpg11d_mod_online WHERE last_action < NOW() - INTERVAL 2 MINUTE' in plugins\onlinestats\codebase.php on line 122

mySQL error: Table 'photo.cpg11d_mod_online' doesn't exist





Debug windows #2

File: C:\inetpub\wwwroot\flashwebb\vacation\include\functions.inc.php - Line: 272 

Debug Info 

Debug Output: show / hide 


USER:
------------------
Array
(
    [ID] => 26092cebe5e6fbab66cf43e6b0d4eceb
    [am] => 1
)

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

        )

    [group_quota] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [can_post_comments] => 0
    [can_upload_pictures] => 0
    [can_create_albums] => 0
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [access_level] => 3
    [disk_max] => 0
    [disk_min] => 0
    [has_admin_access] => 0
    [group_name] => Guests
    [can_create_public_albums] => 0
    [can_see_all_albums] => 0
    [group_id] => 3
    [allowed_albums] => Array
        (
        )

)

==========================
Queries:
------------------
Array
(
   
  • => SELECT name, value FROM cpg11d_config [include\init.inc.php:179] (1.74 ms)
  • [1] => SELECT * FROM cpg11d_plugins ORDER BY priority
[include\plugin_api.inc.php:52] (2.42 ms)
    [2] => DELETE FROM `photo`.cpg11d_sessions WHERE time < 1397713731 AND remember = 0 [bridge\coppermine.inc.php:251] (1.79 ms)
    [3] => DELETE FROM `photo`.cpg11d_sessions WHERE time < 1396507731 [bridge\coppermine.inc.php:255] (0.09 ms)
    [4] => UPDATE cpg11d_config SET value = 1397717331 WHERE name = 'session_cleanup' [bridge\coppermine.inc.php:259] (0.2 ms)
    [5] => 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(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, MAX(access_level) AS access_level, 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 (3) [bridge\udb_base.inc.php:323] (1.36 ms)
    [6] => SELECT group_name FROM cpg11d_usergroups WHERE group_id= 3 [bridge\udb_base.inc.php:327] (0.1 ms)
    [7] => SELECT COUNT(*) FROM cpg11d_categorymap WHERE group_id in (3) [bridge\udb_base.inc.php:340] (1.1 ms)
    [8] => SELECT aid FROM cpg11d_albums WHERE moderator_group IN (3) [include\init.inc.php:272] (0.96 ms)
    [9] => SELECT lang_id FROM cpg11d_languages WHERE enabled='YES' [include\init.inc.php:330] (2.1 ms)
    [10] => DELETE FROM cpg11d_mod_online WHERE last_action < NOW() - INTERVAL 2 MINUTE [plugins\onlinestats\codebase.php:122] (1.33 ms)
)

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

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

==========================
COOKIE :
------------------
Array
(
    [CNB_test1] => value1
    [CNB_test2] => value2
    [CNB_test3] => value3
    [CNB_test4] => value4
)

==========================





Hi
i remove the cpg11d_mod_online from the database
Logged

Αndré

  • Administrator
  • Coppermine addict
  • *****
  • Country: de
  • Offline Offline
  • Gender: Male
  • Posts: 15764

i remove the cpg11d_mod_online from the database
I assume this fixed your issue. If so, please
tag your thread as "solved" by clicking on the "Topic Solved" button on the bar at the left hand side at the bottom of your thread.
Logged
Pages: [1]   Go Up
 

Page created in 0.022 seconds with 20 queries.