#23 Export - fatal error 'fetch_assoc'

[Anonymous]

Adminer was doing everything well until recently when I slightly changed one my database (removed is_deleted columns from every table) and since that, it can't export anything from any database (even database that I didn't touch). Export result:

-- Adminer 2.2.0 dump
SET NAMES utf8;
SET foreign_key_checks = 0;
SET time_zone = 'SYSTEM';
SET sql_mode = 'NO_AUTO_VALUE_ON_ZERO';

<br />
<b>Fatal error</b>: Call to a member function fetch_assoc() on a non-object in <b>D:\Webs\html\mysql\index.php</b> on line <b>438</b><br />

[Jakub Vrána]

Please specify your MySQL version. This line exports routines and events which are available since MySQL 5 resp. 5.1.

[Nobody/Anonymous]

5.1.37-community via MySQLi.

I really didn't do anything special with the database and I can't export even from different databases since that moment.

[Jakub Vrána]

This has probably nothing to do with your change. Can you please verify your rights? What's the output of SHOW GRANTS?

[Nobody/Anonymous]

It's very strange that the export worked before the removal of few columns from several tables.

SHOW GRANTS:

GRANT ALL PRIVILEGES ON *.* TO 'lasthunter'@'localhost' IDENTIFIED BY PASSWORD '*F94F4BD10F2A2E3210541F7BD2F2B08706C3363D'

[Jakub Vrána]

Can you please report the result of following commands?

SHOW FUNCTION STATUS;
SHOW PROCEDURE STATUS;
SHOW EVENTS;

It would probably produce some error.

[Nobody/Anonymous]

First two results are empty and the last one shows following error:

Cannot proceed because system tables used by Event Scheduler were found damaged at server start

[Jakub Vrána]

Then please fix your server before export.

[Jakub Vrána]

SVN version now ignores this error.