2 posts / 0 new
Last post
Last seen: 5 years 4 months ago
Joined: 11/15/2013
Can't create Courses & Classes

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

James Aparicio
James Aparicio's picture
Last seen: 1 week 5 days ago
Joined: 10/30/2013
Hi Scott,

Hi Scott,

It is very difficult to debug this without looking at the instance.

Best regards