Notifications
Clear all

reviews.php (error)

5 Posts
2 Users
0 Reactions
1,911 Views
 Elle
(@jenny)
Posts: 594
Honorable Member
Topic starter
 

http://ink.accio.nu/reviews.php (I've tried reviews.php on all recently upgraded sites, also)

I was planning on creating something that showed all recent reviews for all stories etc but decided to go on reviews.php in case there was something like that anyway; I'm not sure if the errors are "OK" or whatever but yeah:

A fatal MySQL error was encountered.
Query: SELECT * FROM ink_fanfiction_categories WHERE parentcatid = '-1' ORDER BY displayorderORDER BY review.reviewid DESC LIMIT 0,25
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 'BY review.reviewid DESC LIMIT 0,25' at line 1

And with debug turned on:

Notice: Undefined variable: title in /home/accionu/public_html/ink/reviews.php on line 255

255: $tpl->assign("pagetitle", "<div id="pagetitle">"._REVIEWSFOR."$title"</div>");

... although I don't think that's really an error ...

Heads up. =D


archive: dramione.org
site: accio.nu

Available for skin/mod commission! πŸ™‚

 
Posted : 03/10/2007 9:02 am
(@tammy)
Posts: 2577
Member Moderator
 

The script never calls that page without supplying the ID of something that's been reviewed like a story or a series.  It's not a bug.  It's an error on your part in calling the page incorrectly.


 
Posted : 06/10/2007 1:00 am
 Elle
(@jenny)
Posts: 594
Honorable Member
Topic starter
 

Ah.

That makes more sense.

Possible to script it so if review.php gets called on its own it can display the latest reviews given? I was thinking of messing around with the if/elseif/else but because it kind of gets called "a lot" in the script I'm not sure whether that might just screw it up.


archive: dramione.org
site: accio.nu

Available for skin/mod commission! πŸ™‚

 
Posted : 06/10/2007 12:07 pm
(@tammy)
Posts: 2577
Member Moderator
 

No it's going to stay with the error message. 


 
Posted : 16/10/2007 12:42 am
 Elle
(@jenny)
Posts: 594
Honorable Member
Topic starter
 

Ah, OK then.

Thanks. πŸ™‚


archive: dramione.org
site: accio.nu

Available for skin/mod commission! πŸ™‚

 
Posted : 16/10/2007 4:22 pm
Share: