phpwiki-talk

[Phpwiki-talk] mysql install?

[Andrew H. <ah...@op...>]

hi there,

i posted this to the sf.net forum, but it appears that it's exceptionally 
low volume, so please forgive me for posting to the list as well.

i'm attempting to set phpwiki up for the first time, against mysql.

i've created the database and schema, and get the following when trying to 
hit the index.php page for the first time:
<error>
C:\Program 
Files\openlink\Virtuoso30beta\vsp\PHP\phpwiki-1.3.3\lib\main.php:579: 
Warning[2]: Failed opening 'lib/WikiDB/mysql://...@localhost/phpwiki.php' 
for inclusion (include_path='.;c:\php\includes;C:\Program 
Files\openlink\Virtuoso30beta\vsp\PHP\phps\php-4.2.3-Win32\pear')

Fatal error: Cannot instantiate non-existent class: 
wikidb_mysql://dbuser:dbpass@localhost/phpwiki in C:\Program 
Files\openlink\Virtuoso30beta\vsp\PHP\phpwiki-1.3.3\lib\main.php on line 579
</error>

can anyone suggest why the "failed opening" error is showing?

cheers,
andrew

Re: [Phpwiki-talk] mysql install?

[Martin G. <gim...@gi...>]

Andrew Hill <ah...@op...> writes:

> I'm attempting to set phpwiki up for the first time, against mysql.
>
> I've created the database and schema, and get the following when
> trying to hit the index.php page for the first time:
>
> C:\Program
> Files\openlink\Virtuoso30beta\vsp\PHP\phpwiki-1.3.3\lib\main.php:579:
> Warning[2]: Failed opening
> 'lib/WikiDB/mysql://...@localhost/phpwiki.php' for inclusion
> (include_path='.;c:\php\includes;C:\Program
> Files\openlink\Virtuoso30beta\vsp\PHP\phps\php-4.2.3-Win32\pear')

My guess is, that you've specified the 'dbtype' entry in the $DBParams
array as 'mysql://...' when you should have put that information into
the 'dsn' entry instead. The 'dbtype' entry should be 'SQL'.

So, use something like 

$DBParams = array(
   'dbtype' => 'SQL',
   'dsn' => "mysql://db_username:db_password@db_hostname/db_name",
   ...
)

and not

$DBParams = array(
   'dbtype' => "mysql://db_username:db_password@db_hostname/db_name",
   ...
)

I hope that helps --- if not, then post your index.php file.

-- 
Martin Geisler                       My GnuPG Key: 0xF7F6B57B

See http://gimpster.com/ and http://phpweather.net/ for:
PHP Weather => Shows the current weather on your webpage and
PHP Shell   => A telnet-connection (almost :-) in a PHP page.