Error while trying to run a query to force classic postbit

[Miraimaher]

Hello, I had this error while i was trying to run a query to force the classic postbit



I read similar problems suggested to check your config.php file, but i think mine is correct?

 

Hopefully someone can help, thanks alot in advance!

[Ashley1]

You need to replace "mybb_users" with the prefix you're using.

[Miraimaher]

Where can I find the "mybb_users"? I checked on my config.php but theres nothing like that there and I checked the tables that show on phpmyadmin but there was no mybb_users, I only found this one that says users but instead of mybb it has the same name as it says on the table_prefix from my config.php



EDIT: Oh, or you mean I have to change the mybb_users from the query I was running? right?

[Ashley1]

You don't need to look in any files if you already know what your table prefix is.

the query fails because you have a different table prefix than the default one.

so instead of executing:

UPDATE `mybb_users` SET `classicpostbit` = '1' WHERE `classicpostbit` = '0'

you should execute:

UPDATE `prefix_users` SET `classicpostbit` = '1' WHERE `classicpostbit` = '0'

whatever your prefix is.

[Miraimaher]

Thanks Ashley1, its fixed now, I got confused but now that you confirmed that it was the query that i needed to change, it worked fine