Support » Plugin: NextScripts: Social Networks Auto-Poster » The log does not contain information

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author NextScripts

    (@nextscripts)

    Please make sure you have the correct tables.

    https://www.nextscripts.com/snap-wordpress-tables/

    I do not use MySQL. I’m using Sqlite3 database. What should I do in this case?

    Plugin Author NextScripts

    (@nextscripts)

    You still need to create those tables.

    Error screenshot https://i.imgur.com/qHJlk9S.png

    I used this SQL code

    CREATE TABLE wp_nxs_log (
    id bigint(20) NOT NULL AUTO_INCREMENT,
    date datetime DEFAULT '1970-01-01 00:00:01' NOT NULL,
    uid bigint(20) DEFAULT 0 NOT NULL,
    act VARCHAR(255) DEFAULT '' NOT NULL,
    nt VARCHAR(255) DEFAULT '' NOT NULL,
    type VARCHAR(255) DEFAULT '' NOT NULL,
    flt VARCHAR(20) DEFAULT '' NOT NULL,
    nttype VARCHAR(20) DEFAULT '' NULL,
    msg text NOT NULL,
    extInfo text NULL,
    UNIQUE KEY id (id)
    );
    
    CREATE TABLE wp_nxs_query(
    id bigint(20) NOT NULL AUTO_INCREMENT,
    datecreated datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    type VARCHAR(55) DEFAULT '' NOT NULL,
    postid mediumint(9) NULL,
    uid bigint(20) DEFAULT 0 NOT NULL,
    nttype VARCHAR(55) NULL,
    timetorun datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
    refid mediumint(9) NULL,
    descr VARCHAR(255) NULL,
    extInfo text NULL,
    UNIQUE KEY id (id)
    );

    Error in query (1): near “AUTO_INCREMENT”: syntax error

    Please write the SQL command for Sqlite3

Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘The log does not contain information’ is closed to new replies.