Hi,
At this moment we have 3 websites in one webapplication with MMBase.
Because one of this website goes to another CMS we want to give all this
sites their own web application. So I make 2 copies of the exciting
webaplpication; add them in tomcat and modified the links in the jsp
files.
We also made copies of the database so each webapplication has his own
database.
We changed this in jdbc.xml; But the other settings and builders are the
same.
When I test this on my developing machine everything works fine (mysql
5, windows, tomcat 5.5.12) but on the production servers (linux, apache
5.5.12, mysql 4.1) is gives this error and it seems that he don't get
any data from the database:
2006-12-15 14:21:54,809 ERROR org.mmbase.module.Module -
startModules(): module([EMAIL PROTECTED]) not found to
'init'!: class org.mmbase.storage.StorageException: Table 'mm_object'
already exists in query:CREATE TABLE mm_object (number integer NOT NULL,
PRIMARY KEY (number), otype integer, INDEX otype (otype), owner
varchar(12) NOT NULL )
2006-12-15 14:21:54,811 ERROR org.mmbase.module.Module -
org.mmbase.storage.StorageException: Table 'mm_object' already exists in
query:CREATE TABLE mm_object (number integer NOT NULL, PRIMARY KEY
(number), otype integer, INDEX otype (otype), owner varchar(12) NOT NULL
)
at
org.mmbase.storage.implementation.database.DatabaseStorageManager.create
Table(DatabaseStorageManager.java:1949)
at
org.mmbase.storage.implementation.database.DatabaseStorageManager.create
(DatabaseStorageManager.java:1846)
at
org.mmbase.storage.implementation.database.DatabaseStorageManager.create
(DatabaseStorageManager.java:2084)
at org.mmbase.module.core.MMBase.createMMBase(MMBase.java:487)
at org.mmbase.module.core.MMBase.init(MMBase.java:369)
at org.mmbase.module.Module.startModule(Module.java:125)
at org.mmbase.module.core.MMBase.getMMBase(MMBase.java:587)
at org.mmbase.module.RemoteMMCI.getHost(RemoteMMCI.java:92)
at org.mmbase.module.RemoteMMCI.init(RemoteMMCI.java:61)
at org.mmbase.module.Module.startModule(Module.java:125)
at org.mmbase.module.Module.startModules(Module.java:334)
at org.mmbase.module.Module.getModule(Module.java:385)
at org.mmbase.module.Module.getModule(Module.java:359)
at org.mmbase.module.core.MMBase.getMMBase(MMBase.java:583)
at
org.mmbase.servlet.MMBaseStartThread.run(MMBaseStartThread.java:40)java.
sql.SQLException: Table 'mm_object' already exists
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2926)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1571)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1666)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2972)
at com.mysql.jdbc.Connection.execSQL(Connection.java:2902)
at com.mysql.jdbc.Statement.executeUpdate(Statement.java:929)
at
org.mmbase.module.database.MultiStatement.executeUpdate(MultiStatement.j
ava:57)
at
org.mmbase.storage.implementation.database.DatabaseStorageManager.create
Table(DatabaseStorageManager.java:1936)
at
org.mmbase.storage.implementation.database.DatabaseStorageManager.create
(DatabaseStorageManager.java:1846)
at
org.mmbase.storage.implementation.database.DatabaseStorageManager.create
(DatabaseStorageManager.java:2084)
at org.mmbase.module.core.MMBase.createMMBase(MMBase.java:487)
at org.mmbase.module.core.MMBase.init(MMBase.java:369)
at org.mmbase.module.Module.startModule(Module.java:125)
at org.mmbase.module.core.MMBase.getMMBase(MMBase.java:587)
at org.mmbase.module.RemoteMMCI.getHost(RemoteMMCI.java:92)
at org.mmbase.module.RemoteMMCI.init(RemoteMMCI.java:61)
at org.mmbase.module.Module.startModule(Module.java:125)
at org.mmbase.module.Module.startModules(Module.java:334)
at org.mmbase.module.Module.getModule(Module.java:385)
at org.mmbase.module.Module.getModule(Module.java:359)
at org.mmbase.module.core.MMBase.getMMBase(MMBase.java:583)
at
org.mmbase.servlet.MMBaseStartThread.run(MMBaseStartThread.java:40)
Does anybody know why?
Greets Dave
--------------------------------------------------------------------------------
The information contained in this communication is confidential and may be
legally privileged. It is intended solely for the use of the individual or
entity to whom it is addressed and others authorised to receive it. If you are
not the intended recipient you are hereby notified that any disclosure,
copying, distribution or taking any action in relation to the contents of this
information is strictly prohibited and may be unlawful. Neither the sender nor
the represented institution are liable for the correct and complete
transmission of the contents of an e-mail, or for its timely receipt.
_______________________________________________
Users mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/users
