HomeUnityBlogs
 
 
crazyleaf

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/
)
bad
0
good
 
 

Comments

crazyleaf
crazyleaf 148 days agocomment permalink
 
Can anybody answer this ? Especially the first error who keeps appearing ...
 
bad
0
good
 
 
VictorT
VictorT 148 days agocomment permalink
 
Can you please firstly indicate the hosting company and hosting plan that you are using?
 
bad
0
good
 
 
crazyleaf
crazyleaf 148 days agocomment permalink
 
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 ....
 
bad
0
good
 
 


Post a Comment

Please login to post a comment.

This Post
 
 
crazyleaf Blog
All Blogs
Found a bug? Have a suggestion? We really value your feedback!
 
© 2008 BoonEx Ltd
ABN 27 127 966 581
 
PET:0.415966033936