I am beginner leaner of open Calais, facing error but don't know how to solve this, can please someone help me to solve this..;

PDOException: 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 '))' at line 2: SELECT base.tid AS tid, base.vid AS vid, base.name AS name, base.description AS description, base.format AS format, base.weight AS weight, v.machine_name AS vocabulary_machine_name FROM {taxonomy_term_data} base INNER JOIN {taxonomy_vocabulary} v ON base.vid = v.vid WHERE (base.name LIKE :db_condition_placeholder_0 ESCAPE '\') AND (base.vid IN ()) ; Array ( [:db_condition_placeholder_0] => Nintendo ) in DrupalDefaultEntityController->load() (line 196 of /mnt/www/html/info797dev/docroot/includes/entity.inc).

Comments

xcf33’s picture

Hi

This does not seem like an opencalais issue. Rather it seems you have some database inconsistencies.

I would suggest the following:

1. Delete the taxonomy vocabulary created by opencalais (i.e. person, region, organization, etc)
2. Re-configure the content type to enable open calais, this will allow the system to re-create the taxonomy vocabularies.

Let me know if this helps.

Cheers!

Nazia’s picture

Thanks for your reply and suggestion but i did as you mentioned and its still giving same error.. I read on some blogs that open Calais gives these kind of error on submitting node/any content type... is that true? or is there any way to solve this issue?

wastrilith2k’s picture

Are you still experiencing this error?

If so, can you please provide a bit about how you are trying to use OpenCalais? Are you having it analyze blog content or integrating it with something else? What taxonomies and settings are you using?

--James

Stephen Rockwell’s picture

Issue summary: View changes

I'm experiencing this error. Did anyone solve this one?

ElusiveMind’s picture

This error occurs when an OpenCalais taxonomy does not exist for the term entity retrieved. These term entities are slightly changed from what was installed by the module at runtime. This is a longstanding bug in the module.

1. Make sure you have the latest 7.x-1.x code at: https://github.com/ElusiveMind/opencalais

2. Uninstall the module

3. Reinstall the module

If this does not fix the problem, please file a bug report at:
https://github.com/ElusiveMind/opencalais/issues

ElusiveMind’s picture

Assigned: Unassigned » ElusiveMind
ElusiveMind’s picture

Status: Active » Needs review
ElusiveMind’s picture

Status: Needs review » Fixed

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.