What's new
Xen Factory

Register today to become a member! Once signed in, you'll be able to start purchasing our products, ask questions, request support and suggest new ideas!

  • This area is dedicated to the support of our xF1 add-ons. For xF2, please use the dedicated area: HERE.
  • We are aware that a no permission error was shown when you tried to purchase in the last 2 days, this is now fixed.

Support Resolved errors with EM: mysqli prepare error: unknown column

dotpro

New Member
Hi,

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

see screenshot
 

Attachments

  • xfa-mod-error.jpg
    xfa-mod-error.jpg
    87 KB · Views: 2

Clement

Freaky Coder
Staff member
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
 

dotpro

New Member
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

Hi,

Yes that table has the xfa_extmod_file_state colum

The mod is disabled until this issue is resolved.
 

Clement

Freaky Coder
Staff member
Oh sorry, my question was about the xf_post table and the xfa_extmod_links_state column
 

Clement

Freaky Coder
Staff member
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.
 

dotpro

New Member
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
 

Clement

Freaky Coder
Staff member
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
 
Top