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 existDebug 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
(
)
[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
)
==========================