https://bugzilla.wikimedia.org/show_bug.cgi?id=30678

--- Comment #1 from [email protected] 2011-09-01 10:36:59 UTC ---
Furthermore, if I edit the patch to force create the table (by removing IF NOT
EXISTS), then I get the following error (varbinary isn't recognised)


Creating click_tracking table...PHP Warning:  pg_query(): Query failed: ERROR: 
type "varbinary" does not exist
LINE 3:  session_id varbinary(255) NOT NULL,
                    ^ in /path/to/includes/db/DatabasePostgres.php on line 237
A database query syntax error has occurred.
The last attempted database query was:
"CREATE TABLE click_tracking (
 action_time char(14) NOT NULL,
 session_id varbinary(255) NOT NULL,
 is_logged_in tinyint NOT NULL,
 user_total_contribs integer,
 user_contribs_span1 integer,
 user_contribs_span2 integer,
 user_contribs_span3 integer,
 namespace integer NOT NULL,
 event_id integer NOT NULL,
 additional_info varbinary(255)
 ) /*$wgDBTableOptions*/
"
from within function "DatabaseBase::sourceFile(
/path/to/extensions/ClickTracking/patches/ClickTracking.sql )".
Database returned error "1: ERROR:  type "varbinary" does not exist
LINE 3:  session_id varbinary(255) NOT NULL,

-- 
Configure bugmail: https://bugzilla.wikimedia.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
You are on the CC list for the bug.

_______________________________________________
Wikibugs-l mailing list
[email protected]
https://lists.wikimedia.org/mailman/listinfo/wikibugs-l

Reply via email to