Re: [sqlite] General error: 11 malformed database schema - near "'NOCASE'":

2014-05-09 Thread RSmith
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

Re: [sqlite] General error: 11 malformed database schema - near "'NOCASE'":

2014-05-09 Thread Simon Slavin
On 9 May 2014, at 1:16pm, Werner Kleiner wrote: > If I connect to this db with PHPLiteadmin it tells me "No Table in Database" > But if I connect on Windows with e.g. Sqlitestudio all is fine. I'm betting that you're not connecting to the same database file in all these methods. See if you ca

Re: [sqlite] General error: 11 malformed database schema - near "'NOCASE'":

2014-05-09 Thread Werner Kleiner
Strange thing is: If I connect to this db with PHPLiteadmin it tells me "No Table in Database" But if I connect on Windows with e.g. Sqlitestudio all is fine. ??? -- View this message in context: http://sqlite.1065341.n5.nabble.com/General-error-11-malformed-database-schema-near-NOCASE-tp7557

Re: [sqlite] General error: 11 malformed database schema - near "'NOCASE'":

2014-05-09 Thread Stephan Beal
On Fri, May 9, 2014 at 2:09 PM, Stephan Beal wrote: > On Fri, May 9, 2014 at 1:43 PM, Kleiner Werner wrote: > >> The PHP connection to SQLite DB (3.3.7) is made with PDO. >> > > It's not clear in the docs whether 3.3 has NOCASE. Perhaps it did not? 3.3 > is ancient. > > http://www.sqlite.org/rel

Re: [sqlite] General error: 11 malformed database schema - near "'NOCASE'":

2014-05-09 Thread Stephan Beal
On Fri, May 9, 2014 at 1:43 PM, Kleiner Werner wrote: > The PHP connection to SQLite DB (3.3.7) is made with PDO. > It's not clear in the docs whether 3.3 has NOCASE. Perhaps it did not? 3.3 is ancient. http://www.sqlite.org/releaselog/3_3_7.html -- - stephan beal http://wanderinghorse.ne

[sqlite] General error: 11 malformed database schema - near "'NOCASE'":

2014-05-09 Thread Kleiner Werner
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