PDA

View Full Version : Message problem


tanerokutan
12-17-2010, 04:51 PM
my vbulletin software sending automatic messages to my admin address (hundreds of message everyday)
what is the problem ? how can I fix it ?

here's the one of them :

-------------------------------------------------------------

This message was created automatically by mail delivery software.

A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed:

dbmaster@example.com
retry time not reached for any host after a long failure period

------ This is a copy of the message, including all the headers. ------

Return-path: <admin@gsfans.org>
Received: from ttarena by server.gsfans.org with local (Exim 4.69)
(envelope-from <admin@gsfans.org>)
id 1PTemE-0003fl-0Q
for dbmaster@example.com; Fri, 17 Dec 2010 20:11:34 +0200
To: dbmaster@example.com
Subject: vBulletin Database Error!
From: dbmaster@example.com <dbmaster@example.com>
Message-ID: <20101217181133.5f301e3a1a66@www.gsfans.org>
MIME-Version: 1.0
Content-Type: text/plain
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-Mailer: vBulletin Mail via PHP
Date: Fri, 17 Dec 2010 20:11:33 +0200

Database error in vBulletin 4.0.3:

Invalid SQL:
SELECT parent.nodeid, parent.styleid, parent.layoutid from cms_node AS node INNER JOIN cms_node AS parent ON node.nodeleft BETWEEN parent.nodeleft AND parent.noderight
WHERE node.nodeid =
ORDER BY parent.nodeleft DESC ;;

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 'ORDER BY parent.nodeleft DESC' at line 3
Error Number : 1064
Request Date : Friday, December 17th 2010 @ 08:11:33 PM
Error Date : Friday, December 17th 2010 @ 08:11:33 PM
Script : http://www.gsfans.org/list.php?r=day/1292450401
Referrer : http://www.gsfans.org/content/
IP Address : 77.92.23.31
Username : sercangs
Classname : vB_Database
MySQL Version :

Lynne
12-17-2010, 05:43 PM
Try repairing your nodes - vbulletin cms > repair nodes

tanerokutan
12-17-2010, 09:11 PM
thank you.

--------------- Added 1292680116 at 1292680116 ---------------

I repaired cms/nodes but unfortunately there is no positive result.
Hundreds of mails are coming.
please help me

new example :
----------------------------------------
This message was created automatically by mail delivery software.

A message that you sent could not be delivered to one or more of its recipients. This is a permanent error. The following address(es) failed:

dbmaster@example.com
retry time not reached for any host after a long failure period

------ This is a copy of the message, including all the headers. ------

Return-path: <admin@gsfans.org>
Received: from ttarena by server.gsfans.org with local (Exim 4.69)
(envelope-from <admin@gsfans.org>)
id 1PTvtR-0001sR-PF
for dbmaster@example.com; Sat, 18 Dec 2010 14:28:12 +0200
To: dbmaster@example.com
Subject: vBulletin Database Error!
From: "dbmaster@example.com" <dbmaster@example.com>
Message-ID: <20101218122809.99ad6a500f54@www.gsfans.org>
MIME-Version: 1.0
Content-Type: text/plain; charset="windows-1254"
Content-Transfer-Encoding: 8bit
X-Priority: 3
X-Mailer: vBulletin Mail via PHP
Date: Sat, 18 Dec 2010 14:28:09 +0200

Database error in vBulletin 4.0.3:

Invalid SQL:

REPLACE INTO searchlog
(userid,ipaddress,searchhash,sortby,sortorder,sear chtime,dateline,completed,criteria,results)
VALUES
(8513,'78.21.36.64','68a0c686de680a9ae75414ef8192d 1be','groupdateline','desc',0,1292675232,0,'O:18:\"vB_Search_Criteria\":15:{s:28:\"\0vB_Search_Criteria\0keywords\";a:0:{}s:32:\"\0vB_Search_Criteria\0raw_keywords\";s:0:\"\";s:29:\"\0vB_Search_Criteria\0titleonly\";b:0;s:27:\"\0vB_Search_Criteria\0filters\";a:2:{s:11:\"contenttype\";a:1:{s:2:\"eq\";a:1:{i:0;i:1;}}s:7:\"datecut\";a:1:{s:2:\"gt\";s:10:\"1292618599\";}}s:24:\"\0vB_Search_Criteria\0sort\";a:2:{i:0;s:13:\"groupdateline\";i:1;s:4:\"desc\";}s:27:\"\0vB_Search_Criteria\0grouped\";i:1;s:31:\"\0vB_Search_Criteria\0searchterms\";a:4:{s:10:\"searchdate\";s:9:\"lastvisit\";s:13:\"contenttypeid\";s:1:\"1\";s:11:\"search_type\";i:1;s:9:\"showposts\";i:0;}s:32:\"\0vB_Search_Criteria\0criteria_set\";b:1;s:35:\"\0vB_Search_Criteria\0advanced_typeid\";b:0;s:35:\"\0vB_Search_Criteria\0display_strings\";a:2:{s:4:\"type\";s:10:\"T?r: Posts\";s:7:\"newitem\";s:13:\"Yeni Mesajlar\";}s:32:\"\0vB_Search_Criteria\0common_words\";a:0:{}s:30:\"\0vB_Search_Criteria\0highlights\";a:0:{}s:33:\"\0vB_Search_Criteria\0search_string\";N;s:26:\"\0vB_Search_Criteria\0errors\";a:0:{}s:11:\"search_type\";s:3:\"new\";}','');

MySQL Error : Lock wait timeout exceeded; try restarting transaction
Error Number : 1205
Request Date : Saturday, December 18th 2010 @ 02:27:12 PM
Error Date : Saturday, December 18th 2010 @ 02:28:09 PM
Script : http://www.gsfans.org/search.php?do=getnew&contenttype=vBForum_Post
Referrer : http://www.gsfans.org/turk-telekom-arena-aslantepe-stadimizin-insaati/944-aslantepe-ttarena-kamera-takip-basligi-2550.html
IP Address : 78.21.36.64
Username : UABel?iKa06
Classname : vB_Database
MySQL Version :

alencete
09-25-2011, 07:57 AM
I have a similar problem, and i have a solution, for you xD

Go to:

AdminCP => Maintenance => Repair / Optimize Tables

Make all yes...

And press Repair button.