MyBB Community Forums

Hello,
Im looking for someone help me cure an issue on my website, no members can post/create new threads. I cant disable or update plug ins, I cant run an update to the forums themselves. Essentially the forum is now in hibernation mode. Old threads can be accessed etc but any kind of posting results in mybb mysql error. Im currently looking for someone to atleast fix the mysql errors so I can update the site and get my forum active again. Im willing to pay via paypal for the service feel free to PM me.

Here's an idea of what youd be working with..
https://community.mybb.com/thread-216116.html

https://community.mybb.com/thread-225866.html

You really don’t need to pay someone to do this.

Jump into your phpMyAdmin and run this.

 SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'STRICT_TRANS_TABLES',''));

Should resolve your problem. If it doesn’t pop back and we’ll wipe all the SQL modes.

Just to confirm because im a bit rusty at all this, I want to go into my phpadmin, go to my mybb database and submit the query?

---

(2020-04-14, 09:37 PM)s3_gunzel Wrote: [ -> ]You really don’t need to pay someone to do this.

Jump into your phpMyAdmin and run this.

 SET GLOBAL sql_mode=(SELECT REPLACE(@@sql_mode,'STRICT_TRANS_TABLES',''));

Should resolve your problem. If it doesn’t pop back and we’ll wipe all the SQL modes.

I submitted the query? and then I tested the forum and it came up with this error

Quote:MyBB has experienced an internal SQL error and cannot continue.

SQL Error: 1054 - Unknown column 'p.posthash' in 'where clause' Query: SELECT p.pid FROM mybb_posts p WHERE p.uid='2' AND p.fid='21' AND p.subject='Test' AND p.message='Test' AND p.posthash='3feef71455a5ffca7bad303439218677'

probably database was disturbed when you attempted upgrading.

you can try adding posthash column

ALTER TABLE `mybb_posts` ADD `posthash` varchar(32) NOT NULL default '';

[SQL queries guidance]

if above doesn't help, you may PM me temporary access to
your forum admin panel & webhost control panel (both required)

(2020-04-14, 07:20 PM)vegathechosen Wrote: [ -> ]Hello,
Im looking for someone help me cure an issue on my website, no members can post/create new threads. I cant disable or update plug ins, I cant run an update to the forums themselves. Essentially the forum is now in hibernation mode. Old threads can be accessed etc but any kind of posting results in mybb mysql error. Im currently looking for someone to atleast fix the mysql errors so I can update the site and get my forum active again. Im willing to pay via paypal for the service feel free to PM me.

Here's an idea of what youd be working with..
https://community.mybb.com/thread-216116.html

https://community.mybb.com/thread-225866.html

Hello,
Greetings

I'd Glad to assist you.
PM Sent, Please Check.

Very Best Regards
Carter W

Problem solved thanks @.m. for the assist im beyond grateful!

I will close this as it is solved.

Next time please avoid opening Requests / Services / Jobs while seeking for support.
I'm not saying that was your intention but it was ultimately the result.