[TYPO3] Solution to the direct_mail bug

Vlatko Surlan vlatkoDOTsurlan at gmail.com
Wed Feb 21 20:13:43 CET 2007


Upon installing direct_mail 2.2.0 on typo3 4.0.2 and enabling debugSql 
in install tool I've got the following when loading the list module in 
backend (or almost any other module):

Warning: Invalid argument supplied for foreach() in 
/home/valdezhr/public_html/typo3_src/typo3/class.db_list.inc on line 685
caller	t3lib_DB::exec_SELECTquery
ERROR	Unknown column 'pid' in 'where clause'
lastBuiltQuery	SELECT count(*)
FROM tt_address
WHERE
pid=1
debug_backtrace	sc_db_list->main // localrecordlist->generatelist // 
localrecordlist->gettable // localrecordlist->settotalitems // 
t3lib_db->exec_selectquery // t3lib_db->debug

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL 
result resource in 
/home/valdezhr/public_html/typo3_src/t3lib/class.t3lib_db.php on line 814

Warning: Cannot modify header information - headers already sent by 
(output started at 
/home/valdezhr/public_html/typo3_src/typo3/class.db_list.inc:685) in 
/home/valdezhr/public_html/typo3_src/typo3/template.php on line 613

Fix:

ALTER TABLE `tt_address` ADD `pid` INT( 11 ) UNSIGNED NOT NULL DEFAULT 
'0' FIRST ;


More information about the TYPO3-english mailing list