[TYPO3] Database issues with tt_address

Franz Holzinger franz at fholzinger.com
Fri Dec 15 15:16:13 CET 2006


Hello Dirk,

>> mysql_num_rows(): supplied argument is not a valid MySQL result 
>> resource in class.t3lib_db.php on line 789.
>>  Here is the concerned code of class.t3lib_db.php: 
> 
> After enabling sql debug in installation tool, i got those information:
> 
> caller	t3lib_DB::exec_SELECTquery
> 
> ERROR	Unknown column 'uid' in 'field list'
> 
> lastBuiltQuery	SELECT name,uid,pid,image,hidden,email
> FROM tt_address
> WHERE
> pid=251 AND tt_address.deleted=0
> ORDER BY name
> LIMIT 21
> 
Use the phpMyadmin and execute this SQL query from there.

Check that your tt_address table contains the uid column.

- Franz



More information about the TYPO3-english mailing list