Database error - it was all going so well :-(

[robbieuk]

Hi guys (again)

It was all going so well with TP & I was adding boxes & then all of a sudden I pressed save & had this error

Any ideas?

Database 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 On Line' WHERE id = 8' at line 1

UPDATE smf_tp_blocks SET title = 'Who's On Line' WHERE id = 8

[IchBin]

Perhaps you could give us some information so we can help. If you could follow our posting guidelines, it would help us help you much quicker. Thanks.
Posting Guidelines

[robbieuk]

OK Sorry
So I'm using SMF 2.0 RC3 with no current errors except for this one

My mods intalled are:

AjaxChat Integration 3.2.1 (modified for SMF 2 RC3) 
Treasury 2.05   
Pretty URLs 1.0     
Sitemap 2.1.0     
SimpleDesk - 1.0
Google Member Map 3.0 2.0 beta 2
RSS Feeder 1.1.4
Twitter and Facebook Publisher mod 2.2   
Global Headers Footers 2.0   
TinyPortal 1.099   
Ad Managment 2.3.6.1 
MessagePreviewOnHover 1.7   
SMF Links 2.1.3   
SMF Staff Page 1.7   
Google Tagged 1.4   
YouTube BBCode 2.6   
Welcome Topic Mod

[bloc]

Remove the apostrophe in the title and it will work.

This should work in the latest beta though.

[robbieuk]

Remove the apostrophe in the title and it will work.

This should work in the latest beta though.

Remove the apostrophe in which title

Sorry I'm a complete newb

[G6Cad]

from the box/boxes you have added one in the title for your box/boxes

[robbieuk]

OMG your a star(s) :up:

That has prob caused hours of hell for some people including me of course

Is there going an update to cure that?

[IchBin]

As Bloc said, the latest beta should fix that. If I were you I'd upload all the TP files again replacing the existing ones. See if that fixes the problem.