vb.org Archive - I'm getting a database error. Help!

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vB3 General Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=111)

- - I'm getting a database error. Help! (https://vborg.vbsupport.ru/showthread.php?t=190286)

I'm getting a database error. Help!

I just started to get this error:

Quote:

http://www.democraticwarrior.com/for...p?type=dberror Database error The [Removed URL] database has encountered a problem. Please try the following:

Load the page again by clicking the [Removed] button in your web browser.
Open the www.XXXXXXXXXX home page, then try to open another page.
Click th [Removed] button to try another link.

The [removed] forum technical staff have been notified of the error, though you may contact if the problem persists.
We apologise for any inconvenience.

I haven't installed any hacks that would cause that. Also, I have reinstalled 3.7.3 and got the same error right after step 5 of 5.

View the source on the page and post the actual database error you see at the bottom.

I just grabbed it:

Code:

<!--

Database error in vBulletin 3.7.3:



Invalid SQL:

INSERT INTO mailqueue (dateline,toemail,fromemail,subject,message,header) VALUES ('1220820083','cthulu@q.com','Webmaster@yoursite.com','We miss you!','&lt;p&gt;Dear Wally's Dad&lt;/p&gt;



&lt;p&gt;We noticed you have not been posting at yoursite for a while. The forum has greatly expanded and  we look forward to seeing you &lt;/p&gt;

&lt;p&gt;If you don\'t remember your password, you can request it here: &lt;a href=&quot;http://www.yoursite.com/login.php?do=lostpw&quot;&gt;http://www.yoursite.com/forum/login.php?do=lostpw&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;We hope to see you soon&lt;/p&gt;

&lt;p&gt;&amp;nbsp;&lt;/p&gt;

&lt;p&gt;Kindest Regards&lt;/p&gt;

&lt;p&gt;&lt;a href=&quot;http://www.yoursite.com&quot;&gt;yoursite&lt;/a&gt;&lt;/p&gt;','MIME-Version: 1.0

Content-type: text/html; charset=iso-8859-1

To: Wally's Dad &lt;cthulu@q.com&gt;

From: yoursite - Forums Reminder Service &lt;Webmaster@yoursite.com&gt;

');



MySQL Error   : 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 's Dad&lt;/p&gt;



&lt;p&gt;We noticed you have not been posting at yoursite for a ' at line 1

Error Number  : 1064

Request Date  : Sunday, September 7th 2008 @ 03:41:22 PM

Error Date    : Sunday, September 7th 2008 @ 03:41:23 PM

Script        : http://www.yoursite.com/

Referrer      : https://vborg.vbsupport.ru/showthread.php?t=190286

IP Address    : xxxxxx

Username      : 

Classname     : vB_Database

MySQL Version : 

-->

It doesn't like what you have in the "To:" field since the username has an apostrophe. You need to ask in that modification thread for help fixing this error.

Quote:

Originally Posted by Lynne (Post 1616869)

View the source on the page and post the actual database error you see at the bottom.

I just grabbed it:

Code:

<!--

Database error in vBulletin 3.7.3:



Invalid SQL:

INSERT INTO mailqueue (dateline,toemail,fromemail,subject,message,header) VALUES ('1220820083','cthulu@q.com','Webmaster@yoursite.com','We miss you!','&lt;p&gt;Dear Wally's Dad&lt;/p&gt;



&lt;p&gt;We noticed you have not been posting at yoursite for a while. The forum has greatly expanded and  we look forward to seeing you &lt;/p&gt;

&lt;p&gt;If you don\'t remember your password, you can request it here: &lt;a href=&quot;http://www.yoursite.com/login.php?do=lostpw&quot;&gt;http://www.yoursite.com/forum/login.php?do=lostpw&lt;/a&gt;&lt;/p&gt;

&lt;p&gt;We hope to see you soon&lt;/p&gt;

&lt;p&gt;&amp;nbsp;&lt;/p&gt;

&lt;p&gt;Kindest Regards&lt;/p&gt;

&lt;p&gt;&lt;a href=&quot;http://www.yoursite.com&quot;&gt;yoursite&lt;/a&gt;&lt;/p&gt;','MIME-Version: 1.0

Content-type: text/html; charset=iso-8859-1

To: Wally's Dad &lt;cthulu@q.com&gt;

From: yoursite - Forums Reminder Service &lt;Webmaster@yoursite.com&gt;

');



MySQL Error   : 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 's Dad&lt;/p&gt;



&lt;p&gt;We noticed you have not been posting at yoursite for a ' at line 1

Error Number  : 1064

Request Date  : Sunday, September 7th 2008 @ 03:41:22 PM

Error Date    : Sunday, September 7th 2008 @ 03:41:23 PM

Script        : http://www.yoursite.com/

Referrer      : https://vborg.vbsupport.ru/showthread.php?t=190286

IP Address    : xxxxxx

Username      : 

Classname     : vB_Database

MySQL Version : 

-->

It doesn't like what you have in the "To:" field since the username has an apostrophe. You need to ask in that modification thread for help fixing this error.

I can't access my ACP or I would change the name myself. I guess I should ask the author of the Mod anyways?

I'm surprised that error is stopping you from accessing the ACP though. But anyway, you can disable your plugins through your config.php file
Note: To temporarily disable the plugin system, edit config.php and add this line right under <?php

PHP Code:


		
			
define('DISABLE_HOOKS', true);

Quote:

Originally Posted by Lynne (Post 1616881)

PHP Code:


		
			
define('DISABLE_HOOKS', true);

Thanks Lynne!!

I may be wrong here but I think the modification may be vulnerable to attack. You should ask the author of the hack to investigate this error.

Quote:

Originally Posted by Opserty (Post 1616956)

I may be wrong here but I think the modification may be vulnerable to attack. You should ask the author of the hack to investigate this error.

Thank you! I shall.

Alternatively, you could report it and a member of staff will take a look.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (2)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02315 seconds Memory Usage 1,740KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (2)bbcode_code_printable (2)bbcode_php_printable (4)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (8)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: