penth

Forum Replies Created

Viewing 4 replies - 1 through 4 (of 4 total)
  • Forum: Plugins
    In reply to: [WordPress MU Domain Mapping] Domain Mapping not playing with pg4wp?
    Thread Starter penth

    (@penth)

    13 years ago

    Kludge has worked only partially. Even restoring the key constraint in the database leaves me with seven different domains all pointing to the first site I linked. :p

    KEY 'blog_id' ('blog_id','domain','active')
    replaced by
    UNIQUE ('blog_id','domain','active')

    Forum: Plugins
    In reply to: [WordPress MU Domain Mapping] Domain Mapping not playing with pg4wp?
    Thread Starter penth

    (@penth)

    13 years ago

    Thanks, hawk, Logs are on their way.

    Forum: Plugins
    In reply to: [WordPress MU Domain Mapping] Domain Mapping not playing with pg4wp?
    Thread Starter penth

    (@penth)

    13 years ago

    This is a kludge, but it was just enough tweaking to get it playing nice. I had to replace tinyint and take out the automatic trigger.

    /srv/wordpress/plugins/wordpress-mu-domain-mapping$ diff --normal domain_mapping.php domain_mapping.php.original
98,99c98,100
< 				<code>active</code> int(4) default '1',
< 				PRIMARY KEY  (<code>id</code>)
---
> 				<code>active</code> tinyint(4) default '1',
> 				PRIMARY KEY  (<code>id</code>),
> 				KEY <code>blog_id</code> (<code>blog_id</code>,<code>domain</code>,<code>active</code>)
108c109
< 				<code>t</code> timestamp NOT NULL default CURRENT_TIMESTAMP,
---
> 				<code>t</code> timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
    Forum: Plugins
    In reply to: [WordPress MU Domain Mapping] Domain Mapping not playing with pg4wp?
    Thread Starter penth

    (@penth)

    13 years ago

    I did some checking in the postgres logs and found the following:

    2013-04-17 12:39:13 EDT ERROR:  type "tinysmallint" does not exist at character
183
2013-04-17 12:39:13 EDT STATEMENT:  CREATE TABLE wpst_domain_mapping (
                                        id bigint NOT NULL DEFAULT nextval('wpst
_domain_mapping_seq'::text),
                                        blog_id bigint NOT NULL,
                                        domain varchar(255) NOT NULL,
                                        active tinysmallint default '1',
                                        PRIMARY KEY  (id),
                                        KEY blog_id (blog_id,domain,active)
                                );;
        CREATE SEQUENCE wpst_domain_mapping_seq;
2013-04-17 12:39:13 EDT ERROR:  syntax error at or near "on" at character 181
2013-04-17 12:39:13 EDT STATEMENT:  CREATE TABLE wpst_domain_mapping_logins (
                                        id varchar(32) NOT NULL,
                                        user_id bigint NOT NULL,
                                        blog_id bigint NOT NULL,
                                        t timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
                                        PRIMARY KEY  (id)
                                );;
2013-04-17 12:39:14 EDT ERROR:  relation "wpst_domain_mapping" does not exist at character 21
Viewing 4 replies - 1 through 4 (of 4 total)