>>Most likely it can be removed. (Unless you have a signal handler!)
I'm using a modified version of the signals code, so I put it back in.
The original reason the code was removed was that after going through
the code itself, I didn't see any calls to send_update. In fact, that's
the only call to the code I see anywhere, thought it might have been
mistakenly put in there, my bad.
--
If you run the mud interactively (outside of a startup script) do any
messages go the the mud "console" when the write occurs?
Nothing at all there.
--
When you say "write" to the database, are you doing an insert, or an
update?
(this could be important, and maybe not)
Either is doing it, oddly enough, either will do it.
--
Another question, What version of MySQL are you running again? The code
supplied only works with 3.23.x
mysql Ver 11.13 Distrib 3.23.36, for pc-linux-gnu (i686)
--
gdb ../src/rom <enter gdb>
Breakpoint 2, send_query (command=0xbfffbac8 "INSERT INTO helps_needed
VALUES ('Xantha','test')")
at sql_connect.c:69
69 sigaddset(&set, SIGUSR1);
70 sigaddset(&set, SIGIO);
71 sigaddset(&set, SIGALRM);
72 sigaddset(&set, SIGUSR2);
73 sigaddset(&set, SIGINT);
74 sigaddset(&set, SIGQUIT);
75 sigaddset(&set, SIGHUP);
76 sigaddset(&set, SIGTERM);
77 sigaddset(&set, SIGABRT);
78 if(sigprocmask(SIG_BLOCK,&set,NULL)<0)
81 db = (struct database *) calloc(1, sizeof(struct
database ));
83 if (mysql_query(&my_connection, command))
87 if (!(db->result=mysql_store_result(&my_connection)))
89 error_db(command, 2 );
Breakpoint 2, send_query (command=0xbfff81e0 "SELECT * from stats WHERE
uname = 'Xantha' ")
<<from here it's all downhill.. crash_copyover called as it should be,
game rebooted>>
--
What about the mysql log? It can be really useful!
Cause: Unknown
Error: (error length: 0)
executing: INSERT INTO helps_needed VALUES ('Xantha','test') (It IS a
valid query)
(In this case, it's not really helpful, though usually, yeah I'd agree
it is:))
--
the define for &my_connection:
MYSQL my_connection;
