2011-12-22, 06:05 AM
(2011-12-19, 03:10 PM)enhu Wrote: [ -> ]users pruningdon't seemtowork too.
i tried once again the commandQuote:DELETE FROMmybb_users
where postnum=0
and it now returned
Quote:#1054 - Unknown column 'postsnum' in 'where clause'
yet no users has been deleted still
I'm not sure how you managed that. Perhaps horrid spelling is common between you and your server.
I advise against using the query anyway. As Labrocca said, members leave traces in other tables. Use the pruning tool instead. If that isn't working for you, then your forum has an issue. Post in the support forums.