Documentation

Troubleshooting Guide

Having issues with HkDevs CodeForge Database Studio? This comprehensive guide covers common problems and their solutions to get you back up and running quickly.

Troubleshooting Overview

Quick Fixes

Common solutions for immediate problems

Debug Tools

Built-in tools for diagnosing issues

Expert Support

Professional assistance when needed

Before You Start

Check if you're running the latest version
Review the error logs in storage/logs/laravel.log
Verify your system meets the requirements
Test in a development environment first

Installation Issues

Composer Installation Fails

Symptoms:

Package hkdevs/codeforge-database-studio not found

Possible Causes:

• Package repository not configured
• Invalid authentication credentials
• Network connectivity issues
• Outdated Composer version

Solutions:

composer self-update

composer clear-cache

composer config --list

Migration Errors During Installation

Symptoms:

SQLSTATE[42S01]: Base table or view already exists

Solution:

php artisan codeforge:install --force
php artisan migrate:fresh
php artisan codeforge:install

Warning: migrate:fresh will drop all tables. Only use in development environments.

Plugin Not Appearing in Filament

Check Plugin Registration:

// In your AdminPanelProvider.php
use HkDevs\CodeForgeStudio\CodeForgeStudioPlugin;

public function panel(Panel $panel): Panel
{
    return $panel
        ->plugins([
            CodeForgeStudioPlugin::make(),
        ]);
}

Clear Caches:

php artisan config:clear
php artisan cache:clear
php artisan route:clear
php artisan view:clear

Configuration Problems

Environment Variables Not Working

Common Issues:

Missing quotes around values
Cached config values
Incorrect variable names
Environment-specific .env files

Solutions:

php artisan config:clear

php artisan config:cache

Example .env Configuration:

CODEFORGE_ENABLED=true
CODEFORGE_ENABLE_QUERY_LOGGING="true"
CODEFORGE_SLOW_QUERY_THRESHOLD=1000

Database Connection Issues

Test Database Connection:

php artisan codeforge:health-check --connection=mysql

Verify Database Configuration:

php artisan tinker
>>> DB::connection()->getPdo();
>>> DB::select('SELECT 1');

Permission Denied Errors

Check File Permissions:

# Linux/Mac
sudo chown -R www-data:www-data storage/
sudo chmod -R 775 storage/

# Windows (Run as Administrator)
icacls storage /grant "IIS_IUSRS:(OI)(CI)F" /T

Database User Permissions:

Ensure your database user has sufficient privileges for CREATE, ALTER, DROP, and INDEX operations.

Performance Issues

Slow Dashboard Loading

Possible Causes:

• Large number of database tables
• Slow database queries
• Insufficient server resources
• Cache not configured

Solutions:

Enable Redis caching

Increase cache TTL values

Optimize database queries

Performance Optimization:

# In .env
CODEFORGE_CACHE_DRIVER=redis
CACHE_DRIVER=redis
SESSION_DRIVER=redis

# Increase cache duration
CODEFORGE_SCHEMA_CACHE_TTL=3600

High Memory Usage

Monitor Memory Usage:

php artisan codeforge:debug --memory

Optimization Settings:

# Limit result sizes
CODEFORGE_MAX_RESULT_SIZE=1000
CODEFORGE_BATCH_SIZE=500

# Enable query optimization
CODEFORGE_ENABLE_QUERY_CACHE=true

Query Timeout Issues

Adjust Timeout Settings:

# In .env
CODEFORGE_DB_TIMEOUT=60
CODEFORGE_QUERY_TIMEOUT=30000

# MySQL specific
DB_OPTIONS_PDO_MYSQL_ATTR_TIMEOUT=60

Identify Slow Queries:

php artisan codeforge:debug --slow --limit=10

Common Errors

Class 'CodeForgeStudioPlugin' not found

Class 'HkDevs\CodeForgeStudio\CodeForgeStudioPlugin' not found

Solutions:

composer dump-autoload
php artisan clear-compiled
php artisan optimize:clear

Verify Installation:

composer show hkdevs/codeforge-database-studio

CSRF Token Mismatch

Clear Sessions and Cache:

php artisan session:table
php artisan migrate
php artisan cache:clear

Check Session Configuration:

Ensure your session driver is properly configured in config/session.php

Maximum Execution Time Exceeded

Increase PHP Limits:

# In php.ini
max_execution_time = 300
memory_limit = 512M
max_input_vars = 3000

Use Background Processing:

# Enable queue for long operations
QUEUE_CONNECTION=database
php artisan queue:work

Debugging Tools

Built-in Debug Commands

codeforge:debug

General debugging information

codeforge:health-check

Database health diagnostics

codeforge:collect-metrics

Performance metrics collection

Log Files

storage/logs/laravel.log

General application logs

storage/logs/codeforge.log

Plugin-specific logs

storage/logs/query.log

Database query logs

Enable Debug Mode

# In .env
APP_DEBUG=true
CODEFORGE_DEBUG=true
LOG_LEVEL=debug

# For development only - never enable in production

Security Warning: Never enable debug mode in production environments as it may expose sensitive information.

Getting Support

Professional Support

Get expert help from our development team for complex issues and custom implementations.

Contact Support Team

Comprehensive guides and API documentation to help you resolve issues independently.

Browse Documentation

When Contacting Support

Include This Information:

• Laravel version and PHP version
• CodeForge Database Studio version
• Complete error message and stack trace
• Steps to reproduce the issue
• Relevant configuration settings
• Log file excerpts (without sensitive data)

System Information Command:

php artisan about
php artisan codeforge:debug --export

This generates a support report with system details

Support Response Times

Critical Issues

2-4 hours

Standard Support

24-48 hours

General Inquiries

2-5 business days

Still Having Issues?

Professional support is available to help you resolve any problems quickly and efficiently.

Email Support Debug Commands Check FAQ