[TYPO3-dev] Suddenly mysql related errors in Extension Manager

[Jigal van Hemert]

Hi all,

A couple of days ago this phenomenon started on a T3 v.3.8 installation:

When accessing the Information page (also Backup/Delete, Dump DB, Upload
pages) in the Extension Manager on top of the screen Warnings like:

Warning: mysql_fetch_assoc(): supplied argument is not a valid MySQL
result resource in
/var/www/vhosts/bms.ontw.eurorscg4d.nl/pub/t3lib/class.t3lib_db.php on
line xxx

appear. The warnings originate from the t3lib_DB::admin_get_fields() and
admin_get_keys() functions. The queries (SHOW columns FROM <table> ;
SHOW keys FROM <table>) run happily from within the phpMyAdmin extension
(which uses the same db/user/password for its connection).
The calls to these function are performed by the routine that compares
the table structure in the database with those in the ext_tables.sql
files. Further testing revealed that the MySQL connection object was not
set (NULL), even after a call to sql_pconnect(). ($this->link was NULL
right after the call to mysql_connect() ).

The rest of the backend seems to function fine. Apart from the missing
remarks about database tables that need to be updated (quite logically
if the compare function fails) and the warning on top of the pages. A
few functions don't work because of the Warnings (downloading
extensions, etc.)

I then turned to the INSTALL tool. Database Analyser shows a successful
connection and can select the correct database. COMPARE option shows the
same warning on the beginning of the page and furthermore wants to
create most of the tables from scratch.

I performed the usual REPAIR and OPTIMIZE commands on the database,
cleared the FE cache, the typo3conf cache, the database cache tables and
the temp_CACHED_* files from typo3conf.

Any ideas what goes wrong an how I can fix it?

Kind regards,

Jigal van Hemert
Programmer

Euro RSCG 4D