[magnus]

Originally Posted by will_lean

Hi
ive managed to get this working no problem on 3.0.1
however i just got the error

Invalid SQL:
SELECT vbgarage_users.*,user.username FROM vbgarage_users LEFT JOIN user ON vbgarage_users.userid = user.userid ORDER BY username ASC LIMIT 0,25

mysql error: Table databasename.vbgarage_users' doesn't exist

mysql error number: 1146

i did have it working just before i tried to view the list?
my table is vb3_vbgarage_users not vbgarage_users

if i add in my table prefix it tells me

the table vbulletin.user' doesn't exist

$result_list = $DB_site->query("
		SELECT vbgarage_users.*,user.username FROM vbgarage_users LEFT JOIN user ON vbgarage_users.userid = user.userid ORDER BY username ASC LIMIT $pos,$perpage
	");

anyone help me with this???

Eh? I'm confused. The code you pasted doesn't include " . TABLE_PREFIX . ", yet, you say you have a table prefix. So, of course it's not going to work. I have " . TABLE_PREFIX . " included in all SQL queries. Did you remove it or something?