I followed the jboss portal rc-1 installation instruction to configure the mysql db (4.1.11), but got these errors:
mysql> source setup.ddl; ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syn tax to use near 'constraint FKF606014114931AFE' at line 1 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syn tax to use near 'constraint FKF410173894E6A686' at line 1 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syn tax to use near 'constraint FKF410173894E6B1C9' at line 1 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syn tax to use near 'constraint FK93CC44D0C691B5FF' at line 1 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syn tax to use near 'constraint FK97AA4873FAF7DF89' at line 1 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syn tax to use near 'constraint FKC496306482E27870' at line 1 ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syn tax to use near 'constraint FK93CC461094E6B1C9' at line 1 Query OK, 0 rows affected, 1 warning (0.02 sec) Query OK, 0 rows affected, 1 warning (0.00 sec) Query OK, 0 rows affected, 1 warning (0.00 sec) Query OK, 0 rows affected, 1 warning (0.00 sec) Query OK, 0 rows affected, 1 warning (0.00 sec) Query OK, 0 rows affected, 1 warning (0.00 sec) Query OK, 0 rows affected, 1 warning (0.00 sec) Query OK, 0 rows affected (0.14 sec) Query OK, 0 rows affected (0.09 sec) Query OK, 0 rows affected (0.09 sec) Query OK, 0 rows affected (0.06 sec) Query OK, 0 rows affected (0.06 sec) Query OK, 0 rows affected (0.05 sec) Query OK, 0 rows affected (0.09 sec) Query OK, 0 rows affected (0.23 sec) Records: 0 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.14 sec) Records: 0 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.14 sec) Records: 0 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.13 sec) Records: 0 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.14 sec) Records: 0 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.14 sec) Records: 0 Duplicates: 0 Warnings: 0 Query OK, 0 rows affected (0.14 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> select version(); +-----------+ | version() | +-----------+ | 4.1.11-nt | +-----------+ 1 row in set (0.00 sec) mysql> show tables; +--------------------------+ | Tables_in_jbossportal | +--------------------------+ | jbp_role_membership | | jbp_roles | | jbp_user_pref | | jbp_user_pref_prop_value | | jbp_user_pref_set | | jbp_user_prop | | jbp_users | +--------------------------+ 7 rows in set (0.00 sec) View the original post : http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3877125#3877125 Reply to the post : http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3877125 ------------------------------------------------------- This SF.Net email is sponsored by Oracle Space Sweepstakes Want to be the first software developer in space? Enter now for the Oracle Space Sweepstakes! http://ads.osdn.com/?ad_id=7393&alloc_id=16281&op=click _______________________________________________ JBoss-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/jboss-user
