thanks for your interest!
> Has any one of you installed tikiwiki with sqlite 2.8.15 or wahtever
> version you have under windows server 2003 ?
That's a not very common setup.. I guess, that not many have done that and the
procentual count may even be lower on this mailinglist.
> I think that if don't make some shanges into the tiki-1.9-sqlite.sql
> tiki wiki will never run.
Yup, most probably very true..!
> The maijor problem is that the bigserial column type.
> well I made some fixes into that file when downloaded 1.8.2 , and
> thought that you will fix that problem when 1.9.X release is
As mentioned above: since only a few use that, it's not very likely - without
help at least....
> Also as you know you use the sql command "SHOW TABLES" when make
> backup. But that sql commant returs an error when execute it under
> sqlite database. GUESS WHY IT DOES NOT WORK ? :-) ".tables" must be
> used instead.
Yup, such 'little' things break database-compatibility. :-/
> My question is are you manae to have REAL SQLite support or not ? And
> if you want I can send you my fixed tiki-1.8.2-sqlite.sql file.
Yes, we want to be compatible with everything - world domination doesn't come
from no nothing. ;)
To make the process of generating that script a little clearer to you:
We have one "master-script" made for MySQL, which gets transformed to
PostgreSQL, Oracle, SQLite etc. by a very well (usabilitywise) designed
co-operation of several scripts.
For your case of SQLite it is in
if you have a CVS-checkout! It's not included in the standard distribution.
This PHP-script handles all the conversion from MySQL-syntax to SQLite. The
developers only take care of the MySQL-file. That's great and that's the way
it's gonna stay!
What can be done: Improve that script!!
We could really need help in improving and debugging that!
Would you be up to help with such a task?
> Have a NICE day
Thanks a lot, you too! :)