MyBB Community Forums

Title says it all.

you can use SQL query like below (assuming that mybb_ is the table prefix)

DELETE FROM `mybb_privatemessages` WHERE dateline < 1356998400 AND readtime > 0

1356998400 is UnixTimeStamp for 2013 January 01 - UTC 00:00

guidance for SQL queries --> common SQL queries - how to run them

(2014-02-20, 01:00 PM).m. Wrote: [ -> ]you can use SQL query like below (assuming that mybb_ is the table prefix)

DELETE FROM `mybb_privatemessages` WHERE dateline < 1356998400 AND readtime > 0

1356998400 is UnixTimeStamp for 2013 January 01 - UTC 00:00

guidance for SQL queries --> common SQL queries - how to run them

Thanks for the reply but I get this error

#1146 - Table 'error_mybb.mybb_privatemessages' doesn't exist

^ error_mybb is your database name.
what is the prefix for the database tables ? you have to use it instead of mybb in the SQL query

(2014-02-20, 02:21 PM).m. Wrote: [ -> ]^ error_mybb is your database name.
what is the prefix for the database tables ? you have to use it instead of mybb in the SQL query

OMG how noob I am.

tnx worked.

appreciated.
I would be grateful if you reply my last post on this topic as well.
http://community.mybb.com/thread-42986-p...pid1062881