[TYPO3] Database issues with tt_address

Dirk Völlger forums at thebiketour.net
Fri Dec 15 13:05:38 CET 2006


> I got some issues with tt_address. I installed the extension and can also
> insert adress records which are correctly saved in the db. But while
> saving as well as clicking on listview of the concerned sysfolder i get
> the following error: 
> 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

debug_backtrace	sc_db_list->main // localrecordlist->generatelist //
localrecordlist->gettable // t3lib_db->exec_select_queryarray //
t3lib_db->exec_selectquery // t3lib_db->debug


More information about the TYPO3-english mailing list