Click here to go to the forum index Click here for the home page
 
Author Message

<  Site news and feedback  ~  Toppy Remote Control Error

Page 1 of 1
nbr_uk
Posted: Wed Sep 15, 2010 6:12 am Reply with quote
Joined: 15 Aug 2010 Posts: 5
Hi, using Toppy remote control for the first time - after trying to create a timer i get the following SQL 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 'repeat) VALUES (1479, 'web', 5, '2010-9-15', '0715', 15, 'MrMen', 'once')' at line 1

I've tried adjusting the settings for the timer and used a different browser but still get the same - is there a problem with the server?

Thanks, nbr_uk
View user's profile Send private message
nwhitfield
Posted: Wed Sep 15, 2010 8:06 am Reply with quote
Site Admin Joined: 20 Mar 2005 Posts: 9511 Location: London
There might well be; I'll have a check later today and see if something went amiss with the move from one database server to another recently.

_________________
Support this site - make a donation to our running costs
View user's profile Send private message Visit poster's website
nbr_uk
Posted: Wed Sep 15, 2010 11:12 am Reply with quote
Joined: 15 Aug 2010 Posts: 5
Thanks nwhitfield - looking forward to testing it!

Cheers, nbr_uk
View user's profile Send private message
matpol
Posted: Fri Oct 15, 2010 7:21 am Reply with quote
Joined: 15 Jun 2009 Posts: 24
I still get this error
View user's profile Send private message
nwhitfield
Posted: Fri Oct 15, 2010 10:11 am Reply with quote
Site Admin Joined: 20 Mar 2005 Posts: 9511 Location: London
Sorry - completely slipped my mind while I was busy in the office.

Will take a look at that now.

_________________
Support this site - make a donation to our running costs
View user's profile Send private message Visit poster's website
nwhitfield
Posted: Fri Oct 15, 2010 10:17 am Reply with quote
Site Admin Joined: 20 Mar 2005 Posts: 9511 Location: London
That's now fixed; sorry - a field name turned into a reserved word with the update from MySQL4 to 5.

_________________
Support this site - make a donation to our running costs
View user's profile Send private message Visit poster's website

Display posts from previous:  

All times are GMT
Page 1 of 1

Jump to:  

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum