#46212 [Opn->Csd]: SQLite3::exec() with a valid CREATE TABLE fails

From:	scottmac@php.net	Date:	Thu, 23 Oct 2008 08:34:13 +0000
Subject:	#46212 [Opn->Csd]: SQLite3::exec() with a valid CREATE TABLE fails
References:	1	Groups:	php.bugs
Request:	Send a blank email to php-bugs+get-129995@lists.php.net to get a copy of this message

 ID:               46212
 Updated by:       scottmac@php.net
 Reported By:      kristof dot coomans at telenet dot be
-Status:           Open
+Status:           Closed
 Bug Type:         SQLite related
 Operating System: Windows XP
 PHP Version:      5.3CVS-2008-10-01 (snap)
 Assigned To:      scottmac


Previous Comments:
------------------------------------------------------------------------

[2008-10-23 07:59:51] kristof dot coomans at telenet dot be

Yes, it works again as expected with the last snapshot I downloaded.
Thanks!

------------------------------------------------------------------------

[2008-10-20 23:58:36] scottmac@php.net

Can you try a 5.3 snapshot from http://windows.php.net/snapshots/

I think this could be optimisation related and recently fixed.

------------------------------------------------------------------------

[2008-10-01 16:25:40] kristof dot coomans at telenet dot be

Yes, the user has permission to read & write to the directory & file.

------------------------------------------------------------------------

[2008-10-01 15:58:12] scottmac@php.net

Does the user you're running the script as have permission to write the
database file and the directory the script is in?

That's usually the reason for this sort of error.

------------------------------------------------------------------------

[2008-10-01 15:56:11] scottmac@php.net

This works on Linux and Mac but not Windows.

------------------------------------------------------------------------

The remainder of the comments for this report are too long. To view
the rest of the comments, please view the bug report online at
    http://bugs.php.net/46212

-- 
Edit this bug report at http://bugs.php.net/?id=46212&edit=1



   

Thread (7 messages)

• kristof dot coomans at telenet dot beWed, 01 Oct 2008 15:37:09 +0000
  • scottmac@php.netWed, 01 Oct 2008 15:56:12 +0000#46212 [Opn->Asn]: SQLite3::exec() with a valid CREATE TABLE fails
  • scottmac@php.netWed, 01 Oct 2008 15:58:13 +0000#46212 [Asn]: SQLite3::exec() with a valid CREATE TABLE fails
  • kristof dot coomans at telenet dot beWed, 01 Oct 2008 16:25:40 +0000#46212 [Asn]: SQLite3::exec() with a valid CREATE TABLE fails
  • scottmac@php.netMon, 20 Oct 2008 23:58:37 +0000#46212 [Asn->Fbk]: SQLite3::exec() with a valid CREATE TABLE fails
  • kristof dot coomans at telenet dot beThu, 23 Oct 2008 07:59:52 +0000#46212 [Fbk->Opn]: SQLite3::exec() with a valid CREATE TABLE fails
  • scottmac@php.netThu, 23 Oct 2008 08:34:13 +0000#46212 [Opn->Csd]: SQLite3::exec() with a valid CREATE TABLE fails