Please upgrade here. These earlier versions are no longer being updated and have security issues.
HackerOne users: Testing against this community violates our program's Terms of Service and will result in your bounty being denied.
Options

A lot of Bonks after removing SPAM manually from mysql discussion table

mromro
edited May 2011 in Vanilla 2.0 - 2.8
hey there.

got a lot of bonks after I deleted a lot of spam and users directly with mysql after import from phpbb.

whats the reason?
should i delete the posts first in phpbb and then re-import again?
or is there any other solution/workaround?

cheers
m.

here is the error:
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 ')' at line 5
SELECT u.UserID, COALESCE(u.CountComments,0) + COALESCE(u.CountDiscussions,0) AS PostCount FROM GDN_User u WHERE UserID IN (6823,)
The error occurred on or near: /vanilla/library/database/class.database.php
232: $PDOStatement = $this->Connection()->query($Sql);
233: }
234:
235: if ($PDOStatement === FALSE) {
236: trigger_error(ErrorMessage($this->GetPDOErrorMessage($this->Connection()->errorInfo()), $this->ClassName, 'Query', $Sql), E_USER_ERROR);
237: }
238:
239: $ReturnType = GetValue('ReturnType', $Options);
240:

commented out line 236 and it works, but is this relevant to any other function?
Sign In or Register to comment.