I use Windows / sqlite / mojoportal 126.96.36.199.
It is a fresh install. I create multiple host and I tried
to add some feature to child site. When I click '>' button
I got this error. Is it my fault? I am very new with
this portal, maybe some config problem?
It sounds like a bug to me. I will try to replicate it today and will post again later.
If you are working with the source code, this is now fixed in svn trunk and it will be fixed in the next release. I would say that using the multi sites feature with SQLite may work ok if the aggregate traffic of all the sites is pretty low. For any site that is expected to handle a lot of traffic I would go with one of the other database platforms. SQLite basically has one connection whereas the other dbs all have a pool of connections which is much more suited to a multi threaded application like web apps. If you get a lot of traffic SQLite performance will probably have problems because each request must wait its turn to use the same connection to the database, so a lot of simultaneous requests will probably result in not great performance.
For sites with relatively low traffic its can be a nice choice because its easy to deploy since there is no database to install, but it also can't work in Medium Trust hosting environments, so that is something else to be aware of.
Thanks for the fix, and for detailed info about SQLITE!!
I tried the new source and I can install the second site.
(I copied the sqlite3.dll to Web/Bin folder, without
this I got error.)