I get this error when I try to run it:
Database error in vBulletin 3.0.6:
Invalid SQL:
UPDATE thread
SET forumid =
Where lastpost <= 1110979914
AND forumid =
mysql 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 'Where lastpost <= 1110979914
AND forumid =' at line 3
mysql error number: 1064
Any ideas?
Here's a sample of the php file I've edited:
// edit the forum id number where the threads have to be moved FROM
$fromforuma="153";
// edit the forum id number where the threads have to be moved TO
$toforuma="63";
$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET forumid = $toforuma
Where lastpost <= $movedate
AND forumid = $fromforuma
");
// edit the forum id number where the threads have to be moved FROM
$fromforumb="4";
// edit the forum id number where the threads have to be moved TO
$toforumb="63";
$DB_site->query("
UPDATE " . TABLE_PREFIX . "thread
SET forumid = $toforumb
Where lastpost <= $movedate
AND forumid = $fromforumb
");
.
.
.
.
.
.
|