Last modified: 2010-05-15 15:40:39 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
working on it
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.
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?
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).
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)
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..
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 }
Does this still happen with 1.9.0 or can we close this?
Assuming all this stuff works now; seems a combination of things that have been fixed and possible other errors.