WordPress.org

Ready to get started?Download WordPress

Forums

PostgreSQL for WordPress (PG4WP)
[resolved] PG4WP error (2 posts)

  1. cavila
    Member
    Posted 2 years 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/

  2. cavila
    Member
    Posted 2 years ago #

    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)
     )

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic