Clueless Guy Seeking Some Quick Advise! plz!

[zane99]

Hi, i have a UK based forum thats been in operation about 4months, its been quite a success so far & we are averaging at about 30-40 members(exluding guests) online at once. The site is growing everyday & with an average of 1,500 posts a day or more.

Started to have some issues, probabaly because we are still on shared hosting?

I really do not have a clue about these things, but something tells me we need to update our hosting package...

DO i need to go to a dedicated server? & if i do, does anyone have any recomendations or general advise where to start for me?

Any advise would be greatly apreciated! thanks all

[incisor]

what issues are you having?

[zane99]

mutiple DB erros, alot to do with mySQL, the hosting company im with currently has checked it & said its nothing to do with them but our problems, whatever that means

[Colin F]

Please post the exact errors you are receiving.

[zane99]

usually its a error about max connections to mtSQL soclet or something along those lines & similar erros, today its this;

Database error in vBulletin 3.5.3:

Invalid SQL:

SELECT
post.*, post.username AS postusername, post.ipaddress AS ip, IF(post.visible = 2, 1, 0) AS isdeleted,
user.*, userfield.*, usertextfield.*,
icon.title as icontitle, icon.iconpath,

level,
deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason,
editlog.userid AS edit_userid, editlog.username AS edit_username, editlog.dateline AS edit_dateline,
editlog.reason AS edit_reason,
post_parsed.pagetext_html, post_parsed.hasimages,
IF(displaygroupid=0, user.usergroupid, displaygroupid) AS displaygroupid

, journals.journaldesc, journals.journal_id
FROM post AS post
LEFT JOIN user AS user ON(user.userid = post.userid)
LEFT JOIN userfield AS userfield ON(userfield.userid = user.userid)
LEFT JOIN usertextfield AS usertextfield ON(usertextfield.userid = user.userid)
LEFT JOIN icon AS icon ON(icon.iconid = post.iconid)
LEFT JOIN reputationlevel AS reputationlevel ON(user.reputationlevelid = reputationlevel.reputationleve lid)
LEFT JOIN deletionlog AS deletionlog ON(post.postid = deletionlog.primaryid AND type = 'post')
LEFT JOIN editlog AS editlog ON(editlog.postid = post.postid)
LEFT JOIN post_parsed AS post_parsed ON(post_parsed.postid = post.postid AND post_parsed.styleid_code = -1 AND post_parsed.styleid_html = -1 AND post_parsed.styleid_php = -1 AND post_parsed.styleid_quote = -1)
LEFT JOIN journals AS journals ON (journals.journalist_id=post.userid)
WHERE post.postid IN (0,154754)
ORDER BY post.dateline;



this is the only time the above erro has been thrown up, ususally its the one about max connections to sockets blah blah

[Colin F]

You'll have to post the entire error message.

[zane99]

You'll have to post the entire error message.

it comes and goes, i usualy get about 50 db error messages to email a day.

unfortuantly i just cleaned out my mailbox, will post the full error up when it next happnes