🔧 SPEEDots Server Diagnostic

This tool checks your server configuration for SPEEDots Store API.

Server Time: 2026-07-07 16:36:17

1. PHP Environment

[PASS] PHP Version
Version: 8.2.4
Required: PHP 7.0 or higher
[PASS] PDO MySQL Extension
PDO and PDO_MySQL extensions are loaded
[PASS] JSON Support
JSON encoding/decoding available
[PASS] speedstore.php Exists
Path: C:\xampp\htdocs\speedots/speedstore.php
File found
Size: 57069 bytes
Modified: 2026-06-17 07:51:38
[PASS] games/ Directory
Path: C:\xampp\htdocs\speedots/games
Directory exists and is writable

2. Database Connection

[FAIL] Database Connection
Host: localhost
Database: speedots
User: root
Password: ******************************
✗ Connection failed
Error: SQLSTATE[HY000] [1045] Access denied for user 'root'@'localhost' (using password: YES)
[FAIL] Database Exists
Database: speedots
Database does not exist. Create it with:
CREATE DATABASE speedots CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;
[WARN] published_games Table
Table does not exist. It will be auto-created on first game submission.
[INFO] Published Games
Games in database: 0
No games published yet

3. API Functionality Test

[FAIL] API Response Test
Cannot generate JSON response
Error:
Deprecated: htmlspecialchars(): Passing null to parameter #1 ($string) of type string is deprecated in C:\xampp\htdocs\speedots\diagnostic.php on line 360

4. Recommendations

âš  Issues Found

Please fix the following issues:

  1. Fix database connection (check credentials in speedstore.php)
  2. Create the database: CREATE DATABASE speedots

5. Test Links

Manual API Tests

After fixing any issues above, test these endpoints:

6. Configuration Summary

Database Configuration:
  Host:     localhost
  Database: speedots
  User:     root
  Password: ******************************

File Paths:
  This file:    C:\xampp\htdocs\speedots\diagnostic.php
  speedstore:   C:\xampp\htdocs\speedots/speedstore.php
  games dir:    C:\xampp\htdocs\speedots/games

Server Info:
  PHP Version:  8.2.4
  Server:       Apache/2.4.56 (Win64) OpenSSL/1.1.1t PHP/8.2.4
  Document Root: C:/xampp/htdocs

SPEEDots Server Diagnostic v1.0 | Generated: 2026-07-07 16:36:17