[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