[Spika]

Originally Posted by designBox

Sorry for the double post but this is concerning another error.
It came to my attention that if the forum name had a ' in its name then vbSponsor is generating an error when clicking to the sponsor's link.

I pasted here this error:

Database error in vBulletin 3.5.3:

Invalid SQL:
INSERT INTO `vBSponsors` ( `id` , `sponsor_name` , `forum_id`, `forum`, `date` ) VALUES ( '', 'Your link here', '97', 'Programmer's Alley', '1140258987');

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 Alley', '1140258987')' at line 1
Error Number : 1064
Date		 : Saturday, February 18th 2006 @ 11:36:27 AM
Script	   : http://www.hostnode.com/vB.Sponsors/link.php?f=97
Referrer	 : http://www.hostnode.com/forum.php
IP Address   : XXXXXXXXXXXXX
Username	 : XXXXXXXXXXXXX
Classname	: vb_database

I changed the name of the forum, but i reported this error at it may help some others.

Hello I have similar error:

Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO `vbulletin_vBSponsors` ( `id` , `sponsor_name` , `forum_id`, `forum`, `date` ) VALUES ( '', 'Encuentro BMWRIDERS '06', '12', 'Kedadas', '1154175656');

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 '06', '12', 'Kedadas', '1154175656')' at line 1
Error Number : 1064
Date         : Saturday, July 29th 2006 @ 12:20:56 PM
Script       : http://www.gstrail.es/foro/vB.Sponsors/link.php?f=12
Referrer     : http://www.gstrail.es/foro/forumdisplay.php?f=3
IP Address   : xxx.xxx.xxx.xxx
Username     : Nickname
Classname    : vb_database

I don?t have ' in the name of the forum, help please


Solved, Reinstalling