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

[dotpro]

Hi,

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

see screenshot

 

[Clement]

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]

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]

Oh sorry, my question was about the xf_post table and the xfa_extmod_links_state column

 

[dotpro]

Oh sorry, my question was about the xf_post table and the xfa_extmod_links_state column

No.

 

[Clement]

No ? You mean it's not there ?

 

[dotpro]

No ? You mean it's not there ?

The column is not there.

 

[Clement]

Oh, that's not normal.

Please run the following query manually, reactivate the addon and see if that works correctly now.

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]

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]

I ran the query manually and it says:
MySQL said:

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

 

[dotpro]

I ran the query manually and it says:
MySQL said:

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

I was able to fix this by clearing some disk space.

 

[Clement]

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