MySQL - Printable Version

MySQL - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: MySQL (/showthread.php?tid=275623)

MySQL - [IL]HeHu - 10.08.2011

This is the error it shows:

PHP код:



[Wed Aug 10 15:17:25 2011] Error (0): Failed to exeute query. Unknown column 'TIMESTAMP' in 'field list'.

This is what it shows it on:

PHP код:



    format(saveQuery, sizeof(saveQuery),"INSERT INTO `arecords` (`type`,`ip`,`name`,`admin`,`time`,`reason`,`otime`) VALUES (0, '%s', '%s', '%s', 0, '%s',TIMESTAMP)",ip,name,name2,reason);

    mysql_query(saveQuery);

It's in /kick

Re: MySQL - JaTochNietDan - 10.08.2011

I don't think that keyword exists in MySQL, try CURRENT_TIMESTAMP instead.

Re: MySQL - [IL]HeHu - 10.08.2011

Cheers!