[Tickets #5031] agora.mysql.sql script has errors (mysql 5.0)

[bugs@bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/?id=5031
-----------------------------------------------------------------------
 Ticket             | 5031
 Created By         | nilskaiser at gmx.net
 Summary            | agora.mysql.sql script has errors (mysql 5.0)
 Queue              | Agora
 Type               | Bug
 State              | Unconfirmed
 Priority           | 1. Low
 Owners             | 
-----------------------------------------------------------------------


nilskaiser at gmx.net (2007-02-24 08:00) wrote:

Running the agora.mysql.sql scripts gives me the following errors:

mysql> source agora.mysql.sql
Query OK, 0 rows affected (0.02 sec)

Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

Query OK, 0 rows affected (0.00 sec)

Query OK, 0 rows affected (0.01 sec)
Records: 0  Duplicates: 0  Warnings: 0

ERROR 1064 (42000): 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
'CREAT
E INDEX agora_messages_forum_id ON agora_messages (forum_id)' at line 21
ERROR 1146 (42S02): Table 'horde.agora_messages' doesn't exist
ERROR 1146 (42S02): Table 'horde.agora_messages' doesn't exist
Query OK, 0 rows affected (0.00 sec)

However the agora.sql scripts runs fine. The mysql file looks different
than the  mysql scripts of different horde apps. Maybe it was just wrongly
renamed?