[redland-dev] [Redland librdf RDF API 0000529]: MySql storage error on initial creation

[Mantis Bug Tracker]

The following issue has been SUBMITTED. 
====================================================================== 
http://bugs.librdf.org/mantis/view.php?id=529 
====================================================================== 
Reported By:                Olivier Berger
Assigned To:                
====================================================================== 
Project:                    Redland librdf RDF API
Issue ID:                   529
Category:                   api
Reproducibility:            have not tried
Severity:                   major
Priority:                   normal
Status:                     new
====================================================================== 
Date Submitted:             2013-02-07 13:23
Last Modified:              2013-02-07 13:23
====================================================================== 
Summary:                    MySql storage error on initial creation
Description: 
Trying to apply the example from http://blog.literarymachine.net/?p=5 (testing
the https://github.com/literarymachine/LibRDF library), I have a failure at
MySQL tables creation :

librdf_php_last_log_message() displays :
MySQL table creation failed: You have an error in your SQL syntax; check the
manual that corresponds to your MySQL server version for the right syntax to use
near 'TYPE=MyISAM DELAY_KEY_WRITE=1 MAX_ROWS=100000000 AVG_ROW_LENGTH=33' at
line 10
PHP Fatal error:  Uncaught exception 'LibRDF_Error' with message 'Unable to
create storage' in .../literarymachine/LibRDF/LibRDF/Storage.php:113
Stack trace:
#0 .../literarymachine/LibRDF/example3.php(32):
LibRDF_Storage->__construct('mysql', 'example3', 'new='yes',?    ...')
#1 {main}
  thrown in .../literarymachine/LibRDF/LibRDF/Storage.php on line 113

Unfortunately, the full MySQL query is not available to provide more details

Steps to Reproduce: 
The PHP code is :

// copied from http://blog.literarymachine.net/?p=5

require_once('LibRDF/LibRDF.php');
 
$store = new LibRDF_Storage("mysql", "whatever",
        "new='yes',
        host='localhost',
        database='test',
        user='admin',
        password='whocares'");


====================================================================== 

Issue History 
Date Modified    Username       Field                    Change               
====================================================================== 
2013-02-07 13:23 Olivier Berger New Issue                                    
======================================================================