[Edrondol]

Originally Posted by wildweaselmi

Disregard... It appears that DB error popped back up. I am wondering if it is something to do with special characters or length of question and/or answer. I was able to create a FAQ with just a few characters and nothing special.

So I was on a mission... I found out that if your answer has ' in it anywhere, you will get the below database error, but just hit back and remove any sign of ' and it works.

Database error in vBulletin 4.0.0:

Invalid SQL:
INSERT INTO vb_microsupport_faq
                                 SET categoryid='11',
                                     question='My machine is displaying a Blue Screen during bootup, did I loose all my data?',
                                     answer='No you haven't lost it but when you get a Blue Screen it's difficult to get past it.  MyWiseGuys has a few tricks up its sleeve to backup your data and see if we can repair that Blue Screen so you can continue working.  In the event it's beyond repair, we can re-load Windows on your machine and then restore your data so you are back in business.',
                                     important = '0';

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 't lost it but when you get a Blue Screen it's difficult to get past it.  MyWiseG' at line 4
Error Number  : 1064
Request Date  : Monday, December 28th 2009 @ 02:55:55 PM
Error Date    : Monday, December 28th 2009 @ 02:55:55 PM
Script        : http://www.mywiseguys.com/forums/support.php?do=saveupdatefaq
Referrer      : http://www.mywiseguys.com/forums/support.php?do=addeditfaq
IP Address    : 24.11.27.21
Username      : wildweaselmi
Classname     : vB_Database
MySQL Version : 5.1.41

I got the same thing and tested without a ' in the answer and it worked. So is there a quick way to fix this or do I just have to relearn how to type things?