This Might Be A Wiki:New Server and MediaWiki 1.4.12 Migration Issue Tracker Page

Please use this page to help us track issue with

• The move to new web server hardware
• The upgrade to MediaWiki 1.4.12

What Has Changed

Date: 2/4/2006
Prior Upgrade: MediaWiki 1.4.11 Migration Issue Tracker Page
Next Upgrade: Fellowsites.org Migration Issue Tracker Page
Summary of Changes:

Item	Old Version	New Version	Notes
Hosting	Scott's Server	GoDaddy
MediaWiki	1.4.11	1.4.12

Problems

Searching Issue For "Dan And Lisa"

• Wow, this is weird. Do a search for Dan And Lisa. It returns this SQL error:

A database query syntax error has occurred. This may indicate a bug in the software. The last attempted database query was:

    (SQL query hidden)

from within function "". MySQL returned error "1064: You have an error in your SQL syntax near 'AND (MATCH (si_title) AGAINST ('lisa')) ) AND cur_namespace IN (0,1,2,3,4,5,6,7' at line 1 (localhost)".

Can we test this on the old server, to see if it happened there as well? And, if anyone sees this happen with any other searches, please post the search entry here. --Duke33 12:35, 7 Feb 2006 (CST)

I've figured out when it happens, it's whenever you do a search for 'and', and then a word. So if you search for anything with 'and' followed by a word, such as just "and fudge," it'll produce the error. -CapitalQ ♫ talk ♪ 16:38, 7 Feb 2006 (CST)

The problem also occurs when searching for 'or' followed by a word. I'm guessing the wiki, much like search engines (other than Google), produces different results when adding 'and' or 'or' into a query. -CapitalQ ♫ talk ♪ 16:47, 7 Feb 2006 (CST)

Solved problems

Missing images

• Movie poster at Sensurround missing, kid pics of Linnell and Flansburgh that Ecks uploaded are now missing, and a lot of other images are missing.

Could it be that pictures and such uploaded after a certain point weren't moved?

Yes, we need to do one last image sync. --SR

Fixed! If you still see a page with a missing image, make an incredibly minor change to it (just add a space in between lines or something), save, and the image should work again.

Show attendance

• You can't mark yourself present for a show, because you see this even if you're logged into the Wiki:

Wikians At This Show
No wikians have attended this show.

You must be logged in to mark yourself as having attended this show

Also, any shows which were marked as attended by anyone before the migration now say No wikians have attended this show.

I've fixed this now. Had to modify my scripts. Will tackle song votes next.--Duke33 07:13, 7 Feb 2006 (CST)

Voting

• Voting isn't working.

Or rather, all votes have been blanked. The votes are, indeed, there. The code to display them needs some attention. --SR

Urgh, what the heck is going on? It's connecting to the db properly. I verified that. I'm not sure why it's not getting the data ok though. Perhaps it has something to do with the fact that we moved down to mysql 3.0??? --Duke33 16:34, 4 Feb 2006 (CST)

Ok, i looked again. Scott, can you look at the server? For some reason, it seems that certain parameters being passed onto the URL are being ignored. Dunno if it's something in the apache config? Here's a test script I wrote. It should output the values passed on each parameter. As you'll notice, the results are blank. test script for Scott^{Link Removed} --Duke33 19:29, 4 Feb 2006 (CST)

Based on more input from Scott, I did some digging and found this: php.net. Looks like it is set by default to not accept variables passed in on the command line. I think if we edit the php.ini file, that could fix it. I'll have to ask Scott to do that. --Duke33 15:43, 5 Feb 2006 (CST)

Ok, it's working, BUT, it does not work for songs that have apostrophes or other URL encoding. I will take care of that. --Duke33 16:56, 7 Feb 2006 (CST)

Voting for all songs is working. Once i dug into the code, i can't for the life of me figure out how it was ever working for songs with apostrophes, but it obviously was somehow!--Duke33 06:09, 8 Feb 2006 (CST)

Voting CSS

• The CSS on the voting pages is messed up. I need to fix it. See this page^{Link Removed}.

Here's the code that is busted:

/*<![CDATA[*/ @import "http://tmbw.net/wiki/index.php?title=-&action=raw&smaxage=0&gen=css";

Should be:

/*<![CDATA[*/ @import "/wiki/index.php?title=MediaWiki:Monobook.css&action=raw&ctype=text/css&smaxage=18000";

Should be fixed now, i believe. If anyone sees any more problems, let me know. --Duke33 08:25, 9 Feb 2006 (CST)

Breakdown

When you vote, you can't see how others voted for the song anymore. -Ecks

Oh yeah...i was doing some maintenance, and removed that page intentionally. --Duke33 14:28, 10 Feb 2006 (CST)

Tons of [Edit]'s at the bottom of Don't Let's Start EP

• I don't know if this is just an issue with coding or what, but the edit buttons on the Don't Let's Start (EP) are down near the bottom of the page, but when editing, everything looks fine in the "code" if you will. --ArAn 10:37, 4 Feb 2006 (CST)

Ok, so it's kind of cheating, but i removed the old image, and it's ok. If someone wants to re-upload it and add it back in, that's cool. --Duke33 11:33, 13 Feb 2006 (CST)

Taglines

• ThisMightBeABot hasn't copied any taglines over to Previous Taglines since February 2nd. -CapitalQ ♫ talk ♪ 11:03, 27 Feb 2006 (CST)

Yeah, he's still not working, due to some problems i've been having with him on this server. Still working on him! --Duke33 11:36, 27 Feb 2006 (CST)

Uploading

• Uploading images produces this error:

Internal error

Could not copy file "/tmp/phpblPvzd" to "/var/www/vhosts/tmbw.net/httpdocs/wiki/images/5/58/(Image name).jpg".

Fixed! Please try again and let me know if it fails. --SR

Uploading seems to work for every image format except jpgs (and jpegs), which still produce that error. -CapitalQ ♫ talk ♪ 11:01, 27 Feb 2006 (CST)

I'd say jpg's are the most commonly used picture format on this server. could this function be fixed so jpg's could be uploaded again? I have some images of TMBG EP covers CD's in jpg format, but they won't upload since they are jpg's. -Nosaj56 21:08, 4 Mar 2006 (CST)

It seems to be a sort of naming issue with the files. Add a number to the beginning of the filename (1blah.jpg), and it'll upload fine. At least it works that way for me. -CapitalQ ♫ talk ♪ 21:09, 4 Mar 2006 (CST)

Try it again...we were doing some backups, and we were out of space on the machine, so it might not have been allowing certain files to be copied over. See if it's still happening. --Duke33 09:51, 7 Mar 2006 (CST)