[post:448#3959]
Devil Doll
05/22/2010 08:50 AM
Reviews: 365
Posts: 1574
|
series 1815 (Blue Dragon: Tenkai no Shichi Ryuu) is not accessible (regardless of the type of link being used):
System error
error: DBD::mysql::st execute failed: Subquery returns more than 1 row at /opt/perl/site_lib/5.8.8/DBIx/Abstract.pm line 339.
context:
...
335: " SQL: $sqln".
336: "STACK TRACEn".
337: Carp::longmess()."n";
338: }
339: if (!$sth->execute(@bind_values)) {
340: eval('use Carp;');
341: die 'DBIx::Abstract (execute): '.$sth->errstr."n".
342: " SQL: $sqln".
343: "STACK TRACEn".
...
code stack: /opt/perl/site_lib/5.8.8/DBIx/Abstract.pm:339
/opt/perl/site_lib/5.8.8/DBIx/Abstract.pm:370
/opt/www/anime/html/comp/series_sparkline:10
/opt/perl/site_lib/5.12.0/HTML/Mason/Request.pm:848
/opt/www/anime/html/comp/series_sparkline:8
/opt/www/anime/html/series.html:86
/opt/www/anime/html/autohandler:98
The message text appears to indicate that the database contains a duplicate entry for this anime ("abstract" = synopsis?) where the SQL query doesn't expect one, i. e. this would be an issue only for this anime.
|
Loading, please wait... |
|
[post:448#4022]
Rebecca
06/13/2010 09:12 AM
Reviews: 23
Posts: 772
|
No, it actually has to do with when the page table, which tracks every unique page generated by the site, ends up with more then one entry for that particular series page. This is used as part of hit tracking. This is happening due to a combination of a race condition and insufficient constraints on the database. Beyond fixing that part, I've made the sparkline generation sufficiently robust that it won't die should this happen again.
So all that means, fixed. =)
|
Loading, please wait... |
|