Roy thanks for responding. I did change the strict mode as the wiki said: | 1. If you have MySQL 5 installed already and running in strict mode, edit the my.ini (or my.cfg) file of MySQL and remove the "STRICT_TRANS_TABLES" part from the line: sql-mode=STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | 2. Add "jdbcCompliantTruncation=false" in your datasource descriptor file (*-ds.xml) under the deploy directory. Your connection URL should look like: <connection-url>jdbc:mysql://your-host-name:3306/jbossportal?useServerPrepStmts=false&jdbcCompliantTruncation=false</connection-url> | Although looking at it now it seems the NO_AUTO_CREATE_USER setting would be the reason I was not able to login as admin as the admin could not be created automaticly. comments? So I do have the my.ini configured as described for the truncation issue. Does anyone know why I'm getting: | Table 'jbossportal.jbp_instance_per_user' doesn't exist | Thanks in advance, Andrew View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3967916#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...