serendipity_event_trackback.php creates mysqlisch table

[ads]

Hello,

the trackback plugin contains SQL code to create a table - which is quite MySQL-specific:

Code: Select all

$sql = "CREATE TABLE {$serendipity['dbPrefix']}delayed_trackbacks (
id int(11) NOT NULL ,
timestamp int(10) unsigned default NULL,
PRIMARY KEY (id)
)";

At least on PostgreSQL, the "unsigned" fails - and since S9Y never shows any SQL errors, I only found this problem when checking the logfile.

[garvinhicking]

Hi!

Thakns for reporting, I changed this to use our DB layer for {UNSIGNED} detection.

Regards,
Garvin