StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PODOM Error - ID 'someAnchor' already defined in Entity, line X
primarykey
Id
3614586
data
AcceptedAnswerId
3614620
AnswerCount
1
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2010-09-01T02:10:29.223
FavoriteCount
0
LastActivityDate
2015-05-18T20:03:55.730
LastEditDate
2015-05-18T20:03:55.730
LastEditorUserId
472495
OwnerUserId
205814
ParentId
0
PostTypeId
1
Score
5
ViewCount
11712
LastEditorDisplayName
text
Body
<p>If I try to load an HTML document into PHP DOM I get an error along the lines of:</p> <pre><code>Error DOMDocument::loadHTML() [domdocument.loadhtml]: ID someAnchor already defined in Entity, line: 9 </code></pre> <p>I cannot work out why. Here is some code that loads an HTML string into DOM. </p> <p>First without containing an anchor tag and second with one. The second document produces an error.</p> <p>Hopefully you should be able to cut and paste it into a script and run it to see the same output:</p> <pre><code><?php ini_set('display_errors', 1); error_reporting(E_ALL); $stringWithNoAnchor = <<<EOT <!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"> <head> <title>My document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> </head> <body > <h1>Hello</h1> </body> </html> EOT; $stringWithAnchor = <<<EOT <!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"> <head> <title>My document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> </head> <body > <h1>Hello</h1> <a name="someAnchor" id="someAnchor"></a> </body> </html> EOT; class domGrabber { public $_FileErrorStr = ''; /** *@desc DOM object factory does the work of loading the DOM object */ public function getLoadAsDOMObj($htmlString) { $this->_FileErrorStr =''; //reset error container $xmlDoc = new DOMDocument(); set_error_handler(array($this, '_FileErrorHandler')); // Warnings and errors are suppressed $xmlDoc->loadHTML($htmlString); restore_error_handler(); return $xmlDoc; } /** *@desc public so that it can catch errors from outside this class */ public function _FileErrorHandler($errno, $errstr, $errfile, $errline) { if ($this->_FileErrorStr === null) { $this->_FileErrorStr = $errstr; } else { $this->_FileErrorStr .= (PHP_EOL . $errstr); } } } $domGrabber = new domGrabber(); $xmlDoc = $domGrabber->getLoadAsDOMObj($stringWithNoAnchor ); echo 'PHP Version: '. phpversion() .'<br />'."\n"; echo '<pre>'; print $xmlDoc->saveXML(); echo '</pre>'."\n"; if ($domGrabber->_FileErrorStr) { echo 'Error'. $domGrabber->_FileErrorStr; } $xmlDoc = $domGrabber->getLoadAsDOMObj($stringWithAnchor); echo '<pre>'; print $xmlDoc->saveXML(); echo '</pre>'."\n"; if ($domGrabber->_FileErrorStr) { echo 'Error'. $domGrabber->_FileErrorStr; } </code></pre> <p>I get the following out put in my Firefox source code view:</p> <pre><code>PHP Version: 5.2.9<br /> <pre><?xml version="1.0" encoding="iso-8859-1" standalone="yes"?> <!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" xmlns="http://www.w3.org/1999/xhtml"><head><title>My document</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /></head><body> <h1>Hello</h1> </body></html> </pre> <pre><?xml version="1.0" encoding="iso-8859-1" standalone="yes"?> <!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" xmlns="http://www.w3.org/1999/xhtml"><head><title>My document</title><meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /></head><body> <h1>Hello</h1> <a name="someAnchor" id="someAnchor"></a> </body></html> </pre> Error DOMDocument::loadHTML() [<a href='domdocument.loadhtml'>domdocument.loadhtml</a>]: ID someAnchor already defined in Entity, line: 9 </code></pre> <p>So, why is DOM saying that someAnchor is already defined?</p> <hr> <p>Update:</p> <p>I experimented with both </p> <ul> <li>Instead of using loadHTML() I used the loadXML() method - and that fixed it</li> <li>Instead of having both id and name I used just id - Attribute and that fixed it.</li> </ul> <p>See the comparison script here for the sake of completion:</p> <pre><code><?php ini_set('display_errors', 1); error_reporting(E_ALL); $stringWithNoAnchor = <<<EOT <!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"> <head> <title>My document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> </head> <body > <p>stringWithNoAnchor</p> </body> </html> EOT; $stringWithAnchor = <<<EOT <!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"> <head> <title>My document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> </head> <body > <p>stringWithAnchor</p> <a name="someAnchor" id="someAnchor" ></a> </body> </html> EOT; $stringWithAnchorButOnlyIdAtt = <<<EOT <!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"> <head> <title>My document</title> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> </head> <body > <p>stringWithAnchorButOnlyIdAtt</p> <a id="someAnchor"></a> </body> </html> EOT; class domGrabber { public $_FileErrorStr = ''; public $useHTMLMethod = TRUE; /** *@desc DOM object factory does the work of loading the DOM object */ public function loadDOMObjAndWriteOut($htmlString) { $this->_FileErrorStr =''; $xmlDoc = new DOMDocument(); set_error_handler(array($this, '_FileErrorHandler')); // Warnings and errors are suppressed if ($this->useHTMLMethod) { $xmlDoc->loadHTML($htmlString); } else { $xmlDoc->loadXML($htmlString); } restore_error_handler(); echo "<h1>"; echo ($this->useHTMLMethod) ? 'using xmlDoc->loadHTML() ' : 'using $xmlDoc->loadXML()'; echo "</h1>"; echo '<pre>'; print $xmlDoc->saveXML(); echo '</pre>'."\n"; if ($this->_FileErrorStr) { echo 'Error'. $this->_FileErrorStr; } } /** *@desc public so that it can catch errors from outside this class */ public function _FileErrorHandler($errno, $errstr, $errfile, $errline) { if ($this->_FileErrorStr === null) { $this->_FileErrorStr = $errstr; } else { $this->_FileErrorStr .= (PHP_EOL . $errstr); } } } $domGrabber = new domGrabber(); echo 'PHP Version: '. phpversion() .'<br />'."\n"; $domGrabber->useHTMLMethod = TRUE; //DOM->loadHTML $domGrabber->loadDOMObjAndWriteOut($stringWithNoAnchor); $domGrabber->loadDOMObjAndWriteOut($stringWithAnchor ); $domGrabber->loadDOMObjAndWriteOut($stringWithAnchorButOnlyIdAtt); $domGrabber->useHTMLMethod = FALSE; //use DOM->loadXML $domGrabber->loadDOMObjAndWriteOut($stringWithNoAnchor); $domGrabber->loadDOMObjAndWriteOut($stringWithAnchor ); $domGrabber->loadDOMObjAndWriteOut($stringWithAnchorButOnlyIdAtt); </code></pre>
Tags
<php><dom><anchor>
Title
DOM Error - ID 'someAnchor' already defined in Entity, line X
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. UShalfer
UserOwnerUserId
1. USJW.
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
2. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
3. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. COUpdate: I found out that html tidy was putting the id attribute into my xhtml docs .... looking into http://tidy.sourceforge.net/docs/quickref.html#anchor-as-name currently getting a new error: tidy::parseFile() [tidy.parsefile]: Unknown Tidy Configuration Option 'anchor-as-name' but that's a separate (but related) issue. Just for your interest.
  singulars
  PostPostId
  PODOM Error - ID 'someAnchor' already defined in Entity, line X
  UserUserId
  USJW.
2. COJust another note: loadXML() does not work if you have entities in the doc , such as £ OR £ (I sppose i could declare them - but that defeats the point of xhtml) So I found loadHTML() has to be used with anchors that do not both have id and name attributes set to the same value.
  singulars
  PostPostId
  PODOM Error - ID 'someAnchor' already defined in Entity, line X
  UserUserId
  USJW.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.