View Single Post
  #5  
Old 28 Jun 2006, 04:16
Paul M's Avatar
Paul M Paul M is offline
 
Join Date: Sep 2004
Real name: Paul M
This is the same error as this thread ;

http://www.vbulletin.org/forum/showthread.php?t=119719

The broken line is this one ;


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

The table name is missing from the WHERE section after the table prefix.

i.e. TABLE_PREFIX . "userid should be TABLE_PREFIX . "user.userid

However, table prefix should not be used in WHERE clauses anyway, instead you should us an AS after the initial table selection, like this ;


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

Finally, since only one table is actually used in this select, the table references can be dropped completely as no ambiguity is possible.


Block Disabled:      (Update License Status)  
Suspended or Unlicensed Members Cannot View Code.

__________________
Former vBulletin.org Staff Member


Cable Forum
Please do not PM me about custom work - I no longer undertake any.
Note: I will not answer support questions via e-mail or PM - please use the relevant thread or forum.
Reply With Quote