FIXED: Special characters in episode names make their pages inaccessible

I added an episode named "Yūki" to To Heart 2 adnext.

Clicking on the link to this episode on the anime page, i. e. http://anime.mikomi.org/episode/2374/Y%C5%ABki.html, has interesting results, most notably different results in different web browsers.

In Firefox 3.6.13, the request leads to a Firefox error message:

Error: Redirection error. The requested website redirects the request so that it can never be completed." (translated by me, I have no English Firefox at hand).

In MSIE 8.0, the CAR server runs into an Internal Server Error with the following trace data:

System error

error: DBD::mysql::st execute failed: 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 ') AND series_title.type != 'invisible'' at line 6 at /opt/perl/site_lib/5.8.8/DBIx/Abstract.pm line 339.

context: ...
335: " SQL: $sql\n".
336: "STACK TRACE\n".
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: $sql\n".
343: "STACK TRACE\n".
...

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/data/search:62
/opt/www/anime/html/by-search.html:8
/opt/www/anime/html/autohandler:98

raw error
DBD::mysql::st execute failed: 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 ') AND
series_title.type != 'invisible'' at line 6 at /opt/perl/site_lib/5.8.8/DBIx/Abstract.pm line 339.
Trace begun at /opt/perl/site_lib/5.12.0/HTML/Mason/Exceptions.pm line 129
HTML::Mason::Exceptions::rethrow_exception('DBD::mysql::st execute failed: 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 \') AND^J series_title.type != \'invisible\'\' at line 6 at /opt/perl/site_lib/5.8.8/DBIx/Abstract.pm line 339.^J') called at /opt/perl/site_lib/5.8.8/DBIx/Abstract.pm line 339
DBIx::Abstract::__literal_query('DBIx::Abstract=HASH(0x90cda28)', 'SELECT^J COUNT( DISTINCT series_title.id )^JFROM series^J INNER JOIN series_title ON series.id = series_title.series_id^JWHERE^J ( ) AND^J series_title.type != \'invisible\'^J ^J') called at /opt/perl/site_lib/5.8.8/DBIx/Abstract.pm line 370
DBIx::Abstract::query('DBIx::Abstract=HASH(0x90cda28)', 'SELECT^J COUNT( DISTINCT series_title.id )^JFROM series^J INNER JOIN series_title ON series.id = series_title.series_id^JWHERE^J ( ) AND^J series_title.type != \'invisible\'^J ^J') called at /opt/www/anime/html/data/search line 62
HTML::Mason::Commands::__ANON__('search', '', 'adult', 1, 'per_page', 10, 'start', 1, 'google', 0) called at /opt/perl/site_lib/5.12.0/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9101140)', 'search', '', 'adult', 1, 'per_page', 10, 'start', 1, 'google', 0) called at /opt/perl/site_lib/5.12.0/HTML/Mason/Request.pm line 1297
eval {...} at /opt/perl/site_lib/5.12.0/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, 'search', '', 'adult', 1, 'per_page', 10, 'start', 1, 'google', 0) called at /opt/www/anime/html/by-search.html line 8
HTML::Mason::Commands::__ANON__('vars', 'HASH(0x90ce268)', 'tdir', '/themes/default', 'path_info', '', 'search', '') called at /opt/perl/site_lib/5.12.0/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x9092168)', 'vars', 'HASH(0x90ce268)', 'tdir', '/themes/default', 'path_info', '', 'search', '') called at /opt/perl/site_lib/5.12.0/HTML/Mason/Request.pm line 1302
eval {...} at /opt/perl/site_lib/5.12.0/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'vars', 'HASH(0x90ce268)', 'tdir', '/themes/default', 'path_info', '', 'search', '') called at /opt/perl/site_lib/5.12.0/HTML/Mason/Request.pm line 1355
HTML::Mason::Request::scomp('HTML::Mason::Request::CGI=HASH(0x90cdec8)', 'HTML::Mason::Component::FileBased=HASH(0x9092168)', 'vars', 'HASH(0x90ce268)', 'tdir', '/themes/default', 'path_info', '', 'search', '') called at /opt/www/anime/html/autohandler line 98
HTML::Mason::Commands::__ANON__('search', '') called at /opt/perl/site_lib/5.12.0/HTML/Mason/Component.pm line 135
HTML::Mason::Component::run('HTML::Mason::Component::FileBased=HASH(0x8f4e170)', 'search', '') called at /opt/perl/site_lib/5.12.0/HTML/Mason/Request.pm line 1297
eval {...} at /opt/perl/site_lib/5.12.0/HTML/Mason/Request.pm line 1292
HTML::Mason::Request::comp(undef, undef, undef, 'search', '') called at /opt/perl/site_lib/5.12.0/HTML/Mason/Request.pm line 481
eval {...} at /opt/perl/site_lib/5.12.0/HTML/Mason/Request.pm line 481
eval {...} at /opt/perl/site_lib/5.12.0/HTML/Mason/Request.pm line 433
HTML::Mason::Request::exec('HTML::Mason::Request::CGI=HASH(0x90cdec8)') called at /opt/perl/site_lib/5.12.0/HTML/Mason/CGIHandler.pm line 190
eval {...} at /opt/perl/site_lib/5.12.0/HTML/Mason/CGIHandler.pm line 190
HTML::Mason::Request::CGI::exec('HTML::Mason::Request::CGI=HASH(0x90cdec8)') called at /opt/perl/site_lib/5.12.0/HTML/Mason/Interp.pm line 342
HTML::Mason::Interp::exec(undef, undef, 'search', '') called at /opt/perl/site_lib/5.12.0/HTML/Mason/CGIHandler.pm line 121
eval {...} at /opt/perl/site_lib/5.12.0/HTML/Mason/CGIHandler.pm line 121
HTML::Mason::CGIHandler::_handler('HTML::Mason::CGIHandler=HASH(0x8f2d858)', 'HASH(0x90693a0)') called at /usr/local/bin/mason-http line 217
eval {...} at /usr/local/bin/mason-http line 215
HTTP::MasonServer::handle_request('HTTP::MasonServer=HASH(0x8f1ff88)', 'CGI=HASH(0x9069190)') called at /opt/perl/site_lib/5.12.0/HTTP/Server/Simple/CGI.pm line 154
eval {...} at /opt/perl/site_lib/5.12.0/HTTP/Server/Simple/CGI.pm line 154
HTTP::Server::Simple::CGI::handler('HTTP::MasonServer=HASH(0x8f1ff88)') called at /usr/local/bin/mason-http line 186
HTTP::MasonServer::handler('HTTP::MasonServer=HASH(0x8f1ff88)') called at /opt/perl/site_lib/5.12.0/HTTP/Server/Simple.pm line 401
HTTP::Server::Simple::__ANON__('HTTP::MasonServer::NetServer0=HASH(0x8f32b48)') called at /opt/perl/site_lib/5.12.0/Net/Server.pm line 141
Net::Server::run_client_connection('HTTP::MasonServer::NetServer0=HASH(0x8f32b48)') called at /opt/perl/site_lib/5.12.0/Net/Server/PreFork.pm line 273
eval {...} at /opt/perl/site_lib/5.12.0/Net/Server/PreFork.pm line 273
Net::Server::PreFork::run_child('HTTP::MasonServer::NetServer0=HASH(0x8f32b48)') called at /opt/perl/site_lib/5.12.0/Net/Server/PreFork.pm line 229
Net::Server::PreFork::run_n_children('HTTP::MasonServer::NetServer0=HASH(0x8f32b48)', 1) called at /opt/perl/site_lib/5.12.0/Net/Server/PreFork.pm line 455
Net::Server::PreFork::coordinate_children('HTTP::MasonServer::NetServer0=HASH(0x8f32b48)') called at /opt/perl/site_lib/5.12.0/Net/Server/PreFork.pm line 401
Net::Server::PreFork::run_parent('HTTP::MasonServer::NetServer0=HASH(0x8f32b48)') called at /opt/perl/site_lib/5.12.0/Net/Server/PreFork.pm line 147
Net::Server::PreFork::loop('HTTP::MasonServer::NetServer0=HASH(0x8f32b48)') called at /opt/perl/site_lib/5.12.0/Net/Server.pm line 116
Net::Server::run('HTTP::MasonServer::NetServer0', 'port', 8000) called at /opt/perl/site_lib/5.12.0/HTTP/Server/Simple.pm line 271
HTTP::Server::Simple::run('HTTP::MasonServer=HASH(0x8f1ff88)') called at /usr/local/bin/mason-http line 81

HTTP::MasonServer::run('HTTP::MasonServer=HASH(0x8f1ff88)') called at /usr/local/bin/mason-http line 356

Edited on 01/19/2011 03:43 AM.

This is fixed.

Two errors there, first, I assumed that any non ASCII URL characters would be encoded by the browser, foolish, I know. Second, I assumed that my URL decoder would extract into characters and not bytes.

Confirmed. Given that episode Yūki of To Heart 2 adnext carries the content now I don't have any use for the episode Yuuk of To Heart 2 adnext entry any more - is there a way to delete the latter?

Sure, I can do that.

This thread apparently can be renamed to "FIXED: ".

Not yet, I have to delete the stray episode.