Advanced search  

News:

cpg1.5.28 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.26 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Critical error - There was an error while processing a database query.  (Read 45 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
Pages: [1]   Go Up
 

Page created in 0.256 seconds with 20 queries.