Database error

Hello for some months, I keep getting "Database error" and more in the blog post per day, having blocked the blogs, I found them on the forum, we have blocked all the categories in which people can post messages,I find myself always have this message for the blogs. This is disadvantageous, how to stop this problem,which is a forum like the blog, I have members who have posted messages, therefore, not able to make aréinstallaton.

My question is how can I stop this kind of position, power and control as a code to post with poster or anything else. How come that a dolphin so big flaw at this level

 

---

 

Query:

SELECT COUNT(*) FROM `bx_blogs_posts`  left JOIN `Profiles` ON `Profiles`.`ID`=`bx_blogs_posts`.`OwnerID` left JOIN `sys_categories` ON `sys_categories`.`ID`=`bx_blogs_posts`.`PostID` WHERE 1 AND `bx_blogs_posts`.`PostStatus` ='approval' AND `bx_blogs_posts`.`OwnerID` ='4467' AND `sys_categories`.`Category` ='Tech News' 

Mysql error: Got error 134 from storage engine

 

----

which slow down the server and sometimes freezes

Quote · 6 Jan 2012

You will need to Restore all the Categories Restricted to  Normal  to stop the database  error message.

If you want  to restrict Users from posting to specific categories   or all Blog categories, you will need to hire a developer to properly rewrite  the  Code in   Blogs Module    to perform that restrict function.

Your Success is permanent when you help others around you to Succeed.
Quote · 6 Jan 2012

You can try repairing the tables, which can be done easily from within phpMyAdmin.

BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin
Quote · 6 Jan 2012

 

You can try repairing the tables, which can be done easily from within phpMyAdmin.

 What should I repair ?

Quote · 6 Jan 2012

 

 

You can try repairing the tables, which can be done easily from within phpMyAdmin.

 What should I repair ?

I don't know which tables are the culprit in this case, so running a repair on the ones included in the query which caused the error should suffice. 

BoonEx Certified Host: Zarconia.net - Fully Supported Shared and Dedicated for Dolphin
Quote · 7 Jan 2012

Query:

SELECT COUNT(*) FROM `bx_blogs_posts`  left JOIN `Profiles` ON `Profiles`.`ID`=`bx_blogs_posts`.`OwnerID` left JOIN `sys_categories` ON `sys_categories`.`ID`=`bx_blogs_posts`.`PostID` WHERE 1 AND `bx_blogs_posts`.`PostStatus` ='approval' AND `bx_blogs_posts`.`OwnerID` ='15079' AND `sys_categories`.`Category` ='Tech News' 

Mysql error: Got error 134 from storage engine

Found error in the file '/home/msite/public_html/inc/classes/BxDolSearch.php' at line 511.
Called 'db_value' function with erroneous argument #0.


Debug backtrace:

Array
(
    [1] => Array
        (
            [file] => /home/msite/public_html/inc/classes/BxDolDb.php
            [line] => 253
            [function] => error
            [class] => BxDolDb
            [object] => BxDolDb Object
                (

 


Query:

			SELECT COUNT(*)
			FROM `bx_blogs_posts`
			
			LEFT JOIN `sys_categories` ON `sys_categories`.`ID` = `bx_blogs_posts`.`PostID`
		
			WHERE 1
			
			AND `sys_categories`.`Category` = 'Tech News' AND `sys_categories`.`Type`='bx_blogs'
		
			AND `bx_blogs_posts`.`OwnerID`='14335'
			AND `PostStatus`='approval'
		

Mysql error: Got error 134 from storage engine

Found error in the file '/home/msite/public_html/modules/boonex/blogs/classes/BxBlogsDb.php' at line 181.
Called 'getOne' function with erroneous argument #0.


Debug backtrace:

Array

 

Debug backtrace:

Array
(
    [1] => Array
        (
            [file] => /home/msite/public_html/inc/classes/BxDolDb.php
            [line] => 82
            [function] => error
            [class] => BxDolDb
            [object] => BxDolPrivacyQuery Object
                (
                    [_sTable] => bx_blogs_posts
                    [_sFieldId] => PostID
                    [_sFieldOwnerId] => OwnerID
                    [_sGroupCache] => sys_ps_group_
                    [_sGroupsByOwnersCache] => sys_ps_groups_owners_
                    [_sGroupMembersCache] => sys_ps_group_members_
                    [_sObjectCache] => sys_ps_object_
                    [_sActionCache] => sys_ps_action_
                    [_sActionDefaultCache] => sys_ps_action_default_
                    [error_checking] => 1
                    [error_message] => Lost connection to MySQL server during query

 

Debug backtrace:

Array
(
    [1] => Array
        (
            [file] => /home/msite/public_html/inc/classes/BxDolDb.php
            [line] => 82
            [function] => error
            [class] => BxDolDb
            [object] => BxDolSubscriptionQuery Object
                (
                    [_sPrefix] => sys_sbs_
                    [_oSubscription] => BxDolSubscription Object
                        (
                            [_oDb] => BxDolSubscriptionQuery Object

 

 

 

 

 

 

 

 

 

Quote · 8 Jan 2012
 
 
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.