at the command prompt, type mysql -u wiki -p wiki ( enter password when prompted ) mysql> show tables;
This will list all the tables in your database. On Fri, 06 Jun 2008 12:41:03 +1200 Roger Searle <[EMAIL PROTECTED]> wrote: > I can log in to mysql and see that the wiki database contains the table > "page" which has the fields stated in the select query below. > LocalSettings.php has the line $wgDBprefix="wiki" and gives this error: > > Table 'wiki.Wikipage' doesn't exist (localhost) > > So if I change the line $wgDBprefix to "test" I get: > Table 'wiki.testpage' doesn't exist (localhost) > > Shouldn't it be looking for the table "wiki.page"? So if I comment out the > $wgDBprefix line or make it if I make the line $wgDBprefix="" > I get: > Table 'wiki.page_restrictions' doesn't exist (localhost) > (page_restrictions is a field in the table "page") > > Somewhat confused at this point, I'm sure I'm overlooking something minor... > The table names are NOT all prefixed by a string. > > > > > Steve Holdoway wrote: > > Isn't there a prefix string in this file as well?? Can't remember, and > > haven't got the code to hand. Look at the names of the tables that are > > created, and it they're all prefixed by a string, then update accordingly. > > > > Steve > > > > On Fri, 06 Jun 2008 11:15:06 +1200 > > Roger Searle <[EMAIL PROTECTED]> wrote: > > > > > >> MediaWiki internal error. > >> > >> Original exception: exception 'DBQueryError' with message 'A database > >> error has occurred > >> Query: SELECT > >> page_id,page_namespace,page_title,page_restrictions,page_counter,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len > >> > >> FROM `Wikipage` WHERE page_namespace = '0' AND page_title = 'Main_Page' > >> LIMIT 1 > >> Function: Article::pageData > >> Error: 1146 Table 'wiki.Wikipage' doesn't exist (localhost) > >> ' in /usr/share/mediawiki/includes/Database.php:840 > >> Stack trace: > >>
pgpRl54ZBAaUy.pgp
Description: PGP signature
