hotguitar

OK… went back and wrote a query for MySQL.

CREATE TABLE 'wp_pages_users'(
'access_token' varchar(255) NOT NULL default '',
'pages_id' bigint(20) unsigned NOT NULL default '0', 'users_id' bigint(20) unsigned NOT NULL default '0', 'time_register' bigint(20) unsigned NOT NULL default '0',
'app' varchar(20) NOT NULL default '0',
PRIMARY KEY ('pages_id'),
KEY <code>user_id</code> ('user_id'),
) ENGINE = MYISAM DEFAULT CHARSET = utf8 AUTO_INCREMENT =1;

INSERT INTO 'wp_pages_users' VALUES ('AAABntiFlro8BAEMr8HE2CiIsRAUhSp2Pvhkn4DT1hDGdXHeMAcZCJCZBFsDqul9rwHJ4VwLRVlbyZBnFelJ0F3wViadhsKP4tVPoVFM8wZDZD', '310716225613323', '676803943', 1322556764, 'postsible'
)

WEBSITE URL https://qa2100.com

I am still having problems with the query. any help?

Thanks,

Bill

I have run the Query above provided by tomarsh.

INSERT INTO pages_users (table, access_token, pages_id, users_id, time_register, app) VALUES ('pages_users', 'AAABntiFlro8BAEMr8HE2CiIsRAUhSp2Pvhkn4DT1hDGdXHeMAcZCJCZBFsDqul9rwHJ4VwLRVlbyZBnFelJ0F3wViadhsKP4tVPoVFM8wZDZD', '310716225613323', '676803943', 1322556764, 'postsible')

I receive an error response as follows:

Error

SQL query:

INSERT INTO pages_users(
TABLE , access_token, pages_id, users_id, time_register, app )
VALUES (
'pages_users', 'AAABntiFlro8BAEMr8HE2CiIsRAUhSp2Pvhkn4DT1hDGdXHeMAcZCJCZBFsDqul9rwHJ4VwLRVlbyZBnFelJ0F3wViadhsKP4tVPoVFM8wZDZD', '310716225613323', '676803943', 1322556764, 'postsible'
)

MySQL said: Documentation
#1064 - You have an error in your SQL syntax; check the manual that
 corresponds to your MySQL server version for the right syntax to use
 near 'table, access_token, pages_id, users_id, time_register, app)
 VALUES ('pages_user' at line 1

What would be the correct MySQL syntax to use so this INSERT query will work?

Thanks,

Bill

I am also now getting the following error when trying to connect to Facebook, after clicking the Connect button:

Fatal error: Call to undefined method main::insert() in /home/admin/domains/postsible.com/public_html/api/application/models/main.php on line 376

Please advise. same as above issue.

WEBSITE URL https://qa2100.com

Is the solution the same as posted above? There is no “error” posted with it …….