WordPress4SQLite – alpha one

The project finally see some light. It comes to a prematured state where it is working smoothely, but with lack of some features. I have to go thru every piece of code where SQL statements are present and I make them SQLite compatible. The project is not finished, Category and Image upload is not working properly but I will complete them next week. I have been suddenly bz in another official project which I have to complete within next 5 days, so I may not be able to contribute before next week. But I am extremely confident that I can solve those problems.

You can download this prematured version of WordPress4SQLite from the following link and just after modifying the config file as usually, you can proceed.

Please note that error reporting has been turned off just to save you from some annoyances :D. If want to turn error reporting on, open wp-includes/wp-db.php and remove the error_reporting() function.

There is a sample config.php file present already. You can modify it to kickstart using WordPress4SQLite. Please use absolute path for database file.

Download From Here : WordPress4SQLite

You can see a running version of WordPress4SQLite here

About these ads

22 thoughts on “WordPress4SQLite – alpha one

  1. Nice work, this will rock my NSLU2 with thttpd and sqlite!

    I tried, but i got an error:
    Your PHP installation appears to be missing the MySQL which is required for WordPress.

    Something i’m missing out?

  2. I am getting the same error as b-ill

    “Your PHP installation appears to be missing the MySQL which is required for WordPress.”

    maybe a new post on this could help :)

  3. Hi, I am sorry I didnt comment out a MySQLI check in default wordpress code. That code just check if mysql extension is loaded or not. To solve this problem you can open wp-settings.php in the root directory and go directly to Line # 49 and Line # 50

    Now comment out those lines as shown below

    //if ( !extension_loaded(‘mysql’) )
    //die( ‘Your PHP installation appears to be missing the MySQL which is required for WordPress.’ );

    Now Install. The problem will be solved. Thanks

  4. I did that :)
    It works now.. with the flaws you discribed..
    I’m sure you will fix that.. and then I’ll just patch it to my wordpress :)

    Was wondering though.. you made this custum wordpress, but wordpress updates reguarly.. is there a way to update this wordpress with the official release without messin’ it all up?

  5. Hi again,

    Ok, that comment out line #49 and #50 did help, but then a new problem came up

    This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at DB_HOST. This could mean your host’s database server is down.

    * Are you sure you have the correct username and password?
    * Are you sure that you have typed the correct hostname?
    * Are you sure that the database server is running?

    But SQlite is installed, and I use localhost. I’ve never worked with SQlite before, what is it that i’m missing out, thanks for all help.

    b-ill

  6. Hasin: sqlite_fetch_object in wp-includes/wp-db.php line #183 is an php5 onlly function. Is it intended to support only php5?

  7. Just a note on b-ill’s last comment. I found that I not only had to use an absolute path, but also had to create an empty database file first with ‘touch wpdb.db’.

  8. Any further development? I would love to see this run on LAMP. I can set up easily enough, but then I get “It doesn’t look like you’ve installed WP yet”.

  9. I installed your SQLite version on my WRTSL54GS router and it seems to work well so far. Haven’t put it through much testing yet, but looks great. Thanks for all the work. When you start getting close to finishing your port, could you create a set of diff files against the stock WordPress version so that we can continue to migrate your port forward as WordPress rolls out new versions?

    Once again great work. I was almost going to try a port myself and you beat me to it. See my installation here:

    http://denizenbox.denizenid.com/wp/

    -Andrew

  10. Ok i have lighttpd running and php. I installed sqlite. But i dont know how to use it. Cansome body write a little tut for me. I run linux.

    Sollie.

  11. Hi Hasin,
    No new post from you and your last comment is from August 23, 2006 so I think I’m save to assume you put your energy on other fields to good use.

    1. I’m interested to use WP + SQLite.
    2. My field is “Knowledgeflows in Development Aid”
    3. I run WP on XAMPP on a USB Stick as a private life diary (5 categories, many tags)
    4. I will hire a theme designer to adjust the 2813 theme to my sketched layout
    5. I like to pay to get WP 2.1.3 adjusted to SQLite
    (with the risk of not upgrading for the next year which is not a problem as the Blog/Wiki is not on the Internet. Sometimes on an Intranet)

    Questions
    A. Is it right that you stopped working on WP + SQLite?
    B. Do you know who else is actively working on it ? (I researched all old threads, yours and fcicq are the latest activities I found)
    C. Any suggestion how I should proceed?

    Have a wonderful time with your children, bfh

  12. Hello,

    How is Business,

    My name is Donald Joseph I am presently in the UK here i work as a videographer & Priest.

    The reason why i am contacting you is that my wife sharron will be Celibrating her 40th Birthday Party soon, precisely on the 21th of october 2006 ,please check your avalability for this date becouse I will like you to take care of the giving some kinda intresting stories aspect of the event.

    I came across your profile and am impressed with your
    services,experience,your kind of story of course is okay by me.

    The venue address of the event is 257 east 2nd street
    01001 AGAWAM MA

    We are expecting about 80-100 guest & its going to be an indoor party.

    The party starts 2pm-5pm according to our program of the event.

    You are to start performing when it is 1pm till the end of the party.
    There will no be any dance from guest nor familly for any reason what
    we
    only need from you is for you to just give us interesting Stories.

    All expenses would be taken care of by me;Please I want the best
    service from you, because she is my only wife & i love her so much.
    So your best production is needed at this occasion.

    Pls Let me know your CHARGES to work for 3 Hours on that day,2pm -5pm
    when the event will be ending,moreso let me know how you plan to
    move down here with your electronics?

    I will want to put it to your notice that i will take care of your
    hotel only if requested from you,please let me know how many of you
    will be comming for this event?

    I hope to read from you soon & also to have your service QUOTE
    which will only include your travel,feeding, and your service fee.
    I look forward to your response and also your price package so that
    i can make quick arrangement of paying you a deposit payment so
    that you can book my wife event on your calendar.

    Pls email me back asap.
    Best Regards

    Priest Donald

  13. Hi, thanx for your works.

    I’m trying your WordPress4SQLite.
    However, whenever I try to log-in as admin, I just face “You do not have sufficient permissions to access this page.” error message.
    What should do I to solve this problem?

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s