Database Diagnostic Report

<h1>Database Diagnostic Report</h1><pre>=== ENVIRONMENT VARIABLES ===
DB_CONNECTION: mysql
DB_HOST: localhost
DB_DATABASE: nexusart_inv
DB_USERNAME: nexusart_nftnexus
DB_PASSWORD: ***SET***

=== DATABASE CONNECTION TEST ===
✓ Database connection successful!

=== CHECKING TABLES ===
Tables found: 44
  - activity_log
  - asset_update_log
  - assets
  - broker_applications
  - demo_fund_applications
  - investment_campaigns
  - investment_listings
  - investment_opportunities
  - investments
  - joint_account_activity_log
  - joint_account_invitations
  - joint_account_members
  - joint_account_transactions
  - joint_accounts
  - managers
  - messages
  - notifications
  - partnership_accounts
  - partnership_activity_log
  - partnership_invitations
  - partnership_members
  - partnership_transactions
  - payment_details
  - payment_methods
  - payment_requests
  - payments
  - pnl_history
  - portfolio_assets
  - portfolios
  - refresh_tokens
  - special_plans
  - stock_suggestions
  - transactions
  - user_activity
  - user_adoptions
  - user_balances
  - user_restrictions
  - user_settings
  - user_special_investments
  - users
  - wallets
  - watchlist_assets
  - watchlists
  - withdrawal_requests

=== CHECKING USER: billhooge@gmail.com ===
✓ User found!
  ID: 1
  Email: billhooge@gmail.com
  Role: admin
  Full Name: Bill Hooge
  Created: 2025-06-08 18:33:06
</pre><p><strong>IMPORTANT:</strong> Delete this file after viewing the results for security!</p>