ERROR: type "blob" does not exist
Closed, ResolvedPublic

Description

Intalling Cargo 0.6.1. on MW 1.24 with postgresql-9.3 maintenance/update.php raises

Function: DatabaseBase::sourceFile( /var/www/vitalinux/extensions/Cargo/Cargo.sql )
Error: 42704 ERROR:  type "blob" does not exist
LINE 5:  table_schema BLOB NOT NULL
Lmorillas updated the task description. (Show Details)
Lmorillas raised the priority of this task from to Needs Triage.
Lmorillas added a subscriber: Lmorillas.
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMar 26 2015, 2:58 PM

@Lmorillas - sorry for the long delay on this. It looks like changing the type from "BLOB" to "blob" in that file might be enough to fix the problem, strangely enough. Could you please try that, if you haven't already found another fix?

Thanks, @Yaron_Koren, but blob raises the same error:

Function: DatabaseBase::sourceFile( /var/www/vitalinux/extensions/Cargo/Cargo.sql )
Error: 42704 ERROR:  type "blob" does not exist
LINE 5:  table_schema blob NOT NULL

I changed blob by TEXT but I must test it before.

CREATE TABLE /*_*/cargo_tables (
        template_id int NOT NULL,
        main_table varchar(200) NOT NULL,
        field_tables varchar(200) NOT NULL,
        table_schema TEXT NOT NULL
) /*$wgDBTableOptions*/;

I'll let you know if it works.

Yaron_Koren closed this task as Resolved.Jul 30 2015, 12:59 AM
Yaron_Koren claimed this task.

It's been "text" instead of "blob" for a long time now, so I'm assuming this issue is fixed.