DB Error: SELECT with no TABLE?

[Tom Spilman]

  I'm trying to install 1.3.9 and had lots of trouble ( the instructions for MySQL suck ). I've now got these errors....

lib/WikiDB/backend/PearDB.php:765: Fatal[256]: wikidb_backend_mysql: fatal database error

DB Error: no such table
(SELECT sess_data FROM phpwiki_ WHERE sess_id='ea79324b5ab076884580178b1f821de3' [nativecode=1146 ** Table 'tspilman_phpwiki.phpwiki_' doesn't exist])

lib/WikiUserNew.php:130: Notice[8]: Undefined variable: USER_AUTH_ORDER

lib/WikiGroup.php:29: Warning[512]: No or unsupported GROUP_METHOD defined

lib/main.php:29: Notice[8]: Undefined index: db_session_table

lib/WikiDB/backend/PearDB.php:765: Fatal[256]: wikidb_backend_mysql: fatal database error

DB Error: no such table
(SELECT sess_data FROM phpwiki_ WHERE sess_id='ea79324b5ab076884580178b1f821de3' [nativecode=1146 ** Table 'tspilman_phpwiki.phpwiki_' doesn't exist])

.... so to me this looks like a bug where a query is being made with the prefix name, but without a table name. Or did i somehow misunderstand the MySQL instructions? Impossible!! =)

[Reini Urban]

You forgot to define the session table name in DBParams.
  SELECT sess_data FROM phpwiki_

[Reini Urban]

And most of your other configurationsd are also not set.

>Undefined variable: USER_AUTH_ORDER
>No or unsupported GROUP_METHOD defined

So it looks like something fundamentally is wrong with your setup.
Those variables have useful defaults in index.php

[Tom Spilman]

Where does it instruct me to do this?  What more am i supposed to define?  Am i configuring the wiki or am i writing code now?

[Tim Hunter]

in the index.php config look for the section where you define the $DBParams array

add to it
'db_session_table'   => 'session',

or whatever you want to define your session table as

[Sarky]

I've got the same problem, the configurator.php of 1.3.9 seems to be terribly buggy because it simply misses some important configurations.

I added USER_AUTH_ORDER, GROUP_METHOD and $DBParam['db_session_table'] manually and now don't get any errors when I load index.php in my browser, but the page doesn't display anything?!

I am using SQL PEAR with MySQL database and created the tables by using schemas/mysql.sql. Platform is Windows.

Please help.

[Reini Urban]

The configurator is a left over from older days and I simple forgot to delete it from these releases.

Now it is gone.