Hello,
I was using 1.2.14 (Yes, I know I'm bad for not upgrading) and I logged in today and nobody can post new threads or replies.
We get errors like this:
Quote:MySQL error: 1062
Duplicate entry '366468' for key 1
Query: INSERT INTO fl_posts (tid, fid, subject, icon, uid, username, dateline, message, ipaddress, includesig, smilieoff, visible, posthash) VALUES ('15231', '23', 'test 2', '0', '2', 'PFOnline', '1255453988', 'test 2', '68.124.109.30', 'no', 'no', '1', '86553a9d7084ea876448070adefc60bc')
My board is here:
http://www.pinkfloydonline.com/forums/
How should I go about trying to fix this? Should I just try to backup and upgrade to the latest version? Does it even make sense backing up now? Now that theres an error?
My last "good" backup before this error was about a month ago.
At least you're on 1.2.14 and not 1.2.1 like one person was
First thing I'd do is look in the posts database, see if there's a post with a pid of 366468 on the last page and delete it.
If not, unfortunately 1.2 isn't supported here anymore as it's well over a year old. You'll need to upgrade to get support. It's doubtful upgrading would fix it but upgrading is in your best interest as you'll be able to get further support and you'll be using a version we know better
[Wiki: Upgrading] (Broken link, head over to docs.mybb.com instead)
Backup files and database, deactivate all plugins, remove all files apart from ./inc/config.php, ./inc/settings.php, ./uploads/, ./uploads/avatars/, and ./admin/backups/, and upload the 1.4.9 package. Go to
http://www.pinkfloydonline.com/forums/in...pgrade.php, choose 1.4.9, run through the wizard, enjoy 1.4.
Hi Matt,
I tried looking in phpmyadmin and it won't let me view that page that the post with a pid of 366468 is on. It let's me view all other pages.
I can't view it in my hosts MySQL tool either and it says it's corrupt/crashed.
How do I go about deleting it?
Sounds like someone may have posted something it didn't like or did an exploit or something?
I don't know if it helps, but I also get this error when viewing the AdminCP:
Quote:MySQL error: 1030
Got error 127 from table handler
Query: SELECT COUNT(pid) AS newposts FROM fl_posts WHERE dateline>'1255376222' AND visible='1'
Is there an error message?? Try running this query:
SELECT `pid` FROM `fl_posts` ORDER BY `pid` DESC LIMIT 0, 20;
Is 366468 a result??
OK I did that, this is what it returned:
366468
366467
366466
366465
366464
366463
366462
366461
366460
366459
366458
366457
366456
366455
366454
366453
366452
366451
366450
366449
Maybe I should delete all those pid's?
Shouldn't be necessary, 366468 is probably the only one causing the problem.
DELETE FROM `mybb_posts` WHERE `pid` = '366468';
That'll get rid of it, should fix the error.
Sorry, I'm a little slow, I get it now.
I tried deleting 366468 and got this error:
Quote:SQL query:
DELETE FROM fl_posts WHERE pid =366468 LIMIT 1
MySQL said:
#1030 - Got error 127 from table handler
OK let me try that.
Get a similar error when running that query:
Quote:Error
SQL query:
DELETE FROM fl_posts WHERE pid = '366468'
MySQL said:
#1030 - Got error 127 from table handler
Thanks for your help, btw, I promise to upgrade once I get this fixed! lol
Appears to not be even letting me delete it?
WOOOO!!!!!!!!!!!!!! Not sure how, but problem fixed! lol
I clicked repair table, think that might of done it, or maybe it deleted it in the MySQL tool?
I tried that query there too.
Thanks so much for your help!
Now it's time to backup and upgrade!
Cheers.