Last modified: 2010-05-15 15:40:39 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 T8589, the corresponding Phabricator task for complete and up-to-date bug report information.
First Last Prev Next    This bug is not in your last search results.
Bug 6589 - DB Errors on 1.7.0 upgrade
DB Errors on 1.7.0 upgrade
Status: RESOLVED WORKSFORME
Product: MediaWiki
Classification: Unclassified
Installer (Other open bugs)
1.7.x
Other FreeBSD
: Normal major (vote)
: ---
Assigned To: Nobody - You can work on this!
http://ffproject.net/forumwiki/config...
:
Depends on:
Blocks:
  Show dependency tree / graph
 
Reported: 2006-07-08 06:51 UTC by Jules
Modified: 2010-05-15 15:40 UTC (History)
0 users

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Description Jules 2006-07-08 06:51:11 UTC 
Errors for 4.0 MySQL

install-utils.inc

Having a hell of a time doing this 1.7.0 upgrade... Getting errors on
install-utils.inc, line 96 which as far as I have figured out happens whenever
the script actually tries to do something that is on tables.sql

I went onto MySQLAdmin and created what was needed every time I got the darn
error and finally got through it.

    I wasn't going to say anything and assume my host /server was the problem
but I found out that table.sql has errors in it. Specifically, there is one
table it creats with ENGINE=InnoDb instead of the correct Syntax TYPE=InnoDB so
now I know it is not ONLY my server / host that is the culprit. kila01@yahoo.com
06:33, 8 July 2006 (UTC) ~~~

Others

After finally getting trough all the problems in install-utils no I'm stuck on
another error.

 Initialising "MediaWiki" namespace...

 Fatal error:  Call to undefined method DatabaseMysql::maxListLen() in 
 /home/ffprojec/public_html/forumwiki/maintenance/InitialiseMessages.inc on line 125

Any chance I can get some help with this one ? ~~~ 06:33, 8 July 2006 (UTC)

Here is the last log:

Checking environment...

    * PHP 5.1.4: ok
    * Warning: PHP's register_globals option is enabled. MediaWiki will work
correctly, but this setting increases your exposure to potential security
vulnerabilities in PHP-based software running on your server. You should disable
it if you are able.
    * PHP server API is apache2handler; 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.
    * Found ImageMagick: /usr/local/bin/convert; image thumbnailing will be
enabled if you enable uploads.
    * Found GD graphics library built-in.
    * Installation directory: /home/ffprojec/public_html/forumwiki
    * Script URI path: /forumwiki

      Notice: Use of undefined constant MAG_NOGALLERY - assumed 'MAG_NOGALLERY'
in /home/ffprojec/public_html/forumwiki/languages/Language.php on line 216

      Notice: Use of undefined constant MAG_CURRENTDAY2 - assumed
'MAG_CURRENTDAY2' in /home/ffprojec/public_html/forumwiki/languages/Language.php
on line 226

      Notice: Use of undefined constant MAG_NUMBEROFPAGES - assumed
'MAG_NUMBEROFPAGES' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 230

      Notice: Use of undefined constant MAG_NUMBEROFUSERS - assumed
'MAG_NUMBEROFUSERS' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 233

      Notice: Use of undefined constant MAG_NAMESPACEE - assumed
'MAG_NAMESPACEE' in /home/ffprojec/public_html/forumwiki/languages/Language.php
on line 237

      Notice: Use of undefined constant MAG_TALKSPACE - assumed 'MAG_TALKSPACE'
in /home/ffprojec/public_html/forumwiki/languages/Language.php on line 238

      Notice: Use of undefined constant MAG_TALKSPACEE - assumed
'MAG_TALKSPACEE' in /home/ffprojec/public_html/forumwiki/languages/Language.php
on line 239

      Notice: Use of undefined constant MAG_SUBJECTSPACE - assumed
'MAG_SUBJECTSPACE' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 240

      Notice: Use of undefined constant MAG_SUBJECTSPACEE - assumed
'MAG_SUBJECTSPACEE' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 241

      Notice: Use of undefined constant MAG_FULLPAGENAME - assumed
'MAG_FULLPAGENAME' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 242

      Notice: Use of undefined constant MAG_FULLPAGENAMEE - assumed
'MAG_FULLPAGENAMEE' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 243

      Notice: Use of undefined constant MAG_SUBPAGENAME - assumed
'MAG_SUBPAGENAME' in /home/ffprojec/public_html/forumwiki/languages/Language.php
on line 244

      Notice: Use of undefined constant MAG_SUBPAGENAMEE - assumed
'MAG_SUBPAGENAMEE' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 245

      Notice: Use of undefined constant MAG_BASEPAGENAME - assumed
'MAG_BASEPAGENAME' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 246

      Notice: Use of undefined constant MAG_BASEPAGENAMEE - assumed
'MAG_BASEPAGENAMEE' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 247

      Notice: Use of undefined constant MAG_TALKPAGENAME - assumed
'MAG_TALKPAGENAME' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 248

      Notice: Use of undefined constant MAG_TALKPAGENAMEE - assumed
'MAG_TALKPAGENAMEE' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 249

      Notice: Use of undefined constant MAG_SUBJECTPAGENAME - assumed
'MAG_SUBJECTPAGENAME' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 250

      Notice: Use of undefined constant MAG_SUBJECTPAGENAMEE - assumed
'MAG_SUBJECTPAGENAMEE' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 251

      Notice: Use of undefined constant MAG_IMG_MANUALTHUMB - assumed
'MAG_IMG_MANUALTHUMB' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 257

      Notice: Use of undefined constant MAG_PLURAL - assumed 'MAG_PLURAL' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 278

      Notice: Use of undefined constant MAG_FULLURL - assumed 'MAG_FULLURL' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 279

      Notice: Use of undefined constant MAG_FULLURLE - assumed 'MAG_FULLURLE' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 280

      Notice: Use of undefined constant MAG_LCFIRST - assumed 'MAG_LCFIRST' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 281

      Notice: Use of undefined constant MAG_UCFIRST - assumed 'MAG_UCFIRST' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 282

      Notice: Use of undefined constant MAG_LC - assumed 'MAG_LC' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 283

      Notice: Use of undefined constant MAG_UC - assumed 'MAG_UC' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 284

      Notice: Use of undefined constant MAG_RAW - assumed 'MAG_RAW' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 285

      Notice: Use of undefined constant MAG_DISPLAYTITLE - assumed
'MAG_DISPLAYTITLE' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 286

      Notice: Use of undefined constant MAG_RAWSUFFIX - assumed 'MAG_RAWSUFFIX'
in /home/ffprojec/public_html/forumwiki/languages/Language.php on line 287

      Notice: Use of undefined constant MAG_NEWSECTIONLINK - assumed
'MAG_NEWSECTIONLINK' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 288

      Notice: Use of undefined constant MAG_CURRENTVERSION - assumed
'MAG_CURRENTVERSION' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 289

      Notice: Use of undefined constant MAG_URLENCODE - assumed 'MAG_URLENCODE'
in /home/ffprojec/public_html/forumwiki/languages/Language.php on line 290

      Notice: Use of undefined constant MAG_CURRENTTIMESTAMP - assumed
'MAG_CURRENTTIMESTAMP' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 291

      Notice: Use of undefined constant MAG_DIRECTIONMARK - assumed
'MAG_DIRECTIONMARK' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 292

      Notice: Use of undefined constant MAG_LANGUAGE - assumed 'MAG_LANGUAGE' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 293

      Notice: Use of undefined constant MAG_CONTENTLANGUAGE - assumed
'MAG_CONTENTLANGUAGE' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 294

      Notice: Use of undefined constant MAG_PAGESINNAMESPACE - assumed
'MAG_PAGESINNAMESPACE' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 295

      Notice: Use of undefined constant MAG_NUMBEROFADMINS - assumed
'MAG_NUMBEROFADMINS' in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 296

      Notice: Use of undefined constant MAG_FORMATNUM - assumed 'MAG_FORMATNUM'
in /home/ffprojec/public_html/forumwiki/languages/Language.php on line 297

      Notice: Undefined variable: wgCachedMessageArrays in
/home/ffprojec/public_html/forumwiki/languages/Language.php on line 301
    * Connecting to ffprojec_forumwiki on localhost as ffprojec_wikiusr...success.
    * Connected to 4.0.16; using enhancements for mySQL 4.
    * Database ffprojec_forumwiki exists
    * There are already MediaWiki tables in this database. Checking if updates
are needed...

      ...hitcounter table already exists.
      ...querycache table already exists.
      ...objectcache table already exists.
      ...categorylinks table already exists.
      ...logging table already exists.
      ...user_newtalk table already exists.
      ...transcache table already exists.
      ...trackbacks table already exists.
      ...externallinks table already exists.
      ...job table already exists.
      ...langlinks table already exists.
      ...querycache_info table already exists.
      ...filearchive 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.
      ...have user_real_name field in user table.
      ...have user_token field in user table.
      ...have user_email_token field in user table.
      ...have user_registration field in user table.
      ...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 ss_total_pages field in site_stats table.
      ...have iw_trans field in interwiki table.
      ...have ipb_range_start field in ipblocks table.
      ...have ss_images field in site_stats table.
      ...already have interwiki table
      ...indexes seem up to 20031107 standards
      Already have pagelinks; skipping old links table updates.
      ...image primary key already set.
      The watchlist table is already set up for email notification.
      Adding missing watchlist talk page rows... ok
      ...user table does not contain old email authentication field.
      Logging table has correct title encoding.
      ...page table already exists.
      revision timestamp indexes already up to 2005-03-13
      ...rev_text_id already in place.
      ...page_namespace is already a full int (int(11)).
      ...ar_namespace is already a full int (int(11)).
      ...rc_namespace is already a full int (int(11)).
      ...wl_namespace is already a full int (int(11)).
      ...qc_namespace is already a full int (int(11)).
      ...log_namespace is already a full int (int(11)).
      ...already have pagelinks table.
      ...templatelinks table already exists
      No img_type field in image table; Good.
      Already have unique user_name index.
      ...user_groups table already exists.
      ...user_groups is in current format.
      ...wl_notificationtimestamp is already nullable.
      ...timestamp key on logging already exists.
      Setting page_random to a random value on rows where it equals 0...changed
0 rows
      Initialising "MediaWiki" namespace...


      Fatal error:  Call to undefined method DatabaseMysql::maxListLen() in
/home/ffprojec/public_html/forumwiki/maintenance/InitialiseMessages.inc on line 125
Comment 1 Domas Mituzas 2006-07-08 07:25:29 UTC 
working on it
Comment 2 Jules 2006-07-08 10:31:47 UTC 
Many thanks for working on it! Would you like the db user / pwd on my server ?

PS: install-utils.inc mentions that errors on that function may be due to
authentication problems of MySQL 5 versus 4.0, due to the password hashing size
differences betwen those versions...  I wonder if the script is hashing my 4.0
password with the larger 4.1 size. That would make all the "create table" and
like statements fail.
Comment 3 Rob Church 2006-07-08 11:08:01 UTC 
Incidentally, "ENGINE" *is* valid syntax as of a certain MySQL version, and
according to another bug on this tracker, "TYPE" stops being so when we hit a
certain version. Good old consistent MySQL AB, eh?

I'm irked to see those undefined constants errors. Has someone broken magic
words at the last minute or removed one of the if statements from Language.php
or MagicWords.php?
Comment 4 Jules 2006-07-08 17:09:12 UTC 
I think the undefined constants has to do with the php error level warnings
settings on my host. If I set it to ignore warnings on each php program it goes
away...

As for the ENGINE versus TYPE, that is what I guessed. Which lead me to believe
the tables.sql file and others have the wrong version commands sometimes. And
then I read that authentication changed the hashing of passwords significantly
from 4.0 to 4.1.... Makes me suspect my password is being hashed for 4.1 (longer
hash size) and MySQL is not accepting the db users, because it expects a 16 bit
password (smaller).
Comment 5 Jules 2006-07-08 17:43:39 UTC 
Fixed THAT error on InstallMessages.inc by setting a fixed number for chunks of
messages
	//$maxitems = $dbr->maxListLen();
	$maxitems = 100 ; //JD quick fix

Only to get another:

Setting page_random to a random value on rows where it equals 0...changed 0 rows
Initialising "MediaWiki" namespace...
A database error has occurred
Query: INSERT  INTO `ffwk_page`
(page_id,page_namespace,page_title,page_counter,page_restrictions,page_is_redirect,page_is_new,page_random,page_touched,page_latest,page_len)
VALUES
(NULL,'8','1movedto2','0','','0','1','0.736567087605','20060708173038','0','0')
Function: Article::insertOn
Error: 1062 Duplicate entry '8-1movedto2' for key 2 (localhost)

Backtrace:
GlobalFunctions.php line 451 calls wfBacktrace()
Database.php line 397 calls wfDebugDieBacktrace()
Database.php line 347 calls Database::reportQueryError()
Database.php line 937 calls Database::query()
Article.php line 951 calls Database::insert()
InitialiseMessages.inc line 205 calls Article::insertOn()
InitialiseMessages.inc line 72 calls initialiseMessagesReal()
updaters.inc line 823 calls initialiseMessages()
index.php line 606 calls do_all_updates()

---------------------
Since my users are screaming at me, I'm removing the key it's trying to insert again
Ditto for another error
Error: 1062 Duplicate entry '8-1movedto2_redir' for key 2 (localhost)
Comment 6 Jules 2006-07-08 18:42:36 UTC 
Augh!!!! It seems the entire namespace 8 is duplicate!!!
Looking at InstallMessages.inc it seems that it is comparing "page_title" to
DBkey which is namespace+page title. (line 190ish)
Meh... too complex for my limited wiki experience. Giving up..
Comment 7 Jules 2006-07-08 21:14:19 UTC 
OK, got it to skip that duplicate key error...
I figured out that the problem is comparing apples to oranges on line 192. This
happens because the $existingTitles loaded a bit 
before does not have "page_title" as key.
After much fiddling with InstallMessages.inc I figured out that line 111 had 
the source of $existingTitles pointing to $wgAllMessagesEn
---------------------------
# Get keys from $wgAllMessagesEn, which is more complete than the local language
	$first = true;
	if ( $messageArray ) {
		$sortedArray = $messageArray;
	} else {
		$sortedArray = $wgAllMessagesEn;
        }
--------------------------
by setting $messageArray = true, the script runs.

I got to see my homepage but the install is obviously very sccrewed up. I get
this on "Special:preferences"

<b>Fatal error</b>:  Call to undefined function:  wfemptymsg() in
<b>/home/ffprojec/public_html/forumwiki/skins/MonoBook.php</b> on line <b>146</b>

And other crazy errors..

At this point I'm scrapping the 1.7.0 install and going for 1.6  I wish I could
keep waiting for a bug fix but this is a live site

I can leave the Wiki the way it was when I first reported the error, on a
different folder so you guys can debug this 1.7.0 problem. 
Let me know if this is needed.

Thanks!

Jules 


	}
Comment 8 Brion Vibber 2007-01-15 22:49:52 UTC 
Does this still happen with 1.9.0 or can we close this?
Comment 9 Brion Vibber 2007-01-17 12:07:19 UTC 
Assuming all this stuff works now; seems a combination of things that have been
fixed and possible other errors.
Note You need to log in before you can comment on or make changes to this bug.
First Last Prev Next    This bug is not in your last search results.

Navigation
Links