Jahia Install Forum > Error on startup...

0 (0 Good)
0 (0 Bad)

Error on startup (MySQLSyntaxErrorException: Table 'jahia.jr_v_bundle' doesn't exist)

by  chris »  2012/02/10 16:00

Hello,

we receive the following error on the first startup after successful installation on a linux system:

2012-02-10 16:18:44,411: ERROR [main] ConnectionHelper$RetryManager, org.apache.jackrabbit.core.util.db.ConnectionHelper: Failed to execute SQL (stacktrace on DEBUG log level)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'jahia.jr_v_bundle' doesn't exist
        at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
        at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
        at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
        at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
        at com.mysql.jdbc.Util.handleNewInstance(Util.java:407)
        at com.mysql.jdbc.Util.getInstance(Util.java:382)
        at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3603)
        at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3535)
        at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1989)
        at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2150)
        at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2626)
        at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2119)
        at com.mysql.jdbc.PreparedStatement.execute(PreparedStatement.java:1362)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at org.apache.commons.dbcp.DelegatingPreparedStatement.execute(DelegatingPreparedStatement.java:172)
        at org.apache.jackrabbit.core.util.db.ConnectionHelper.execute(ConnectionHelper.java:438)
        at org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:359)
        at org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:339)
        at org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:335)
....

The installation script created several tables (around 30 tables). The database is mysql 5. For installation we used the Jahia_xCM_v6.5.1.0_r39069.jar.

Thanks for your help.

 

Greetings from Germany,

Chris

  (chris)

Number of messages  5
Registration date
0 (0 Good)
0 (0 Bad)

Re: Error on startup (MySQLSyntaxErrorException: Table 'jahia.jr_v_bundle' doesn't exist)

by  shyrkov »  2012/02/10 16:20

Hello Chris,

there seems to be a problem creating tables. Default Jahia installation has around 50 of them.

Could you check our installation log file? It should be in the <install-path>/logs/install.log

By any chance could you provide the following data:

1) <install-path>/logs/install.log

2) <install-path>/logs/install.properties

?

 

Kind regards

Sergiy

  • Re: Error on startup (MySQLSyntaxErrorException: Table 'jahia.jr_v_bundle' doesn't exist)
    2012/02/10 16:20

    shyrkov <p> Hello Chris,</p> <p> there seems to be a problem creating tables. Default Jahia installation has around 50 of them.</p> <p> Could you check our installation log file? It should be in the &lt;install-path&gt;/logs/install.log</p> <p> By any chance could you provide the following data:</p> <p> 1) &lt;install-path&gt;/logs/install.log</p> <p> 2) &lt;install-path&gt;/logs/install.properties</p> <p> ?</p> <p> &nbsp;</p> <p> Kind regards</p> <p> Sergiy</p>

  • Number of messages  407
    Registration date Feb 10, 2012
    0 (0 Good)
    0 (0 Bad)

    Re: Re: Error on startup (MySQLSyntaxErrorException: Table 'jahia.jr_v_bundle' doesn't exist)

    by  chris »  2012/02/13 11:00

    Hello Sergiy,

     

    thank you for your fast response and help.

    We solved the problem. The problem was a lack of rights for the existing database user jahia therefore the user was not able to execute all sql command from the install script.

    Kind regards,

    Chris

     

      (chris)

    Number of messages  5
    Registration date
    Contact
    Share
    Feedback

    Get in touch

    Whether you are a current user or if you are just evaluating Jahia, we are here to help.

    Contact us

    Share this page