re 3: "desc page" shows that "page_restrictions" is a field in the page
table.
The best sense I could make of the situation was that it looked as
though "page" was being appended to the table name - not from
LocalSettings.php but somewhere else. Anyway would fit your suggestion
that the database has changed shape. It looks like I am best to recover
the text from the dump file and recreate some pages in a new
installation. There are only a small number of pages, I'll be able to
recreate it in a shorter time than I've spent on trying to restore it so
far!
I really appreciate all the assistance that you have offered, bit of a
shame I've been beaten by this one, good learning none the less. And
more to look out for when I get this going again.
Cheers,
Roger
Steve Holdoway wrote:
OK, there're a few possible issues here.
1. The original error message below shows that you're prefixing your tables
with 'Wiki'
2. Is wikimedia accessing the database as roger? I thought it was using the
user 'wiki', which is why I was asking you to access the database as that user,
to ensure that the user had proper access to the database.
But...
3. When you set the prefix to '', then it *does* find the page table, but then falls over by not finding the table 'page_restrictions', which sure enough doesn't exist.
I'd say that you're restoring to a different version of wikimedia than the
original... as the database has changed shape ):
Steve.
On Fri, 06 Jun 2008 13:01:31 +1200
Roger Searle <[EMAIL PROTECTED]> wrote:
(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:
