Bug #17725
closedWarning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/sciottob/public_html/typo3_src/ty
0%
Description
I get this error almost all the time now when I try to use the INSTALL tool. I looked at the cache hash issue that was fixed with mediumblob, but that was already done on my sql tables. This is an incredibly frustrating error. On pages with news, whenever there is a new record I get the following errors:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL result resource in /home/sciottob/public_html/typo3_src/typo3/sysext/dbal/class.ux_t3lib_db.php on line 1725
Warning: Cannot modify header information - headers already sent by (output started at /home/sciottob/public_html/typo3_src/typo3/sysext/dbal/class.ux_t3lib_db.php:1725) in /home/sciottob/public_html/typo3_src/typo3/sysext/cms/tslib/class.tslib_fe.php on line 2898
Anyone have any ideas how to fix
The problem goes away on refresh, but my error log is long.
(issue imported from #M6600)
Updated by Andrew Franks about 17 years ago
Also, when I go to the Install Compare tables, it has a lot of changes, and when I click update, nothing happens.
Updated by Martin Kutschker about 17 years ago
Turn on TYPO3_DB and/or DABL debugging/logging to see what is causing the error. I recall hacking an older version of tt_news because ot wasn't DBAL ready at all. Lot's of sloppy Mysql code ;-)
Updated by Andrew Franks about 17 years ago
OK and this will probably reveal how Noob I am, but how can I check that and turn it on if it isn't?
Updated by Andrew Franks about 17 years ago
It seems as if I have dbug on but it's blank.
Updated by Frans Lichtenauer about 17 years ago
Same error when using the 'web/List' feature in the BE menu
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/marstall/public_html/typo3/sysext/dbal/class.ux_t3lib_db.php on line 1307
The error was introduced for me with version 4.1.2
Updated by Andrew Franks almost 17 years ago
It was a space on line 1307. I compared it with another site that was working.