query(”
INSERT INTO wp_ennu_assessment_questions (
assessment_type, question_key, question_text, question_type,
options, is_required, scoring_config, sort_order, is_active,
created_at, updated_at
) VALUES (
‘skin’,
‘ennu_global_gender’,
‘What is your gender?’,
‘radio’,
‘{\”female\”:\”FEMALE\”,\”male\”:\”MALE\”}’,
1,
‘[]’,
0,
1,
NOW(),
NOW()
) ON DUPLICATE KEY UPDATE
question_text = VALUES(question_text),
question_type = VALUES(question_type),
options = VALUES(options),
is_required = VALUES(is_required),
scoring_config = VALUES(scoring_config),
sort_order = VALUES(sort_order),
is_active = VALUES(is_active),
updated_at = NOW()
“);
if ($result !== false) {
echo “✅ Test insert successful\n”;
// Check if it worked
$count = $wpdb->get_var(“SELECT COUNT(*) FROM wp_ennu_assessment_questions WHERE assessment_type = ‘skin'”);
echo “???? Skin questions count: $count\n”;
if ($count > 0) {
echo “???? Import is working! Ready to import all data.\n”;
}
} else {
echo “❌ Test insert failed: ” . $wpdb->last_error . “\n”;
}
echo “\n???? Test complete\n”;
?>
