Title: penth's Replies | WordPress.org

---

# penth

  [  ](https://wordpress.org/support/users/penth/)

 *   [Profile](https://wordpress.org/support/users/penth/)
 *   [Topics Started](https://wordpress.org/support/users/penth/topics/)
 *   [Replies Created](https://wordpress.org/support/users/penth/replies/)
 *   [Reviews Written](https://wordpress.org/support/users/penth/reviews/)
 *   [Topics Replied To](https://wordpress.org/support/users/penth/replied-to/)
 *   [Engagements](https://wordpress.org/support/users/penth/engagements/)
 *   [Favorites](https://wordpress.org/support/users/penth/favorites/)

 Search replies:

## Forum Replies Created

Viewing 4 replies - 1 through 4 (of 4 total)

 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WordPress MU Domain Mapping] Domain Mapping not playing with pg4wp?](https://wordpress.org/support/topic/domain-mapping-not-playing-with-pg4wp/)
 *  Thread Starter [penth](https://wordpress.org/support/users/penth/)
 * (@penth)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/domain-mapping-not-playing-with-pg4wp/#post-3675395)
 * 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](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WordPress MU Domain Mapping] Domain Mapping not playing with pg4wp?](https://wordpress.org/support/topic/domain-mapping-not-playing-with-pg4wp/)
 *  Thread Starter [penth](https://wordpress.org/support/users/penth/)
 * (@penth)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/domain-mapping-not-playing-with-pg4wp/#post-3675376)
 * Thanks, hawk, Logs are on their way.
 *   Forum: [Plugins](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WordPress MU Domain Mapping] Domain Mapping not playing with pg4wp?](https://wordpress.org/support/topic/domain-mapping-not-playing-with-pg4wp/)
 *  Thread Starter [penth](https://wordpress.org/support/users/penth/)
 * (@penth)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/domain-mapping-not-playing-with-pg4wp/#post-3675374)
 * 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](https://wordpress.org/support/forum/plugins-and-hacks/)
    In
   reply to: [[WordPress MU Domain Mapping] Domain Mapping not playing with pg4wp?](https://wordpress.org/support/topic/domain-mapping-not-playing-with-pg4wp/)
 *  Thread Starter [penth](https://wordpress.org/support/users/penth/)
 * (@penth)
 * [13 years, 1 month ago](https://wordpress.org/support/topic/domain-mapping-not-playing-with-pg4wp/#post-3675365)
 * 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)