Search options (Page 12 of 13)

Sweet yah... now the pdo_sqlite dblayer is a litle more functional... lol ~.~

Now I have to track down a problem with loading up the $pun_user variable 0.o

EDIT --

Is it safe to assume that only non-altering sql commands (ie: SELECT is good, but DROP TABLE, or INSERT are things that alter the database) will use a call to $db->fetch_row or $db->fetch_assoc or $db->num_rows or $db->result?
With pdo, every fetch removes a row of data permanently, and the command needs to be executed again to re-populate the data of a SELECT, or what not.

EDIT --

Anyone have a premade "test_dblayer.php"? I need to find out what my pdo_sqlite isn't doing right that the sqlite backend is doing right. It's got to do with the differnt ways that sqlite (which I based my backend on) and pdo return fetches, and alter thier data structures after doing said fetch.

Could the value returned from $db->query be a private data structure that can only be viewed with $db->fetch_assoc or $db->fetch_row or $db->result? I'm having the odd error, here and there. Makes me wonder if the $result data is expected to be an array when returned from $db->query on occation.

Killer instinct

Can always write a plug-in to display the last 5 posts (or a link to the last 5 posts) in forum "reviewed stories".

As for the second, you should be able to disable "viewing" forum "recently-submited-stories" but allow "posting" to forum "recently-submited-stories". No link shows up to allow people to post to stories forum, but you should be able to make your own link. As an admin check the forum stories, and click on the post button. You should get a link, that's something like this:

"http://<my url>/<forum path>/post.php?fid=XXX"

XXX is a number indicating the forum topic new posts are made to. Just add that link into the menu at the top of the page, so people have:

[PunBB.org] [Index] [User list] [Rules] [Search] [Profile] [b][Submit my story][/b] [Logout]

It may require a litle php know how and some editing of the punbb php scripts, but you should be able to get something functional. Could also add a database entry to table users, as a bool/int that indicates if someone has already submitted thier story. What you end up with is a forum topic that has unreviewed stories, and as you review them (or another mod reviews them) they are moved to the revied-stories topic. The newest 5 reviewed-stories posts get a link on the main page (by using some php and sql know-how).

Thanks, now I have a moderatly functioning punbb with pdo_sqlite support

PS: Your not stalking me smatys, your stalking EVERYBODY!!! AHAHAHAHA Runnnnnnnnnaaaaaawaaay!

Change the permissions on catch to 777 (world read, write, and executable)
Change the permissions on all files in the catch dir to 666 (world read/writeable)

PS: You can modify the above depending on your know how of your server. chown to the web user, and or group, and give only that user and/or group permissions to read/write to them files and dir (edit: but don't disallow your ftp user account read/write access!!!). Also some webservers don't need executable permission to allow php, cgi etc.. to view and modify the content of that directory).

PPS: There's a couple directories/files that need write permission to function correctly, for example to allow uploading of avatars <install-dir>/img/avatars needs to be writable by the web user.

sqlite (v2.x) != sqlite3 (v3.x)

$ sqlite3 temp.db3 "BEGIN TRANSACTION; CREATE TABLE blah (id INTEGER NOT NULL); COMMIT;"
$ sqlite3 temp.db3 ".dump"
BEGIN TRANSACTION;
CREATE TABLE blah (id INTEGER NOT NULL);
COMMIT;
$ sqlite temp.db3 ".dump"
Unable to open database "temp.db3": file is encrypted or is not a database

sqlite3 adds support for many things that were missing from sqlite, but would slow down sqlite. So you want a fast simple database, use sqlite. You want a kindah fast database with some extras use sqlite3.

EDIT --

Reverse the above; sqlite3 test.db ".dump" on a sqlite db will spit out

BEGIN TRANSACTION;
COMMIT;

Regadless of how much or what kind of data you have in the database.

EDIT --

Well I've managed to get a sqlite3 database to be created... But "CREATE TABLE X(Y);"  never get's commited... even if I call $db->start_transaction() before $db->query() and $db->end_transaction() after the query... This is all done with the install.php script, in a clear punbb install (no mod or databases, etc...).

Anyone one know of an alternative to the php5-sqlite3 mod? I've hurd PDO might work with some effort?

@Smartys Public libraries in my area only have basic web access (no downloading content, 90% of shortcut keys disbled, etc..), so you can't ftp/sftp from them ;.; But I suppose Paul and you are right, board description shouldn't allow any html in it ;p

> It appears as if, when you submit the form, it never gets posted. I can't believe this has anything to do with PunBB.

Agreed. Probably something wrong with my php install

> Have you successfully run any other PHP scripts that include forms?

Nope, but I've done perl forms successfully.

I'll play around a bit with my php install and see what comes up. Hopefully I can get $_POST variable to hold some data in another simple php script. Thanks Rickard and others for the effort and help

When I first install php5 into the chroot, I forgot a few libs and got some errors (ohh and the page never actually displayed correctly). After fixing that (and now the page does display correctly) there hasn't been an errors in the logs

I might have forgotten to mention that I've set the owner to www-user:www-user 755 for the forum directory (and sub directories); www-user:www-user 644 for all the files. This is the way lighttp works (it ignores run permissions; If it can read the file, and it's extention is "XXX", then it's run by program "Y"; lighttp is run as www-user:www-user).

I've also tried with the database created with sqlite, or sqlite3; and without any database created.