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
Comment #1
xcf33 CreditAttribution: xcf33 commentedHi
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!
Comment #2
Nazia CreditAttribution: Nazia commentedThanks 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?
Comment #3
wastrilith2k CreditAttribution: wastrilith2k commentedAre 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
Comment #4
Stephen Rockwell CreditAttribution: Stephen Rockwell commentedI'm experiencing this error. Did anyone solve this one?
Comment #5
ElusiveMind CreditAttribution: ElusiveMind commentedThis 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
Comment #6
ElusiveMind CreditAttribution: ElusiveMind commentedComment #7
ElusiveMind CreditAttribution: ElusiveMind commentedComment #8
ElusiveMind CreditAttribution: ElusiveMind commented