The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
|
#1
|
|||
|
|||
Getting SQl/php error, help plz
This error is occuring when i try to mass prune users.
Code:
Database error in vBulletin Control Panel 2.2.7: Invalid SQL: SELECT userid,username FROM user WHERE userid IN() LIMIT 0 mysql error: You have an error in your SQL syntax near ') LIMIT 0' at line 1 mysql error number: 1064 Code:
...... $users = $DB_site->query("SELECT userid,username FROM user WHERE userid IN($userids) LIMIT $startat,50"); if ($DB_site->num_rows($users)) { while ($user = $DB_site->fetch_array($users)) { echo "<p>Updating threads and posts for user: <i>$user[username]</i> ....\n"; flush(); $DB_site->query("UPDATE thread SET postuserid=0, postusername='".addslashes($user[username])."' WHERE postuserid=$user[userid]"); $DB_site->query("UPDATE post SET userid=0, username='".addslashes($user[username])."' WHERE userid=$user[userid]"); echo "<b>done</b>.</p>\n"; flush(); ....... I'm running MySQL 3.23.41 and php 4.2.2 anyone know whats goin on? |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|