MyBB Community Forums

I'm really not sure if this isa bug or not as I think I did manage to split a post from a thread before (but my memory fails me)

This is the mySQL error I receive when I try to split the post:

MySQLi error: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ALL THIS PART HERE IS THE CONTENT)' at line 1
Query: INSERT INTO mybb_threads (fid, subject, icon, uid, username, dateline, lastpost, lastposter, replies, visible, notes) VALUES ('ALL THE VALUES HERE);

My host uses mySQL 5.0.x.x.

Merging threads is fine... it's just the splitting posts.

Thanks in advance for any help!

Well we won't be able to figure it out until you say what is in the "ALL THIS PART HERE IS THE CONTENT" Can you repost the exact error, or PM it to me.

Also, what method did you use to split the post?

Hi Dennis,
Thanks for your reply I've PM'd the full error details to you.

With regards to method, it's something I've always used:
1. Check the relevant post tickbox
2. Scroll to bottom of the post
3. Select 'Split Posts'
4. It gets to the 'set new thread title/location' page
5. I click submit, and the error pops up.

Thanks

Are you running MyBB 1.2.7?

I did run the upgrade a while back when it came out and the main admin info page says it's 1.2.7.

Can you download MyBB 1.2.7 again and extract inc/class_moderation.php from the pacakage. Delete the existing inc/class_moderation.php from your server and reupload inc/class_moderation.php. See if that fixes your problem.

Sorry about the late reply. I've just tried to upload a new class_moderation.php but it still gives the same message. What I have noticed though is that the content in the first part *isn't* in fact the actual post I selected. Is this usual? As in, it says 'MejiX' but the last poster was a 'Faust'.

Thanks again

Can you try this inc/class_moderation.php file please and see if your problem is fixed. Try splitting the same posts.

Hi DennisTT,
Thank you so much for your help! It works perfectly now! ^^ WOW! Thanks again!
Hopefully it wasn't too much of a big thing to fix.