website/admin/minimal_import_test.php

<?php
// Minimal test to isolate exact hanging point in wordpress_import.php
error_reporting(E_ALL);
ini_set('display_errors', 1);
ini_set('max_execution_time', 30);
ini_set('memory_limit', '256M');

echo "<h1>Minimal WordPress Import Test</h1>";
echo "<p>Step 1: PHP working</p>";

// Test 2: Basic includes without auth
echo "<p>Step 2: Testing basic includes...</p>";

try {
    require_once '../includes/config.php';
    echo "<p>✓ Config included</p>";
} catch (Exception $e) {
    echo "<p>✗ Config error: " . $e->getMessage() . "</p>";
    exit;
}

try {
    require_once '../includes/database.php';
    echo "<p>✓ Database included</p>";
} catch (Exception $e) {
    echo "<p>✗ Database error: " . $e->getMessage() . "</p>";
    exit;
}

// Test 3: Database connection
echo "<p>Step 3: Testing database connection...</p>";

try {
    $db = Database::getInstance();
    echo "<p>✓ Database instance created</p>";
    
    $result = $db->query("SELECT 1 as test");
    echo "<p>✓ Database query successful</p>";
} catch (Exception $e) {
    echo "<p>✗ Database error: " . $e->getMessage() . "</p>";
    exit;
}

// Test 4: WordPress connection (same as main interface)
echo "<p>Step 4: Testing WordPress connection...</p>";

$wpConfig = [
    'host' => '10.15.10.8',
    'database' => 'valtsu_valtsu',
    'username' => 'root',
    'password' => 'jotainaivanmuuta'
];

try {
    echo "<p>About to connect to WordPress...</p>";
    
    // Set timeout options
    $options = [
        PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION,
        PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,
        PDO::ATTR_TIMEOUT => 10,
        PDO::MYSQL_ATTR_INIT_COMMAND => "SET NAMES utf8mb4"
    ];
    
    $dsn = "mysql:host={$wpConfig['host']};dbname={$wpConfig['database']};charset=utf8mb4";
    echo "<p>DSN: $dsn</p>";
    
    $wpDb = new PDO($dsn, $wpConfig['username'], $wpConfig['password'], $options);
    echo "<p>✓ WordPress PDO created</p>";
    
    // Test connection
    $wpDb->query("SELECT 1");
    echo "<p>✓ WordPress connection test successful</p>";
    
    // Get stats
    echo "<p>Getting stats...</p>";
    $stats = [];
    
    try {
        $stats['posts'] = $wpDb->query("SELECT COUNT(*) FROM wp_posts WHERE post_type = 'post'")->fetchColumn();
        echo "<p>✓ Posts count: {$stats['posts']}</p>";
    } catch (Exception $e) {
        echo "<p>⚠ Posts query failed: " . $e->getMessage() . "</p>";
        $stats['posts'] = 0;
    }
    
    try {
        $stats['categories'] = $wpDb->query("SELECT COUNT(*) FROM wp_term_taxonomy WHERE taxonomy = 'category'")->fetchColumn();
        echo "<p>✓ Categories count: {$stats['categories']}</p>";
    } catch (Exception $e) {
        echo "<p>⚠ Categories query failed: " . $e->getMessage() . "</p>";
        $stats['categories'] = 0;
    }
    
    try {
        $stats['users'] = $wpDb->query("SELECT COUNT(*) FROM wp_users")->fetchColumn();
        echo "<p>✓ Users count: {$stats['users']}</p>";
    } catch (Exception $e) {
        echo "<p>⚠ Users query failed: " . $e->getMessage() . "</p>";
        $stats['users'] = 0;
    }
    
    try {
        $stats['comments'] = $wpDb->query("SELECT COUNT(*) FROM wp_comments")->fetchColumn();
        echo "<p>✓ Comments count: {$stats['comments']}</p>";
    } catch (Exception $e) {
        echo "<p>⚠ Comments query failed: " . $e->getMessage() . "</p>";
        $stats['comments'] = 0;
    }
    
    echo "<h2>✓ All tests completed successfully!</h2>";
    echo "<p>Stats: " . print_r($stats, true) . "</p>";
    
} catch (Exception $e) {
    echo "<p>✗ WordPress connection error: " . $e->getMessage() . "</p>";
    echo "<p>File: " . $e->getFile() . "</p>";
    echo "<p>Line: " . $e->getLine() . "</p>";
    exit;
}

echo "<h2>Test completed - WordPress connection works!</h2>";
?>