Log in

View Full Version : I'm getting a database error. Help!

Fungsten
09-07-2008, 07:35 PM
I just started to get this error:


http://www.democraticwarrior.com/forum/image.php?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 (http://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.
Lynne
09-07-2008, 07:41 PM
View the source on the page and post the actual database error you see at the bottom.

I just grabbed it:
<!--
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.c om','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.
Fungsten
09-07-2008, 07:51 PM
View the source on the page and post the actual database error you see at the bottom.

I just grabbed it:
<!--
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.c om','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?
Lynne
09-07-2008, 07:55 PM
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

define('DISABLE_HOOKS', true);
Fungsten
09-07-2008, 08:08 PM
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

define('DISABLE_HOOKS', true);


Thanks Lynne!!
Opserty
09-07-2008, 09:55 PM
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.
Fungsten
09-07-2008, 10:26 PM
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.
Dismounted
09-08-2008, 06:40 AM
Alternatively, you could report it and a member of staff will take a look.