|
music section
Link |
by wildshot08
on 2010-08-21 05:25:00
|
|
Every time i click the music section this message appears can't seem to access it. I'm wondering why it happened though last time i visited it was fine. Error writing file '/tmp/MYyRNw4k' (Errcode: 28) Original SQL: SELECT anime, artist, type, time, fsize, lyrics, hasLyrics, playid, yesid, itunes, catno, asin, partno, buy, vscore, id, name, added, online, added >= 100820 AS isNew FROM Amusic ORDER BY added DESC, id DESC LIMIT 0, 20 |
|
Re: music section
Link |
by
on 2010-08-21 05:34:01 |
theres some problems in the server, bear with it till gendou fixed it himself  |
|
Re: music section
Link |
by wildshot08
on 2010-08-21 05:35:00
|
| okay thanks for answering just want to know.. |
|
Re: music section
Link |
by
on 2010-08-21 05:57:46 (edited 2010-08-21 08:00:22)
|
Temporary solutions for this is to type the keywords on the address bar using this:http://gendou.com/q/(type the anime/music you want to search)For example, I wanna search for Highschool of the Dead songs, just type "highschool of the dead" the address bar. Should look like this: http://gendou.com/q/highschool of the dead Or, you can use the Quick search on the navbar. This one:  Click on the "Q" beside the Download link to toggle quick search.  |
|
Re: music section
Link |
by
on 2010-08-21 06:27:02 |
|
Haha I just began studying about SQL database query statements and woot, came this error. Given me some examples of how SQL statements are like for a particular website ^^
Humans are just robots with limited flexibility.
|
|
Re: music section
Link |
by
on 2010-08-21 13:41:20 |
|
I didn't want to make another thread, but also note there's a similar error for viewing your own forum posts. I haven't checked elsewhere to see if there's a similar issue, if I find any I'll report them for you guys. 
------- |
|
Re: music section
Link |
by
on 2010-08-21 15:32:50 (edited 2010-08-21 16:04:10)
|
|
My retarded web host has stupidly allocated only 1MB of space to the /tmp directory, so any MySQL operations which use filesort on table ranges greater than 1MB are guaranteed to fail!!! I am working with them to fix the problem ASAP! UPDATE: Problem solved.... For now. 
|