PHP Version: 8.1.34
DIR: /home/digvputi/public_html/clientradar_v2/scrapers
── Test 1: Loading _base.php ──
✅ _base.php loaded
── Test 2: fetchUrl (httpbin.org) ──
✅ fetchUrl OK — 396 bytes received
── Test 3: extractSkills ──
✅ Skills found (7): PHP, Laravel, React, MySQL, Docker, REST, API
── Test 4: extractBudget ──
✅ "Budget is $500 - $1,500 fixed"
→ min=500 max=1500
✅ "Up to $2000 for this project"
→ min= max=2000
✅ "Starting from $800 per month"
→ min=800 max=
✅ "Compensation: $50+/hr"
→ min=50 max=
✅ "No budget mentioned here at all"
→ min= max=
✅ All budget tests passed
── Test 5: DB connection ──
✅ DB connected — leads in table: 10
── Test 6: insertLead (test row) ──
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'url' in 'WHERE' in /home/digvputi/public_html/clientradar_v2/app/db.php:38
Stack trace:
#0 /home/digvputi/public_html/clientradar_v2/app/db.php(38): PDO->prepare()
#1 /home/digvputi/public_html/clientradar_v2/app/db.php(47): dbq()
#2 /home/digvputi/public_html/clientradar_v2/scrapers/_base.php(152): dbOne()
#3 /home/digvputi/public_html/clientradar_v2/scrapers/test_base.php(79): insertLead()
#4 {main}
thrown in /home/digvputi/public_html/clientradar_v2/app/db.php on line 38