Chris Adams wrote: > > On 2006-04-07, at 5:17 PM, Matt Brown wrote: >> - I assume you are using sqlite? > > Correct. > >> - Is your database stored in the standard location >> /var/lib/phpwiki/phpwiki_pagedb.db ? > > Yes - the file opened correctly with sqlite for the database upgrade > scripts.
OK, The most likely cause is one of these upgrade scripts failing - although you should definitely have got an error... Can I get you to do the following please? On a copy of the original database (ie what you were upgrading from), run the following two commands in order /usr/bin/sqlite DB_FILE < \ /usr/share/doc/phpwiki/schemas/sqlite-upgrade-1.3.10.sql /usr/bin/sqlite DB_FILE < \ /usr/share/doc/phpwiki/schemas/sqlite-upgrade-1.3.11.sql (replacing DB_FILE with the location of the old database) after each command you could check that the contents of the page table in the database appears correct. You can do this by loading up the database with sqlite DB_FILE which will drop you at a console where you can execute standard sql commands. The command .schema [tablename] will show you the tables in the database and the structure of a table. > I believe so - we were using external HTTP authentication which IIRC was > not turned on by default or configurable using debcconf. If you'd like I > can send you the old index.php. It's probably not relevant at this stage, the results of the above tests will be much more revealing. My current hypothesis is that there is something in your database that is causing the upgrade scripts to silently fail. I can't reproduce the problem here unfortunately so hopefully you'll be able to see something go wrong with the above tests. Thanks for your help. -- Matt Brown [EMAIL PROTECTED] Mob +64 21 611 544 www.mattb.net.nz
signature.asc
Description: OpenPGP digital signature
