WordPress.org

Ready to get started?Download WordPress

Forums

Postsible : Facebook Content Management
[resolved] I get and error when I click on the "Connect (6 posts)

  1. tomarsh
    Member
    Posted 2 years ago #

    Error Number: 1054

    Unknown column 'table' in 'field list'

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

    Filename: /home/admin/domains/postsible.com/public_html/api/models/main.php

    Line Number: 448

    http://wordpress.org/extend/plugins/postsible-facebook-content-management/

  2. jackavin
    Member
    Plugin Author

    Posted 2 years ago #

    Thanks you for report this bug. This issue has been resolved.

  3. paulgagu
    Member
    Posted 1 year ago #

    I got this error when click CONNECT:

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

  4. hotguitar
    Member
    Posted 1 year ago #

    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 http://qa2100.com

    Is the solution the same as posted above? There is no "error" posted with it .......

  5. hotguitar
    Member
    Posted 1 year ago #

    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

  6. hotguitar
    Member
    Posted 1 year ago #

    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 http://qa2100.com

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

    Thanks,

    Bill

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic