Publisher does not support the Fluid field type. Please do not contact asking when support will be available.

If you purchased an add-on from expressionengine.com, be sure to visit boldminded.com/claim to add the license to your account here on boldminded.com.

Ticket: MySQL error when installing Publisher Low Search

Status	Resolved
Add-on / Version	Publisher Low Search 2.0
Severity
EE Version	2.9.2

Keiron Lowe

Mar 27, 2015

When I try to install the Publisher Low Search plugin, I get the following error:

A Database Error Occurred
Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '{ee()->publisher_lib->default_lang_id} AFTER `site_id`' at line 1

ALTER TABLE `{ee()->db->dbprefix}low_search_indexes` ADD COLUMN `publisher_lang_id` int(4) NOT NULL DEFAULT {ee()->publisher_lib->default_lang_id} AFTER `site_id`

Filename: third_party/publisher_low_search/ext.publisher_low_search.php

Line Number: 408

If I refresh the page, it switches between that error and this one:

A Database Error Occurred
Error Number: 1054

Unknown column 'publisher_lang_id' in 'where clause'

DELETE FROM `exp_low_search_indexes` WHERE `publisher_lang_id` != 1

Filename: third_party/publisher_low_search/ext.publisher_low_search.php

Line Number: 432

BoldMinded (Brian)

Keiron, I just uploaded a fix for this to Devot:ee. Sorry about that.

Keiron Lowe

No worries, thanks for the quick fix, it worked.