<?php
// Load WordPress
require_once('/Users/danieliser/LocalSites/fluentboards/app/public/wp-load.php');
global $wpdb;
// Check current boards
$boards = $wpdb->get_results("SELECT id, title, type, created_by FROM {$wpdb->prefix}fbs_boards");
echo "Current boards in database:\n";
foreach($boards as $board) {
echo "ID: {$board->id}, Title: {$board->title}, Type: {$board->type}, Created By: {$board->created_by}\n";
}
// Try to insert a board directly
$result = $wpdb->insert(
$wpdb->prefix . 'fbs_boards',
[
'title' => 'Direct DB Test Board',
'type' => 'task',
'description' => 'Testing direct database insertion',
'currency' => 'USD',
'background' => serialize(['id' => 'solid_1', 'is_image' => false, 'image_url' => null, 'color' => '#d1d8e0']),
'created_by' => 2,
'created_at' => current_time('mysql'),
'updated_at' => current_time('mysql')
]
);
if($result === false) {
echo "\nInsert failed: " . $wpdb->last_error . "\n";
} else {
echo "\nInsert successful! New board ID: " . $wpdb->insert_id . "\n";
}
// Check boards again
$boards = $wpdb->get_results("SELECT id, title FROM {$wpdb->prefix}fbs_boards");
echo "\nBoards after insert:\n";
foreach($boards as $board) {
echo "ID: {$board->id}, Title: {$board->title}\n";
}