Assign Courses for Children not working

Antonio / Chris - we are going on our next round of course registrations. I have upgraded our site to the following:


PHP Version 5.3.8
Joomla! Version Joomla! 2.5.2 Stable [ Ember ] 5-March-2012 14:00 GMT
Joomdle: You are using Joomdle 0.7
JSPT Current Version 3.4.767
HikaShop Business 1.5.6, Joomla!™ E-Commerce Extension
JomSocial Version: 2.4.2
Moodle 1.9.13

I am having an issue with the menu item: assign course. Children show up in Student Module but they do not show up as a choice for assigning courses to... Any ideas?



Thanks,
Ron

Hi Ron.

Thanks for the bug report. I just tested it locally, and can confirm the problem.

I will look into it asap, and let you know.

Antonio

Hi again.

Just took a quick look, and it seems Joomla>1.7 stores user params differently.

If you want to fix it yourself, edit file administrator/components/com_joomdle/helper/parents.php, function getChildren.

Change sql by this one:

Antonio - thanks for the quick reply. When I made the change below, I only get the message:

"Waiting for <website name>..." in the bottom left of the browser window. It never goes to the page.

Could there be a typo in the change below?

I copied and pasted from my code.
I checked it now, and it is the same as in my code, so I don't know what may be happening to you.

Antonio - I checked again. If I wait long enough, it will eventually come back showing many students that do not belong to the parent account - all being available to select. In my case, it literally shows hundreds of students that can be chosen. Looking in the joomla users database under params, there are now many parents registered with each student. Somehow, more and more parents entries are being added to the params field in the users table. One the Moodle side, it only shows the correct student / parent relationship.

That sound like there is a bug somewhere, although I don't know where.

Did you use the sync parents action in users view recently?

If you could debug which action is triggering the adding of new parents to student accounts, we could look into it.
I can't think of why more parents got added to students accounts.

Antonio - sorry for the delay in getting back to this. Hope this will help. Here is a typical entry that I am seeing in the joomla users table. Note the farther down the table I go (higher user id number), the more parent id numbers are associated with that user. Another thing I have also noticed. All new entries since updating to J2.5 seem to be working fine. Only entries done with J1.5 seem to have this issue.

Any ideas on how to best "clean up" the user table?

{"admin_language":"","language":"","editor":"","helpsite":"","timezone":"","update_cache_list":"1","u_parent_id":"","u62_parent_id":"62","u92_parent_id":"92","u98_parent_id":"98","u348_parent_id":"348","emailVerified":"0","u260_parent_id":"260","u265_parent_id":"265","u232_parent_id":"232","u222_parent_id":"222","u241_parent_id":"241","u202_parent_id":"202","u360_parent_id":"360","u192_parent_id":"192","u190_parent_id":"190","u269_parent_id":"269","u236_parent_id":"236","u278_parent_id":"278","u234_parent_id":"234","u244_parent_id":"244","u292_parent_id":"292","u295_parent_id":"295","u227_parent_id":"227","u247_parent_id":"247","u299_parent_id":"299","u180_parent_id":"180","u392_parent_id":"392","u226_parent_id":"226","u264_parent_id":"264","u262_parent_id":"262","u263_parent_id":"263","u327_parent_id":"327","u199_parent_id":"199","u270_parent_id":"270","u239_parent_id":"239","u256_parent_id":"256","u254_parent_id":"254","u347_parent_id":"347","u340_parent_id":"340","u399_parent_id":"399","u533_parent_id":"533","u185_parent_id":"185","u707_parent_id":"707","u363_parent_id":"363","u201_parent_id":"201","u568_parent_id":"568","u372_parent_id":"372","u395_parent_id":"395","u375_parent_id":"375","u242_parent_id":"242","u385_parent_id":"385","u231_parent_id":"231","u220_parent_id":"220","u259_parent_id":"259","u400_parent_id":"400","u172_parent_id":"172","u719_parent_id":"719","u421_parent_id":"421","u409_parent_id":"409","u418_parent_id":"418","u435_parent_id":"435","u868_parent_id":"868","u223_parent_id":"223","u248_parent_id":"248","u425_parent_id":"425","u213_parent_id":"213","u449_parent_id":"449","u323_parent_id":"323","u441_parent_id":"441","u286_parent_id":"286","u470_parent_id":"470","u473_parent_id":"473","u450_parent_id":"450","u430_parent_id":"430","u485_parent_id":"485","u451_parent_id":"451","u493_parent_id":"493","u387_parent_id":"387","u590_parent_id":"590","u420_parent_id":"420","u506_parent_id":"506","u315_parent_id":"315","u448_parent_id":"448","u229_parent_id":"229","u505_parent_id":"505","u513_parent_id":"513","u517_parent_id":"517","u519_parent_id":"519","u525_parent_id":"525","u528_parent_id":"528","u207_parent_id":"207","u534_parent_id":"534","u518_parent_id":"518","u530_parent_id":"530","u322_parent_id":"322","u374_parent_id":"374","u543_parent_id":"543","u549_parent_id":"549","u617_parent_id":"617","u437_parent_id":"437","u581_parent_id":"581","u563_parent_id":"563","u569_parent_id":"569","u757_parent_id":"757","u574_parent_id":"574","u542_parent_id":"542","u171_parent_id":"171","u560_parent_id":"560","u602_parent_id":"602","u585_parent_id":"585","u488_parent_id":"488","u577_parent_id":"577","u508_parent_id":"508","u401_parent_id":"401","u597_parent_id":"597","u522_parent_id":"522","u603_parent_id":"603","u419_parent_id":"419","u552_parent_id":"552","u612_parent_id":"612","u627_parent_id":"627","u182_parent_id":"182","u609_parent_id":"609","u631_parent_id":"631","u626_parent_id":"626","u636_parent_id":"636","u532_parent_id":"532","u639_parent_id":"639","u191_parent_id":"191","u650_parent_id":"650","u521_parent_id":"521","u644_parent_id":"644","u388_parent_id":"388","u663_parent_id":"663","u608_parent_id":"608","u531_parent_id":"531","u665_parent_id":"665","u675_parent_id":"675","u674_parent_id":"674","u648_parent_id":"648","u712_parent_id":"712","u689_parent_id":"689","u490_parent_id":"490","u699_parent_id":"699","u691_parent_id":"691","u705_parent_id":"705","u696_parent_id":"696","u710_parent_id":"710","u715_parent_id":"715","u414_parent_id":"414","u659_parent_id":"659","u721_parent_id":"721","u640_parent_id":"640","u656_parent_id":"656","u730_parent_id":"730","u685_parent_id":"685","u782_parent_id":"782","u739_parent_id":"739","u744_parent_id":"744","u747_parent_id":"747","u743_parent_id":"743","u759_parent_id":"759","u619_parent_id":"619","u310_parent_id":"310","u763_parent_id":"763","u777_parent_id":"777","u780_parent_id":"780","u642_parent_id":"642","u562_parent_id":"562","U813_parent_id":"813","u813_parent_id":"813","u791_parent_id":"791","u801_parent_id":"801","u804_parent_id":"804","u814_parent_id":"814","u806_parent_id":"806","u810_parent_id":"810","u781_parent_id":"781","u832_parent_id":"832","u840_parent_id":"840","u862_parent_id":"862","u866_parent_id":"866","u870_parent_id":"870","u865_parent_id":"865","u839_parent_id":"839","u886_parent_id":"886","u867_parent_id":"867","u881_parent_id":"881","u897_parent_id":"897","u896_parent_id":"896","u893_parent_id":"893","u871_parent_id":"871","u895_parent_id":"895","u907_parent_id":"907","u883_parent_id":"883","u916_parent_id":"916","u920_parent_id":"920","u928_parent_id":"928","u921_parent_id":"921","u923_parent_id":"923","u924_parent_id":"924","u941_parent_id":"941","u949_parent_id":"949","u952_parent_id":"952","u956_parent_id":"956","u957_parent_id":"957","u914_parent_id":"914","u958_parent_id":"958","u975_parent_id":"975","u929_parent_id":"929","u978_parent_id":"978","u973_parent_id":"973","u961_parent_id":"961","u214_parent_id":"214","u992_parent_id":"992","u991_parent_id":"991","u987_parent_id":"987","u997_parent_id":"997","u1006_parent_id":"1006","u1004_parent_id":"1004","u990_parent_id":"990","u1017_parent_id":"1017","u1019_parent_id":"1019","u1015_parent_id":"1015","u1026_parent_id":"1026","u1025_parent_id":"1025","u1029_parent_id":"1029","u1033_parent_id":"1033","u1035_parent_id":"1035","u1041_parent_id":"1041","u1013_parent_id":"1013","u1044_parent_id":"1044","u1030_parent_id":"1030","u1048_parent_id":"1048","u1054_parent_id":"1054","u1001_parent_id":"1001","u1063_parent_id":"1063","u1050_parent_id":"1050","u1070_parent_id":"1070","u1060_parent_id":"1060","u1031_parent_id":"1031","u971_parent_id":"971","u1077_parent_id":"1077","u1069_parent_id":"1069","u918_parent_id":"918","u1089_parent_id":"1089","u1003_parent_id":"1003","u932_parent_id":"932","u1005_parent_id":"1005","u1072_parent_id":"1072","u1090_parent_id":"1090","u1092_parent_id":"1092","u1105_parent_id":"1105","u1106_parent_id":"1106","u1082_parent_id":"1082","u1117_parent_id":"1117","u1000_parent_id":"1000","u1116_parent_id":"1116","u1123_parent_id":"1123","u1127_parent_id":"1127","u1129_parent_id":"1129","u1104_parent_id":"1104","u1132_parent_id":"1132"}

I don't know what happened to end with that kind of entries...

As for cleaning the user table, I can think of one way, although you should test in a development enviroment first, or with only some users:
- SQL update to set params to default values for all users (admin_language":"","language":"","editor":"","helpsite":"","timezone":"","update_cache_list":"1")
- Go to Joomdle->Users and use "sync parents" feature, that takes parent info from Moodle and passes it to Joomla user params

Do you know if the default params for Joomla 2.5 are the same for Joomla 1.5? Looks like for new users that registered after I upgraded to 2.5, the default param may be:

{"update_cache_list":1,"emailVerified":"0"}
or
{"update_cache_list":1}

Thank you
Ron