Home N-13 News Forums Help Search
RegisterForgot password?
How to add image to post necklacesdiscou
Known bugs - 4.0.3 necklacesdiscou

Latest N-13 News 4.0.3

What is N-13 News?
Where can I get help?
Known bugs

Forums Help & Support Upgrade 3.4 Error Unable to prepare
Spanker
Posted on 25 Dec 2009, 21:43:07

Access: Member
Total Posts: 12
Joined: 2009-10-16

I can see all the news in my page, i just cant do anything in the admin side.
I allways get this error:

"Optimizing all tables: Unable to prepare: OPTIMIZE TABLE news30_story
Arguments: "
#1365
Chris
Posted on 26 Dec 2009, 06:09:07

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

If you edit the modules/home.php module, on about on 93~ you'll see the following lines

Code:
DataAccess::put("OPTIMIZE TABLE $newstable");
DataAccess::put("OPTIMIZE TABLE $newstable");
.....
DataAccess::put("OPTIMIZE TABLE $newsprivate");
DataAccess::put("OPTIMIZE TABLE $newsprivateout");
DataAccess::put("OPTIMIZE TABLE $newsaccesslogs"); 


Delete all of those lines then save and the problem should hopefully go away.
#1367
Network-13.com © 2013