[FLOW3-general] Notice: Undefined index: identifier

[Karsten Dambekalns]

Hi.

On 27.01.10 17:13, Georg Ortner wrote:
> 1) First off all with the configuration above you will get an
> "SQLSTATE[HY000] [2002] Invalid argument" Exception from PdoBackend. We
> need to specify also a host. E.g.:

That depends on your PHP setup. The lines I posted work for me, probably
because I have configured pdo_mysql.default_socket to
/opt/local/var/run/mysql5/mysqld.sock.

> 2) Now before this can work you need to create the tables. Therefor you
> can use
> Packages/Framework/FLOW3/Resources/Private/Persistance/SQL/DDL.sql. But
> if you want to feed mysql directly (without PDO in between) you need to
> change a little bit of the syntax.

The easier way is to issue this command before creating the tables:
 SET SESSION sql_mode='ANSI';
That makes MySQL understand the correct syntax we use :) You can also
make that the default for your server.

> throw an exception because apparently the index on line 36 in DDL.sql is
> too long for mysql.

Yes, the behaviour of MySQL is broken (IMHO). That will be solved with
an upcoming setup/install tool which then adds length limits to the
created index.

> 3) Now you need to define an encryptionKey for the security package. But
> be warned if you change that in your global configuration it won't work
> because in Framework/FLOW3/Configuration/Settings.yaml it is set to an
> empty string and your global setting will be owned. (Shall I open an
> issue for that?)

Yes, please. That shouldn't be the case. Include your relevant
configuration parts with the report, thanks.

Regards,
Karsten