Error Number 145 Vbulletin
3.6.8 Register Help Members List Today's Posts Search Quick Links Thread Tools #1 22 Oct 2007, 10:27 tunistunis Member Join Date: Jun 2007 Error Number : 145 Database error in vBulletin 3.6.8 Error Number : 145 Database error in vBulletin 3.6.8 Invalid SQL: SELECT access.*, forum.forumid, FIND_IN_SET(access.forumid, forum.parentlist) AS ordercontrol FROM xxxforum AS forum INNER JOIN xxxaccess AS access ON (access.userid = 2 AND FIND_IN_SET(access.forumid, forum.parentlist)) ORDER BY ordercontrol DESC; MySQL Error : Table './xxxxxx/xxxforum' is marked as crashed and should be repaired Error Number : 145 Please Help ME Thanks No members have liked this post. tunistunis View Public Profile Find all posts by tunistunis #2 22 Oct 2007, 10:44 Marco van Herwaarden Coder Join Date: Jul 2004 To fix this run Repair/Optimize in the Admin CP. You may need to run it more than once to fix all errors: Admin CP -> Maintenance -> Repair/Optimize Tables -> Check All -> Continue If you can not access your AdminCP, then you can upload the tools.php file from the vbulletin .zip file do_not_upload/ folder into your forumdir/admincp/ directory and run it through the browser, there's a switch there to run optimize and repair. Run it a few times for best result. If you cannot access either the Admin CP or tools.php you can also use a tool like phpMyAdmin to repair tables. __________________ Marco van Herwaarden Ex vBulletin.org Coordinator No members have liked this post. Marco van Herwaarden View Public Profile Find all posts by Marco van Herwaarden Likes Received: 7 #3 22 Oct 2007, 11:47 tunistunis Member Join Date: Jun 2007 AdminCP not works i have this file backup for my forum (forumbackup-10-21-2007-xxxx.sql) how to restore my forum help me Please thanks No members have liked this post. tunistunis View Public Profile Find all posts by tunistunis #4 22 Oct 2007, 13:52 Marco van Herwaarden Coder Join Date: Jul 2004 No need to restore if that is the only error you get. Please read my post again, there are also instruction for when you can not access the AdminCP anymore. __________________ Marco van Herwaarden Ex vBulletin.org Coordinator No members have liked this post. Marco van Herwaarden View Public Profile Find all posts by Marco van Herwaarden Likes Received: 7 « Previous Thread | Next Thread » Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) Thread Tools Show Printable Version Posting Rules You may not post new threads You may not post replies You may not p
Forums Hosting Security and Technology Vbulletin problem after Mysql update If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 8 of 8 Thread: Vbulletin problem after Mysql update Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced http://www.vbulletin.org/forum/showthread.php?t=160818 Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-07-2003,06:01 AM #1 Serverplan View Profile View Forum Posts View Forum Threads Web Hosting Master Join Date Aug 2002 Posts 1,632 Vbulletin problem after Mysql update Hi after Mysql update4.0.12 i get this error from Vbulletin forum how can i fix this? Can't open file: 'thread.MYI'. (errno: 145) Error query http://www.webhostingtalk.com/showthread.php?t=130027 SQL : SHOW KEYS FROM `thread` Can't open file: 'thread.MYI'. (errno: 145) Database error in vBulletin 2.2.8: Invalid SQL: INSERT INTO thread (threadid,title,lastpost,forumid,open,replycount,p ostusername,postuserid,lastposter,dateline,iconid, visible,attach) VALUES (NULL,'Nevica... ','1049702408','16','1','0','René','132','René','1 049702408','0','1','0') mysql error: Got error 127 from table handler mysql error number: 1030 Date: Monday 07th of April 2003 10:00:08 AM Script: http://www.xxx.com//forum/forum/newthread.php Referer: http://www.xxx.com//forum/newthread...read&forumid=16 ------------------------------------------------------------------------------------------------------------------------------ Database error in vBulletin 2.2.8: Invalid SQL: SELECT COUNT(*) AS threads FROM thread mysql error: Can't open file: 'thread.MYI'. (errno: 145) mysql error number: 1016 Date: Monday 07th of April 2003 11:11:47 AM Script: http://www.xxx.com//forum/forum/ Referer: ------------------------------------------------------------------------------------------------------------------------------ Database error in vBulletin 2.2.8: Invalid SQL: SELECT thread.threadid FROM thread WHERE thread.forumid = 16 AND thread.sticky=0 AND thread.visible=1 AND lastpost >= 1047110496 AND sticky=0 ORDER BY sticky DESC, lastpost DESC LIMIT 0,30 mysql error: Got error 127 from table handler mysql error number: 1030 Date: Monday 07th of April 2003 10:01:36 AM Script: http://www.xxx.com/forum/forum/foru...p?s=&forumid=16 Referer: http://www.xxx.com//forum/index.php?s= Reply With Quote 0 04-07-2003,07:15 AM #2 LinuXpert View Profile View Forum Posts View Forum Threads Visit Homepage Web Hosting Master Join Date Apr 2002 Posts 565 Go to /var/lib/mysql/data and check the per
Separate names with a comma. Newer Than: Search this thread only Search this forum only Display results as threads Useful Searches Recent Posts More... Pilots of America Home https://www.pilotsofamerica.com/community/threads/vbulletin-mysql-error.39294/ Forums > Pilot's Lounge > Technical Corner > Vbulletin MySQL error Discussion in 'Technical Corner' started by gkainz, Dec 11, 2010. gkainz Final Approach Joined: Feb 23, 2005 Messages: 6,811 Location: Arvada, CO Display name: Greg Kainz another board I visit is throwing an error and they have no support. I'm an Oracle DBA but have never touched MySQL. A quick google search shows options for error number Repair Table in MySQL - would that be the first obvious fix for something like this error? -------------------------------------- vBulletin Database Error! Database error in vBulletin 3.8.4: Invalid SQL: SELECT post.*, IF(post.visible = 2, 1, 0) AS isdeleted, editlog.userid AS edit_userid, editlog.dateline AS edit_dateline, editlog.reason AS edit_reason, editlog.hashistory FROM post AS post LEFT JOIN editlog AS editlog ON (editlog.postid = post.postid) WHERE post.postid = 1624179; MySQL Error : error number 145 Table './diese3_vb/post' is marked as crashed and should be repaired Error Number : 145 gkainz, Dec 11, 2010 #1 murphey Final Approach PoA Supporter Joined: Aug 21, 2008 Messages: 5,745 Location: Colorado Display name: murphey gkainz said: ↑ another board I visit is throwing an error and they have no support. I'm an Oracle DBA but have never touched MySQL. A quick google search shows options for Repair Table in MySQL - would that be the first obvious fix for something like this error?Click to expand... Yes. It's also common when there's a huge load on the system or one of the tables got corrupted. I've yet to find any software error messages that mean anything until you understand what caused the problem. a** Backwards and has been for decades. Before repair, can you get a dump of the current contents of the table and examine it? It may be something simple as a data type conflict that snuck thru or worse case, the whole table is trash...er...corrupted. Do you have the DDL that created the table? After attempting to repair, the next option would be to delete it (and hope there's a backup to relo