[TYPO3] mysql_fetch_assoc(): Error - Can't login to BE

[Almir Orle]

Hi,

When I klick on COMPARE in install tool I get following message:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
result resource in /home/brkadm/www/brk/typo3/t3lib/class.t3lib_db.php
on line 913

But i says that I should update following tables: 
CREATE TABLE cache_hash (
hash varchar(32) NOT NULL default '',
content mediumblob NOT NULL,
tstamp int(11) unsigned NOT NULL default '0',
ident varchar(20) NOT NULL default '',
PRIMARY KEY (hash)
);

AND

CREATE TABLE cache_pages (
id int(11) unsigned NOT NULL auto_increment,
hash varchar(32) NOT NULL default '',
page_id int(11) unsigned NOT NULL default '0',
reg1 int(11) unsigned NOT NULL default '0',
HTML mediumblob NOT NULL,
tstamp int(11) unsigned NOT NULL default '0',
expires int(10) unsigned NOT NULL default '0',
cache_data mediumblob NOT NULL,
KEY page_id (page_id),
KEY sel (hash,page_id),
PRIMARY KEY (id)
);

When I click on Write to database I get even more errors saying:
Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
result resource in /home/brkadm/www/brk/typo3/t3lib/class.t3lib_db.php
on line 931

And tables are never updated... Please help me out.

Best regards,
Almir Orle


>>> typo3 at fm-world.ru 06-04-09 20:08 >>>
Hi!

Almir Orle wrote:
> I have some problems with my typo3 site. I got following errors:
> 
> Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
> result resource in /home/brkadm/www/brk/t3lib/class.t3lib_db.php on
line
> 741
> 
> Warning: mysql_free_result(): supplied argument is not a valid MySQL
> result resource in /home/brkadm/www/brk/t3lib/class.t3lib_db.php on
line
> 766

If you did upgrade from previous version, you must go to /typo3/install,
select Database Analyzer there and COMPARe/update database. If you did
not do any upgrades, you need to check your mysql tables with "CHECK
TABLE" statement for corruption.

Dmitry.

-- 
"It is our choices, that show what we truly are,
far more than our abilities." (A.P.W.B.D.)