• 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
Joined
Nov 30, 2017
Messages
7
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

MtoR

Freaky Coder
Staff member
Joined
Nov 14, 2015
Messages
5,753
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
Joined
Nov 30, 2017
Messages
7
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.
 

MtoR

Freaky Coder
Staff member
Joined
Nov 14, 2015
Messages
5,753
Oh sorry, my question was about the xf_post table and the xfa_extmod_links_state column
 

MtoR

Freaky Coder
Staff member
Joined
Nov 14, 2015
Messages
5,753
No ? You mean it's not there ?
 

MtoR

Freaky Coder
Staff member
Joined
Nov 14, 2015
Messages
5,753
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
Joined
Nov 30, 2017
Messages
7
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
 

dotpro

New Member
Joined
Nov 30, 2017
Messages
7
I ran the query manually and it says:
MySQL said:

#1114 - The table '#sql-2fd2_e376ea' is full
 

MtoR

Freaky Coder
Staff member
Joined
Nov 14, 2015
Messages
5,753
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