6.0.0-beta1
8/7/25

[#5031] agora.mysql.sql script has errors (mysql 5.0)
Summary agora.mysql.sql script has errors (mysql 5.0)
Queue Agora
Type Bug
State Resolved
Priority 1. Low
Owners
Requester nilskaiser (at) gmx (dot) net
Created 02/24/2007 (6739 days ago)
Due
Updated 02/24/2007 (6739 days ago)
Assigned
Resolved 02/24/2007 (6739 days ago)
Github Issue Link
Github Pull Request
Milestone
Patch No

History
02/24/2007 09:57:26 PM Chuck Hagenbuch Comment #2
State ⇒ Resolved
Reply to this comment
Fixed in CVS (missing comma at the end of the agora_messages table 
definition).
02/24/2007 04:00:58 PM nilskaiser (at) gmx (dot) net Comment #1
State ⇒ Unconfirmed
Priority ⇒ 1. Low
Type ⇒ Bug
Summary ⇒ agora.mysql.sql script has errors (mysql 5.0)
Queue ⇒ Agora
Reply to this comment
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?

Saved Queries