Jump to:
| Project: | phpEdu |
| Version: | 6.x-1.1-beta4 |
| Component: | Code |
| Category: | bug report |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Issue Summary
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
#1
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.
#2
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.
#3
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
#4
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
#5
Same problem for me, any solution?