Database error: Invalid SQL: CREATE TEMPORARY TABLE tmp_news SELECT SQL_CALC_FOUND_ROWS t.news_id as news_id, t.title as title, t.content as content, t.date_created as date_created, u.user_id as user_id, u.username as username, u.user_avatar as user_avatar, u.user_fname as user_fname, u.user_lname as user_lname FROM news t, phpbb_users u WHERE t.active = '1' AND t.type = 'user' AND t.user_id = u.user_id ORDER BY t.date_created DESC LIMIT 20, 10
MySQL Error: 1067 (Invalid default value for 'date_created')
Session halted.