Last modified: 2010-05-15 15:56:47 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T7529, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 5529 - Attempt to add field to non-existant watchlist table
Attempt to add field to non-existant watchlist table
Status: RESOLVED INVALID
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
1.6.x
PC Windows XP
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2006-04-10 21:36 UTC by David
Modified: 2010-05-15 15:56 UTC (History)
0 users

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description David 2006-04-10 21:36:07 UTC
During upgrade from mediawiki 1.5.3 to 1.6.2

I am using the latest version of EasyPHP (1.8) on Windows XP

MediaWiki 1.6.2 Installation

    * Don't forget security updates! Keep an eye on the low-traffic release
announcements mailing list.

Checking environment...

Please include all of the lines below when reporting installation problems.

    * PHP 4.3.10 installed
    * PHP server API is apache; ok, using pretty URLs (index.php/Page_Title)
    * Have XML / Latin1-UTF-8 conversion support.
    * PHP is configured with no memory_limit.
    * Have zlib support; enabling output compression.
    * Neither Turck MMCache nor eAccelerator are installed, can't use object
caching functions
    * GNU diff3 not found.
    * Couldn't find GD library or ImageMagick; image thumbnailing disabled.
    * Installation directory: c:\easyphp\www\mediawiki
    * Script URI path: /mediawiki
    * Environment checked. You can install MediaWiki.
    * Warning: $wgSecretKey key is insecure, generated with mt_rand(). Consider
changing it manually.

      Generating configuration file...
    * Database type: mysql
    * PHP is linked with old MySQL client libraries. If you are using a MySQL
4.1 server and have problems connecting to the database, see
http://dev.mysql.com/doc/mysql/en/old-client.html for help.
    * Attempting to connect to database server as root...success.
    * Connected to 4.1.9-max; You are using MySQL 4.1 server, but PHP is linked
to old client libraries; if you have trouble with authentication, see
http://dev.mysql.com/doc/mysql/en/old-client.html for help.
    * Database wikidb exists
    * There are already MediaWiki tables in this database. Checking if updates
are needed...
    * DB user account ok

      ...hitcounter table already exists.
      ...querycache table already exists.
      ...objectcache table already exists.
      ...categorylinks table already exists.
      ...logging table already exists.
      ...validate table already exists.
      ...user_newtalk table already exists.
      ...transcache table already exists.
      ...trackbacks table already exists.
      ...externallinks table already exists.
      ...job table already exists.
      ...have ipb_id field in ipblocks table.
      ...have ipb_expiry field in ipblocks table.
      ...have rc_type field in recentchanges table.
      ...have rc_ip field in recentchanges table.
      ...have rc_id field in recentchanges table.
      ...have rc_patrolled field in recentchanges table.
      ...user table does not exist, skipping new field patch
      ...user table does not exist, skipping new field patch
      ...user table does not exist, skipping new field patch
      ...user table does not exist, skipping new field patch
      ...have log_params field in logging table.
      ...have ar_rev_id field in archive table.
      ...have ar_text_id field in archive table.
      ...have page_len field in page table.
      ...have rev_deleted field in revision table.
      ...have img_width field in image table.
      ...have img_metadata field in image table.
      ...have img_media_type field in image table.
      ...have val_ip field in validate table.
      ...site_stats table does not exist, skipping new field patch
      ...have iw_trans field in interwiki table.
      ...have ipb_range_start field in ipblocks table.
      ...site_stats table does not exist, skipping new field patch
      ...already have interwiki table
      ...indexes seem up to 20031107 standards
      Already have pagelinks; skipping old links table updates.
      ...image primary key already set.
      Adding wl_notificationtimestamp field for email notification
management.Query "ALTER TABLE `watchlist` ADD (wl_notificationtimestamp
varchar(14) binary)
      " failed with error code "Table 'wikidb.watchlist' doesn't exist (localhost)".
Comment 1 David 2006-04-10 22:15:36 UTC
My mistake. I was apparently restoring off a corrupt mysql dump.

However I still have this problem (after restoring off a non-broken dump):

(I am running EasyPHP, perhaps it doesn't provide InnoDB support)

MediaWiki 1.6.2 Installation

    * Don't forget security updates! Keep an eye on the low-traffic release
announcements mailing list.

Checking environment...

Please include all of the lines below when reporting installation problems.

    * PHP 4.3.10 installed
    * PHP server API is apache; ok, using pretty URLs (index.php/Page_Title)
    * Have XML / Latin1-UTF-8 conversion support.
    * PHP is configured with no memory_limit.
    * Have zlib support; enabling output compression.
    * Neither Turck MMCache nor eAccelerator are installed, can't use object
caching functions
    * GNU diff3 not found.
    * Couldn't find GD library or ImageMagick; image thumbnailing disabled.
    * Installation directory: c:\easyphp\www\mediawiki
    * Script URI path: /mediawiki
    * Environment checked. You can install MediaWiki.
    * Warning: $wgSecretKey key is insecure, generated with mt_rand(). Consider
changing it manually.

      Generating configuration file...
    * Database type: mysql
    * PHP is linked with old MySQL client libraries. If you are using a MySQL
4.1 server and have problems connecting to the database, see
http://dev.mysql.com/doc/mysql/en/old-client.html for help.
    * Attempting to connect to database server as root...success.
    * Connected to 4.0.15-max-debug
    * Database wikidb exists
    * There are already MediaWiki tables in this database. Checking if updates
are needed...
    * DB user account ok

      ...hitcounter table already exists.
      ...querycache table already exists.
      ...objectcache table already exists.
      ...categorylinks table already exists.
      ...logging table already exists.
      ...validate table already exists.
      ...user_newtalk table already exists.
      ...transcache table already exists.
      ...trackbacks table already exists.
      Creating externallinks table...Query "CREATE TABLE `externallinks` (
       el_from int(8) unsigned NOT NULL default '0',
       el_to blob NOT NULL default '',
       el_index blob NOT NULL default '',
       KEY (el_from, el_to(40)),
       KEY (el_to(60), el_from),
       KEY (el_index(60))
       ) ENGINE=InnoDB
      " failed with error code "You have an error in your SQL syntax.  Check the
manual that corresponds to your MySQL server version for the right syntax to use
near 'ENGINE=InnoDB' at line 8 (localhost)".
Comment 2 Brion Vibber 2006-04-10 22:19:44 UTC
See bug 5508 for your second issue.

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links