This Might Be A Migration Issue Tracker Page

From This Might Be A Wiki

Please use this page to help us track issue with

  • The move to new web server hardware
  • Re-upgrade from mysql 3 to mysql 4.

What Has Changed[edit]

Date: 6/5/2006
Prior Upgrade: New Server and MediaWiki 1.4.12 Migration Issue Tracker Page
Next Upgrade: MediaWiki 1.6.7 Issue Tracker Page
Summary of Changes:

Item Old Version New Version Notes
Hosting GoDaddy Fellowsites
MySQL 3.0 4.0 The site had previously been on MySQL 4, but when we moved to GoDaddy, it only supported version 3.


Main Page[edit]

I just accessed and got the site's directory. So that's a problem. I needed to add "wiki/index.php/Main_Page" to the end to get to the main page. --badqueso 02:02, 6 Jun 2006 (MDT)

Fixed. --05:08, 6 Jun 2006 (MDT)Scott Redd

Song Voting System[edit]

The song voting system is messed up. New votes aren't recorded, and it says the song doesn't have enough votes to rank. Looks like it's making a new database. - Whirrrlwind (Woosh!) 04:23, 6 Jun 2006 (MDT)

I tried, and it worked for me, but it could always be something song-specific. Can you tell me which song(s) you have tried voting for? --Duke33 05:19, 6 Jun 2006 (MDT)
I was working on the Man, It's So Loud In Here pages when I noticed an error in the voting frame, and that my vote was gone. I voted again and it said that there aren't enough votes for the song (which I know isn't true). When I just returned to the page to check, the vote field was gone. It says:
Parse error: parse error, unexpected T_VARIABLE in /home/tmbwnet/public_html/votes/single_vote_query.php3 on line 31
In case this is of any help for you. - Whirrrlwind (Woosh!) 05:43, 6 Jun 2006 (MDT)
Yeah, i think i know part of the problem...looks like it's something with songs that have apostrophes...It might take me a while today, but i'll get it working later tonite, promise.--Duke33 05:59, 6 Jun 2006 (MDT)
Memo to myself:
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/tmbwnet/public_html/votes/insert_vote_logic.php3 on line 64
Ok - i think i've fixed all the problems. If you run into any issues, please let me know. --Duke33 20:17, 6 Jun 2006 (MDT)
Noticed one little problem with songs like Gloria Says "Blast Her Out". Will investigate later. --Duke33 06:58, 7 Jun 2006 (MDT)
Think that's fixed now too.

Copying Tagline[edit]

Looks like there is a problem with the bot that copies taglines to the archival page. [1]. I will take care of it. --Duke33 05:16, 7 Jun 2006 (MDT)

Fixed - it actually had nothing to do with the move at all. CapitalQ thought he'd get fancy, and remove the comment tags from the page, which busted my script.  :) --Duke33 19:54, 7 Jun 2006 (MDT)
Hahahaha, I had no idea TMBaB checked for that. Whoopsie. :D -CapitalQtalk ♪ 19:56, 7 Jun 2006 (MDT)

Interp. Pages and TMBaB[edit]

It seems TMBaB has been adding [[Category:|{{PAGENAMEE}}]] or [[Category|{{PAGENAMEE}}]] to the bottom of interpretations (such as Bastard), while it should be adding [[Category:Interpretations:|{{PAGENAMEE}}]] instead. -CapitalQtalk

Fixed --Duke33 18:47, 7 Jun 2006 (MDT)

Not Searching[edit]

I attempted a boolean search (John not Flansburgh) and got a database query syntax error. The gist of the message:

from within function "". MySQL returned error "1064: 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 '(MATCH (si_title) AGAINST ('Flansburgh')) ) AND cur_namespace (localhost)".

Is this not allowed anymore (or was it ever) or is it a migration error? This Might Be A Wiki:Searching says it's allowed. It should be noted that "or" and "and" work. --badqueso 03:14, 12 Jun 2006 (MDT)

We noticed that in the last upgrade - see the New Server and MediaWiki 1.4.12 Migration Issue Tracker Page. I thought that it was something with the old server and possibly our downgrade to mysql 3.0 at the time, but since it is occurring here as well, I'm guessing it's a bug with MediaWiki 1.4.12 --Duke33 06:31, 12 Jun 2006 (MDT)

Error 1062[edit]

Sorry for posting more errors when this page seems to be settled, but this one is happening way too frequently. It happens randomly whenever I load a new page:

from within function "MediaWikiBagOStuff:_doquery". MySQL returned error "1062: Duplicate entry 'tmbwnet_wikidb:messages:Sitenotice' for key 1 (localhost)".

I don't know what you guys can do about it, but I just reload the page and it'll work. --badqueso 13:05, 15 Jun 2006 (MDT