Hello

When I try to index my content, I've got an error message :
Couldn't index items. Check the logs for details.

And in the logs, errors like :
SQLSTATE[42000]: Syntax error or access violation: 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 'WHERE (item_id = '75')' at line 1

always with mention of "WHERE item_id = 'xx'"

Server is "Database server", not SolR at this time.

In phpMyAdmin I can see that tables where created for this index, but they are empty.

Have you got an idea of what it could be ?

thank you

Comments

drunken monkey’s picture

drunken monkey
he/him
Primary language German
Location Vienna, Austria
commented
Status: Active » Closed (duplicate)

See #1346846: Fix DB exception when indexing with stale index data.

dhayles’s picture

dhayles commented

I have the same problem as above but the link you suggest doesn't solve this problem:

I have the following line in my log that looks a bit dodgy:

SEVERE: org.apache.solr.common.SolrException: [doc=default_node_index-1] missing required field: entity_type

However I have checked the field list and can confirm that there is no existing field named 'entity_type'.

dhayles’s picture

dhayles commented

Although that error doesn't appear if I have the solr server turned off. but the error message still appears:

Couldn't index items. Check the logs for details.

It is impossible for me to index anything using this module. does anyone know of a better module for using facets?