Skip to content

Instantly share code, notes, and snippets.

@m4tm4t
Created February 11, 2011 23:30
Show Gist options
  • Save m4tm4t/823261 to your computer and use it in GitHub Desktop.
Save m4tm4t/823261 to your computer and use it in GitHub Desktop.
2011-02-12 00:27:30 SQL: DELETE FROM corpse WHERE corpse_type = '0' OR time < (UNIX_TIMESTAMP()-'259200')
2011-02-12 00:27:30 SQL ERROR: function unix_timestamp() does not exist
LINE 1: ...TE FROM corpse WHERE corpse_type = '0' OR time < (UNIX_TIMES...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2011-02-12 00:27:33 SQL: DELETE FROM creature_respawn WHERE respawntime <= UNIX_TIMESTAMP(NOW())
2011-02-12 00:27:33 SQL ERROR: function unix_timestamp(timestamp with time zone) does not exist
LINE 1: DELETE FROM creature_respawn WHERE respawntime <= UNIX_TIMES...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2011-02-12 00:27:34 SQL: DELETE FROM gameobject_respawn WHERE respawntime <= UNIX_TIMESTAMP(NOW())
2011-02-12 00:27:34 SQL ERROR: function unix_timestamp(timestamp with time zone) does not exist
LINE 1: ...LETE FROM gameobject_respawn WHERE respawntime <= UNIX_TIMES...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2011-02-12 00:27:34 SQL : SELECT entry,UNIX_TIMESTAMP(start_time),UNIX_TIMESTAMP(end_time),occurence,length,holiday,description FROM game_event
2011-02-12 00:27:34 SQL ERROR: function unix_timestamp(timestamp without time zone) does not exist
LINE 1: SELECT entry,UNIX_TIMESTAMP(start_time),UNIX_TIMESTAMP(end_t...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2011-02-12 00:27:37 SQL : SELECT guid, ticket_text, response_text, UNIX_TIMESTAMP(ticket_lastchange), ticket_id FROM character_ticket ORDER BY ticket_id ASC
2011-02-12 00:27:37 SQL ERROR: function unix_timestamp(timestamp without time zone) does not exist
LINE 1: SELECT guid, ticket_text, response_text, UNIX_TIMESTAMP(tick...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
2011-02-12 00:27:37 SQL: DELETE FROM ip_banned WHERE unbandate<=UNIX_TIMESTAMP() AND unbandate<>bandate
2011-02-12 00:27:37 SQL ERROR: function unix_timestamp() does not exist
LINE 1: DELETE FROM ip_banned WHERE unbandate<=UNIX_TIMESTAMP() AND ...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment