All Low add-ons are now owned by EEHarbor. Read the blog post.

Support archive

Low Search install issue...

twofish 17 Jul 2012 16:40 problem, rejected

Low -

I'm getting this 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 'fields TEXT NOT NULL, entries TEXT NOT NULL, PRIMARY KEY (log_id))' at line 1

CREATE TABLE IF NOT EXISTS exp_low_search_replace_log ( log_id int(10) unsigned NOT NULL AUTO_INCREMENT, site_id int(4) unsigned NOT NULL, member_id int(10) unsigned NOT NULL, replace_date int(10) unsigned NOT NULL, keywords varchar(150) NOT NULL, replacement varchar(150) NOT NULL, fields TEXT NOT NULL, entries TEXT NOT NULL, PRIMARY KEY (log_id))

Filename: third_party/low_search/libraries/Low_search_model.php

Line Number: 332

I'm running the latest of both EE and Low Search. I'm using MSM.

Thanks for any help!

Best,
Jacob

Replies

  1. Low 17 Jul 2012 16:47

    Hi Jacob,

    What version of MySQL are you using?

  2. twofish 17 Jul 2012 16:50

    4.1.22-standard

  3. Low 17 Jul 2012 17:09

    Looks like the 'fields' attribute is a reserved word in MySQL < 5. Is there any chance you can upgrade MySQL to 5+? On a sidenote, ExpressionEngine 2.6 will also require MySQL 5.

  4. twofish 17 Jul 2012 17:28

    I'll check with the host provider. It's client work - so it's out of my control somewhat.

    I know they are planning on switching hosts soon.

    Thanks - I'll let you know if it isn't resolved somehow.