Order Processing Debug

📋 Check Log File

❌ Log file doesn't exist yet - no orders attempted

📦 Check Dependencies

✅ Database config exists

✅ Stripe config exists

✅ Mail config exists

✅ Stripe library exists

✅ PHPMailer exists

🔍 Current Session State

Session ID: t6gbmlqpqrgkispju6b18muqa8
CSRF Token: 49038af53bcd26a32d0b8f4b173452d763867466f92ce369b14a798a7946d3b2
Cart items: NO CART
Session data:
Array
(
    [csrf] => 49038af53bcd26a32d0b8f4b173452d763867466f92ce369b14a798a7946d3b2
)

🧪 Test Order Form

This form will show you exactly what gets submitted:

🗄️ Database Connection Test

✅ Database config loaded

✅ Database connection working - Total orders: 143

av_orders table columns:

• id (bigint(20) unsigned)
• order_number (varchar(64))
• first_name (varchar(100))
• last_name (varchar(100))
• email (varchar(254))
• phone (varchar(20))
• delivery_method (enum('delivery','pickup'))
• payment_method (varchar(50))
• bank_reference (varchar(100))
• address_line_1 (varchar(255))
• address_line_2 (varchar(255))
• city (varchar(100))
• postcode (varchar(20))
• subtotal (decimal(10,2))
• shipping (decimal(10,2))
• total (decimal(10,2))
• payment_intent_id (varchar(191))
• status (enum('pending','confirmed','shipped','delivered','cancelled'))
• created_at (datetime)
• updated_at (datetime)
• lucky_dip_completed (tinyint(1))
• special_requests (text)
• collection_date (datetime)
• collection_payment_method (varchar(50))
• payment_status (varchar(20))
• deposit_amount (decimal(10,2))
• balance_due (decimal(10,2))
• paid_amount (decimal(10,2))
• shipping_carrier (varchar(100))
• shipping_tracking (varchar(255))
• shipped_at (timestamp)
• admin_notes (text)
• discount_code (varchar(50))
• discount_amount (decimal(10,2))
• shipping_address (text)
• shipping_cost (decimal(10,2))
• has_backorder (tinyint(1))
• payment_token (varchar(255))
• payment_deadline (datetime)
• balance_paid_at (datetime)
• payment_reminder_sent (tinyint(1))
• payment_reminder_sent_at (datetime)
• stripe_payment_intent_balance (varchar(255))
• is_preorder (tinyint(1))

💳 Stripe Configuration

✅ Stripe keys defined

Publishable key: pk_live_51S7...

Secret key: sk_live_...

📝 Debugging Steps

1. Check the log file above - Most important!
2. Try the test order - Will show exact error
3. Check browser console when clicking real 'Place order' button
4. Look at network tab in browser dev tools to see if request is sent