Question sur la RelaxArcade IBPro

[fastgil.com]

Postez ici vos questions ou problèmes avec l'arcade RelaxArcade IBPro ! Une erreur ? Un bug ? Une incompréhension ? On est là pour vous aider

Stelle hier deine Fragen oder Probleme mit der RelaxArcade IBPro! Ein Fehler? Ein Bug? Etwas unklar? Wir helfen dir gerne weiter

Post your questions or issues with RelaxArcade IBPro here! Got an error, bug, or something confusing? We're here to help

[Miri4ever]

First launch giving those errors.

SQL ERROR [ mysqli ]

Table 'Forum.phpbb_config' doesn't exist [1146]

SQL

UPDATE phpbb_config SET config_value = 1760458678 WHERE config_name = "ra_last_gotd_update"

SQL ERROR [ mysqli ]

Table 'Forum.phpbb_ra_game_rating' doesn't exist [1146]

SQL

SELECT a.game_id,b.game_name,b.game_pic,b.game_scorevar FROM phpbb_ra_game_rating a LEFT JOIN phpbb_ra_games b ON a.game_id = b.game_id GROUP BY a.game_id ORDER BY AVG(a.game_rating_val) DESC LIMIT 0,5

BACKTRACE

[fastgil.com]

Miri, eine neue Version kannst du hier herunterladen, um dein Tabellenproblem zu lösen. Bitte deinstalliere die alte Version der Datenbank vollständig, damit die neue korrekt installiert werden kann.


hier

[StringCGN]

SQL ERROR [ mysqli ]

Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db_299010_10.a.game_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]

SQL

SELECT a.game_id, SUM(a.playcount) as gplaycount, c.gid, c.game_name, c.game_pic, c.game_scorevar FROM phpbb_usgra_scores a LEFT JOIN (SELECT a.user_id, a.game_id, b.game_id as gid, b.game_pic, b.game_name, b.game_scorevar FROM phpbb_usgra_scores a LEFT JOIN phpbb_usgra_games b ON a.game_id = b.game_id WHERE a.score_date = (SELECT MAX(score_date) FROM phpbb_usgra_scores WHERE user_id = 2) GROUP BY a.user_id ) c ON a.user_id = c.user_id WHERE a.user_id = 2

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1031
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 216
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 353
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/teamrelax/relaxarcade/controller/arcade_list.php
LINE: 2310
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/teamrelax/relaxarcade/controller/arcade_list.php
LINE: 1556
CALL: teamrelax\relaxarcade\controller\arcade_list->statistique()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 151
CALL: teamrelax\relaxarcade\controller\arcade_list->handle()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 68
CALL: Symfony\Component\HttpKernel\HttpKernel->handleRaw()

FILE: [ROOT]/app.php
LINE: 35
CALL: Symfony\Component\HttpKernel\HttpKernel->handle()

[fastgil.com]

The file to replace is ext/teamrelax/relaxarcade/controller/arcade_list.php. This file completely replaces the existing file and clears the cache.

Code : Tout sélectionner

ext/teamrelax/relaxarcade/controller/arcade_list.php

arcade_list.zip

The fix was already in place in the upcoming version 1.30.

[StringCGN]

Now I have that:

SQL ERROR [ mysqli ]

In aggregated query without GROUP BY, expression #2 of SELECT list contains nonaggregated column 'c.gid'; this is incompatible with sql_mode=only_full_group_by [1140]

SQL

SELECT SUM(a.playcount) AS gplaycount, c.gid, c.game_name, c.game_pic, c.game_scorevar FROM phpbb_usgra_scores a LEFT JOIN ( SELECT s.user_id, s.game_id AS gid, g.game_name, g.game_pic, g.game_scorevar FROM phpbb_usgra_scores s LEFT JOIN phpbb_usgra_games g ON s.game_id = g.game_id WHERE s.user_id = 2 ORDER BY s.score_date DESC LIMIT 1 ) c ON a.user_id = c.user_id WHERE a.user_id = 2

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 1031
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 216
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 353
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/ext/teamrelax/relaxarcade/controller/arcade_list.php
LINE: 2313
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/teamrelax/relaxarcade/controller/arcade_list.php
LINE: 1556
CALL: teamrelax\relaxarcade\controller\arcade_list->statistique()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 151
CALL: teamrelax\relaxarcade\controller\arcade_list->handle()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 68
CALL: Symfony\Component\HttpKernel\HttpKernel->handleRaw()

FILE: [ROOT]/app.php
LINE: 35
CALL: Symfony\Component\HttpKernel\HttpKernel->handle()

[fastgil.com]

Try this file. And don't forget to disable and clear your cache. Please tell me your PHP version.

arcade_list_fixed.zip

Code : Tout sélectionner

ext/teamrelax/relaxarcade/controller/arcade_list.php

[StringCGN]

Intallation games

[phpBB Debug] PHP Warning: in file [ROOT]/ext/teamrelax/relaxarcade/arcade/includes/tar.php on line 45: require_once(PEAR.php): Failed to open stream: No such file or directory

[fastgil.com]

You need to leave the game in its compressed file and install it using ACP; but first, you need to have at least one game category created. How do you install your games? And do you have the arcade folder in the heart of your forum?