[sqlite] sqlite3_get_table
In previous versions (<=3.4.10) I use to do if (errmsg) { free(errmsg) ; } without problem. In 3.5.6 the free() will segfault (yes, even after if) with a "invalid pointer" message. It's my old understanding that sqlite3_get_table (previously sqlite_get_table) will malloc for *errmsg and I'll need to do the free(). Has anything changed? I'm just recompiling old codes with the new lib. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Japanese-Korean characters
The only restriction is to escape \0. I've been storing GB2312, BIG5 and UTF8 Chinese characters since 2.x versions without any problem. Japanese/korean characters should be OK.
Re: [sqlite] sqlite3 error in kexi-0.1beta5
>> kexi: btree.c:1043: sqlite3BtreeOpen: Assertion >> `sizeof(ptr)==sizeof(char*)' failed. KCrash: Application 'kexi' crashing... >See also: >http://www.mail-archive.com/sqlite-users%40sqlite.org/msg04718.html >http://bugs.kde.org/show_bug.cgi?id=92563 Can't understand why that is a bug as sqlite3 itself can run without problem. Probably that's because kexi share the config.h file with 3rdparty software. I got it solved by renaming my own copy of libsqlite3.so as libkexisql3.so and do a make install.
Re: [sqlite] sqlite.so for php 4
>can anyone send me sqlite.so for php 4, i can't see http://www.mail-archive.com/sqlite-users@sqlite.org/msg01393.html
[sqlite] sqlite3 error in kexi-0.1beta5
I got this. kexi: btree.c:1043: sqlite3BtreeOpen: Assertion `sizeof(ptr)==sizeof(char*)' failed. KCrash: Application 'kexi' crashing... Can't figure out at this moment as I still work use 2.8.12 in production.
[sqlite] bug in time() ?
I think the time() function is not reporting the correct time. The date part is OK. I also note that CVSTrac uses C codes to handle datetime i.e. not relying on sqlite. Is there a bug? Some investigation ... bash-2.05b$ date Wed Mar 31 11:12:03 HKT 2004 bash-2.05b$ sqlite SQLite version 2.8.12 Enter ".help" for instructions sqlite> SELECT strftime('%s','now'); 1080701286 sqlite> select datetime(1080701286,'unixepoch'); 2004-03-31 02:48:06 sqlite> select datetime(1080701286,'localtime'); 2954147-07-10 19:59:59 sqlite> select datetime('now'); 2004-03-31 02:49:07 - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
Re: [sqlite] phpSQLiteAdmin
Lay AndrÃs <[EMAIL PROTECTED]> >Anybody use phpSQLiteAdmin? >(http://www.phpguru.org/phpSQLiteAdmin.html) >Because it don't works for me, no error, only it >redirects to a login.php?SessionID=..., and nothing. Have you tried SQLiteManager http://sqlitemanager.sourceforge.net/ ? It's extremely simply to install. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
[sqlite] Re: PHP extention (or sqlite.so)
I have placed a copy of sqlite.so (php 4.2.2 + sqlite 2.8.12) at http://home.graffiti.net/kenlo/sqlite.so Simply placed it in /usr/lib/php4 and load it with dl('sqlite.so') or via php.ini as usual. Compiling sqlite.so for php < 4.3.3 is a bit tricky because of some changes in config.m4 (I believe). Here are the steps to get it compiled. 1. Get SQLite-1.0.2 or later from pecl.php.net 2. Get sqlite-php from http://sourceforge.net/projects/sqlite-php/ 3. Copy config.m4 and Makefile.in from this package to the SQLite-1.0.2 directory 4. run phpize 5. run ./configure --with-sqlite=shared 6. run make 7. that's it Of course you must have the latest sqlite compiled and installed first. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]