Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
Mandrill	[ DIR ]	drwxr-sr-x	2016-02-10 08:42
temp	[ DIR ]	drwxr-sr-x	2022-06-16 13:37
.htaccess	35 B	-rw-r--r--	2023-03-13 09:52
CESA_Ci Applications2b.pdf	800.6 KB	-rw-r--r--	2008-08-14 11:23
CESA_vector logo_high res.jpg	334.84 KB	-rw-r--r--	2008-08-14 11:10
Fulton_Press_small.pdf	84.39 KB	-rw-r--r--	2008-08-11 10:41
LAUNCH OF CESA.pdf	69.23 KB	-rw-r--r--	2008-08-14 11:24
Mandrill.php	6.44 KB	-rw-r--r--	2016-02-10 08:42
Overview_template_QMS_for_SMME-v2 _2.pdf	43.08 KB	-rw-r--r--	2008-09-26 12:04
ToSendProcess.php	46.4 KB	-rw-r--r--	2026-04-01 10:55
XPertMailer.php	38.69 KB	-rw-r--r--	2008-08-06 07:29
ad-reminders.php	2.7 KB	-rw-r--r--	2024-05-16 09:16
awards-from-forminator-debug.php	7.13 KB	-rw-r--r--	2025-06-23 16:02
awards-from-forminator-direct.php	9.69 KB	-rw-r--r--	2025-06-24 06:23
awards-from-forminator-fixed.php	7.42 KB	-rw-r--r--	2025-06-23 16:09
awards-from-forminator-step-by-step.php	6.93 KB	-rw-r--r--	2025-06-23 16:12
awards-from-forminator.php	18.54 KB	-rw-r--r--	2026-06-29 10:02
batch-job.php	948 B	-rw-r--r--	2026-08-24 10:20
bulk-mail-check.php	443 B	-rw-r--r--	2025-08-22 11:48
checkmail.php	6.35 KB	-rw-r--r--	2008-08-06 09:18
class.email-reader.php	15.58 KB	-rw-r--r--	2008-08-06 09:18
cron-5-minutes-root.sh	527 B	-rwxr-xr-x	2026-08-21 08:23
cron-daily-v3.sh	192 B	-rwxr-xr-x	2025-09-11 17:37
cron-daily.sh	500 B	-rwxr-xr-x	2025-12-29 09:32
cron-hourly.sh	413 B	-rwxr-xr-x	2025-09-01 13:33
cron-monthly.sh	83 B	-rwxr-xr-x	2025-06-27 15:38
cron.sh	369 B	-rwxr-xr-x	2026-04-16 10:02
export-attendees-google.php	3.07 KB	-rw-r--r--	2026-08-24 10:20
export-member-data-google.php	3.69 KB	-rw-r--r--	2026-08-24 10:20
export.php	1.96 KB	-rw-r--r--	2010-04-13 14:54
exportgooglecontacts.php	1.18 KB	-rw-r--r--	2022-06-16 14:41
import.php.bak	4.84 KB	-rw-r--r--	2010-05-06 07:59
importdup.php	3.34 KB	-rw-r--r--	2010-05-19 14:20
importschool.php	5.09 KB	-rw-r--r--	2010-05-19 14:05
php8.1_cli_errors.log	43.15 KB	-rw-r--r--	2025-12-31 10:58
phpinfo.php	20 B	-rw-r--r--	2024-04-16 11:40
receivemail.class.php	4.65 KB	-rw-r--r--	2008-08-06 07:51
sce-send-certificates.php	750 B	-rw-r--r--	2026-08-24 10:20
sendlater.php	12.86 KB	-rw-r--r--	2026-01-16 09:53
sendsms.php	4.3 KB	-rw-r--r--	2026-01-16 09:43
simple-wp-test.php	1.74 KB	-rw-r--r--	2025-06-23 16:05
sync-anual-declarations.php	3.22 KB	-rw-r--r--	2026-08-24 10:20
system-checks.php	798 B	-rw-r--r--	2026-08-24 10:20
test-send.php	786 B	-rw-r--r--	2024-04-11 07:55
test-wp-load.php	2.29 KB	-rw-r--r--	2025-06-23 16:02
training-material-expiry-check.php	4.12 KB	-rw-r--r--	2026-06-12 11:48
training-provider-expiry-check.php	4.51 KB	-rw-r--r--	2026-06-12 11:48
unemployed-reminders.php	2.43 KB	-rw-r--r--	2024-05-16 09:06
update-qms-cert-status.php	3.54 KB	-rw-r--r--	2026-08-24 10:20
wp-diagnostic.php	4.39 KB	-rw-r--r--	2025-06-23 16:08
wp-load-bypass.php	3.03 KB	-rw-r--r--	2025-06-23 16:08
wp-load-minimal.php	3.01 KB	-rw-r--r--	2025-06-23 16:08

Rename

<?php

// Start output buffering to prevent "headers already sent" warnings
ob_start();

// Enhanced error reporting
ini_set('display_errors', 1);
ini_set('log_errors', 1);
error_reporting(E_ALL);

// Set error log file
ini_set('error_log', '/tmp/awards-debug.log');

// Set required server variables for WordPress
if (!isset($_SERVER['HTTP_HOST'])) {
    $_SERVER['HTTP_HOST'] = 'localhost';
}
if (!isset($_SERVER['REQUEST_URI'])) {
    $_SERVER['REQUEST_URI'] = '/';
}

echo "=== Starting Awards Script Debug ===\n";
echo "PHP Version: " . phpversion() . "\n";
echo "Current working directory: " . getcwd() . "\n";

// Step 1: Set document root
if (!isset($_SERVER['DOCUMENT_ROOT']) || strlen($_SERVER['DOCUMENT_ROOT']) <= 0) {
    $_SERVER['DOCUMENT_ROOT'] = str_replace('/crons', '', getcwd());
}

echo "Document root set to: " . $_SERVER['DOCUMENT_ROOT'] . "\n";

// Step 2: Check if required files exist
$required_files = [
    "/ADOdb/adodb.inc.php",
    "/vendor/autoload.php",
    "/cfg/config.php",
    "/php/includes/sqlFunctions.php",
    "/php/includes/BaseTableClass.php",
    "/php/includes/MemberFirm.php",
    "/wp-load.php"
];

echo "\n=== Checking required files ===\n";
foreach ($required_files as $file) {
    $full_path = $_SERVER['DOCUMENT_ROOT'] . $file;
    if (file_exists($full_path)) {
        echo "✓ Found: $file\n";
    } else {
        echo "✗ Missing: $file\n";
        echo "  Full path: $full_path\n";
    }
}

// Step 3: Include files with error handling
echo "\n=== Including required files ===\n";

try {
    echo "Including ADOdb...\n";
    include_once($_SERVER['DOCUMENT_ROOT'] . "/ADOdb/adodb.inc.php");
    echo "✓ ADOdb included\n";
} catch (Exception $e) {
    echo "✗ Error including ADOdb: " . $e->getMessage() . "\n";
    exit(1);
}

try {
    echo "Including vendor autoload...\n";
    include_once($_SERVER['DOCUMENT_ROOT'] . "/vendor/autoload.php");
    echo "✓ Vendor autoload included\n";
} catch (Exception $e) {
    echo "✗ Error including vendor autoload: " . $e->getMessage() . "\n";
    exit(1);
}

try {
    echo "Including config...\n";
    include_once($_SERVER['DOCUMENT_ROOT'] . "/cfg/config.php");
    echo "✓ Config included\n";
} catch (Exception $e) {
    echo "✗ Error including config: " . $e->getMessage() . "\n";
    exit(1);
}

try {
    echo "Including sqlFunctions...\n";
    include_once($_SERVER['DOCUMENT_ROOT'] . "/php/includes/sqlFunctions.php");
    echo "✓ sqlFunctions included\n";
} catch (Exception $e) {
    echo "✗ Error including sqlFunctions: " . $e->getMessage() . "\n";
    exit(1);
}

try {
    echo "Including BaseTableClass...\n";
    include_once($_SERVER['DOCUMENT_ROOT'] . "/php/includes/BaseTableClass.php");
    echo "✓ BaseTableClass included\n";
} catch (Exception $e) {
    echo "✗ Error including BaseTableClass: " . $e->getMessage() . "\n";
    exit(1);
}

try {
    echo "Including MemberFirm...\n";
    include_once($_SERVER['DOCUMENT_ROOT'] . "/php/includes/MemberFirm.php");
    echo "✓ MemberFirm included\n";
} catch (Exception $e) {
    echo "✗ Error including MemberFirm: " . $e->getMessage() . "\n";
    exit(1);
}

// Step 4: Load WordPress
echo "\n=== Loading WordPress ===\n";
try {
    echo "Loading wp-load.php...\n";
    require_once($_SERVER['DOCUMENT_ROOT'] . '/wp-load.php');
    echo "✓ WordPress loaded successfully\n";

// Test if WordPress functions are available
    if (function_exists('get_post_meta')) {
        echo "✓ WordPress function get_post_meta is available\n";
    } else {
        echo "✗ WordPress function get_post_meta is NOT available\n";
    }

if (function_exists('wp_get_current_user')) {
        echo "✓ WordPress function wp_get_current_user is available\n";
    } else {
        echo "✗ WordPress function wp_get_current_user is NOT available\n";
    }
} catch (Exception $e) {
    echo "✗ Error loading WordPress: " . $e->getMessage() . "\n";
    exit(1);
}

// Step 5: Test database connection
echo "\n=== Testing database connections ===\n";

// Check if WordPress DB constants are defined
if (defined('WP_HOST') && defined('WPDB_USER') && defined('WPDB_PASS') && defined('WPDB_DB')) {
    echo "✓ WordPress DB constants are defined\n";
    echo "  Host: " . WP_HOST . "\n";
    echo "  User: " . WPDB_USER . "\n";
    echo "  Database: " . WPDB_DB . "\n";
} else {
    echo "✗ WordPress DB constants are NOT defined\n";
    echo "  WP_HOST defined: " . (defined('WP_HOST') ? 'Yes' : 'No') . "\n";
    echo "  WPDB_USER defined: " . (defined('WPDB_USER') ? 'Yes' : 'No') . "\n";
    echo "  WPDB_PASS defined: " . (defined('WPDB_PASS') ? 'Yes' : 'No') . "\n";
    echo "  WPDB_DB defined: " . (defined('WPDB_DB') ? 'Yes' : 'No') . "\n";
}

try {
    echo "Creating WordPress database connection...\n";
    $sqlfWP = new sqlFunctions(WP_HOST, WPDB_USER, WPDB_PASS, WPDB_DB);
    echo "✓ WordPress database connection created\n";
} catch (Exception $e) {
    echo "✗ Error creating WordPress database connection: " . $e->getMessage() . "\n";
    exit(1);
}

// Step 6: Test WordPress database query
echo "\n=== Testing WordPress database query ===\n";
$wpFormsSQL = "SELECT * FROM wp_posts p "
    . "INNER JOIN wp_postmeta pm ON p.id = pm.post_id "
    . "WHERE p.post_type = 'forminator_forms'";

echo "SQL Query: $wpFormsSQL\n";

try {
    $wpForms = $sqlfWP->getAll($wpFormsSQL);
    echo "✓ Query executed successfully\n";
    echo "Found " . count($wpForms) . " forminator forms\n";

if (count($wpForms) > 0) {
        echo "First form ID: " . $wpForms[0]['ID'] . "\n";
        echo "First form title: " . $wpForms[0]['post_title'] . "\n";
    }
} catch (Exception $e) {
    echo "✗ Error executing WordPress query: " . $e->getMessage() . "\n";
    exit(1);
}

// Step 7: Test WordPress functions
echo "\n=== Testing WordPress functions ===\n";
if (count($wpForms) > 0) {
    try {
        $firstForm = $wpForms[0];
        echo "Testing get_post_meta with form ID: " . $firstForm['ID'] . "\n";

$formMeta = get_post_meta($firstForm['ID']);
        echo "✓ get_post_meta executed successfully\n";
        echo "Found " . count($formMeta) . " meta fields\n";

if (isset($formMeta['forminator_form_meta'])) {
            echo "✓ forminator_form_meta found\n";
            $forminatorMeta = unserialize($formMeta['forminator_form_meta'][0]);
            if ($forminatorMeta) {
                echo "✓ forminator meta unserialized successfully\n";
                if (isset($forminatorMeta['settings']['form_name'])) {
                    echo "Form name: " . $forminatorMeta['settings']['form_name'] . "\n";
                }
            } else {
                echo "✗ Failed to unserialize forminator meta\n";
            }
        } else {
            echo "✗ forminator_form_meta not found in post meta\n";
            echo "Available meta keys: " . implode(', ', array_keys($formMeta)) . "\n";
        }
    } catch (Exception $e) {
        echo "✗ Error testing WordPress functions: " . $e->getMessage() . "\n";
    }
}

echo "\n=== Debug completed ===\n";
echo "If you see this message, the basic setup is working.\n";
echo "Remove the exit statement from the original script to continue processing.\n";

// Flush the output buffer
ob_end_flush();