Database errors
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/
)