|
Haven't registered yet? Do it here now!
|
buttster
Joined: 26 Jun 2008 Posts: 148 Location: Central Vallery California
|
|
|
|
|
|
|
Posted: Wed Apr 08, 2009 11:27 pm Post subject: mysql errors happening a lot lately |
|
|
|
|
|
|
|
|
|
|
I go in and edit the first of 50 entries for a feed, I hit save and close that window out, go back to the window showing the 50 feeds and hit refresh to see the list again and this constantly happens: Query to MySQL Failed: Table 'fe' is marked as crashed and should be repaired, I go and repair it in control panel. I am in the list after clicking the search button, not the review window. |
|
|
|
|
|
|
|
Atanasis Owner
Joined: 22 May 2004 Posts: 4284 Location: The Net
|
|
|
|
|
|
|
Posted: Wed Apr 08, 2009 11:34 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
Table 'fe' ?? There isn't such table in BA _________________ Thanks,
Kaktusan
|
|
|
|
|
|
|
|
buttster
Joined: 26 Jun 2008 Posts: 148 Location: Central Vallery California
|
|
|
|
|
|
|
Posted: Thu Apr 09, 2009 12:18 am Post subject: |
|
|
|
|
|
|
|
|
|
|
reply from server techs
Strange, the table that had the problem was:
buttster_ba.baentries
error : Key 2 doesn't point at same records that key 1
error : Corrupt
I've forced a repair on all tables for this database. The error is gone now
I will have to see if it continues or stops now, will keep you informed
thanks much |
|
|
|
|
|
|
|
buttster
Joined: 26 Jun 2008 Posts: 148 Location: Central Vallery California
|
|
|
|
|
|
|
Posted: Fri Apr 10, 2009 2:46 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
still crashing table in mysql constantly with that crazy "fe table" not sure what to do, |
|
|
|
|
|
|
|
Atanasis Owner
Joined: 22 May 2004 Posts: 4284 Location: The Net
|
|
|
|
|
|
|
Posted: Fri Apr 10, 2009 11:06 pm Post subject: |
|
|
|
|
|
|
|
|
|
|
never had BA table going corrupt so far, even that recently. There is definitely something wrong going on your server. Has this been happening on any of the rest my scripts? _________________ Thanks,
Kaktusan
|
|
|
|
|
|
|
|
buttster
Joined: 26 Jun 2008 Posts: 148 Location: Central Vallery California
|
|
|
|
|
|
|
Posted: Sat Apr 11, 2009 12:37 am Post subject: |
|
|
|
|
|
|
|
|
|
|
techs I believe fixed the problem with this reply:
I've completed upgrading MySQL and upgraded/rebuilt PHP.
I've just done about 6 edits, and have been unable to replicate the problem.
Hopefully this has solved the issue. |
|
|
|
|
|
|
|
Atanasis Owner
Joined: 22 May 2004 Posts: 4284 Location: The Net
|
|
|
|
|
|
|
Posted: Sat Apr 11, 2009 10:59 am Post subject: |
|
|
|
|
|
|
|
|
|
|
ok, yeah i were to suggest to upgrade php/mysql..
keep me posted how it goes.. _________________ Thanks,
Kaktusan
|
|
|
|
|
|
|
|
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2002 phpBB Group
|
|
|
|
| |