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. Link to comment https://forums.phpfreaks.com/topic/111619-solved-mysql-unchangeable/ 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. Link to comment https://forums.phpfreaks.com/topic/111619-solved-mysql-unchangeable/#findComment-572962 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. Link to comment https://forums.phpfreaks.com/topic/111619-solved-mysql-unchangeable/#findComment-572965 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. Link to comment https://forums.phpfreaks.com/topic/111619-solved-mysql-unchangeable/#findComment-572966 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. Link to comment https://forums.phpfreaks.com/topic/111619-solved-mysql-unchangeable/#findComment-572968 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. Link to comment https://forums.phpfreaks.com/topic/111619-solved-mysql-unchangeable/#findComment-572998 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? Link to comment https://forums.phpfreaks.com/topic/111619-solved-mysql-unchangeable/#findComment-573107 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. Link to comment https://forums.phpfreaks.com/topic/111619-solved-mysql-unchangeable/#findComment-573206 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. Link to comment https://forums.phpfreaks.com/topic/111619-solved-mysql-unchangeable/#findComment-573233 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 Link to comment https://forums.phpfreaks.com/topic/111619-solved-mysql-unchangeable/#findComment-573241 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.