FIXED: Accessing an undefined category causes SQL syntax error


Back to topics list
[post:319#2898]
Devil Doll

09/11/2008 03:51 PM

Reviews: 365
Posts: 1574

Example: http://anime.mikomi.org/by-key/undefined

[post:319#2902]
Rebecca

09/11/2008 09:52 PM

Reviews: 23
Posts: 773

Now it gives you a more reasonable error message. The only weird thing is if you go to say: http://anime.mikomi.org/by-key/undefined/Action Then it'll give you the contents of the Action category. (Normally it'd be the intersection of the results of the two categories.)

[post:319#2904]
Xenoknight

09/11/2008 10:37 PM

Reviews: 244
Posts: 514

"(Normally it'd be the intersection of the results of the two categories.)"

I noticed that too. When I want to search for two genres at once, I can't click next without losing the search as it reverts back to the original topic. Like when you have a "Harem/Fan Service Titles" double search on screen, when you go to hit next, it reverts back to just a "Harem" search. We have 80 harems and 220 fan-service titles. Once harem is clicked, it says 46 fan-service titles are available within the harem genre. With the double search displayed, it starts on page one and the dropbox says there are 8 pages of the double search criteria, but remember you can't hit next without it reverting back to the 80 harems.

You see the problem here? Not even the drop box there works as it still reverts back to the regular harem search.

Edited on 09/12/2008 08:53 AM.

[post:319#2905]
Devil Doll

09/11/2008 11:23 PM

Reviews: 365
Posts: 1574

I confirm Xenoknight's observation. Other than that, I'm fine with the fix of the SQL issue (I only stumbled over it when mistyping keywords while setting links via the [keyword:] namespace, I'm not even sure whether I could use two keywords here...?).

[post:319#2966]
Rebecca

09/17/2008 01:35 PM

Reviews: 23
Posts: 773

I didn't actually understand what you were talking about when you first wrote this, but I do now:

When viewing a compound by-key page, using the pager reverts to a view of only the first keyword.

[post:319#2967]
Xenoknight

09/17/2008 01:41 PM

Reviews: 244
Posts: 514

Can you fix that? Is their a way browse by the double keyword search? It would save alot of time when looking for new stuff to watch.

[post:319#2968]
Rebecca

09/17/2008 01:45 PM

Reviews: 23
Posts: 773

*eyeroll* Of course I can fix it. =) Give me a second to actually look into the problem. I was just sharing when I first figure out what the heck was meant. (I appreciate your eagerness but it also does seem to rub me the wrong way some times too.) It is, now, in fact, fixed.

Edited on 09/17/2008 01:53 PM.

Reply to this topic Start a new topic
Back to topics list

Community Anime Reviews

anime mikomi org