Hi maybe some one can help me. all night I would say like 50 emails im getting the same error code
Database error in TheVortex
Query:
SELECT `p`.*, `f`.`ID`,
if(`DateLastNav` > SUBDATE(NOW( ), INTERVAL 1 MINUTE ), 1, 0) AS `is_online`,
UNIX_TIMESTAMP(p.`DateLastLogin`) AS 'TS_DateLastLogin', UNIX_TIMESTAMP(p.`DateReg`) AS 'TS_DateReg' FROM (
SELECT `ID` AS `ID` FROM `sys_friend_list` WHERE `Profile` = '1' AND `Check` =1
UNION
SELECT `Profile` AS `ID` FROM `sys_friend_list` WHERE `ID` = '1' AND `Check` =1
) AS `f`
INNER JOIN `Profiles` AS `p` ON `p`.`ID` = `f`.`ID`
WHERE 1 AND p.`Status`='Active' AND p.`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE)
ORDER BY p.`DateLastNav` DESC
LIMIT 5
Mysql error: Got error 28 from storage engine
Found error in the file '/home/minglewi/public_html/thevortex.co/inc/profiles.inc.php' at line 459.
Called 'db_res' function with erroneous argument #0.
Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/minglewi/public_html/thevortex.co/inc/classes/BxDolDb.php
[line] => 237
[function] => error
[class] => BxDolDb
[object] => BxDolDb Object
(
[error_checking] => 1
[error_message] => Got error 28 from storage engine
[host] => localhost
[port] =>
[socket] =>
[dbname] => minglewi_vortex
[user] => *****
[password] => *****
[link] => Resource id #26
[current_res] =>
[current_arr_type] => 1
[oParams] => BxDolParams Object
(
[_oDb] => BxDolDb Object
*RECURSION*
[_oCache] => BxDolCacheFile Object
(
[sPath] => /home/minglewi/public_html/thevortex.co/cache/
)
[_sCacheFile] => sys_options_62f2878bfddc6fe5dbe7dfb6123d5f4c.php
[_aParams] => [truncated]
)
[oDbCacheObject] => BxDolCacheFile Object
(
[sPath] => /home/minglewi/public_html/thevortex.co/cache/
)
)
[type] => ->
[args] => Array
(
[0] => Database query error
[1] =>
[2] => SELECT `p`.*, `f`.`ID`,
if(`DateLastNav` > SUBDATE(NOW( ), INTERVAL 1 MINUTE ), 1, 0) AS `is_online`,
UNIX_TIMESTAMP(p.`DateLastLogin`) AS 'TS_DateLastLogin', UNIX_TIMESTAMP(p.`DateReg`) AS 'TS_DateReg' FROM (
SELECT `ID` AS `ID` FROM `sys_friend_list` WHERE `Profile` = '1' AND `Check` =1
UNION
SELECT `Profile` AS `ID` FROM `sys_friend_list` WHERE `ID` = '1' AND `Check` =1
) AS `f`
INNER JOIN `Profiles` AS `p` ON `p`.`ID` = `f`.`ID`
WHERE 1 AND p.`Status`='Active' AND p.`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE)
ORDER BY p.`DateLastNav` DESC
LIMIT 5
)
)
[2] => Array
(
[file] => /home/minglewi/public_html/thevortex.co/inc/db.inc.php
[line] => 33
[function] => res
[class] => BxDolDb
[object] => BxDolDb Object
(
[error_checking] => 1
[error_message] => Got error 28 from storage engine
[host] => localhost
[port] =>
[socket] =>
[dbname] => minglewi_vortex
[user] => *****
[password] => *****
[link] => Resource id #26
[current_res] =>
[current_arr_type] => 1
[oParams] => BxDolParams Object
(
[_oDb] => BxDolDb Object
*RECURSION*
[_oCache] => BxDolCacheFile Object
(
[sPath] => /home/minglewi/public_html/thevortex.co/cache/
)
[_sCacheFile] => sys_options_62f2878bfddc6fe5dbe7dfb6123d5f4c.php
[_aParams] => [truncated]
)
[oDbCacheObject] => BxDolCacheFile Object
(
[sPath] => /home/minglewi/public_html/thevortex.co/cache/
)
)
[type] => ->
[args] => Array
(
[0] => SELECT `p`.*, `f`.`ID`,
if(`DateLastNav` > SUBDATE(NOW( ), INTERVAL 1 MINUTE ), 1, 0) AS `is_online`,
UNIX_TIMESTAMP(p.`DateLastLogin`) AS 'TS_DateLastLogin', UNIX_TIMESTAMP(p.`DateReg`) AS 'TS_DateReg' FROM (
SELECT `ID` AS `ID` FROM `sys_friend_list` WHERE `Profile` = '1' AND `Check` =1
UNION
SELECT `Profile` AS `ID` FROM `sys_friend_list` WHERE `ID` = '1' AND `Check` =1
) AS `f`
INNER JOIN `Profiles` AS `p` ON `p`.`ID` = `f`.`ID`
WHERE 1 AND p.`Status`='Active' AND p.`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE)
ORDER BY p.`DateLastNav` DESC
LIMIT 5
)
)
[3] => Array
(
[file] => /home/minglewi/public_html/thevortex.co/inc/profiles.inc.php
[line] => 459
[function] => db_res
[args] => Array
(
[0] => SELECT `p`.*, `f`.`ID`,
if(`DateLastNav` > SUBDATE(NOW( ), INTERVAL 1 MINUTE ), 1, 0) AS `is_online`,
UNIX_TIMESTAMP(p.`DateLastLogin`) AS 'TS_DateLastLogin', UNIX_TIMESTAMP(p.`DateReg`) AS 'TS_DateReg' FROM (
SELECT `ID` AS `ID` FROM `sys_friend_list` WHERE `Profile` = '1' AND `Check` =1
UNION
SELECT `Profile` AS `ID` FROM `sys_friend_list` WHERE `ID` = '1' AND `Check` =1
) AS `f`
INNER JOIN `Profiles` AS `p` ON `p`.`ID` = `f`.`ID`
WHERE 1 AND p.`Status`='Active' AND p.`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE)
ORDER BY p.`DateLastNav` DESC
LIMIT 5
)
)
[4] => Array
(
[file] => /home/minglewi/public_html/thevortex.co/inc/classes/BxDolFriendsPageView.php
[line] => 429
[function] => getMyFriendsEx
[args] => Array
(
[0] => 1
[1] => AND p.`DateLastNav` > SUBDATE(NOW(), INTERVAL 1 MINUTE)
[2] => last_nav_desc
[3] => LIMIT 5
)
)
[5] => Array
(
[file] => /home/minglewi/public_html/thevortex.co/inc/classes/BxDolMemberMenu.php(486) : eval()'d code
[line] => 2
[function] => get_member_menu_friends_list
[class] => BxDolFriendsPageView
[object] => BxTemplMemberMenu Object
(
[sBubbles] =>
[sMemberMenuPosition] => bottom
[iBubblesUpdateTime] => 30000
[iNotifyDestroyTime] => 3000
[sQueryPageReciver] => member_menu_queries.php
[sBubblePrefix] => bubble_
[oCacheObject] =>
[iKeysFileTTL] => 600
[sMenuCacheFile] => sys_menu_member
[sMenuMemberKeysCache] => mm_sys_menu_member_keys_
)
[type] => ->
[args] => Array
(
[0] => 1
)
)
[6] => Array
(
[file] => /home/minglewi/public_html/thevortex.co/inc/classes/BxDolMemberMenu.php
[line] => 486
[function] => eval
)
[7] => Array
(
[file] => /home/minglewi/public_html/thevortex.co/member_menu_queries.php
[line] => 60
[function] => getSubMenuContent
[class] => BxDolMemberMenu
[object] => BxTemplMemberMenu Object
(
[sBubbles] =>
[sMemberMenuPosition] => bottom
[iBubblesUpdateTime] => 30000
[iNotifyDestroyTime] => 3000
[sQueryPageReciver] => member_menu_queries.php
[sBubblePrefix] => bubble_
[oCacheObject] =>
[iKeysFileTTL] => 600
[sMenuCacheFile] => sys_menu_member
[sMenuMemberKeysCache] => mm_sys_menu_member_keys_
)
[type] => ->
[args] => Array
(
[0] => 1
[1] => bx_import( 'BxDolFriendsPageView' );
return BxDolFriendsPageView::get_member_menu_friends_list({ID});
[2] => Array
(
)
)
)
does anyone know how I can fix that problem ? I'm using 7.1.2
Danny
