Database query error
| Author | Message |
|---|---|
  kaimuay(2 posts) | Warning: mysql_query() [function.mysql-query]: Unable to save result set in /home/xxxx/public_html/xxxx/inc/db.inc.php on line 96 Database query error
Query:
SELECT COUNT( DISTINCT `Tag` ) FROM `Tags` Mysql error:
Out of memory (Needed 16777143 bytes) error in file /home/xxxx/public_html/xxxx/inc/design.inc.php
at line 1130. Called db_value function with erroneous argument #0 Debug backtrace: Array
(
[1] => Array
(
[file] => /home/xxxx/public_html/xxxx/inc/db.inc.php
[line] => 104
[function] => db_res
[args] => Array
(
[0] => SELECT COUNT( DISTINCT `Tag` ) FROM `Tags`
[1] => 1
)
)
[2] => Array
(
[file] => /home/xxxx/public_html/xxxx/inc/db.inc.php
[line] => 120
[function] => db_arr
[args] => Array
(
[0] => SELECT COUNT( DISTINCT `Tag` ) FROM `Tags`
[1] => 1
)
)
[3] => Array
(
[file] => /home/xxxx/public_html/xxxx/inc/design.inc.php
[line] => 1130
[function] => db_value
[args] => Array
(
[0] => SELECT COUNT( DISTINCT `Tag` ) FROM `Tags`
)
)
[4] => Array
(
[file] => /home/xxxx/public_html/xxxx/inc/design.inc.php
[line] => 1228
[function] => getSiteStatBody
[args] => Array
(
[0] => Array
(
[capt] => Tags
[query] => SELECT COUNT( DISTINCT `Tag` ) FROM `Tags`
[link] =>
[icon] => tgs.gif
)
)
)
[5] => Array
(
[file] => /home/xxxx/public_html/xxxx/inc/classes/BxDolPageView.php
[line] => 319
[function] => getSiteStatUser
[args] => Array
(
)
)
[6] => Array
(
[file] => /home/xxxx/public_html/xxxx/inc/classes/BxDolPageView.php
[line] => 167
[function] => getBlockCode_SiteStats
[class] => BxDolPageView
[type] => ->
[object] => BxTemplIndexPageView Object
(
[sPageName] => index
[aPage] => Array
(
[Width] => 960px
[Columns] => Array
(
[1] => Array
(
[Width] => 75
[Blocks] => Array
(
[21] => Array
(
[Func] => ShareVideos
[Content] =>
[Caption] => _Video Gallery
[Visible] => non,memb
[DesignBox] => 1
)
[16] => Array
(
[Func] => Classifieds
[Content] =>
[Caption] => _Classifieds
[Visible] => non,memb
[DesignBox] => 1
)
[20] => Array
(
[Func] => SharePhotos
[Content] =>
[Caption] => _Photo Gallery
[Visible] => non,memb
[DesignBox] => 1
)
[22] => Array
(
[Func] => ShareMusic
[Content] =>
[Caption] => _Music Gallery
[Visible] => non,memb
[DesignBox] => 1
)
[17] => Array
(
[Func] => Events
[Content] =>
[Caption] => _Events
[Visible] => non,memb
[DesignBox] => 1
)
[7] => Array
(
[Func] => Featured
[Content] =>
[Caption] => _featured members
[Visible] => non,memb
[DesignBox] => 1
)
[14] => Array
(
[Func] => LoginSection
[Content] =>
[Caption] => _Member Login
[Visible] => non
[DesignBox] => 1
)
[10] => Array
(
[Func] => Members
[Content] =>
[Caption] => _Members
[Visible] => non,memb
[DesignBox] => 1
)
[4] => Array
(
[Func] => QuickSearch
[Content] =>
[Caption] => _Quick Search
[Visible] => non,memb
[DesignBox] => 1
)
[18] => Array
(
[Func] => Groups
[Content] =>
[Caption] => _Groups
[Visible] => non,memb
[DesignBox] => 1
)
[12] => Array
(
[Func] => ProfilePhotos
[Content] =>
[Caption] => _Profile Photos
[Visible] => non,memb
[DesignBox] => 1
)
[11] => Array
(
[Func] => Blogs
[Content] =>
[Caption] => _Blogs
[Visible] => non,memb
[DesignBox] => 1
)
[8] => Array
(
[Func] => ProfilePoll
[Content] =>
[Caption] => _Polls
[Visible] => non,memb
[DesignBox] => 1
)
[9] => Array
(
[Func] => Tags
[Content] =>
[Caption] => _Tags
[Visible] => non,memb
[DesignBox] => 1
)
[1] => Array
(
[Func] => SiteStats
[Content] =>
[Caption] => _Site Stats
[Visible] => non,memb
[DesignBox] => 1
)
)
)
[2] => Array
(
[Width] => 25
[Blocks] => Array
(
[2] => Array
(
[Func] => News
[Content] =>
[Caption] => _latest news
[Visible] => non,memb
[DesignBox] => 1
)
[5] => Array
(
[Func] => Leaders
[Content] =>
[Caption] => _Leaders
[Visible] => non,memb
[DesignBox] => 1
)
[19] => Array
(
[Func] => RSS
[Content] => {SiteUrl}orca/?action=rss_all#4
[Caption] => _Forum Posts
[Visible] => non,memb
[DesignBox] => 1
)
[6] => Array
(
[Func] => Feedback
[Content] =>
[Caption] => _Feedback
[Visible] => non,memb
[DesignBox] => 1
)
[13] => Array
(
[Func] => Shoutbox
[Content] =>
[Caption] => _Shoutbox
[Visible] => non,memb
[DesignBox] => 1
)
[3] => Array
(
[Func] => Subscribe
[Content] =>
[Caption] => _Subscribe
[Visible] => non,memb
[DesignBox] => 1
)
[23] => Array
(
[Func] => Articles
[Content] =>
[Caption] => _Articles
[Visible] => non,memb
[DesignBox] => 1
)
[15] => Array
(
[Func] => RSS
[Content] => http://www.boonex.com/unity/blog/featured_posts/?rss=1#4
[Caption] => _BoonEx News
[Visible] => non,memb
[DesignBox] => 1
)
)
)
)
)
[sCode] =>
I'v contacted my server and they said I have plenty of memory.Can't find any topics here or in google. Does anyone knows what this error is? And how to fix this. It only shows on the index page and the others works fine.
Thanks in advance
kaimuay |
| kaimuay (2 posts) | Got it:: It was tags error like it says.
if anyone else gets this problem just goto your phpmyadmin and delete all the tags!!!! But this is just another way to go around it and the bug is still exist.
So Please Experts find a fix. Thankx in advance Kaimuay |
