Database query error

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
Quote · 20 Jun 2009

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

Quote · 20 Jun 2009
 
 
Below is the legacy version of the Boonex site, maintained for Dolphin.Pro 7.x support.
The new Dolphin solution is powered by UNA Community Management System.