Created
October 2, 2012 16:55
-
-
Save Kellyreid/3821067 to your computer and use it in GitHub Desktop.
orphan tcg names
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| %YAML 1.1 | |
| --- | |
| <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" | |
| "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> | |
| <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en" dir="ltr"> | |
| <head> | |
| <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> | |
| <link rel="icon" href="./favicon.ico" type="image/x-icon" /> | |
| <link rel="shortcut icon" href="./favicon.ico" type="image/x-icon" /> | |
| <title>phpMyAdmin</title> | |
| <link rel="stylesheet" type="text/css" href="phpmyadmin.css.php?server=1&token=58ae5d4f55ee483af11ff718a97b0652&js_frame=right&nocache=5387880746" /> | |
| <link rel="stylesheet" type="text/css" href="print.css" media="print" /> | |
| <link rel="stylesheet" type="text/css" href="./themes/pmahomme/jquery/jquery-ui-1.8.custom.css" /> | |
| <meta name="robots" content="noindex,nofollow" /> | |
| <script src="./js/cross_framing_protection.js?ts=1344778698" type="text/javascript"></script> | |
| <script src="./js/jquery/jquery-1.4.4.js?ts=1344778698" type="text/javascript"></script> | |
| <script src="./js/update-location.js?ts=1344778698" type="text/javascript"></script> | |
| <script src="./js/config.js?ts=1344778698" type="text/javascript"></script> | |
| <script src="./js/functions.js?ts=1344778698" type="text/javascript"></script> | |
| <script src="./js/jquery/jquery.qtip-1.0.0.min.js?ts=1344778698" type="text/javascript"></script> | |
| <script src="./js/messages.php?lang=en&db=kelly_tcgplayer&token=58ae5d4f55ee483af11ff718a97b0652" type="text/javascript"></script> | |
| <script type="text/javascript"> | |
| // <![CDATA[ | |
| // Updates the title of the frameset if possible (ns4 does not allow this) | |
| if (typeof(parent.document) != 'undefined' && typeof(parent.document) != 'unknown' | |
| && typeof(parent.document.title) == 'string') { | |
| parent.document.title = 'host2.quietspeculation.com / localhost / kelly_tcgplayer / recent_quotes | phpMyAdmin 3.4.11.1'; | |
| } | |
| // ]]> | |
| </script> | |
| <meta name="OBGZip" content="true" /> | |
| <!--[if IE 6]> | |
| <style type="text/css"> | |
| /* <![CDATA[ */ | |
| html { | |
| overflow-y: scroll; | |
| } | |
| /* ]]> */ | |
| </style> | |
| <![endif]--> | |
| </head> | |
| <body> | |
| <div id="prefs_autoload" class="notice" style="display:none"> | |
| <form action="prefs_manage.php" method="post"> | |
| <input type="hidden" name="token" value="58ae5d4f55ee483af11ff718a97b0652" /> | |
| <input type="hidden" name="json" value="" /> | |
| <input type="hidden" name="submit_import" value="1" /> | |
| <input type="hidden" name="return_url" value="export.php?" /> | |
| Your browser has phpMyAdmin configuration for this domain. Would you like to import it for current session? <br /> | |
| <a href="#yes">Yes</a> / <a href="#no">No</a> | |
| </form> | |
| </div> | |
| <div id="serverinfo"> | |
| <a href="main.php?token=58ae5d4f55ee483af11ff718a97b0652" class="item"> <img class="icon" src="./themes/pmahomme/img/s_host.png" width="16" height="16" alt="" /> | |
| localhost</a> | |
| <span class="separator"><img class="icon" src="./themes/pmahomme/img/item_ltr.png" width="5" height="9" alt="-" /></span> | |
| <a href="db_structure.php?db=kelly_tcgplayer&token=58ae5d4f55ee483af11ff718a97b0652" class="item"> <img class="icon" src="./themes/pmahomme/img/s_db.png" width="16" height="16" alt="" /> | |
| kelly_tcgplayer</a> | |
| <span class="separator"><img class="icon" src="./themes/pmahomme/img/item_ltr.png" width="5" height="9" alt="-" /></span> | |
| <a href="sql.php?db=kelly_tcgplayer&table=recent_quotes&token=58ae5d4f55ee483af11ff718a97b0652" class="item"> <img class="icon" src="./themes/pmahomme/img/s_tbl.png" width="16" height="16" alt="" /> | |
| recent_quotes</a> | |
| </div> | |
| <!-- PMA-SQL-ERROR --> | |
| <div class="error"><h1>Error</h1> | |
| <p><strong>SQL query:</strong> | |
| <a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.0%2Fen%2Fselect.html&token=58ae5d4f55ee483af11ff718a97b0652" target="mysql_doc"><img class="icon" src="./themes/pmahomme/img/b_help.png" width="11" height="11" alt="Documentation" title="Documentation" /></a><a href="tbl_sql.php?sql_query=SELECT+tcg_set_name+%2C+name+FROM+tcg_set_names++RIGHT+JOIN+card_sets++ON+tcg_set_name+%3D+name+%29+a++++WHERE+%28%28%60a%60.%60tcg_set_name%60+IS+NULL+AND+%60a%60.%60name%60+%3D+%27Magic+2011%27%29%29+AND+%28++a.tcg_set_name+IS+NULL+OR+a.name+IS+NULL++%29&show_query=1&db=kelly_tcgplayer&table=recent_quotes&token=58ae5d4f55ee483af11ff718a97b0652"><span class="nowrap"><img src="./themes/pmahomme/img/b_edit.png" title="Edit" alt="Edit" class="icon" width="16" height="16" /> Edit</span></a> </p> | |
| <p> | |
| <span class="syntax"><span class="inner_sql"><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.0%2Fen%2Fselect.html&token=58ae5d4f55ee483af11ff718a97b0652" target="mysql_doc"><span class="syntax_alpha syntax_alpha_reservedWord">SELECT</span></a> <span class="syntax_alpha syntax_alpha_identifier">tcg_set_name</span><span class="syntax_punct syntax_punct_listsep">,</span> <span class="syntax_alpha syntax_alpha_identifier">name</span><br /><span class="syntax_alpha syntax_alpha_reservedWord">FROM</span> <span class="syntax_alpha syntax_alpha_identifier">tcg_set_names</span><br /><span class="syntax_alpha syntax_alpha_reservedWord">RIGHT</span> <span class="syntax_alpha syntax_alpha_reservedWord">JOIN</span> <span class="syntax_alpha syntax_alpha_identifier">card_sets</span> <span class="syntax_alpha syntax_alpha_reservedWord">ON</span> <span class="syntax_alpha syntax_alpha_identifier">tcg_set_name</span> <span class="syntax_punct">=</span> <span class="syntax_alpha syntax_alpha_identifier">name</span><span class="syntax_punct syntax_punct_bracket_close_round">)</span><span class="syntax_alpha syntax_alpha_identifier">a</span><br /><span class="syntax_alpha syntax_alpha_reservedWord">WHERE</span> <span class="syntax_punct syntax_punct_bracket_open_round">(</span><div class="syntax_indent1"><span class="syntax_punct syntax_punct_bracket_open_round">(</span><div class="syntax_indent2"> <span class="syntax_quote syntax_quote_backtick">`a`</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_quote syntax_quote_backtick">`tcg_set_name`</span> <span class="syntax_alpha syntax_alpha_reservedWord">IS</span> <span class="syntax_alpha syntax_alpha_reservedWord">NULL</span> <br /><span class="syntax_alpha syntax_alpha_reservedWord">AND</span> <span class="syntax_quote syntax_quote_backtick">`a`</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_quote syntax_quote_backtick">`name`</span> <span class="syntax_punct">=</span> <span class="syntax_quote syntax_quote_single">'Magic 2011'</span></div><span class="syntax_punct syntax_punct_bracket_close_round">)</span></div><span class="syntax_punct syntax_punct_bracket_close_round">)</span><br /><span class="syntax_alpha syntax_alpha_reservedWord">AND</span> <span class="syntax_punct syntax_punct_bracket_open_round">(</span><div class="syntax_indent1"><span class="syntax_alpha syntax_alpha_identifier">a</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_alpha syntax_alpha_identifier">tcg_set_name</span> <span class="syntax_alpha syntax_alpha_reservedWord">IS</span> <span class="syntax_alpha syntax_alpha_reservedWord">NULL</span> <br /><span class="syntax_alpha syntax_alpha_reservedWord">OR</span> <span class="syntax_alpha syntax_alpha_identifier">a</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_alpha syntax_alpha_identifier">name</span> <span class="syntax_alpha syntax_alpha_reservedWord">IS</span> <span class="syntax_alpha syntax_alpha_reservedWord">NULL</span> </div><span class="syntax_punct syntax_punct_bracket_close_round">)</span></span></span> | |
| </p> | |
| <p> | |
| <strong>MySQL said: </strong><a href="./url.php?url=http%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F5.0%2Fen%2Ferror-messages-server.html&token=58ae5d4f55ee483af11ff718a97b0652" target="mysql_doc"><img class="icon" src="./themes/pmahomme/img/b_help.png" width="11" height="11" alt="Documentation" title="Documentation" /></a> | |
| </p> | |
| <code> | |
| #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 ') a WHERE ((`a`.`tcg_set_name` IS NULL AND `a`.`name` = 'Magic 2011')) AND ( ' at line 1 | |
| </code><br /> | |
| </div><script type="text/javascript"> | |
| //<![CDATA[ | |
| $(document).ready(function(){ | |
| // updates current settings | |
| if (window.parent.setAll) { | |
| window.parent.setAll('en', 'utf8_general_ci', '1', 'kelly_tcgplayer', 'recent_quotes', '58ae5d4f55ee483af11ff718a97b0652'); | |
| } | |
| // set current db, table and sql query in the querywindow | |
| if (window.parent.reload_querywindow) { | |
| window.parent.reload_querywindow( | |
| 'kelly_tcgplayer', | |
| 'recent_quotes', | |
| ''); | |
| } | |
| if (window.parent.frame_content) { | |
| // reset content frame name, as querywindow needs to set a unique name | |
| // before submitting form data, and navigation frame needs the original name | |
| if (typeof(window.parent.frame_content.name) != 'undefined' | |
| && window.parent.frame_content.name != 'frame_content') { | |
| window.parent.frame_content.name = 'frame_content'; | |
| } | |
| if (typeof(window.parent.frame_content.id) != 'undefined' | |
| && window.parent.frame_content.id != 'frame_content') { | |
| window.parent.frame_content.id = 'frame_content'; | |
| } | |
| //window.parent.frame_content.setAttribute('name', 'frame_content'); | |
| //window.parent.frame_content.setAttribute('id', 'frame_content'); | |
| } | |
| }); | |
| //]]> | |
| </script> | |
| </body> | |
| </html> | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment