Page 1 of 1

serendipity_event_trackback.php creates mysqlisch table

Posted: Thu Mar 31, 2011 11:31 pm
by 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.

Re: serendipity_event_trackback.php creates mysqlisch table

Posted: Fri Apr 01, 2011 3:03 pm
by garvinhicking
Hi!

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

Regards,
Garvin