(as -u roger, not -u wiki)
mysql> show tables;
+-----------------+
| Tables_in_wiki |
+-----------------+
| archive |
| categorylinks |
| externallinks |
| filearchive |
| hitcounter |
| image |
| imagelinks |
| interwiki |
| ipblocks |
| job |
| langlinks |
| logging |
| math |
| objectcache |
| oldimage |
| page |
| pagelinks |
| querycache |
| querycache_info |
| querycachetwo |
| recentchanges |
| redirect |
| revision |
| searchindex |
| site_stats |
| templatelinks |
| text |
| trackbacks |
| transcache |
| user |
| user_groups |
| user_newtalk |
| watchlist |
+-----------------+
33 rows in set (0.00 sec)
Steve Holdoway wrote:
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:
