Database Test & Diagnostics

Database Information

Host:localhost
Database:idahoskybooks_db
User:idahoskybooks
PHP Version:8.3.6
Server Time:2026-10-11 18:34:56

Test Results

Connection

Connected to database: idahoskybooks_db

Customers
Records: 4
Columns: 27
Employees
Records: 3
Columns: 32
Invoices
Records: 0
Columns: 32
Invoice items
Records: 2
Columns: 19
Gl accounts
Records: 50
Columns: 21
Sessions

Sessions are working correctly

Issues Found

Users table

Missing columns: role

Existing columns: id, company_id, primary_role_id, role_enum_backup, username, password, email, timezone, full_name, is_active, force_password_change, failed_login_attempts, locked_until, last_login, last_activity, session_token, remember_token, created_at, updated_at, status, use_company_timezone, date_format_preference, time_format_preference
Existing users

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'role' in 'SELECT'

Quick Actions

Go to Login Create Admin User Dashboard
Note: This test page should be deleted after confirming everything works correctly for security reasons.