Forum Settings
       
Reply To Thread

Bug when listing 30 days changes on NPC spellsFollow

#1 Nov 22 2004 at 9:13 AM Rating: Decent
Just found this:
System error 
error: 	Could not get data: Unknown column 's.NPClevel' in 'where clause' at /home/lucy/htdocs/newcspells.html line 63. 
	 
context: 	 
... 		 
59: 	$datewhere and s.) . $class . qq(level < 255 and s.id=c.id	 
60: 	group by c.id order by c.id);	 
61: 		 
62: 	# $m->out($query);	 
63: 	my $sth = $dbh->prepare($query);	 
64: 	$sth->execute() || die "Could not get data: ", $dbh->errstr;	 
65: 	my $numfound = $sth->rows();	 
66: 		 
67: 	</%init>	 
... 		 
code stack: 	/home/lucy/htdocs/newcspells.html:63 
g /usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/Component.pm:134 
g /home/lucy/htdocs/autohandler:8 
g /usr/local/lib/perl5/site_perl/5.8.0/HTML/Mason/Component.pm:134 
g 

Looks like some error in your SQL select statement.
#2 Nov 22 2004 at 10:10 AM Rating: Excellent
***
2,553 posts
Thanks, untill I have time to go in and rewrite the bit that generates the sql, I've removed the link for NPC spells.
____________________________
--Illia
Fumus, draco magus incoluit mare.
Myrx - 70 Holy Priest, Myr - 70 Resto Shaman, Gryd - 70 Prot Warrior
Reply To Thread

Colors Smileys Quote OriginalQuote Checked Help

 

Recent Visitors: 182 All times are in CST
Anonymous Guests (182)