LordOrange Posted June 24, 2008 Share Posted June 24, 2008 I'm running an offline web server on my machine and for the past year or so it's been working fine. I've been using a program called DreamCoder to manage my database. Recently it has started giving me errors when ever I try to edit information in the database. I can't find any obvious reasons. Please can some one help me. Quote Link to comment Share on other sites More sharing options...
fird01 Posted June 24, 2008 Share Posted June 24, 2008 what kind of error.. better if u copy and paste the error here. Quote Link to comment Share on other sites More sharing options...
LordOrange Posted June 24, 2008 Author Share Posted June 24, 2008 There two different ones: Update failed. Found 0 records and 1064 #42000You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4 DreamCoder sends these in a pop up box. Quote Link to comment Share on other sites More sharing options...
gijew Posted June 24, 2008 Share Posted June 24, 2008 Not to be terribly rude but umm, you have an error in your mysql syntax dude What does the query mentioned look like? Mind posting it so we can see what's going on. Quote Link to comment Share on other sites More sharing options...
LordOrange Posted June 24, 2008 Author Share Posted June 24, 2008 Unfortunately all the code for these run in the background and are unaccecible but when I tried to run an update script (mysql_query("UPDATE calendar ('date','event','details') VALUES ('23','event1','something is happening')") I get no errors but nothing happens. Quote Link to comment Share on other sites More sharing options...
gijew Posted June 24, 2008 Share Posted June 24, 2008 Perhaps the problem lies in the data being put into the table. Try sanitizing the data with something simple like addslashes() because it looks like you may have an extra quote in there. Quote Link to comment Share on other sites More sharing options...
fenway Posted June 24, 2008 Share Posted June 24, 2008 What's dreamcoder? Aren't you writing the script yourself? Quote Link to comment Share on other sites More sharing options...
LordOrange Posted June 24, 2008 Author Share Posted June 24, 2008 What's dreamcoder? Aren't you writing the script yourself? DreamCoder is a database manager and the script I have tried (already shown in code tags) does not return any error messages but does nothing at all. Quote Link to comment Share on other sites More sharing options...
trq Posted June 24, 2008 Share Posted June 24, 2008 Field names need not be surrounded in quotes, though the date field will need `backticks` as its a special word. Quote Link to comment Share on other sites More sharing options...
LordOrange Posted June 24, 2008 Author Share Posted June 24, 2008 Thanks. Noticed that. I think the problems with the program and not with my MySQL. Thanks for all you help Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.