PDOException: SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "users" does not exist LINE 1: SELECT SUM(user_balance_total) as total

{main}

plugins/vinexel/vision-serve/deeper/Modules/Database/Flex/Query/Statement.php : 70

app

PDOStatement->execute

plugins/vinexel/vision-serve/deeper/Modules/Database/Flex/Query/Statement.php : 70

app

Deeper\Modules\Database\Flex\Query\Statement->execute

plugins/vinexel/vision-serve/deeper/Modules/Database/Flex/Query/Statement.php : 83

app

Deeper\Modules\Database\Flex\Query\Statement->single

plugins/vinexel/vision-serve/deeper/Modules/Database/Database.php : 108

app

Deeper\Modules\Database\Database->{closure:Deeper\Modules\Database\Database::single():108}

plugins/vinexel/vision-serve/deeper/Modules/Cache/CacheManager.php : 109

app

Deeper\Modules\Cache\CacheManager->remember

plugins/vinexel/vision-serve/deeper/Modules/Services/AutoCache.php : 21

app

Deeper\Modules\Services\AutoCache::get

plugins/vinexel/vision-serve/deeper/Modules/Database/Database.php : 108

app

Deeper\Modules\Database\Database->single

plugins/vinexel/vision-serve/deeper/Modules/Database/Flex/Model/BaseModel.php : 87

app

Deeper\Modules\Database\Flex\Model\BaseModel->single

/app/app/Flymetrade/Models/Admin/BalanceModel.php : 19

app

Flymetrade\Models\Admin\BalanceModel->getTotalBalance

/app/app/Flymetrade/Services/StatsService.php : 30

app

#10

Flymetrade\Services\StatsService->getPlatformStats

/app/app/Flymetrade/Services/HomepageService.php : 36

app

#11

Flymetrade\Services\HomepageService->getHomepageData

/app/app/Flymetrade/Controllers/HomeController.php : 29

app

#12

Flymetrade\Controllers\HomeController->index

[internal code]

vendor

#13

call_user_func_array

plugins/vinexel/vision-serve/core/Modules/Router/Router.php : 596

app

#14

Vinexel\Modules\Router\Router::callAction

plugins/vinexel/vision-serve/core/Modules/Router/Router.php : 470

app

#15

Vinexel\Modules\Router\Router::{closure:Vinexel\Modules\Router\Router::handleMatch():470}

plugins/vinexel/vision-serve/core/Modules/Router/Router.php : 491

app

#16

Vinexel\Modules\Router\Router::handleMatch

plugins/vinexel/vision-serve/core/Modules/Router/Router.php : 356

app

#17

Vinexel\Modules\Router\Router::dispatch

plugins/vinexel/vision-serve/core/Modules/Router/RouterInitializer.php : 92

app

#18

Vinexel\Modules\Router\RouterInitializer::{closure:Vinexel\Modules\Router\RouterInitializer::run():90}

plugins/vinexel/vision-serve/core/Modules/Http/Middleware/ApiMiddleware.php : 17

app

#19

Vinexel\Modules\Http\Middleware\ApiMiddleware->handle

plugins/vinexel/vision-serve/core/Modules/Http/Kernel.php : 67

app

#20

Vinexel\Modules\Http\Kernel->{closure:{closure:Vinexel\Modules\Http\Kernel::handle():67}:67}

plugins/vinexel/vision-serve/core/Modules/Http/Middleware/TracingMiddleware.php : 33

app

#21

Vinexel\Modules\Http\Middleware\TracingMiddleware->handle

plugins/vinexel/vision-serve/core/Modules/Http/Kernel.php : 67

app

#22

Vinexel\Modules\Http\Kernel->{closure:{closure:Vinexel\Modules\Http\Kernel::handle():67}:67}

plugins/vinexel/vision-serve/core/Modules/Http/Kernel.php : 69

app

#23

Vinexel\Modules\Http\Kernel->handle

plugins/vinexel/vision-serve/core/Modules/Router/RouterInitializer.php : 90

app

#24

Vinexel\Modules\Router\RouterInitializer::run

plugins/vinexel/vision-serve/core/Modules/RegisterModule.php : 116

app

#25

Vinexel\Modules\RegisterModule->dispatch

/app/system/framework/Application.php : 140

vendor

#26

Vision\Application->run

/app/public/index.php : 100

app

plugins/vinexel/vision-serve/deeper/Modules/Database/Flex/Query/Statement.php Line 70

    public function execute(?array $parameters = null): bool
    {
        $statement = $this->statement();
        if ($parameters !== null) {
            $this->bindings = $parameters;
        }
        return $statement->execute($parameters);
    }

    /** @return list<array<string,mixed>> */
    public function resultSet(): array
    {
        $this->execute();

plugins/vinexel/vision-serve/deeper/Modules/Database/Flex/Query/Statement.php Line 70

    public function execute(?array $parameters = null): bool
    {
        $statement = $this->statement();
        if ($parameters !== null) {
            $this->bindings = $parameters;
        }
        return $statement->execute($parameters);
    }

    /** @return list<array<string,mixed>> */
    public function resultSet(): array
    {
        $this->execute();

plugins/vinexel/vision-serve/deeper/Modules/Database/Flex/Query/Statement.php Line 83

        return $this->statement()->fetchAll(PDO::FETCH_ASSOC);
    }

    /** @return array<string,mixed>|null */
    public function single(int $fetchMode = PDO::FETCH_ASSOC): ?array
    {
        $this->execute();
        $row = $this->statement()->fetch($fetchMode);
        return is_array($row) ? $row : null;
    }

    public function fetchColumn(int $column = 0): mixed
    {

plugins/vinexel/vision-serve/deeper/Modules/Database/Database.php Line 108

    {
        if (!$this->isReadQuery() || !empty($cacheOptions['bypass_cache'])) {
            return $this->queryBuilder->single();
        }
        $key = $cacheOptions['key'] ?? $this->cacheKey();
        $ttl = $cacheOptions['ttl'] ?? 3600;
        $value = AutoCache::get($key, fn (): ?array => $this->queryBuilder->single(), $ttl, $this->lastTables);
        return is_array($value) ? $value : null;
    }

    public function singleRow(): ?array
    {
        return $this->single();

plugins/vinexel/vision-serve/deeper/Modules/Cache/CacheManager.php Line 109

        $missing = new \stdClass();
        $cached = $this->get($key, $missing);
        if ($cached !== $missing) {
            return $cached;
        }

        $value = $callback();
        $this->put($key, $value, $ttl, $tags);
        return $value;
    }

    public function has(string $key): bool
    {

plugins/vinexel/vision-serve/deeper/Modules/Services/AutoCache.php Line 21

 * development.
 */
final class AutoCache
{
    public static function get(string $cacheKey, callable $callback, int $ttl = 3600, array $tags = []): mixed
    {
        return self::store()->remember($cacheKey, $callback, max(0, $ttl), $tags);
    }

    public static function clear(string $cacheKey): void
    {
        self::store()->forget($cacheKey);
    }

plugins/vinexel/vision-serve/deeper/Modules/Database/Database.php Line 108

    {
        if (!$this->isReadQuery() || !empty($cacheOptions['bypass_cache'])) {
            return $this->queryBuilder->single();
        }
        $key = $cacheOptions['key'] ?? $this->cacheKey();
        $ttl = $cacheOptions['ttl'] ?? 3600;
        $value = AutoCache::get($key, fn (): ?array => $this->queryBuilder->single(), $ttl, $this->lastTables);
        return is_array($value) ? $value : null;
    }

    public function singleRow(): ?array
    {
        return $this->single();

plugins/vinexel/vision-serve/deeper/Modules/Database/Flex/Model/BaseModel.php Line 87

        $bypassCache = !empty($cacheOptions['bypass_cache']);
        $cacheKey = hash('sha256', $this->currentQuery . "\0" . serialize($this->currentParams));
        if (!$bypassCache && array_key_exists($cacheKey, self::$lifecycleCache)) {
            $value = self::$lifecycleCache[$cacheKey];
            return is_array($value) ? $value : null;
        }
        $data = parent::single($cacheOptions);
        $result = $this->autoDecrypt($data);
        if (!$bypassCache) {
            self::$lifecycleCache[$cacheKey] = $result;
        }
        return $result;
    }

/app/app/Flymetrade/Models/Admin/BalanceModel.php Line 19

        return $this->query("SELECT * FROM " . $this->table_users . " WHERE user_role = 'user' ORDER BY user_balance DESC LIMIT 5")
            ->resultSet();
    }

    public function getTotalBalance()
    {
        $result = $this->query("SELECT SUM(user_balance_total) as total_balances FROM " . $this->table_users)->single();
        return $result['total_balances'] ?? 0;
    }

    public function getTotalWithdrawal()
    {
        $result = $this->query("SELECT SUM(user_withdrawal_total) as total_withdrawal FROM " . $this->table_users)->single();

/app/app/Flymetrade/Services/StatsService.php Line 30

     * 
     * @return array
     */
    public function getPlatformStats(): array
    {
        return [
            'total_balance'          => $this->balanceModel->getTotalBalance(),
            'total_withdrawal'       => $this->balanceModel->getTotalWithdrawal(),
            'commission_collected'   => $this->balanceModel->getCommissionCollected(),
            'commission_distributed' => $this->balanceModel->getCommissionDistributed(),
            'total_users'            => $this->generalModel->getTotalUsers(),
            'total_brokers'          => $this->generalModel->getTotalBrokers(),
            'total_account_opened'   => $this->generalModel->getTotalAccounts(),

/app/app/Flymetrade/Services/HomepageService.php Line 36

     * 
     * @return array
     */
    public function getHomepageData(): array
    {
        return array_merge(
            $this->statsService->getPlatformStats(),
            [
                'top_user' => $this->balanceModel->getUsersByBalance(),
                
                // Broker data
                'justmarkets_data' => $this->brokerModel->getJustmarkets(),
                'exness_data' => $this->brokerModel->getExness(),

/app/app/Flymetrade/Controllers/HomeController.php Line 29

    use Protection;

    public function index(): void
    {
        try {
            $homepageService = ServiceProvider::getHomepageService();
            $homepageData = $homepageService->getHomepageData();

            $seo = $this->getSeoData();
            $data = $this->getData(_lang('page_titles.homepage'), array_merge($homepageData, [
                'description' => 'Flymetrade adalah ekosistem IB Forex dan teknologi trading Flyme Tyrant untuk rebate, infrastruktur trading, serta pengembangan Expert Advisor dan analytical tools berbantuan AI.',
                'seo_head' => $seo['seoHeadHtml'],
                'title' => $seo['seoData']['title'] ?? 'Flymetrade',

[internal code] Line 0

[Internal code — source not available]

plugins/vinexel/vision-serve/core/Modules/Router/Router.php Line 596

        $controllerInstance = Container::resolve($controllerClass);

        if (!method_exists($controllerInstance, $method)) {
            return self::sendServerError("Method '{$method}' in controller '{$controllerClass}' not found");
        }

        return call_user_func_array([$controllerInstance, $method], $params);
    }

    /**
     * Execute middleware for the current route.
     *
     * @param string $key Middleware key

plugins/vinexel/vision-serve/core/Modules/Router/Router.php Line 470

                $matches,
                fn($key) => !is_int($key),
                ARRAY_FILTER_USE_KEY
            )
        );

        $destination = fn () => self::callAction($route['action'], $params, $route['namespace'] ?? self::$namespace);
        $middleware = array_values((array) ($route['middleware'] ?? []));
        // API routes always enter the JSON/stateless boundary. Session remains
        // an explicit route middleware (`api-session`).
        if (RequestMode::isApiPath((string) ($route['uri'] ?? ''))
            && !in_array('api', $middleware, true)) {
            array_unshift($middleware, 'api');

plugins/vinexel/vision-serve/core/Modules/Router/Router.php Line 491

                self::$currentMiddleware[] = (string) $middlewareKey;
                return self::invokeMiddleware((string) $middlewareKey, $next);
            };
        }

        try {
            return $destination();
        } catch (\Throwable $exception) {
            if (RequestMode::isApi($_SERVER)) {
                self::jsonError('internal_server_error', 'internal_server_error', 500);
                return null;
            }
            throw $exception;

plugins/vinexel/vision-serve/core/Modules/Router/Router.php Line 356

        }
        // --- End GoEngine Fast Route Lookup ---

        // Immutable route manifests contain precompiled regexes, but static
        // paths can bypass PCRE entirely. Global routes retain precedence.
        if (isset(self::$staticRouteIndex[$requestMethod][$requestUri])) {
            return self::handleMatch(self::$staticRouteIndex[$requestMethod][$requestUri], []);
        }

        // Check global routes first (highest priority)
        foreach (self::$globalRoutes as $index => &$route) {
            if (!isset($route['regex'])) {
                $route['regex'] = self::convertToRegex($route['uri']);

plugins/vinexel/vision-serve/core/Modules/Router/RouterInitializer.php Line 92

        Request::setInstance($request);
        $kernel = new Kernel();

        // Jalankan Kernel untuk Middleware Global (Session, CSRF, dll)
        $kernel->handle($request, function ($request) {
            // Setelah middleware global lolos, jalankan router
            Router::dispatch();
        });
    }
}

plugins/vinexel/vision-serve/core/Modules/Http/Middleware/ApiMiddleware.php Line 17

/** Stateless API boundary: deterministic headers and shared rate limiting. */
final class ApiMiddleware
{
    public function handle(Request $request, Closure $next): mixed
    {
        if (!$request->isApi()) {
            return $next($request);
        }
        if ($request->getAttribute('_api_boundary') === true) {
            return $next($request);
        }
        $request->setAttribute('_api_boundary', true);
        header('Content-Type: application/json; charset=utf-8');

plugins/vinexel/vision-serve/core/Modules/Http/Kernel.php Line 67

        }

        $pipeline = array_merge($this->middleware, $resolved);

        return array_reduce(
            array_reverse($pipeline),
            fn($next, $m) => fn($req) => (new $m())->handle($req, $next),
            $destination
        )($request);
    }

    /**
     * Resolve middleware class by key.

plugins/vinexel/vision-serve/core/Modules/Http/Middleware/TracingMiddleware.php Line 33

        
        // Inject into response header
        header("X-Request-ID: {$requestId}");
        
        // You could also inject this into a global logger context here if using Monolog
        
        return $next($request);
    }
}

plugins/vinexel/vision-serve/core/Modules/Http/Kernel.php Line 67

        }

        $pipeline = array_merge($this->middleware, $resolved);

        return array_reduce(
            array_reverse($pipeline),
            fn($next, $m) => fn($req) => (new $m())->handle($req, $next),
            $destination
        )($request);
    }

    /**
     * Resolve middleware class by key.

plugins/vinexel/vision-serve/core/Modules/Http/Kernel.php Line 69

        $pipeline = array_merge($this->middleware, $resolved);

        return array_reduce(
            array_reverse($pipeline),
            fn($next, $m) => fn($req) => (new $m())->handle($req, $next),
            $destination
        )($request);
    }

    /**
     * Resolve middleware class by key.
     */
    public function resolve(string $key): string

plugins/vinexel/vision-serve/core/Modules/Router/RouterInitializer.php Line 90

    {
        $request = new Request();
        Request::setInstance($request);
        $kernel = new Kernel();

        // Jalankan Kernel untuk Middleware Global (Session, CSRF, dll)
        $kernel->handle($request, function ($request) {
            // Setelah middleware global lolos, jalankan router
            Router::dispatch();
        });
    }
}

plugins/vinexel/vision-serve/core/Modules/RegisterModule.php Line 116

     * This method executes the routing process and triggers
     * the onCreate and onFinish lifecycle hooks.
     */
    public function dispatch(): void
    {
        // Run the main router
        RouterInitializer::run();

        // Lifecycle start hook
        $this->onCreate();

        // Lifecycle finish hook
        $this->onFinish([

/app/system/framework/Application.php Line 140

        if (!$stateless) {
            Signature::injectHttpHeaders();
            Signature::injectCookie();
        }

        // Dispatch the application request
        $this->dispatch();
    }

    protected function onFinish(array $info): void
    {
        parent::onFinish($info);
    }

/app/public/index.php Line 100

    }
};
register_shutdown_function($cleanup);

try {
    $application = Transmitter::http();
    $application->run();
} finally {
    $cleanup();
}

// Flush output. The bootstrap's diagnostic probe is useful in server logs,
// but it must never become a text node after the document's closing tag: that

Request

URL	http://flymetrade.com/
Method	GET

Query Parameters

No query parameters

Headers

X-Forwarded-Proto	https
X-Real-Ip	216.73.217.108
User-Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Accept	/
Via	2.0 Caddy
Accept-Encoding	gzip, br, zstd, deflate
X-Forwarded-For	216.73.217.108
X-Forwarded-Host	flymetrade.com

Runtime

Execution Time	0.0721s
Memory Usage	2.00 MB
PHP Version	8.5.11
Framework	Vinexel v2.0.0

Session Data

_csrf_token	30fca40284d4432268e60d46707623ed669a71cdcbdb7eba11116d80273a6421
_csrf_token_time	1791164108

SQLSTATE[42P01]: Undefined table: 7 ERROR: relation "users" does not exist LINE 1: SELECT SUM(user_balance_total) as total_balances FROM users ^

Fix Preview