havok89 / Hoosk

Hoosk Codeigniter CMS
http://hoosk.org
Other
128 stars 87 forks source link

Does Hoosk can run on SQLite instead of MySQL? #48

Open joejac opened 6 years ago

joejac commented 6 years ago

Hello First, thank you for sharing Hoosk. I have a very limited shared hosting account, question: 1.- Does Hoosk can run on SQLite instead of MySQL? 2.- Your last version is dated 25/04/2017, when will the next version be available? Thanks and regards Jose

joejac commented 6 years ago

Hummm no answer. Is this software yet maintained? Thanks

havok89 commented 6 years ago

Hoosk is built on Codeigniter and I think it does support SQLite.

Its open source so if anyone wants to commit anything I'll check it out and merge it in but I myself just don't have time to actively develop it just now. If there is any major bugs or security issues I will sort those though

joejac commented 6 years ago

Hello and thanks for your kind answer Mr. Henrys, Y saw your demo in your page and I was well impressed, its a pity Hoosk is not well known and you closed hoosk.org. I will try it on a Virtual machine and see if its works with SQLite, I have a very limited VPS, unfortunately I am not a programmer.

I do appreciate a lot your response because I have tested and looked into about 100 CMSs, I only liked 4 and yours is one of them, two of them do not run on my VPS, one no WYSIWYG and yours. I have contacted some developers with questions, but it seems they are too busy to answer, only a couple answered including you. I wish you success. Best regards Jose


From: Callum Henry notifications@github.com Sent: Thursday, November 15, 2018 3:04 AM To: havok89/Hoosk Cc: joejac; Author Subject: Re: [havok89/Hoosk] Does Hoosk can run on SQLite instead of MySQL? (#48)

Hoosk is built on Codeigniter and I think it does support SQLite.

Its open source so if anyone wants to commit anything I'll check it out and merge it in but I myself just don't have time to actively develop it just now. If there is any major bugs or security issues I will sort those though

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/havok89/Hoosk/issues/48#issuecomment-438939162, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AKp0Y2i2UbMP7LONK5JgmeQA_yUJ1xZBks5uvRHlgaJpZM4YWa2e.

havok89 commented 6 years ago

Oh I hadn't noticed the domain expired. Should be back up shortly

joejac commented 5 years ago

Hello Mr. Henry, I tried to install Hooks with SQLite3 installed with a blank database hoosk.db in the browser I get the error "HTTP ERROR 500" but I saw an error in the error.log: "Call to undefined function mysqli_connect() in ...install/index.php:28 ..." So Hooks is using MySQL functions to connect to the database, not PDO.

Is there a way to make some few and easy changes to make Hooks use SQLite, without having to change in all files of the application the mysql functions? Thanks a lot for your kind help. Best regards Jose

havok89 commented 5 years ago

In the following file:

https://github.com/havok89/Hoosk/blob/master/hoosk/hoosk0/config/database.php

on line 71 you should be able to update it there. refer to line 22-25 for options

joejac commented 5 years ago

Hello and thanks, I did the change in line 71 of databse.php:

'dbdriver' => 'sqlite3',

Now after the install page I get the error on the browser:

Error selecting MySQL database:

In the error.log I get:

mod_fcgid: stderr: PHP Warning: mysqli_error() expects exactly 1 parameter, 0 given in /home/user/public_html/install/index.php on line 30, referer: http://domain.com/install/

The file install/index.php on line 30 has:

// Select database mysqli_select_db($con, $mysql_database) or die('Error selecting MySQL database: ' . mysqli_error());

Sorry to bother but, is there any way to make Hoosk to work with SQLite3? Thanks and regards Jose