Wikia

LyricWiki

Talk:Sean Colombo/Archive/2009 July

2,761,038pages on
this wiki

Back to page | < User talk:Sean Colombo | Archive

Replacement filing cabinet This page is an archive of past discussions. Do not edit the contents of this page. If you wish to start a new discussion or revive an old one, please do so on the current talk page.
Replacement filing cabinet
Archive

API

REST API function request

Hi, I'm working with an application which downloads lyrics using the LyricWiki REST API. I'm planning to implement a search feature that'll let the user search for names of songs, albums or artists, but the API doesn't fully support this. For instance let's say the user want's to search for all songs called "Forget The Swan" but doesn't specify an artist, my application then request the page http://lyricwiki.org/api.php?func=getSong&song=Forget+The+Swan&fmt=xml What I would want is the api to return a list of all songs that has that name, something like this

<getSongResponse>
	<result>
		<song>Forget The Swan</song>
		<artist>Dinosaur Jr.</artist>
		<album>Dinosaur</album>
		<lyrics>
			...
		</lyrics>
	</result>
	<result>
		...
	</result>
</getSongResponse>

and similar result for searching for albums without specifying an artist. I can understand if it is a big request but I hope you will consider it

Edit: a better example would be a user searching for a song called "Believe" since there are numerous songs with that name.

Memil 11:37, 6 June 2009 (UTC)

Hi Memil,
We currently don't support a search via the API because it requires too much CPU/memory power. There are no plans to add a search to the API in the near future because of this problem. The last time I checked, the API did something like 50x the traffic of the site itself, so managing the computing overhead is pretty important (since it doesn't generate any revenue to offset its costs).
-Sean Colombo (talk|contribs) 01:16, 5 July 2009 (UTC)


Not Categorized Yet

The wonderful Senv

Sean I'm sure I'm asking this on behalf of many of us. Senv is (as always) doing a superb job with the assistance of his lwt. The only problem is that I can't see the wood for the trees. Meaning that since his edits are prolific and equate to bot edits, they flood my watchlist :( Since this is not a temporary thing, can you do something about it, e.g. give Senv+lwt a bot flag or something? Thanks.  Яєdxx Actions Words 12:46, 25 June 2009 (UTC)

EDIT: The best I can do to resolve this myself is click on my watchlist and then "hide patrolled edits" which helps but is obviously not ideal

Yeah, you're the third different person who's brought this up, lol. It's almost like we need a Cyborg flag for people who are people but have machine assistance ;). I'll talk with Senv and we'll figure out someting. Another temporary fix: instead of hiding patrolled edits, hide minor edits. :)
-Sean Colombo (talk|contribs) 14:56, 25 June 2009 (UTC)
Sorted now thanks!  Яєdxx Actions Words 07:56, 27 June 2009 (UTC)

Category:Language/English is disappearing

Less than 15,000 at the time of typing this (and shrinking fast). Same for other languages – Spanish ~ 1000, German ~ 1200. Could this be the same problem as with the disappearing albums from What Links Here, i.e. because of the pages being categorised from within a complex template? — 6×9 (Talk) 14:30, 4 May 2009 (UTC)

 :( yikes. Not sure on the cause, but your guess seems quite probable. I'll look into that when I get a sec. -Sean Colombo (talk|contribs) 14:34, 4 May 2009 (UTC)
Some of them have come back. Now English is around 20,500, sometimes growing a bit, sometimes shrinking a bit… Weird. — 6×9 (Talk) 18:10, 5 May 2009 (UTC)
Is over 40, 000 now  Яєdxx Actions Words 11:34, 26 May 2009 (UTC)
I don't understand why this was happening or what causes categorizations to actually register, but now this number is over 500,000.
-Sean Colombo (talk|contribs) 00:49, 5 July 2009 (UTC)

Transcluding album pages

The question why we don't simply transclude album pages onto artist pages has come up again. Would it be possible at all to rewrite the API to fetch the tracklist from the album page instead? Because it would be really cool to just use a template with just the album title and year as parameter and let it do the rest (not to mention save a LOT of space). — 6×9 (Talk) 16:10, 20 June 2009 (UTC)

Followed up on the conversation referenced here. -Sean Colombo (talk|contribs) 00:49, 5 July 2009 (UTC)

Traduce lyrics

I propose to traduce all languajes the lyrics if it was possible. Please, leave me your opinion in my discussion page in wikipedia]. I only talk spanish and understand little english. 83.49.95.31 18:19, 27 June 2009 (UTC)

Seeings as the person above only speaks Spanish, I think (s)he wants to propose translation of lyrics into all languages. Traducir is a Spanish word meaning "to translate", and does not mean "traduce" in English (to malign/libel etc.) --WillMak050389 23:57, 27 June 2009 (UTC)
Rfl I sure hope you're right Will ;)  Яєdxx Actions Words 23:12, 28 June 2009 (UTC)
I replied on his Spanish Wikipedia talk page.
-Sean Colombo (talk|contribs) 00:49, 5 July 2009 (UTC)

Page size

I know there is a parser function PAGESIZE, but would it be possible to have this info appear at the bottom of every page, by adding this to the "every single LW page template"?  Яєdxx Actions Words 05:11, 6 April 2009 (UTC)

Where were you thinking? In the footer (the part with the yellow line above/below it)? My guess is that it's probably do-able but I haven't checked yet. -Sean Colombo (talk|contribs) 15:29, 6 April 2009 (UTC)
Right at bottom of page where it says: "This page was last modified on 6 April 2009, at 20:30.   Privacy policy    About LyricWiki    Disclaimers"  Яєdxx Actions Words 16:35, 9 April 2009 (UTC)
Would it also be possible to add the "this page has been accessed x times" back? We used to have it in the footer, but we lost that after the major upgrade...tia ∃cho⚡ierr∀ ( ) 15:55, 6 April 2009 (UTC)
Sorry to say it, but that one (the number of page-hits) isn't coming back :( ...The reason it was gone is that we actually had to shut it off. Once you get past a certain amount of traffic, the code that tracks the views ends up taking so much time that the database doesn't have time for anything else (this happened to us). There is a setting to turn off that updating completely, which is what we had to do (Wikipedia and some other large wikis have to do the same thing). On the bright side, that number wasn't all that accurate anyway since it was only updated when the page was re-generated - and our Squid caching server makes it so that pages (especially popular pages) quite often don't need to be regenerated.
On the other hand, the Squid access-logs do have a decent log of what pages are getting requested, so we could write some sort of cron-job which would go through the logs and we could figure out the most popular pages for a given day/week/month and make SpecialPages with those listed on them or something. Also, I guess there could be a way to keep track accurately by parsing those same log-files, it would just take even more coding to do that right (and efficiently).
-Sean Colombo (talk|contribs) 16:15, 6 April 2009 (UTC)
Thanks Sean, always good to know the gory details. A special page that shows this info for any given page would also do the trick. One other stats related number would be the ratio of web access to api access for the entire site. cheers ∃cho⚡ierr∀ ( ) 18:21, 6 April 2009 (UTC)
If there was some way to check an individual page for its traffic, that would be helpful. I used to track, for instance, the number of hits that a page got with regards to the American Idol page. I tracked how many hits the page itself got for both data's sake (it usually increased over the first month or so and then plateaued for the rest of the season, as I recall) and also to ensure that people were actually visiting it. (No sense in doing the work if no one's using it!) Also, it was interesting to see if the links within were used. Normally the week after a song was listed, it would jump 30-90 hits, depending on the song. For a song that started out with perhaps 10-20 hits after perhaps being around for a couple of years, that was pretty amazing. It's not a huge/high priority, but perhaps something to put on your List of Infinite LyricWiki Tasks.  :-]    Kiefer    talk    contribs    admin   19:17, 6 April 2009 (UTC)

File:Hunter Valentine.jpg

Sean, I'm trying to delete some duplicate images but system is throwing a wobbly when I try to delete this artist image...says something about web directory not being writable..? It's the first artist image that I've tried to delete but I reckon it probably applies to them all.  Яєdxx Actions Words 23:11, 28 June 2009 (UTC)

Old revisions actually… duplicate images is something else. </nitpicking> — 6×9 (Talk) 23:38, 28 June 2009 (UTC)
No, I'm not debating this with you 6.. I'd win anyway ;)  Яєdxx Actions Words 23:45, 28 June 2009 (UTC)
This is the actual error message I got when I tried: Error deleting file: The archive directory "deleted/q/1/c" is not writable by the webserver. Hope that clarifies something. --WillMak050389 04:28, 29 June 2009 (UTC)
Thanks Will yes that's the one. I just copied error message to post here. Sorry I was a bit too tired last night to do it - call it "Tony Bennetted out" lol.  Яєdxx Actions Words 11:30, 29 June 2009 (UTC)

I just tried to delete File:Stone Temple Pilots The Big Empty.svg and got Warning: mkdir() [function.mkdir]: Permission denied in /var/www/html/lyricwiki.org/includes/GlobalFunctions.php on line 1944 and Error deleting file: Could not create directory "deleted/e/w/d".6×9 (Talk) 19:51, 1 July 2009 (UTC)

Should be fixed now... this time permanently. Thanks for the helpful debugging info! -Sean Colombo (talk|contribs) 11:50, 2 July 2009 (UTC)

Google search

Hi Sean!
I'm registered at some others Wikis as well and one of them is interested in replacing the MediaWiki default search with a Google search. I remembered that I had seen it here and looked you up at Special:Version. I'm really curious on how you managed this implementation. Would you be willing to share the knowledge? (o.O)
Greetz, zai (talk|contribs) 15:46, 27 June 2009 (UTC)

Hi zai,
Sorry for the delay in getting back to you. For whatever reason, I thought I had replied to you already. To use Google Site Search on the wiki, just sign up for Google AdSense and they will let you create search boxes with certain settings for how the search will work. To actually cram the search box onto the page, just edit /skins/Monobook.php or whatever your skin file is, and then tweak it until it looks right. If you view the source-code of a LyricWiki page, that should help for tweaking the appearance.
Good luck with it... let me know if you need any more help!
-Sean Colombo (talk|contribs) 00:13, 5 July 2009 (UTC)
Oh hey, thx for the reply!! Was/is a big help and much appreciated :-)
I'll forward it and come back in case we run into trouble.
Greetz, zai (talk|contribs) 16:12, 5 July 2009 (UTC)

Mediawiki API

I am planning on creating a PHP based bot that could use the API described here and here. I have just realised that the API on LW is set up to give lyrics/artists/songs/etc. only. I would build my bot from scratch (I think) retrieving the page source, parsing it through my search terms and submitting it as an edit. This will allow me to do more flexible edits then replace.py (such as getting wikipedia info from artist footer and putting it in the header). As the source code is available for the MW php API, I am asking if you could go about implementing it on LW alongside the current API (when it suits you of course). Greatly appreciated, ♫Humbug(Talk Ctrb) 10:34, 29 December 2008 (UTC)

Hi Humbug,
We actually do have that API set up also. They created the MediaWiki version just a few months after ours, and unfortunately we both ended up using the same filename (api.php) :/... anyway, when we upgraded to the new version of MediaWiki, the API came along with it, but we just moved it to another URL. Use this: http://lyricwiki.org/mw_api.php
Sorry for the confusion,
-Sean Colombo (talk|contribs) 15:42, 29 December 2008 (UTC)
Awesome, thanks. I thought it would be around somewhere!
Also, regarding the previous section... (I'll put it up there) ♫Humbug(Talk Ctrb) 00:24, 30 December 2008 (UTC)
I have a possible bug/question or something. [1] gives me an error which I'm pretty sure shouldn't be there (the same query works on the MW api.php: [2]).
That does look like a bug... probably caused by our .htaccess redirect tricks that move the request all around. I'll look into it. Thanks for the info.
-Sean Colombo (talk|contribs) 21:29, 8 January 2009 (UTC)
I still don't get this. It doesn't look like the request is being rewritten, and yet for some reason, the code reads "mw_api.php" as being set as the "title". Even if I change all of the server vars to use "api.php" instead of "mw_api.php", it still reads "api.php" as the title.
There are a couple more things I can look into...
-Sean Colombo (talk|contribs) 20:49, 5 July 2009 (UTC)
W00t! Finally got it. Had to write an extension for it to clear out some variable... long story. Very strange. Anywho... it works now!
-Sean Colombo (talk|contribs) 01:37, 6 July 2009 (UTC)

Around Wikia's network

Random Wiki