DOWNLOAD DEMO
Current Version: 2.4.0.4 2014-07-18
Need a hand? Join the community.

SQLite error: no such column: SiteGuid

This thread is closed to new posts. You must sign in to post in the forums.
3/27/2009 4:57:26 PM
Gravatar
Total Posts 3

SQLite error: no such column: SiteGuid

Hello,

I use Windows / sqlite / mojoportal 2.2.9.6.
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?

Regards,
Zoltan

3/28/2009 8:01:53 AM
Gravatar
Total Posts 17901

Re: SQLite error: no such column: SiteGuid

Hi,

It sounds like a bug to me. I will try to replicate it today and will post again later.

Best,

Joe 

3/28/2009 11:02:56 AM
Gravatar
Total Posts 17901

Re: SQLite error: no such column: SiteGuid

Hi,

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.

Best,

Joe

3/28/2009 1:01:32 PM
Gravatar
Total Posts 3

Re: SQLite error: no such column: SiteGuid

Hi,

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.)

Best Regards,
Zoltan
 

You must sign in to post in the forums. This thread is closed to new posts.

mojoPortal Hosting Made Easy

Monetize Your Site With Site Membership Pro!

Go Mobile with mojoPortal and Mobile Kit Pro!