Critical error - There was an error while processing a database query.

[flashwebb]

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
  )
  
  ==========================[/b]

[flashwebb]

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
  )
  
  ==========================[/b]
  

Hi
i remove the cpg11d_mod_online from the database

[Αndré]

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.