MyBB Community Forums
Sql error in site - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: 1.8 Support (https://community.mybb.com/forum-175.html)
+--- Forum: General Support (https://community.mybb.com/forum-176.html)
+--- Thread: Sql error in site (/thread-232787.html)



Sql error in site - venomgrills - 2021-06-24

Hey Guys,
I am facing sql errors again and again in my site, Sometime it shows mysql server has gone and sometime it shows mysql user limit. But when I check my logs I got something like this.
<error>
<dateline>1624555861</dateline>
<script>inc/class_parser.php</script>
<line>2016</line>
<type>512</type>
<friendly_type>User Warning</friendly_type>
<message>Parser output validation failed.
array (
  'sourceHtmlEntities' => '
[quote="&quot;bhanu&quot;" pid="399" dateline="1620835056"]

Tools : 
1. Assetfinder  : https://github.com/tomnomnom/assetfinder
2. gau : https://github.com/lc/gau
3.waybackurls :  https://github.com/tomnomnom/waybackurls 
4.Httpx : https://github.com/projectdiscovery/httpx
5.gf :  https://github.com/tomnomnom/gf

For gf tool u can find patterns here : https://github.com/1ndianl33t/Gf-Patterns

6. qsreplace:  https://github.com/tomnomnom/qsreplace
7. FFUF : https://github.com/ffuf/ffuf



@&quot;venomgrills&quot; @&quot;Cb_Kali&quot;  @&quot;tejas.parjane&quot;

[/quote]
',
  'outputHtmlEntities' => '&lt;blockquote class=&quot;mycode_quote&quot;&gt;&lt;cite&gt;&lt;span&gt; (05-12-2021, 04:57 PM)&lt;/span&gt;bhanu Wrote: &lt;a href=&quot;https://venomgrills.com/showthread.php?pid=399#pid399&quot; class=&quot;quick_jump&quot;&gt;&amp;nbsp;&lt;/a&gt;&lt;/cite&gt;Tools : &lt;br /&gt;
1. Assetfinder  : &lt;a href=&quot;https://github.com/tomnomnom/assetfinder&quot; target=&quot;_blank&quot; rel=&quot;noopener&quot; class=&quot;mycode_url&quot;&gt;https://github.com/tomnomnom/assetfinder&lt;/a&gt;&lt;br /&gt;
2. gau : &lt;a href=&quot;https://github.com/lc/gau&quot; target=&quot;_blank&quot; rel=&quot;noopener&quot; class=&quot;mycode_url&quot;&gt;https://github.com/lc/gau&lt;/a&gt;&lt;br /&gt;
3.waybackurls :  &lt;a href=&quot;https://github.com/tomnomnom/waybackurls&quot; target=&quot;_blank&quot; rel=&quot;noopener&quot; class=&quot;mycode_url&quot;&gt;https://github.com/tomnomnom/waybackurls&lt;/a&gt; &lt;br /&gt;
4.Httpx : &lt;a href=&quot;https://github.com/projectdiscovery/httpx&quot; target=&quot;_blank&quot; rel=&quot;noopener&quot; class=&quot;mycode_url&quot;&gt;https://github.com/projectdiscovery/httpx&lt;/a&gt;&lt;br /&gt;
5.gf :  &lt;a href=&quot;https://github.com/tomnomnom/gf&quot; target=&quot;_blank&quot; rel=&quot;noopener&quot; class=&quot;mycode_url&quot;&gt;https://github.com/tomnomnom/gf&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
For gf tool u can find patterns here : &lt;a href=&quot;https://github.com/1ndianl33t/Gf-Patterns&quot; target=&quot;_blank&quot; rel=&quot;noopener&quot; class=&quot;mycode_url&quot;&gt;https://github.com/1ndianl33t/Gf-Patterns&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
6. qsreplace:  &lt;a href=&quot;https://github.com/tomnomnom/qsreplace&quot; target=&quot;_blank&quot; rel=&quot;noopener&quot; class=&quot;mycode_url&quot;&gt;https://github.com/tomnomnom/qsreplace&lt;/a&gt;&lt;br /&gt;
7. FFUF : &lt;a href=&quot;https://github.com/ffuf/ffuf&quot; target=&quot;_blank&quot; rel=&quot;noopener&quot; class=&quot;mycode_url&quot;&gt;https://github.com/ffuf/ffuf&lt;/a&gt;&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
&lt;br /&gt;
@&lt;a id=&quot;mention_1&quot; href=&quot;member.php?action=profile&amp;amp;uid=1&quot; class=&quot;mentionme_mention&quot; title=&quot;venomgrills\'s profile&quot;&gt;&lt;span style=&quot;color: #c61aff; text-shadow: 1px 1px 10px #47ff0f; background: url(https://static.cracked.to/images/bg1.gif);&quot;&gt;venomgrills &lt;/em&gt;&lt;/strong&gt;&lt;/span&gt;&lt;i class=&quot;fas fa-crown&quot;&gt;&lt;/i&gt;&lt;/a&gt; @&lt;a id=&quot;mention_63&quot; href=&quot;member.php?action=profile&amp;amp;uid=63&quot; class=&quot;mentionme_mention&quot; title=&quot;Cb_Kali\'s profile&quot;&gt;&lt;span style=&quot;color: #34de00 ;text-shadow: 1px 1px 10px #47ff0f; background: url(/images/anonshareskin/ranks-backgrounds/vipback.gif);&quot;&gt;Cb_Kali &lt;i class=&quot;fas fa-gem&quot;&gt;&lt;/i&gt;&lt;/span&gt;&lt;/a&gt;  @&lt;a id=&quot;mention_60&quot; href=&quot;member.php?action=profile&amp;amp;uid=60&quot; class=&quot;mentionme_mention&quot; title=&quot;tejas.parjane\'s profile&quot;&gt;&lt;span style=&quot;color: #ff99b1 ;text-shadow: 1px 1px 10px #ff85a2; background: url(/images/anonshareskin/ranks-backgrounds/vipback.gif);&quot;&gt;tejas.parjane &lt;i class=&quot;fas fa-gem&quot;&gt;&lt;/i&gt;&lt;/span&gt;&lt;/a&gt;&lt;/blockquote&gt;',
  'errors' => 
  array (
    0 => 
    LibXMLError::__set_state(array(
      'level' => 3,
      'code' => 26,
      'column' => 184,
      'message' => 'Entity \'nbsp\' not defined
',
      'file' => '',
      'line' => 1,
    )),
    1 => 
    LibXMLError::__set_state(array(
      'level' => 3,
      'code' => 76,
      'column' => 260,
      'message' => 'Opening and ending tag mismatch: span line 15 and em
',
      'file' => '',
      'line' => 15,
    )),
    2 => 
    LibXMLError::__set_state(array(
      'level' => 3,
      'code' => 76,
      'column' => 269,
      'message' => 'Opening and ending tag mismatch: a line 15 and strong
',
      'file' => '',
      'line' => 15,
    )),
    3 => 
    LibXMLError::__set_state(array(
      'level' => 3,
      'code' => 76,
      'column' => 276,
      'message' => 'Opening and ending tag mismatch: blockquote line 1 and span
',
      'file' => '',
      'line' => 15,
    )),
    4 => 
    LibXMLError::__set_state(array(
      'level' => 3,
      'code' => 76,
      'column' => 308,
      'message' => 'Opening and ending tag mismatch: root line 1 and a
',
      'file' => '',
      'line' => 15,
    )),
    5 => 
    LibXMLError::__set_state(array(
      'level' => 3,
      'code' => 5,
      'column' => 309,
      'message' => 'Extra content at the end of the document
',
      'file' => '',
      'line' => 15,
    )),
  ),
)</message>
<back_trace>#0  errorHandler->error() called at [/inc/class_parser.php:2016]
#1  postParser->validate_output() called at [/inc/class_parser.php:1957]
#2  postParser->output_allowed() called at [/inc/class_parser.php:284]
#3  postParser->parse_message() called at [/inc/functions_post.php:810]
#4  build_postbit() called at [/showthread.php:1117]
</back_trace>

</error>


Earlier I was getting dvz shoutbox msgs in error log so I removed that. But still I am facing the same problems.Can anyone will please help me out? 

Thanks in advance.


RE: Sql error in site - Devilshakerz - 2021-06-24

The SQL errors may be related to limits or performance issues with database server (https://dev.mysql.com/doc/refman/8.0/en/gone-away.html) - you host support should be able to help or determine what's happening.

Parser output validation failed is an unrelated, minor warning - it looks like there are redundant </em></strong> HTML tags in Username Style values of some user groups that should be removed.