I am using a standard XAMPP setup on windows. The install did go fine (I think) after I changed the max_execution_time = 300 in php.ini. Everything seems fine in terms of setup.

However, when I create a course , upon submit I get this Warning!

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 ') AND ou.is_admin < 1 AND ou.uid > 1 ORDER BY ou.uid ASC' at line 4 query: SELECT ou.uid FROM og_uid ou WHERE ou.is_active = 1 AND ou.nid IN () AND ou.is_admin < 1 AND ou.uid > 1 ORDER BY ou.uid ASC in C:\xampp\htdocs\phpedu-beta4\sites\all\modules\phpedu\pe_edu\pe_edu_helpers.inc on line 539.

Notice the empty () IN clause which I think is because no course group is associated. From what I understand course should have an associated course group with teachers. I don't see options to create that. When I tried to create it directly by typing /node/add/pe-group-course , get the error message "You can't manually add a course group node without a course context!"

To cross check re-imported the pe-group-course content type, but find that it is not getting listed under content type. The status remains same. What am I missing?

Comments

dakala’s picture

dakala
he/him
Primary language English
Location Fairford, Glos
commented

Make sure you have a Course for the current academic year/term. Also, you have lecturers (teachers) to teach the course. Go to the Course page and you will see a tab "Add Teacher". Click that tab and each time you add a lecturer/teacher a group will be created for them.

sandyray’s picture

sandyray commented

I checked that and think the trouble is the 'Add Teacher' tab does not show. In fact I get the error right when submitting a new course(create). Going to try with a re-install to see if something got corrupted during setup or subsequent configuration.

sandyray’s picture

sandyray commented

Re-installed once again without any error but still facing the same issue i.e warning on new course creation.

BTW, there is another issue with pe_program module. The install schema function function pe_program_schema() declares

'cid'     => array('type' => 'serial', 'unsigned' => TRUE, 'not null' => TRUE, 'default' => 0)

This fails during installation and no table is created even though no error is shown on the message list. Omitting 'default' => 0 does make it go away but I am not sure if that is the right fix or if this is related to a version of mysql

patchak’s picture

patchak commented

I have the same issue, when I create a course node, I get this error :

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 ') AND ou.is_admin < 1 AND ou.uid > 1 ORDER BY ou.uid ASC' at line 4 query: SELECT ou.uid FROM og_uid ou WHERE ou.is_active = 1 AND ou.nid IN () AND ou.is_admin < 1 AND ou.uid > 1 ORDER BY ou.uid ASC in /Applications/MAMP/htdocs/phpedu/phpedu-beta4/sites/all/modules/phpedu/pe_edu/pe_edu_helpers.inc on line 537.

I created a "teacher" user, but still it seems I cannot do anything to associate a course node to a course group, or whatever it needs to actually work!!!

Some details would be welcome about how we need to configure all this!! Thanks for any help!

Patchak

GolDRoger’s picture

GolDRoger commented

Same problem for me, any solution?