On 2014/05/09 13:43, Kleiner Werner wrote:
Hello
I have a strange problem.
On my Windows 7 XAMPP there is a little web application.
The PHP connection to SQLite DB (3.3.7) is made with PDO.
On Windows all is fine.
Now I copied complete project to a Web Hoster.
if I want to call my start page I get the error:
General error: 11 malformed database schema - near "'NOCASE'":
The table has some columns which are declared as NOCASE
I have no idea why the SQLite db works fine on Windows but not on the WebSpace?
(because it is Linux?)
Mainly, the only reason why SQLite would work any differently between one platform and the next is that it is using a different
version of the library. What version does the web app use? (Though I cant imagine it being even older than 3.3.7 which is
prehistoric by any measure - though it very definitely supported NOCASE).
Try opening another DBFile that doesn't exist yet or at any rate does not complain about the schema problem, and get the version
from it ("SELECT sqlite_version()" should work)
Also, post the entire schema here, maybe it contains a quirk that did not
matter in one version and then did in another...
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
