#75 ADOdb XML Schemas don’t work

[Laurens Holst]

Hey,

The ADOdb XML Schemas don’t work. I think they might never have worked, or at least they did not work in version 1.20 either, and I just updated to the latest version and they still don’t work. I’ve created my own class which creates a database based on the XML, but I’d prefer to use the builtin functionality which (as I understand it) has the ability to modify existing tables.

The schema that I can’t apply is attached. It ends with the following error:

<b>Fatal error</b>: Call to undefined method mysql_driver_ADOConnection::MetaIndexes() in <b>C:\Development\Projects\Forum\scripts\adodb_lite\adodb-datadict.inc.php</b> on line <b>270</b><br />

And no, I did not forget to include the pear module :)

~Grauw

[Laurens Holst]

AXMLS example file

[Laurens Holst]

Logged In: YES
user_id=798154
Originator: YES

Sorry, the error above is accidentally from when I tested it without the pear module :). This is the actual error:

<b>Fatal error</b>: Call to undefined method pear_ADOConnection::MetaIndexes() in <b>C:\Development\Projects\Forum\scripts\adodb_lite\adodb-datadict.inc.php</b> on line <b>270</b><br />

~Grauw

[Mark Dickenson]

Logged In: YES
user_id=752816
Originator: NO

Are you including the new META module? All meta functions are now included in the meta module.

[Laurens Holst]

Logged In: YES
user_id=798154
Originator: YES

You’re right. When I do that, I get the following error which is more familiar (that is, I did see it in the previous versions as well):

<b>Fatal error</b>: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1146: Table 'forum.entries' doesn't exist] in EXECUTE(&quot;SHOW INDEX FROM entries&quot;)
' in C:\Development\Projects\Forum\scripts\adodb_lite\adodb-exceptions.inc.php:84
Stack trace:
#0 C:\Development\Projects\Forum\scripts\adodb_lite\adodbSQL_drivers\mysql\mysql_driver.inc(369): adodb_throw('mysql', 'EXECUTE', 1146, 'Table 'forum.en...', 'SHOW INDEX FROM...', false, Object(pear_ADOConnection))
#1 C:\Development\Projects\Forum\scripts\adodb_lite\adodb.inc.php(316): mysql_driver_ADOConnection-&gt;do_query('SHOW INDEX FROM...', -1, -1, false)
#2 C:\Development\Projects\Forum\scripts\adodb_lite\adodbSQL_drivers\mysql\mysql_meta_module.inc(326): ADOConnection-&gt;Execute('SHOW INDEX FROM...')
#3 C:\Development\Projects\Forum\scripts\adodb_lite\adodb-datadict.inc.php(270): mysql_meta_ADOConnection-&gt;MetaIndexes('entries', false, false)
#4 C:\Development\Projects\Forum\scripts\adodb_lite\adodb-xmlschema.inc.php(467): ADODB_DataDict-&gt;MetaIndexes('entries')
#5 C:\Dev in <b>C:\Development\Projects\Forum\scripts\adodb_lite\adodb-exceptions.inc.php</b> on line <b>84</b><br />

~Grauw

p.s. the example at the bottom of http://adodblite.sourceforge.net/datadictionary.php only includes the pear library.