Bugs and Features item #2898988, was opened at 2009-11-17 11:06
Message generated for change (Comment added) made by jakubvrana
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2898988&group_id=264133
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: Adminer
Group: 2.2.1
Status: Closed
>Resolution: Fixed
Priority: 5
Private: No
Submitted By: Nobody/Anonymous (nobody)
Assigned to: Jakub Vrána (jakubvrana)
Summary: Export - fatal error 'fetch_assoc'
Initial Comment:
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 />
----------------------------------------------------------------------
>Comment By: Jakub Vrána (jakubvrana)
Date: 2009-12-11 16:42
Message:
SVN version now ignores this error.
----------------------------------------------------------------------
Comment By: Jakub Vrána (jakubvrana)
Date: 2009-11-30 10:17
Message:
Then please fix your server before export.
----------------------------------------------------------------------
Comment By: Nobody/Anonymous (nobody)
Date: 2009-11-28 17:28
Message:
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
----------------------------------------------------------------------
Comment By: Jakub Vrána (jakubvrana)
Date: 2009-11-23 10:51
Message:
Can you please report the result of following commands?
SHOW FUNCTION STATUS;
SHOW PROCEDURE STATUS;
SHOW EVENTS;
It would probably produce some error.
----------------------------------------------------------------------
Comment By: Nobody/Anonymous (nobody)
Date: 2009-11-18 15:54
Message:
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'
----------------------------------------------------------------------
Comment By: Jakub Vrána (jakubvrana)
Date: 2009-11-18 14:14
Message:
This has probably nothing to do with your change. Can you please verify
your rights? What's the output of SHOW GRANTS?
----------------------------------------------------------------------
Comment By: Nobody/Anonymous (nobody)
Date: 2009-11-18 13:51
Message:
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.
----------------------------------------------------------------------
Comment By: Jakub Vrána (jakubvrana)
Date: 2009-11-18 11:41
Message:
Please specify your MySQL version. This line exports routines and events
which are available since MySQL 5 resp. 5.1.
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=1127745&aid=2898988&group_id=264133
|