1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.
  2. This area is dedicated to the support of our xF1 add-ons. For xF2, please use the dedicated area: HERE.
Chirstmas offer
Guest, until end of december all our add-ons and renewal prices are 50% off.
Start shopping NOW !
Dismiss Notice
We have just posted about our product policy for XF2.
Click HERE to view it.

Support errors with EM: mysqli prepare error: unknown column

Discussion in 'Extended Moderation' started by dotpro, Dec 1, 2017.

  1. dotpro

    dotpro New Member

    Joined:
    Nov 30, 2017
    Messages:
    7
    Likes Received:
    0
    Adress:
    Country:
    Location on Map:
    Hi,

    I installed the mod last night and users are getting this error:
    mysqli prepare error: unknown column 'xfa_extmod_links_state'

    see screenshot
     

    Attached Files:

  2. MtoR

    MtoR Freaky Coder
    Staff Member

    Joined:
    Nov 14, 2015
    Messages:
    3,477
    Likes Received:
    524
    Hi,

    You should disable the mod until we figure out the issue (ie. only active when we try stuff).

    Do you have a xfa_extmod_file_state column in the xf_attachment table ?

    Clément
     
  3. dotpro

    dotpro New Member

    Joined:
    Nov 30, 2017
    Messages:
    7
    Likes Received:
    0
    Adress:
    Country:
    Location on Map:
    Hi,

    Yes that table has the xfa_extmod_file_state colum

    The mod is disabled until this issue is resolved.
     
  4. MtoR

    MtoR Freaky Coder
    Staff Member

    Joined:
    Nov 14, 2015
    Messages:
    3,477
    Likes Received:
    524
    Oh sorry, my question was about the xf_post table and the xfa_extmod_links_state column
     
  5. dotpro

    dotpro New Member

    Joined:
    Nov 30, 2017
    Messages:
    7
    Likes Received:
    0
    Adress:
    Country:
    Location on Map:
    No.
     
  6. MtoR

    MtoR Freaky Coder
    Staff Member

    Joined:
    Nov 14, 2015
    Messages:
    3,477
    Likes Received:
    524
    No ? You mean it's not there ?
     
  7. dotpro

    dotpro New Member

    Joined:
    Nov 30, 2017
    Messages:
    7
    Likes Received:
    0
    Adress:
    Country:
    Location on Map:
    The column is not there.
     
  8. MtoR

    MtoR Freaky Coder
    Staff Member

    Joined:
    Nov 14, 2015
    Messages:
    3,477
    Likes Received:
    524
    Oh, that's not normal.

    Please run the following query manually, reactivate the addon and see if that works correctly now.
    Code:
    ALTER TABLE xf_post ADD `xfa_extmod_links_state` ENUM( 'visible', 'moderated' ) NOT NULL DEFAULT  'visible';
    
    In order to be sure that everything is fine, please also check in xf_node table if the column xfa_extmod_node_conf exists and in the xf_thread_reply_ban table if the column xfa_extmod_trban_conf exists.
     
  9. dotpro

    dotpro New Member

    Joined:
    Nov 30, 2017
    Messages:
    7
    Likes Received:
    0
    Adress:
    Country:
    Location on Map:
    thanks.
    both xf_node table if the column xfa_extmod_node_conf exists and in the xf_thread_reply_ban table if the column xfa_extmod_trban_conf exist
     
  10. dotpro

    dotpro New Member

    Joined:
    Nov 30, 2017
    Messages:
    7
    Likes Received:
    0
    Adress:
    Country:
    Location on Map:
    I ran the query manually and it says:
    MySQL said:

    #1114 - The table '#sql-2fd2_e376ea' is full
     
  11. dotpro

    dotpro New Member

    Joined:
    Nov 30, 2017
    Messages:
    7
    Likes Received:
    0
    Adress:
    Country:
    Location on Map:
    I was able to fix this by clearing some disk space.
     
  12. MtoR

    MtoR Freaky Coder
    Staff Member

    Joined:
    Nov 14, 2015
    Messages:
    3,477
    Likes Received:
    524
    Oh, that may explain why you have had issues.

    It may have popped similarly upon install thus leading to the column not being there.

    Clément
     

Share This Page