Openscholar should escape double quotes in titles (Publications). If not, an incorrect assignment of publication nodes is done to wrong authors and a mysql error is presented when the nodes are opened:

"user warning: 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 ')) ORDER BY timestamp DESC' at line 1 query: SELECT timestamp FROM views_content_cache WHERE (()) ORDER BY timestamp DESC in /home/public_html/sites/all/modules/contrib/views_content_cache/views_content_cache.module on line 164."

we are testing the latest available beta

Comments

rbrandon’s picture

rbrandon commented
Status: Active » Postponed (maintainer needs more info)

I can not reproduce this creating publications with single and double quotes. I also do not see any un-escaped values in the sql you pasted above.

Could you please post steps to reproduce and/or verify that this exists in Beta13.

Thanks,
Richard

taih’s picture

taih commented

thank you very much for your reply. I have checked our version and it's not 13 but 12, indeed. let us update and re-check.

taih’s picture

taih commented
Status: Postponed (maintainer needs more info) » Active

we are experiencing a lot of errors after updating (12->13). sorry, but it seems I will not be able to give you more information immediately.

anyway, thank you very much for your attention. I will keep you updated

taih’s picture

taih commented

Richard, it seems you can close this issue, or at least make it only for the beta 12. beta 13 is having no problem at all dealing with single or double quotes.

thanks for your great job here

simon georges’s picture

simon georges commented
Status: Active » Fixed

As stated by the user, it works now.

Status: Fixed » Closed (fixed)

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

Anonymous’s picture

(not verified) commented
Issue summary: View changes

minor changes in the explanation