[jboss-user] [JBoss Portal] - Re: SQLGrammarException in JBP 2.4

[danny_hon]

I dropped and recreated the database when I tried it.  I just did it again, recreated the database, deleted the data, tmp, work, and log directories in the domain.  When I started the server, it created some of the old tables, but not the new ones.  Here are the tables that it created.

mysql> show tables;
+-------------------------------+
| Tables_in_jbptest             |
+-------------------------------+
| jbp_cms_cmsentry              |
| jbp_cms_repositoryentry       |
| jbp_cms_version_binval        |
| jbp_cms_version_node          |
| jbp_cms_version_prop          |
| jbp_cms_version_refs          |
| jbp_cms_versionentry          |
| jbp_cms_wsp_binval            |
| jbp_cms_wsp_node              |
| jbp_cms_wsp_prop              |
| jbp_cms_wsp_refs              |
| jbp_context                   |
| jbp_instance                  |
| jbp_instance_security         |
| jbp_instance_security_actions |
| jbp_object_node               |
| jbp_object_node_sec           |
| jbp_object_node_sec_actions   |
| jbp_page                      |
| jbp_portal                    |
| jbp_portal_mode               |
| jbp_portal_object             |
| jbp_portal_object_props       |
| jbp_portal_window_state       |
| jbp_portlet_state             |
| jbp_portlet_state_entry       |
| jbp_portlet_state_entry_value |
| jbp_role_membership           |
| jbp_roles                     |
| jbp_user_prop                 |
| jbp_users                     |
| jbp_window                    |
+-------------------------------+
32 rows in set (0.00 sec)

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3963852#3963852

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3963852