Package home | Report new bug | New search | Development Roadmap Status: Open | Feedback | All | Closed Since Version 0.8.6
Bug #6416 dumpDatabase() and CURRENT_TIMESTAMP
Submitted: 2006-01-05 11:27 UTC
From: tvvcox at ossim dot net Assigned: lsmith
Status: Closed Package: MDB2_Schema
PHP Version: 5.0.4 OS:
Roadmaps: (Not assigned)    
Subscription  
Comments Add Comment Add patch


Anyone can comment on a bug. Have a simpler test case? Does it work for you on a different platform? Let us know! Just going to say 'Me too!'? Don't clutter the database with that please !
Your email address:
MUST BE VALID
Solve the problem : 35 + 22 = ?

 
 [2006-01-05 11:27 UTC] tvvcox at ossim dot net
Description: ------------ Dump and load fails on columns with DEFAULT CURRENT_TIMESTAMP (note. this is a need for timestamp columns in MySQL http://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html) Test script: --------------- <?php /* CREATE TABLE foo ( mytime timestamp DEFAULT CURRENT_TIMESTAMP ); */ ini_set('include_path', dirname(__FILE__) . '/include'); require_once 'MDB2/Schema.php'; $dsn = 'mysql://root@localhost/test'; $tmp_file = './test.xml'; $schema =& MDB2_Schema::factory($dsn); $conf = array('output_mode' => 'file', 'output' => $tmp_file); // write the xml schema $schema->dumpDatabase($conf, MDB2_SCHEMA_DUMP_STRUCTURE); // try to load the schema $ret = $schema->parseDatabaseDefinitionFile($tmp_file); if (PEAR::isError($ret)) die($ret->getUserInfo()); ?> Actual result: -------------- Parser error: "CURRENT_TIMESTAMP" is not of type "timestamp" - No error - Byte: 246; Line: 18; Col: 9

Comments

 [2006-01-05 12:15 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!
 [2006-03-21 09:43 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!
 [2006-03-23 13:25 UTC] User who submitted this comment has not confirmed identity
If you submitted this note, check your email.If you do not have a message, click here to re-send
MANUAL CONFIRMATION IS NOT POSSIBLE.  Write a message to pear-dev@lists.php.net
to request the confirmation link.  All bugs/comments/patches associated with this

email address will be deleted within 48 hours if the account request is not confirmed!