Hi,I install the wordpress 2.5.1 wiht you pdo plugins,but the Manage comments box do not display the comments, is it a bug?

[...] just posted a comment here. Having originally thought this was due to a badly behaved plugin, i’ve just looked at it [...]

None plugins, I have deleted all the plugings,but the Manage comments box do not display the comments any more.
Apache 2.0.63 ;php 5.2.6;open eAccelerator and Zend Optimizer

Justin hello I need your help

Here I am trying to install the script WordPress, with the use ODP, follow the steps you had in step by step, but I get the following message

Invalid or missing PDO Driver
Your PHP installation appears not to have the right PDO drivers loaded. These are required for this version of WordPress and the type of database you have specified.

Note: I am installing on the server intranet of the company that work, and the system of the database is SQL Server 2005 or higher

What should I pass the parameters in wp-config.php?

define ( ‘DB_TYPE’, ‘sqlite’), or define ( ‘DB_TYPE’, ‘PDO_DBLIB’);?

I did an installation on my personal machine localhost, with version 2.5.1 of WordPress, this apparent installed, but when I check in mysql, don’t found there is the tables.

Until the moment I do not know what to do, if you can help me I would be very grateful

[...] 于是我就在fcicq留了个言热心的fcicq给了我回复。给我推荐了一个用于Wordpress的Sqlite插件PDO For WordPress [...]

Hi,
First thanks for this great plugin. I was looking for something like that for ages. THANKS!!!
Secondly – will you support WP 2.7?

Justin, so how do you do upgrades – dump, fresh install and reload? any scripts for that?

Thanks again I’ll let you know how it went with 2.7

Great – this sounds just perfect. Thanks again for this plugin and such prompt replies! All the best to you!

Hmmm,

I did those 2 steps as in README and I get database connection error. I have sqlite support with my php.
How can I debug this?

I use 1.0.2 – adding this function to mentioned file didn’t help.

Justin do you use any IM? Like maybe ICQ or something?

Replied – I’m stupid – I have unpacked stuff into / not /wp-content – now things seem to work. BIG THANKS!!!

Hello,

I’m experiencing the same problem to what Martin was going through. I did make sure I unpacked into the correct directory, and I made the change you mentioned above to pdo/db.php. This is with WordPress 2.7 and PDO for WordPress 1.0.2. I’m running on a Debian Linux virtual private server. I thought maybe installing the “php5-sqlite” package would help, but it only made things worse. Now, instead of the “Invalid or missing PDO driver”, I’m getting “Fatal error: Call to a member function bail() on a non-object in /wp-content/pdo/PDOEngine.php on line 77″. If I remove the “php5-sqlite” package, then I’m back to “Invalid or missiong PDO driver”.

Any thoughts?

Thank!

Hello Justin,

Thanks! That did the trick. Once that was done, though, I had to go in and tweak my Apache settings, since the Apache processes suddenly ballooned up to 13-16 MB each and ate up all of my VPS’ memory. Reducing the number of Apache processes did the trick, though.

– Bryce

I really like the idea of your plugin, but I’m having a hard time getting it to work. I did a fresh installation of WP 2.7 and got sqlite installed, and added the appropriate extensions to my php.ini file. When I go to my site it starts to run through the basic setup again (like it did the first time with the MySQL database). However, after putting in my site title and e-mail, the next page (/wp-admin/install.php?step=2) fails with an error:

Error occurred at line 335 in Function prepareQuery.
Error message was: Problem preparing the PDO SQL Statement. Error was Array ( [0] => HY000 [1] => 1 [2] => no such table: wp_options )

(There’s more, but I wasn’t sure how much detail you needed.) I’m running PHP v. 5.2.3 with Apache 2.2.4 on Ubuntu 7.10, with pdo_sqlite v. 1.10.2.6 and version 3.2.8 of the SQLite library. I think it’s awesome that you developed this, and I appreciate any help you can offer.

-Michael

Hi,

I’m trying to setup wordpress w/ PDO, with php5 and lighttpd. Trouble is, I get nothing

It seems the server executes the request, but the browser receives an empty reply. I see no error in the server log files, no crash, nothing.
The only message I’ve been able to receive for now is the plugin complaining about an unsupported PDO driver – when I alter the “DB_TYPE” parameter on purpose to trigger an error: at least some of the files are parsed and executed. As soon as I revert back to the proper configuration (DB_TYPE = “sqlite”), I only receive blank pages
php_info() reports no issue, PDO driver is properly loaded.

I also tried to run the CLI version of PHP5 to get more info, with no luck. When I use ‘strace’ to see the system call, everything looks normal, but the execution stops without any obvious error:
{{{
lstat64(“/var”, {st_mode=S_IFDIR|0755, st_size=336, …}) = 0
lstat64(“/var/www”, {st_mode=S_IFDIR|0755, st_size=152, …}) = 0
lstat64(“/var/www/wordpress”, {st_mode=S_IFDIR|0775, st_size=944, …}) = 0
lstat64(“/var/www/wordpress/wp-content”, {st_mode=S_IFDIR|0775, st_size=232, …}) = 0
lstat64(“/var/www/wordpress/wp-content/pdo”, {st_mode=S_IFDIR|0775, st_size=136, …}) = 0
lstat64(“/var/www/wordpress/wp-content/pdo/PDOEngine.php”, {st_mode=S_IFREG|0664, st_size=16641, …}) = 0
gettimeofday({1237646717, 948278}, NULL) = 0
open(“/var/www/wordpress/wp-content/pdo/PDOEngine.php”, O_RDONLY|O_LARGEFILE) = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=16641, …}) = 0
read(3, “$m){\n\t\t\t$output “…, 8192) = 8192
read(3, “truct($value,$node->$key); \n “…, 8192) = 257
read(3, “”…, 8192) = 0
read(3, “”…, 8192) = 0
close(3) = 0
gettimeofday({1237646717, 999405}, NULL) = 0
lstat64(“/var”, {st_mode=S_IFDIR|0755, st_size=336, …}) = 0
lstat64(“/var/www”, {st_mode=S_IFDIR|0755, st_size=152, …}) = 0
lstat64(“/var/www/wordpress”, {st_mode=S_IFDIR|0775, st_size=944, …}) = 0
lstat64(“/var/www/wordpress/wp-includes”, {st_mode=S_IFDIR|0775, st_size=2400, …}) = 0
lstat64(“/var/www/wordpress/wp-includes/wp-db.php”, {st_mode=S_IFREG|0664, st_size=25032, …}) = 0
gettimeofday({1237646718, 16978}, NULL) = 0
open(“/var/www/wordpress/wp-includes/wp-db.php”, O_RDONLY|O_LARGEFILE) = 3
fstat64(3, {st_mode=S_IFREG|0664, st_size=25032, …}) = 0
read(3, “<?php\n/**\n * WordPress DB Class\n “…, 8192) = 8192
read(3, “db) {\n\t\tif (!@mysql_select_db($db”…, 8192) = 8192
read(3, “\t\tforeach ( (array) array_keys($d”…, 8192) = 8192
brk(0x74f000) = 0x74f000
read(3, “tring false on failure, version n”…, 8192) = 456
read(3, “”…, 8192) = 0
read(3, “”…, 8192) = 0
close(3) = 0
close(2) = 0
close(1) = 0
munmap(0×40020000, 4096) = 0
close(0) = 0
munmap(0x4001f000, 4096) = 0
brk(0x6cb000) = 0x6cb000
munmap(0x40abe000, 528384) = 0
open(“/dev/urandom”, O_RDONLY) = 0
read(0, “\31\303cq”…, 4) = 4
close(0) = 0
open(“/dev/urandom”, O_RDONLY) = 0
read(0, “\210\337\22m”…, 4) = 4
close(0) = 0
open(“/dev/urandom”, O_RDONLY) = 0
read(0, “1\22~v”…, 4) = 4
close(0) = 0
setitimer(ITIMER_PROF, {it_interval={0, 0}, it_value={0, 0}}, NULL) = 0
munmap(0x40a3c000, 93572) = 0
munmap(0x40a53000, 364456) = 0
munmap(0x409b0000, 50136) = 0
munmap(0x409cc000, 457360) = 0
munmap(0×40993000, 117656) = 0
brk(0×645000) = 0×645000
exit_group(255) = ?
}}}

I’m out of idea to solve this issue. Any hints?