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

2006-08-08 Thread danny_hon
I made the changes you recommended. I can now login to the portal. Thank you. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3963883#3963883 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3963883 ___

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

2006-08-08 Thread [EMAIL PROTECTED]
Mysql allow 1024 key lengths, but since were in UTF8 db setting, its using bytes per... so 255*3 + 255*3 > 1024. One workaround Im looking at, is to modify the hibernate cfg: | | | | | instance_seq | | | |

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

2006-08-08 Thread danny_hon
I found these in the log file: 2006-08-08 11:14:02,518 ERROR [org.hibernate.tool.hbm2ddl.SchemaExport] Unsuccessful: create table JBP_INSTANCE_PER_USER (PK bigint not null auto_increment, INSTANCE_PK bigint, SER_STATE longblob, USER_ID varchar(255) not null, PORTLET_REF varchar(255) not null, p

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

2006-08-08 Thread [EMAIL PROTECTED]
Strange. You should have 33 tables, so youre only missing the jbp_instance_per_user table. I'll check with HEAD and mysql4. View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3963856#3963856 Reply to the post : http://www.jboss.com/index.html?module=bb&op=post

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

2006-08-08 Thread 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> s

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

2006-08-08 Thread [EMAIL PROTECTED]
Yes, this is a new table. There should be several new ones. You said you used a new server instance... are you using the same database from a previous version? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3963840#3963840 Reply to the post : http://www.jbos

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

2006-08-07 Thread danny_hon
Yes, it was a brand new server instance (duplicated from default). The problem happens when I tried to login. Looks like it is looking for tables that do not exist. 08:03:01,515 ERROR [JDBCExceptionReporter] Table 'jbptest.jbp_instance_per_user' doesn't exist Is this a new table in RC3? Vie

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

2006-08-04 Thread [EMAIL PROTECTED]
Did you remove your data directory before running the latest version of the code? View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3963330#3963330 Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3963330