Select Page

SNAP for WordPress Tables

SNAP for WordPress Tables

SNAP adds two tables to the WordPress Database. It should create those tables automatically during the activation. In case your site has overprotective security and WordPress does not allow to create tables, please use this SQL code to create them manually:

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

Please note that if are using some other prefix than default “wp_”, please adjust tables names wp_nxs_query and wp_nxs_log accordingly.

SNAP Pro for Wordpress

Pro version upgrade adds the ability to configure more than one account for each social network and some additional features.

Get SNAP Pro

Latest Blogposts

Corrupted cache issue with SNAP Pro.

Corrupted cache issue with SNAP Pro.

What happened? SNAP Pro is checking for API update every 6 hours. Today (May 22, 2019) around 6:30PM EST Google Cloud messed our update server for about 7 minutes. A bunch of "lucky" sites that were checking for update during those 7 minutes got their plugin cache...

Support for “Google My Business” is coming soon…

Support for “Google My Business” is coming soon…

Support for "Google My Business" is coming this fall. Google recently made some kind of blog-a-like functionality available for local business listings. As a local business owner you can add posts, events, offers as well as products to your business listing. Although...

Facebook app review

Facebook app review

We are getting a lot of questions about upcoming deadline for Facebook app review. People are asking what should we do. The honest answer would be: "No one has any idea". We submitted several apps for Facebook review using different ways of describing and explaining...

What happened with Facebook

What happened with Facebook

What happened with Facebook? Facebook made changes to it's API access policy on May 1st, 2018. As the result we introduced our own Premium API for Facebook.  We feel that we need to explain how exactly those changes affected SNAP. Since the beginning Facebook native...

Instagram issues

Instagram issues

Instagram made some very big changes to authentication process. About 70% of our users are affected by them. Before the changes the process was quite simple: Sometimes Instagram decided that login from SNAP is "unusual" and asked for confirmation. You just had to open...

SNAP for Wordpress

SNAP for Wordpress

SNAP for Wordpress MultiUser

SNAP for Wordpress MultiUser

SNAP API

SNAP API