#23 Export - fatal error 'fetch_assoc'

2.2.1
closed-fixed
Jakub Vrána
Common (150)
5
2009-12-11
2009-11-17
Anonymous
No

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 />

Discussion

  • Jakub Vrána
    Jakub Vrána
    2009-11-18

    • status: open --> pending
     
  • Jakub Vrána
    Jakub Vrána
    2009-11-18

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

     
  • 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.

     
    • status: pending --> open
     
  • Jakub Vrána
    Jakub Vrána
    2009-11-18

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

     
  • Jakub Vrána
    Jakub Vrána
    2009-11-18

    • status: open --> pending
     
    • status: pending --> open
     
  • 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
    Jakub Vrána
    2009-11-23

    Can you please report the result of following commands?

    SHOW FUNCTION STATUS;
    SHOW PROCEDURE STATUS;
    SHOW EVENTS;

    It would probably produce some error.

     
  • Jakub Vrána
    Jakub Vrána
    2009-11-23

    • status: open --> pending
     
  • 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

     
    • status: pending --> open
     
  • Jakub Vrána
    Jakub Vrána
    2009-11-30

    • status: open --> closed-rejected
     
  • Jakub Vrána
    Jakub Vrána
    2009-11-30

    Then please fix your server before export.

     
  • Jakub Vrána
    Jakub Vrána
    2009-12-11

    SVN version now ignores this error.

     
  • Jakub Vrána
    Jakub Vrána
    2009-12-11

    • status: closed-rejected --> closed-fixed