[FLOW3-general] Issues with MySQL Connectivity

[Karsten Dambekalns]

Hi.

On 20.11.09 12:26, Muneender Jillella [MUL] wrote:
> #1: Notice: Undefined index: nodetypenamespace ...
 ...
> I think, TYPO3CR is expecting some predefined master data which is not available in the ' TYPO3CR_schema.sql ' file. 

Yes, it needs some more stuff. Should probably go into the file as well.
Should be taken care of by the setup mentioned in my earlier mail. Did
you try that?

You can also check out TYPO3CR_testdata.sql in Tests/Unit/Fixtures - but
make sure to change the UUID contained there to something that deserves
to contain "unique" in it's name!

> Does flow3 officially support MySQL database?. Because when I run script in ' TYPO3CR_schema.sql ',  I got some syntax errors . However I solved those errors and created the tables successfully.

Yes, we support it, unit tests check it works. Setup is a little harder,
though. :)

The "problem" with the file is that it uses ANSI SQL, thus you need to
switch that on in MySQL prior to using that file. At the same time it
contains lenght specifiers for the keys, which are only valid in MySQL
(and thus get filtered in StorageHelper for other DBs).

Ah, the lovely world of database compatibility...

Regards,
Karsten

PS: http://www.netmeister.org/news/learn2quote.html