SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    SitePoint Member
    Join Date
    Jul 2009
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Php sqlite3 problems

    Hi,

    Here is my
    local setup:
    I am using xampp 1.7.1 , php 5.9 and have enabled pdo_sqlite.

    I wrote some php scripts which do parsing of data and create a table.
    All this works fine and has been tested on my machine locally with xampp.

    Now I wanted to move data to remote server, running on linux and php 5.2.0-8+etch15. It also has enabled pdo_sqlite.

    Now the problem is that, when ever I run the same program, I get following error
    "Call to a member function bindParam() on a non-object " but I have checked this call is done on the PDO object only. Any idea what could be the problem?

    Regards

  2. #2
    SitePoint Wizard bronze trophy
    Join Date
    Jul 2008
    Posts
    5,757
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    See http://www.php.net/manual/en/pdo.errorinfo.php

    prepare() probably failed.

  3. #3
    SitePoint Member
    Join Date
    Jul 2009
    Posts
    3
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi,

    Thanks for quick reply.

    I again tried it, after removing the small hack I had put into to circumvent the connection error.

    There is an error at the time of creating database itself.
    " unable to open database file"

    Now my question is, is it so that I donot have access writes to create a new db file?

    how can I check whether the access rights I have are sufficient?( I was given provided with an address where I need to drop my files to test, so dont really know what commands are there to check the access rights etc)

    Regards

  4. #4
    SitePoint Wizard bronze trophy
    Join Date
    Jul 2008
    Posts
    5,757
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    php needs write permission to the directory where the sqlite file will be


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •