mahmood Reply #1, 4 months, 3 weeks ago
hi
i tried to execute some queries within my code(i write a schema and class for my school managment sytem-this is the first step for managing student with in classess and classes are primary groups)
but there is an error in query . there is an empty `` in field list. this is the result:
-----edited------
my bad
i inserted this code on my snippet:
$modx->loadClass('modUserGroup','',false,true)
after remove it all the problems are gone
i tried to execute some queries within my code(i write a schema and class for my school managment sytem-this is the first step for managing student with in classess and classes are primary groups)
$obecjtGraph = '{"bccDays":{},"bccUser":{"PrimaryGroup":{},"Profile":{},"bccUserSchedule":{"bccSchedule":{"bccAct":{}}}}}';
$criteria = $modx->newQuery('bccUserDay');
$criteria->bindGraph($obecjtGraph);
$criteria->where(array('bccUser.id'=>$userid,'bccDays.date'=>$date));
$criteria->prepare();
$q=$modx->getIterator('bccUserDay',$criteria);
$criteria->prepare();
return '['.$criteria->toSQL().']';but there is an error in query . there is an empty `` in field list. this is the result:
SELECT `bccUserDay`.`did` AS `bccUserDay_did`, `bccUserDay`.`uid` AS `bccUserDay_uid`, `bccUserDay`.`desc` AS `bccUserDay_desc`, `bccDays`.`id` AS `bccDays_id`, `bccDays`.`date` AS `bccDays_date`, `bccDays`.`desc` AS `bccDays_desc`, `bccUser`.`id` AS `bccUser_id`, `bccUser`.`username` AS `bccUser_username`, `bccUser`.`password` AS `bccUser_password`, `bccUser`.`cachepwd` AS `bccUser_cachepwd`, `bccUser`.`class_key` AS `bccUser_class_key`, `bccUser`.`active` AS `bccUser_active`, `bccUser`.`remote_key` AS `bccUser_remote_key`, `bccUser`.`remote_data` AS `bccUser_remote_data`, `bccUser`.`hash_class` AS `bccUser_hash_class`, `bccUser`.`salt` AS `bccUser_salt`, `bccUser`.`primary_group` AS `bccUser_primary_group`, ``, `Profile`.`id` AS `Profile_id`, `Profile`.`internalKey` AS `Profile_internalKey`, `Profile`.`fullname` AS `Profile_fullname`, `Profile`.`email` AS `Profile_email`, `Profile`.`phone` AS `Profile_phone`, `Profile`.`mobilephone` AS `Profile_mobilephone`, `Profile`.`blocked` AS `Profile_blocked`, `Profile`.`blockeduntil` AS `Profile_blockeduntil`, `Profile`.`blockedafter` AS `Profile_blockedafter`, `Profile`.`logincount` AS `Profile_logincount`, `Profile`.`lastlogin` AS `Profile_lastlogin`, `Profile`.`thislogin` AS `Profile_thislogin`, `Profile`.`failedlogincount` AS `Profile_failedlogincount`, `Profile`.`sessionid` AS `Profile_sessionid`, `Profile`.`dob` AS `Profile_dob`, `Profile`.`gender` AS `Profile_gender`, `Profile`.`address` AS `Profile_address`, `Profile`.`country` AS `Profile_country`, `Profile`.`city` AS `Profile_city`, `Profile`.`state` AS `Profile_state`, `Profile`.`zip` AS `Profile_zip`, `Profile`.`fax` AS `Profile_fax`, `Profile`.`photo` AS `Profile_photo`, `Profile`.`comment` AS `Profile_comment`, `Profile`.`website` AS `Profile_website`, `Profile`.`extended` AS `Profile_extended`, `bccUserSchedule`.`sid` AS `bccUserSchedule_sid`, `bccUserSchedule`.`uid` AS `bccUserSchedule_uid`, `bccUserSchedule`.`desc` AS `bccUserSchedule_desc`, `bccSchedule`.`id` AS `bccSchedule_id`, `bccSchedule`.`cid` AS `bccSchedule_cid`, `bccSchedule`.`aid` AS `bccSchedule_aid`, `bccSchedule`.`did` AS `bccSchedule_did`, `bccAct`.`id` AS `bccAct_id`, `bccAct`.`name` AS `bccAct_name`, `bccAct`.`desc` AS `bccAct_desc`, `bccAct`.`del` AS `bccAct_del` FROM `modx_bugcc_userday` AS `bccUserDay` LEFT JOIN `modx_bugcc_days` `bccDays` ON `bccUserDay`.`did` = `bccDays`.`id` LEFT JOIN `modx_users` `bccUser` ON `bccUserDay`.`uid` = `bccUser`.`id` LEFT JOIN `modx_membergroup_names` `PrimaryGroup` ON `bccUser`.`primary_group` = `PrimaryGroup`.`id` LEFT JOIN `modx_user_attributes` `Profile` ON `bccUser`.`id` = `Profile`.`internalKey` LEFT JOIN `modx_bugcc_userschedule` `bccUserSchedule` ON `bccUser`.`id` = `bccUserSchedule`.`uid` LEFT JOIN `modx_bugcc_schedule` `bccSchedule` ON `bccUserSchedule`.`sid` = `bccSchedule`.`id` LEFT JOIN `modx_bugcc_act` `bccAct` ON `bccSchedule`.`aid` = `bccAct`.`id` WHERE ( `bccUser`.`id` = '1' AND `bccDays`.`date` = '2011-12-29' ) ORDER BY `bccUserDay`.`did` ASC, `bccUserDay`.`uid` ASC-----edited------
my bad
i inserted this code on my snippet:
$modx->loadClass('modUserGroup','',false,true)
after remove it all the problems are gone