[Plugin: PostgreSQL for WordPress (PG4WP)] PG4WP error

Resolved cavila
(@cavila)

12 years, 4 months ago

It could create other tables but failed with comments table.
Looks like bad generate SQL syntax below:

CREATE TABLE wp321_comments ( comment_ID bigint(20) unsigned NOT NULL auto_increment, comment_post_ID bigint(20) unsigned NOT NULL default ‘0’, comment_author tinytext NOT NULL, comment_author_email varchar(100) NOT NULL default ”, comment_author_url varchar(200) NOT NULL default ”, comment_author_IP varchar(100) NOT NULL default ”, comment_date datetime NOT NULL default ‘0000-00-00 00:00:00’, comment_date_gmt datetime NOT NULL default ‘0000-00-00 00:00:00’, comment_content text NOT NULL, comment_karma int(11) NOT NULL default ‘0’, comment_approved varchar(20) NOT NULL default ‘1’, comment_agent varchar(255) NOT NULL default ”, comment_type varchar(20) NOT NULL default ”, comment_parent bigint(20) unsigned NOT NULL default ‘0’, user_id bigint(20) unsigned NOT NULL default ‘0’, PRIMARY KEY (comment_ID), KEY comment_approved (comment_approved), KEY comment_post_ID (comment_post_ID), KEY comment_approved_date_gmt (comment_approved,comment_date_gmt), KEY comment_date_gmt (comment_date_gmt), KEY comment_parent (comment_parent) ) DEFAULT CHARACTER SET utf8

Using the following shipped db.php

[Code moderated as per the Forum Rules. Please use the pastebin]

http://wordpress.org/extend/plugins/postgresql-for-wordpress/

Viewing 1 replies (of 1 total)

Thread Starter

(@cavila)

I created the table manually my entering the following
CREATE TABLE COMMAND at Postgresql client:

CREATE TABLE wp321_comments (
  comment_ID serial NOT NULL
 , comment_post_ID bigint NOT NULL default '0'
 , comment_author varchar NOT NULL, comment_author_email varchar(100) NOT NULL default ''
 , comment_author_url varchar(200) NOT NULL default '', comment_author_IP varchar(100) NOT NULL default ''
 , comment_date timestamp NOT NULL default now(), comment_date_gmt timestamp NOT NULL default now()
 , comment_content text NOT NULL, comment_karma int NOT NULL default '0', comment_approved varchar(20) NOT NULL default '1'
 , comment_agent varchar(255) NOT NULL default '', comment_type varchar(20) NOT NULL default '', comment_parent bigint NOT NULL default '0'
 , user_id bigint NOT NULL default '0'
 , CONSTRAINT wp321_comments_pk PRIMARY KEY (comment_ID)
 --, KEY comment_approved (comment_approved), KEY comment_post_ID (comment_post_ID)
 --, KEY comment_approved_date_gmt (comment_approved,comment_date_gmt)
-- , KEY comment_date_gmt (comment_date_gmt), KEY comment_parent (comment_parent)
 )

Viewing 1 replies (of 1 total)

The topic ‘[Plugin: PostgreSQL for WordPress (PG4WP)] PG4WP error’ is closed to new replies.