Missings Tables

[ghost]

Hello, Here are list of missing Database Tables :

_QueryException in Connection.php line 624: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'aion_gs.ladder_player' doesn't exist (SQL: select * from ladderplayer order by rating desc limit 5)

_QueryException in Connection.php line 624: SQLSTATE[42S02]: Base table or view not found: 1146 Table 'aion_ws.config_slider' doesn't exist (SQL: select * from config_slider)_

[mathieuletyrant]

Hi,

This is the SQL :

CREATE TABLE `ladder_player` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `rank` int(11) DEFAULT NULL,
  `rating` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[AymenOthmani]

nous avons besoin de la table config_slider s'il vous plaît ajouter

[mathieuletyrant]

A executer dans la DB du site

CREATE TABLE `config_slider` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `path` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[AymenOthmani]

je besoin aussi autre table account_level !! vous remercie pour la réponse :)

[mathieuletyrant]

Ls Database :

CREATE TABLE `account_level` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `account_id` int(11) DEFAULT NULL,
  `total` int(11) DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

[AymenOthmani]

i créé toutes les tables sql mais voici le résultat " http://74.208.230.63/aion/public/ " problème est de quoi? php version?

vous pouvez vous connecter avec le compte id luffy pw luffy

[mathieuletyrant]

Hi,

You must compile CSS and JS. For that you must have NodeJS install and after execute :

npm i
npm i -g gulp
gulp script
gulp style

[mathieuletyrant]

If you need some help, you can contact me on Skype : Mathew78540

[ghost]

Please update procedure to complete the theme generating part if you solve his problem on Skype.

[ghost]

There is an error into main template.

In the file:

resources/views/_layouts/master.blade.php

Replace:

    <link href="/css/font-awesome.min.css" rel="stylesheet">
    <link href="/css/global.css" rel="stylesheet">

With:

    <link href="css/font-awesome.min.css" rel="stylesheet">
    <link href="css/global.css" rel="stylesheet">

EDIT : Hmm, may be there is something missing... URL rewrite rule ? Special Apache module ? I don't really understand where to launch the web site. Apache redirect should point on public folder ?

[mathieuletyrant]

You should point your Vhost on the public folder and if you are on apache, create a .htaccess files with this inside :

Options +FollowSymLinks
RewriteEngine On

RewriteCond %{REQUEST_FILENAME} !-d
RewriteCond %{REQUEST_FILENAME} !-f
RewriteRule ^ index.php [L]

[mathieuletyrant]

Check my last commit, maybe fix for assets link

[ghost]

The .htaccess is already into public folder.

I have updated apache config, now default root is on public folder, but when I click to any link (ie Team) it tries to go to page/team, and page/team does not exists (see screen shot)

[AymenOthmani]

for me everythinks working just i have problems in path ( links) https://scontent-cdg2-1.xx.fbcdn.net/v/t35.0-12/13767360_1204056909638445_3315980957054269986_o.jpg?oh=4002d376a33a5e2a6531aaadee09ccc5&oe=579BF543