Table 'tellque' missing

[dcosper]

I had a similar time stamp problem, the sql and server wants a UNIX timestamp and i cant find a way in sql to make that, so instead i did a int 11 to hold the UNIX_TIMESTAMP date, seems to work fine, but i am just a novice.

[trevius]

Yeah, if it is unix timestamp, then int(11) is what it wants. I just thought it was supposed to be a timestamp, since it looks to be using asctime() to make it a string in this snippet from the source:

time_t rawtime;
struct tm * timeinfo;
time ( &rawtime );
timeinfo = localtime ( &rawtime );
char *telldate=asctime(timeinfo);
....
if (database.RunQuery(query, MakeAnyLenString(&query, "INSERT INTO tellque (Date,Receiver,Sender,Message) values('%s','%s','%s','%s')",telldate,scm->deliverto,scm->from,scm->message), errbuf, &result))

Looks like it just needs to be varchar, so I updated the SQL I posted previously. Tested it and it worked fine.