Error: table wp_nxs_log ‘s primary key is not set at the first column

  • Resolved saveatrain

    (@saveatrain)


    4 years, 7 months ago

    hello, i am trying to access this table and i get the following error,
    do you know what i should do to resolve this please?

    Error: table wp_nxs_log ‘s primary key is not set at the first column

    The page I need help with: [log in to see the link]

Viewing 8 replies - 1 through 8 (of 8 total)
  • Plugin Author lorro

    (@lorro)

    4 years, 7 months ago

    Is this a table from: Social Networks Auto-Poster WordPress Plugin?

    Thread Starter saveatrain

    (@saveatrain)

    4 years, 7 months ago

    yes, but any other table as well i get the same error for some reason…
    do you have a debug file, that i can perhaps send you?

    Plugin Author lorro

    (@lorro)

    4 years, 7 months ago

    If so, wp_nxs_log doesn’t have a primary key, at the first column or elsewhere.

    Are you able to:
    go to phpMyAdmin
    find the table
    go to the structure tab
    find the first row (the id row)
    in the Action column look for the “more” dropdown
    set the id row as the primary key?

    I’ve tested this and the plugin will work then.

    Plugin Author lorro

    (@lorro)

    4 years, 7 months ago

    I only see the no primary key error for the two nxs tables. I don’t see it for other tables, the posts table for instance.

    Thread Starter saveatrain

    (@saveatrain)

    4 years, 7 months ago

    actually i am unable to login to phpmyadmin, since it recognize my server as localhost:3306:3306 for some unknown reason, so i guess the problem is not with you, but with my side….

    sorry

    Plugin Author lorro

    (@lorro)

    4 years, 7 months ago

    Does the :3306 appear in the define line for the MySQL hostname in wp-config.php? If it says localhost:3306 try with just localhost

    It wouldn’t be right for the Simple Table Manage code to alter the structure of other plugins’ tables by setting a primary key if one is not found.

    Plugin Author lorro

    (@lorro)

    4 years, 3 months ago

    We have not heard from you so it looks like your issue has been resolved elsewhere. Marking as closed.

    Thread Starter saveatrain

    (@saveatrain)

    4 years, 3 months ago

    i decided not to deal with it, since i couldn’t find a the table on phpmyadmin
    sorry for not answering before
    happy new year

Viewing 8 replies - 1 through 8 (of 8 total)
  • The topic ‘Error: table wp_nxs_log ‘s primary key is not set at the first column’ is closed to new replies.