Type longtext not supported by PostgreSQL, upgrade.php fails, can't upgrade to 3.1.3

[NameDevRandom]

Hi,

Unfortunately the upgrade script tries to ALTER TABLE fud30_msg_store ALTER COLUMN data TYPE LONGTEXT which fails.
Postgres doesn't have a LONGTEXT datatype, and TEXT supports unlimited length.
How can I skip or disable this needless operation?
I am still using FUDforum 3.0.5 and it really is time to upgrade...

Best regards,

[NameDevRandom]

Found a quick & dirty workaround myself:
add
if ($tbl['name'] == $DBHOST_TBL_PREFIX .'msg_store') { continue; }
in upgrade.php at line 901

[naudefj]

Great workaround!
Function map_mysql_types_to_native() in dbadmin.inc is supposed to map LONGTEXT to TEXT for PgSQL.
We will have to figure out why it's not properly converted...

[naudefj]

Fixed @ 7005adc