Op 13-jul-2006, om 13:13 heeft Dave Schoorl het volgende geschreven:
L.S.
I am deploying the mmbase installation from my local machine
(mmbase version 1.8.0) to a test environment. I exported the
database and imported it in the test environment. This is my first
deployment to the test environment.
My local machine is running Windows XP with MySQL 5.0, whereas the
test environment is running Linux with MySQL 3.23. There are errors
starting the test-environment and in the log I get an jdbc-
exception that the table mm_numberTable does not exist (notice the
capital T). That is correct, since the table is named by mmbase as
'mm_numbertable' (lowercase t). The SQL generated by mmbase both on
my Windows machine as on the Linux machine use
MMBase creates a table named 'numberTable' regardless of the OS it
runs on.
capital T in the tablename (E.g. "UPDATE mm_numberTable SET number
= number + 1" and "SELECT number FROM mm_numberTable".
I believe you that the dump you have created from your Windows MySQL
installation does not include the capital 'T' since DOS is not case
sensitive. Try editing the dump by hand and import it again.
---André
--
André van Toly
MMBase development & Userfriendly webdesign
W: http://www.toly.nl
M: +31(0)627233562
------------------------------------------------------------------
~~<<>>~~
_______________________________________________
Developers mailing list
[email protected]
http://lists.mmbase.org/mailman/listinfo/developers
