Troubleshooting Guide

School Inventory Management System

System Status
Server Status: Auto-detecting...
Database: Auto-detecting...
Test Connection
Application: Ready
Open App
Common Issues & Solutions

Symptoms:
  • Database table has old structure
  • Import fails with "Unknown column" errors
  • Application cannot save data
Solutions:
  1. Reset Database: Click the "Reset Database" button above
  2. Run Setup: Visit setup_database.php
  3. Test Connection: Visit test_connection.php
  4. Manual Reset: This recreates the table with the correct Indonesian Education Department format
Note: Resetting the database will delete all existing data. Make sure to backup important data first.

Symptoms:
  • Application shows error message about server connection
  • Dashboard doesn't load statistics
  • Cannot add, edit, or delete items
Solutions:
  1. Check XAMPP: Ensure XAMPP is running with Apache and MySQL started
  2. Test Connection: Visit test_connection.php to verify server setup
  3. Run Setup: If database doesn't exist, visit setup_database.php
  4. Check Ports: Ensure no other applications are using port 80
Note: The application will automatically fall back to localStorage mode if the server is not available, so you can still use basic functionality.

Symptoms:
  • Cannot connect to MySQL database
  • Error messages about database access
  • PHP files not working properly
Solutions:
  1. Start MySQL: In XAMPP Control Panel, click "Start" for MySQL module
  2. Check Credentials: Default username: "root", password: "" (empty)
  3. Restart XAMPP: Sometimes a full restart fixes connection issues
  4. Check phpMyAdmin: Visit http://localhost/phpmyadmin to verify MySQL is working

Symptoms:
  • PHP files not executing
  • Permission denied errors
  • Files not accessible via browser
Solutions:
  1. Check XAMPP Installation: Ensure files are in the correct htdocs folder
  2. File Path: Files should be in C:\xampp\htdocs\inventaris\
  3. Browser Cache: Clear browser cache and try again
  4. Antivirus: Temporarily disable antivirus that might block PHP execution

Symptoms:
  • Cannot download Excel template
  • Import fails with error messages
  • Export doesn't generate file
Solutions:
  1. Browser Compatibility: Try using Chrome or Firefox
  2. Popup Blockers: Disable popup blockers for download functions
  3. File Format: Ensure Excel files are .xlsx or .xls format
  4. Template Format: Use the provided template for correct column headers
Quick Actions
Setup & Installation
System Information
Required Software:
  • XAMPP (with Apache & MySQL)
  • Modern web browser
  • PHP 7.4 or higher
  • MySQL 5.7 or higher
File Structure:
  • index.html - Main application
  • api.php - API endpoints
  • database.php - Database functions
  • setup_database.php - Setup script

School Inventory Management System v1.0