DYNALEARN | Registration

Something went wrong

Page ID : 109
Content ID : 80
SQLSTATE[HY000]: General error: 1525 Incorrect DATE value: '' The SQL being executed was: SELECT t2.announcement_translation_title AS announcement_title, t2.announcement_translation_content AS announcement_content, t1.announcement_url FROM content_announcement t1 INNER JOIN content_announcement_translation t2 ON t2.announcement_translation_parent_id=t1.announcement_id WHERE t2.announcement_translation_main=1 AND t1.announcement_category='public' AND t1.announcement_status='active' AND (t1.announcement_date IS NULL OR t1.announcement_date='' OR t1.announcement_date<'2025-12-10') AND (t1.announcement_end_date IS NULL OR t1.announcement_end_date='' OR t1.announcement_end_date>'2025-12-10') ORDER BY t1.announcement_sorting ASC
Content :

$listAnnouncement = '';
$queryAnnouncement = "SELECT 
        t2.announcement_translation_title AS announcement_title,  
        t2.announcement_translation_content AS announcement_content,
        t1.announcement_url
    FROM content_announcement t1
    INNER JOIN content_announcement_translation t2 ON t2.announcement_translation_parent_id=t1.announcement_id 
    WHERE 
        t2.announcement_translation_main=1 AND 
        t1.announcement_category='public' AND 
        t1.announcement_status='active' AND 
        (t1.announcement_date IS NULL OR t1.announcement_date='' OR t1.announcement_date<'".date('Y-m-d')."') AND 
        (t1.announcement_end_date IS NULL OR t1.announcement_end_date='' OR t1.announcement_end_date>'".date('Y-m-d')."')
    ORDER BY t1.announcement_sorting ASC";
    $modelAnnouncement = Yii::$app->db->createCommand($queryAnnouncement)->queryAll();
    $listAnnouncement = '<ul>';
    if(!empty($modelAnnouncement)){
        foreach($modelAnnouncement as $rowAnnouncement){
            $listAnnouncement .= '<li>'.$rowAnnouncement['announcement_content'].'</li>';            
        }
    }
    $listAnnouncement .= '</ul>';
                
echo '</div>
                            </div>
                            <div class="col-xs-12 col-md-6">
                                <div class="postit">
                                    <div class="mt-2">
                                        <h5 class="text-title text-center">Announcement</h5>
                                        <p class="text-muted text-center">Please take note to the announcement and information below;</p>
                                        '.$listAnnouncement.'
                                    </div>
                                </div>
                            </div>
                            
                        </div>
                        <div class="row align-items-center justify-content-center">
                            <div class="col-xs-12 text-center">
                                <div class="footerbg mt-2 pt-3 pb-3">© <script>document.write(new Date().getFullYear())</script> 
                                DYNALEARN</div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>';

Registration For Membership

Something went wrong