[opencms-dev] weird error in opencms

[M Butcher]

That's odd... all of my tables were created in upper case (I'm running
RH 8.0 with mysql 3.23, JDK 1.4.1 ant tomcat 4.1.27).

Were all of the tables created in lowercase ('show tables')?

Matt

On Fri, 2003-09-12 at 15:39, Marius Popa Adrian wrote:
> On Fri, 12 Sep 2003 23:49:03 +0300
> Marius Popa Adrian <mapopa at reea.net> wrote:
> 
> > opencms5.0+(jdk1.4.2),redhat9,mysql,(tomcat 4.1.27)
> > 
> > if i open the mysql console (with the same user) the table exists in the database ocmstest 
> > 
> > select * from cms_systemid;
> > +------------------------+------+
> > | TABLE_KEY              | ID   |
> > +------------------------+------+
> > | CMS_GROUPS             |   61 |
> > | CMS_USERS              |   51 |
> > | CMS_TASKPAR            |   11 |
> > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> > 
> > com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error: Database init failed. 
> > root cause was com.opencms.core.CmsException: 33 Resourcebroker-init error. Detailed error: Critical error while loading resourcebroker. 
> > root cause was com.opencms.core.CmsException: 4 Sql exception. Detailed error: [com.opencms.dbpool.CmsIdGenerator]General error: Table 'ocmstest.CMS_SYSTEMID' doesn't exist. 
> > root cause was java.sql.SQLException: General error: Table 'ocmstest.CMS_SYSTEMID' doesn't exist
> 
> If run this query from the mysql (table name in uppercase)
> select * from CMS_SYSTEMID;
> ERROR 1146: Table 'ocmstest.CMS_SYSTEMID' doesn't exist 
> So it seems the query is case sensitive (This is why it throws the exception)
> 
> Any patches for linux?
> 
> _______________________________________________
> This mail is send to you from the opencms-dev mailing list
> To change your list options, or to unsubscribe from the list, please visit
> http://mail.opencms.org/mailman/listinfo/opencms-dev
-- 
M Butcher <mbutcher at grcomputing.net>