Quick Login   
 
Register AdminFusion Tutorials
 
Featured Sponsors


One.com Domain and Hosting


Register
Forum of the Month
Australian Webmaster
fotm

A webmaster forum specifically catering for Australian site owners. We discuss site development, marketing and management issues.

Tag Cloud
Latest Threads
Forum Stats
7,917 Members
165,164 Posts
62 Users Online

Please welcome our newest member, clairlim!

Affiliates
Go Back AdminFusion » Getting Started » Domains and Hosting » Weird Issues with my sites
Welcome to the AdminFusion. AdminFusion is the ultimate resource for forum administrators and moderators. With exclusive articles, interviews with the experts, free downloadable skins, and the revolutionary post exchange system - PostFusion, AdminFusion is the place to go for all of your forum needs.  By joining AdminFusion, you will become part of a thriving admin community and immediately gain access to all of these resources. Registration is fast, simple and absolutely free so please join us today!
Want more than our forums? Try these: Post Fusion Forum Matrix
Old 12-01-2007, 05:02 PM   #1

Rocket 442's Avatar

Title: Apprentice

Points: 4,212, Level: 18Points: 4,212, Level: 18Points: 4,212, Level: 18
Level up: 19%, 38 Points neededLevel up: 19%, 38 Points neededLevel up: 19%, 38 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Jul 2006

Posts: 485

Location: Buffalo, NY

Rocket 442 is a splendid one to beholdRocket 442 is a splendid one to beholdRocket 442 is a splendid one to beholdRocket 442 is a splendid one to beholdRocket 442 is a splendid one to beholdRocket 442 is a splendid one to behold

Recent Blog: OpenX Hosted
Send a message via AIM to Rocket 442 Send a message via MSN to Rocket 442  
 
Weird Issues with my sites

I'm having some problems with my sites over the past 24 hours.

I have 2 sites both on the same server, one a SMF forum, and one a vB forum.

Both are getting errors from their databases, but I did nothing to change their databases at all.

Heres what the vB one says (it will let me view the index, but anything else gives you this)
Quote:
Database error in vBulletin 3.6.4:

Invalid SQL:

SELECT
IF(votenum >= 1, votenum, 0) AS votenum,
IF(votenum >= 1 AND votenum > 0, votetotal / votenum, 0) AS voteavg,
post.pagetext AS preview,
thread.threadid, thread.title AS threadtitle, thread.forumid, pollid, open, replycount, postusername, postuserid, thread.iconid AS threadiconid,
thread.lastpost , thread.lastposter, thread.lastpostid, thread.dateline, IF(views<=replycount, replycount+1, views) AS views, notes, thread.visible, sticky, votetotal, thread.attach,
hiddencount, deletedcount
, NOT ISNULL( subscribethread.subscribethreadid) AS issubscribed
, deletionlog.userid AS del_userid, deletionlog.username AS del_username, deletionlog.reason AS del_reason
, threadread.readtime AS threadread
, threadredirect.expires

FROM vb_thread AS thread
LEFT JOIN vb_deletionlog AS deletionlog ON(thread.threadid = deletionlog.primaryid AND deletionlog.type = 'thread')
LEFT JOIN vb_subscribethread AS subscribethread ON(subscribethread.threadid = thread.threadid AND subscribethread.userid = 2 AND canview = 1)
LEFT JOIN vb_threadread AS threadread ON (threadread.threadid = thread.threadid AND threadread.userid = 2)
LEFT JOIN vb_post AS post ON(post.postid = thread.firstpostid)

LEFT JOIN vb_threadredirect AS threadredirect ON(thread.open = 10 AND thread.threadid = threadredirect.threadid)

WHERE thread.threadid IN (0,1226,1234,1220,1184,1185,1152,1164,1166,1162,11 59,1146,1153,1135,1141,1129,1123,1118,1091,1062,10 55,32)
ORDER BY sticky DESC, lastpost DESC;

MySQL Error : Table './olds442_vb/vb_post' is marked as crashed and should be repaired
Error Number : 145
Date : Saturday, December 1st 2007 @ 12:20:56 AM
Script : Introductions - F-Body Online
Referrer : F-Body Online - Camaro and Firebird Forums
Classname : vB_Database


I have no idea what this could be? My host was looking around, but thinks it happened because of an update I was doing, but I wasn't updating anything.
__________________
Camaro Forums || Firebird Forums
Check out vBulletin Setup for all your vBulletin SEO Questions & Tips
There is always someone faster, and in your case, that someone is Me
Reply With Quote
Old 12-01-2007, 05:26 PM   #2

bcmtouring's Avatar

Title: Veteran

Points: 3,974, Level: 18Points: 3,974, Level: 18Points: 3,974, Level: 18
Level up: 19%, 276 Points neededLevel up: 19%, 276 Points neededLevel up: 19%, 276 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Jun 2006

Posts: 585

Location: New Delhi, India

bcmtouring is a name known to allbcmtouring is a name known to allbcmtouring is a name known to allbcmtouring is a name known to allbcmtouring is a name known to allbcmtouring is a name known to all
 
 
Have you tried repairing the tables from the phpmyadmin?
Reply With Quote
Old 12-01-2007, 05:31 PM   #3

calum's Avatar

Title: Apprentice

Points: 1,426, Level: 10Points: 1,426, Level: 10Points: 1,426, Level: 10
Level up: 11%, 124 Points neededLevel up: 11%, 124 Points neededLevel up: 11%, 124 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Sep 2007

Posts: 161

Location: Scotland

calum will become famous soon enough
Send a message via MSN to calum  
 
Try repairing the tables in phpMyAdmin, also try doing a vBulletin table repair (I don't know about SMF).

Mabye your host has changed some MySQL related settings or upgraded the MySQL version. Try contacting them if you cannot solve the problems.
__________________
Computer Forum
Calum
Football Forum
Reply With Quote
Old 12-01-2007, 05:42 PM   #4

Rocket 442's Avatar

Title: Apprentice

Points: 4,212, Level: 18Points: 4,212, Level: 18Points: 4,212, Level: 18
Level up: 19%, 38 Points neededLevel up: 19%, 38 Points neededLevel up: 19%, 38 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Jul 2006

Posts: 485

Location: Buffalo, NY

Rocket 442 is a splendid one to beholdRocket 442 is a splendid one to beholdRocket 442 is a splendid one to beholdRocket 442 is a splendid one to beholdRocket 442 is a splendid one to beholdRocket 442 is a splendid one to behold

Recent Blog: OpenX Hosted
Send a message via AIM to Rocket 442 Send a message via MSN to Rocket 442  
 
Yup, tried to repair the tables through phpmyadmin.

I've been talking to the host, but they dont seem to know what is up.


EDIT: Repairing them via vB admin panel seemed to work except this one:
vb_post Check Error: Table './olds442_vb/vb_post' is marked as crashed and should be repaired

All others work, and I can now at least view threads
__________________
Camaro Forums || Firebird Forums
Check out vBulletin Setup for all your vBulletin SEO Questions & Tips
There is always someone faster, and in your case, that someone is Me
Reply With Quote
Old 12-01-2007, 05:51 PM   #5

calum's Avatar

Title: Apprentice

Points: 1,426, Level: 10Points: 1,426, Level: 10Points: 1,426, Level: 10
Level up: 11%, 124 Points neededLevel up: 11%, 124 Points neededLevel up: 11%, 124 Points needed
Activity: 0%Activity: 0%Activity: 0%

Join Date: Sep 2007

Posts: 161

Location: Scotland

calum will become famous soon enough
Send a message via MSN to calum  
 
Try posting on the official vbulletin and SMF forums, they will have more of a knowledge about the specific tables etc.
__________________
Computer Forum
Calum
Football Forum
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

 
Posting Rules

Similar Threads
Thread Thread Starter Forum Replies Last Post
can someone explain this weird problem? discojo Domains and Hosting 8 01-26-2007 05:10 PM
no good sites? all good sites filled? Lpspider PostFusion Chat 15 06-13-2006 11:20 PM
Two Proxy/Anonymity Sites, different from the rest w/revenue David Buy and Sell 0 06-07-2006 02:31 AM
How to rotate ads serving across a network of sites? llegent Off Topic 15 05-16-2006 07:37 PM

AdminFusion

All times are GMT +1. The time now is 11:54 AM. Powered by vBulletin® Version 3.7.3
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
Content Relevant URLs by vBSEO 3.1.0 © 2005-2008 AdminFusion - All Rights Reserved


From:
Title:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72