Database errors

crazyleaf posted 5th of February 2008 in Community Voice. 4 comments.
Good day,

I am getting these errors on my Dolphin community and I have absolutely no idea why. Please can anybody help me.

Error 1 :

 YAHOO.Shortcuts.hasSensitiveText = false; YAHOO.Shortcuts.sensitivityType = []; YAHOO.Shortcuts.doUlt = false; YAHOO.Shortcuts.location = "us"; YAHOO.Shortcuts.lang = "us"; YAHOO.Shortcuts.document_id = 0; YAHOO.Shortcuts.document_type = ""; YAHOO.Shortcuts.document_title = ""; YAHOO.Shortcuts.document_publish_date = ""; YAHOO.Shortcuts.document_author = ""; YAHOO.Shortcuts.document_url = ""; YAHOO.Shortcuts.document_tags = ""; YAHOO.Shortcuts.annotationSet = { "lw_1202204210_0": { "text": "zaBox.net", "extended": 0, "startchar": 18, "endchar": 26, "start": 18, "end": 26, "extendedFrom": "", "predictedCategory": "", "predictionProbability": "0", "weight": 1, "type": ["shortcuts:/us/place/virtual/web_site"], "category": ["IDENTIFIER"], "context": "Database error in zaBox.net Your Network Your Friends Query" } };  YAHOO.Shortcuts.overlaySpaceId = "97546169";  YAHOO.Shortcuts.hostSpaceId = "97546168"; 
Database error in zaBox.net - Your Network. Your Friends
Query:
SELECT * FROM `ProfileCompose` WHERE `Column`=2 AND FIND_IN_SET( 'non',
`Visible` ) ORDER BY `Order`

Mysql error:
MySQL server has gone away

Found error in file
/home/zabox/public_html/templates/base/scripts/BxBaseProfileView.php
at line 101. Called db_res function
with erroneous argument #0

Debug backtrace:
Array
(
[1] => Array
(
[file] =>
/home/zabox/public_html/templates/base/scripts/BxBaseProfileView.php
[line] => 101
[function] => db_res
[args] => Array
(
[0] => SELECT * FROM `ProfileCompose` WHERE
`Column`=2 AND FIND_IN_SET( 'non', `Visible` ) ORDER BY `Order`
)

)

[2] => Array
(
[file] =>
/home/zabox/public_html/templates/base/scripts/BxBaseProfileView.php
[line] => 86
[function] => showColumnBlocks
[class] => BxBaseProfileView
[type] => ->
[args] => Array
(
[0] => 2
)

)

[3] => Array
(
[file] => /home/zabox/public_html/profile.php
[line] => 136
[function] => genColumns
[class] => BxBaseProfileView
[type] => ->
[args] => Array
(
)

)

[4] => Array
(
[file] => /home/zabox/public_html/rewrite_name.php
[line] => 73
[args] => Array
(
[0] => /home/zabox/public_html/profile.php
)

[function] => require_once
)

)


Called script: /rewrite_name.php

Request parameters:
Array
(
[ID] => 10
)


Error 2 :


Database error in zaBox.net - Your Network. Your Friends
Query:
SELECT UNIX_TIMESTAMP(`commDate`) AS `commDate`,
`commText`,
`profileID`,
`Profiles`.`NickName`
FROM
`sharePhotoComments`
INNER JOIN `Profiles` ON
`Profiles`.`ID`=`sharePhotoComments`.`profileID`
WHERE `medID`='10' ORDER BY `commDate` DESC LIMIT -2,2

Mysql error:
You have an error in your SQL syntax; check the manual that corresponds
to your MySQL server version for the right syntax to use near '-2,2'
at line 8

Found error in file /home/zabox/public_html/viewPhoto.php
at line 246. Called db_res function
with erroneous argument #0

Debug backtrace:
Array
(
[1] => Array
(
[file] => /home/zabox/public_html/viewPhoto.php
[line] => 246
[function] => db_res
[args] => Array
(
[0] => SELECT UNIX_TIMESTAMP(`commDate`) AS
`commDate`,
`commText`,
`profileID`,
`Profiles`.`NickName`
FROM
`sharePhotoComments`
INNER JOIN `Profiles` ON
`Profiles`.`ID`=`sharePhotoComments`.`profileID`
WHERE `medID`='10' ORDER BY `commDate` DESC LIMIT -2,2
)

)

[2] => Array
(
[file] => /home/zabox/public_html/viewPhoto.php
[line] => 142
[function] => PageCompViewComments
[args] => Array
(
[0] =>
)

)

[3] => Array
(
[file] => /home/zabox/public_html/viewPhoto.php
[line] => 109
[function] => PageCompCreateBlocks
[args] => Array
(
[0] => 1
)

)

)


Called script: /viewPhoto.php

Request parameters:
Array
(
[fileID] => 10


Help pls.

Thanks
[commPage] => http://sahel55.com/articles/omaduro/kimumid/
)
 
Comments
·Oldest
·Top
Please login to post a comment.
crazyleaf
Can anybody answer this ? Especially the first error who keeps appearing ...
VictorT
Can you please firstly indicate the hosting company and hosting plan that you are using?
crazyleaf
Sure. The hosting company is Siteground (http://www.siteground.com) and I am using the shared hosting (750 Gb space, 7500 Gb bandwidth). I think they have anything needed to run Dolphin as these errors appeared recently ....
180
You ever figure out the problem? I have the same error.
 
 
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.
PET:0.064541101455688