Page MenuHomePhabricator

Attempt to add field to non-existant watchlist table
Closed, InvalidPublic

Description

Author: wizzardx

Description:
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)".

Version: 1.6.x
Severity: major
OS: Windows XP
Platform: PC

Details

Reference
bz5529

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 9:11 PM
bzimport set Reference to bz5529.
bzimport added a subscriber: Unknown Object (MLST).

wizzardx wrote:

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)".

See bug 5508 for your second issue.