Forums
Hi Opigno
I've recently migrated to a new host and as well as changed my domain name and since then I can't create Courses and Classes (other content creates fine). I get the same error in the logs each time regardless of whether I try to create a course or a class as it must call the same function and SQL.
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 1: DELETE FROM {opigno_activities_instance_user_day} WHERE (uid = :db_condition_placeholder_0) AND (activity_instance_id IN ()) ; Array ( [:db_condition_placeholder_0] => 1 ) in opigno_activities_reset_achievments() (line 616 of/home/lifeunco/public_html/sites/all/modules/opigno_activities/opigno_activities.module).
also occasionally getting a strange page not found message although not sure if related...
http://lifeup.be/public://cd54df872b8b3c55b9b50aa187d151b3544908762fe93…
Any ideas what's gone wrong?
Many thanks
Scott
Hi Scott,
Hi Scott,
It is very difficult to debug this without looking at the instance.
Best regards