Hallo, Gast! ( — Registrieren)

Letzte Ankündigung: MyBB 1.8.38 veröffentlicht (30.04.24)


Benutzer, die gerade dieses Thema anschauen: 2 Gast/Gäste
Baumstrukturmodus
php in templates kollidiert mit Accountswitcher
Tini93 Offline
Benutzer
***
Beiträge: 83
Themen: 16
Registriert seit: 04.06.2016
MyBB-Version: 1.8.26
#1
18.08.2023, 15:15
Hallo,

ich hoffe, dass ich bei der Suche nichts übersehen habe.

Ich habe bei mir im Forum den Accountswitcher (Version: 2.1.12) von doylecc und php in Templates von zingaburga installiert. Wenn ich beim Accountswitcher einen User anhängen möchte, bekomme ich bei Eingabe des Namens die Fehlermeldung "Loading failed". Ich vermute ganz stark, dass das ein Javascript-Fehler ist. Es liegt auch definitiv am php in Templates-Plugin, denn nach Deinstallation von diesem funktionierte es wieder. Es scheint außerdem generell diese Art von Eingabefeld zu beeinflussen, denn beim Inplaytracker 3.0 von Sparks fly erhalte ich dieselbe Fehlermeldung.

Ich nutze folgende Versionen:

mybb-Version: 1.8.35
php-Version: 7.4.33
SQL Engine: MySQLi 10.5.19

Ich bringe euch außerdem einen Screenshot von der Konsole mit, wenn ich den Fehler untersuche. Vielen Dank schonmal im Voraus!

lg
Tini

   
Homepage Suchen
Zitieren
doylecc Offline
(waldo)
******
Support Team
Beiträge: 2.041
Themen: 10
Registriert seit: 28.06.2007
MyBB-Version: 1.8.x
#2
19.08.2023, 15:16
Es sieht so aus, als ob die Datei xmlhttp.php  einen Serverfehler verursacht, wenn php in Templates aktiviert ist - möglicherweise durch einen der PHP-Codes in einem Template.
Bei der Namenseingabe im Forum wird auf die Funktion get_user zurückgegriffen, die sich ebenfalls in xmlhttp.php befindet und kann so auch nicht funktionieren.

Um näheres zur Ursache des Fehlers herauszufinden, müsstest du mal ins Server error.log schauen.
Homepage Suchen
Zitieren
Tini93 Offline
Benutzer
***
Beiträge: 83
Themen: 16
Registriert seit: 04.06.2016
MyBB-Version: 1.8.26
#3
19.08.2023, 18:18
Hallo doylecc,

vielen Dank für deine schnelle Rückmeldung.

Tatsächlich gibt die error.log nur wenig Aufschluss. Da sind einige alte Fehlermeldungen, aber nicht wirklich etwas zur xmlhttp.php. Ich packe sie einmal als Code hier rein.

Code:
<error>
    <dateline>1690318881</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1054 - Unknown column 'as_uid' in 'field list'
Query: SELECT as_uid FROM mybb_users WHERE uid = '6'</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:801]
#3  DB_MySQLi->simple_select() called at [/inc/plugins/ipt.php:927]
#4  ipt_global() called at [/inc/class_plugins.php:142]
#5  pluginSystem->run_hooks() called at [/global.php:498]
#6  require_once() called at [/index.php:18]
</back_trace>
</error>

<error>
    <dateline>1690319023</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1054 - Unknown column 'as_uid' in 'field list'
Query: SELECT as_uid FROM mybb_users WHERE uid = '0'</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:801]
#3  DB_MySQLi->simple_select() called at [/inc/plugins/ipt.php:927]
#4  ipt_global() called at [/inc/class_plugins.php:142]
#5  pluginSystem->run_hooks() called at [/global.php:498]
#6  require_once() called at [/index.php:18]
</back_trace>
</error>

<error>
    <dateline>1690320253</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1054 - Unknown column 'as_uid' in 'field list'
Query: SELECT as_uid FROM mybb_users WHERE uid = '8'</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:801]
#3  DB_MySQLi->simple_select() called at [/inc/plugins/ipt.php:927]
#4  ipt_global() called at [/inc/class_plugins.php:142]
#5  pluginSystem->run_hooks() called at [/global.php:498]
#6  require_once() called at [/index.php:18]
</back_trace>
</error>

<error>
    <dateline>1690320327</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1054 - Unknown column 'as_uid' in 'field list'
Query: SELECT as_uid FROM mybb_users WHERE uid = '0'</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:801]
#3  DB_MySQLi->simple_select() called at [/inc/plugins/ipt.php:927]
#4  ipt_global() called at [/inc/class_plugins.php:142]
#5  pluginSystem->run_hooks() called at [/global.php:498]
#6  require_once() called at [/index.php:18]
</back_trace>
</error>

<error>
    <dateline>1690320474</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1054 - Unknown column 'as_uid' in 'field list'
Query: SELECT as_uid FROM mybb_users WHERE uid = '0'</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:801]
#3  DB_MySQLi->simple_select() called at [/inc/plugins/ipt.php:927]
#4  ipt_global() called at [/inc/class_plugins.php:142]
#5  pluginSystem->run_hooks() called at [/global.php:498]
#6  require_once() called at [/index.php:18]
</back_trace>
</error>

<error>
    <dateline>1690320476</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1054 - Unknown column 'as_uid' in 'field list'
Query: SELECT as_uid FROM mybb_users WHERE uid = '0'</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:801]
#3  DB_MySQLi->simple_select() called at [/inc/plugins/ipt.php:927]
#4  ipt_global() called at [/inc/class_plugins.php:142]
#5  pluginSystem->run_hooks() called at [/global.php:498]
#6  require_once() called at [/index.php:18]
</back_trace>
</error>

<error>
    <dateline>1690320959</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1054 - Unknown column 'as_uid' in 'field list'
Query: SELECT as_uid FROM mybb_users WHERE uid = '0'</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:801]
#3  DB_MySQLi->simple_select() called at [/inc/plugins/ipt.php:927]
#4  ipt_global() called at [/inc/class_plugins.php:142]
#5  pluginSystem->run_hooks() called at [/global.php:498]
#6  require_once() called at [/index.php:18]
</back_trace>
</error>

<error>
    <dateline>1690320986</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1054 - Unknown column 'as_uid' in 'field list'
Query: SELECT as_uid FROM mybb_users WHERE uid = '0'</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:801]
#3  DB_MySQLi->simple_select() called at [/inc/plugins/ipt.php:927]
#4  ipt_global() called at [/inc/class_plugins.php:142]
#5  pluginSystem->run_hooks() called at [/global.php:498]
#6  require_once() called at [/index.php:18]
</back_trace>
</error>

<error>
    <dateline>1690320999</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1054 - Unknown column 'as_uid' in 'field list'
Query: SELECT as_uid FROM mybb_users WHERE uid = '0'</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:801]
#3  DB_MySQLi->simple_select() called at [/inc/plugins/ipt.php:927]
#4  ipt_global() called at [/inc/class_plugins.php:142]
#5  pluginSystem->run_hooks() called at [/global.php:498]
#6  require_once() called at [/index.php:18]
</back_trace>
</error>

<error>
    <dateline>1690401096</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1146 - Table 'hopegrows.mybb_maps' doesn't exist
Query: SELECT * FROM mybb_maps WHERE fid = '2'</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:801]
#3  DB_MySQLi->simple_select() called at [/inc/functions_forumlist.php:601]
#4  build_forumbits() called at [/inc/functions_forumlist.php:163]
#5  build_forumbits() called at [/index.php:463]
</back_trace>
</error>

<error>
    <dateline>1690401237</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1146 - Table 'hopegrows.mybb_maps' doesn't exist
Query: SELECT * FROM mybb_maps WHERE fid = '2'</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:801]
#3  DB_MySQLi->simple_select() called at [/inc/functions_forumlist.php:601]
#4  build_forumbits() called at [/inc/functions_forumlist.php:163]
#5  build_forumbits() called at [/index.php:463]
</back_trace>
</error>

<error>
    <dateline>1692364634</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1146 - Table 'hopegrows.mybb_newpoints_categories' doesn't exist
Query: SELECT * FROM mybb_newpoints_categories</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/member.php(2868) : eval()'d code(2) : eval()'d code(6) : eval()'d code(4) : eval()'d code:3]
#3  eval() called at [/member.php(2868) : eval()'d code(2) : eval()'d code(6) : eval()'d code:4]
#4  eval() called at [/member.php(2868) : eval()'d code(2) : eval()'d code:6]
#5  eval() called at [/member.php(2868) : eval()'d code:2]
#6  eval() called at [/member.php:2868]
</back_trace>
</error>

<error>
    <dateline>1692364656</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1146 - Table 'hopegrows.newpoints_categories' doesn't exist
Query: SELECT * FROM newpoints_categories</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/member.php(2868) : eval()'d code(2) : eval()'d code(6) : eval()'d code(4) : eval()'d code:3]
#3  eval() called at [/member.php(2868) : eval()'d code(2) : eval()'d code(6) : eval()'d code:4]
#4  eval() called at [/member.php(2868) : eval()'d code(2) : eval()'d code:6]
#5  eval() called at [/member.php(2868) : eval()'d code:2]
#6  eval() called at [/member.php:2868]
</back_trace>
</error>

<error>
    <dateline>1692364685</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1146 - Table 'hopegrows.mybb_newpoints_categories' doesn't exist
Query: SELECT * FROM mybb_newpoints_categories</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/member.php(2868) : eval()'d code(2) : eval()'d code(6) : eval()'d code(4) : eval()'d code:3]
#3  eval() called at [/member.php(2868) : eval()'d code(2) : eval()'d code(6) : eval()'d code:4]
#4  eval() called at [/member.php(2868) : eval()'d code(2) : eval()'d code:6]
#5  eval() called at [/member.php(2868) : eval()'d code:2]
#6  eval() called at [/member.php:2868]
</back_trace>
</error>

<error>
    <dateline>1692364756</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1146 - Table 'hopegrows.mybb_newpoints_categories' doesn't exist
Query: SELECT * FROM  mybb_newpoints_categories</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/member.php(2868) : eval()'d code(2) : eval()'d code(6) : eval()'d code(4) : eval()'d code:3]
#3  eval() called at [/member.php(2868) : eval()'d code(2) : eval()'d code(6) : eval()'d code:4]
#4  eval() called at [/member.php(2868) : eval()'d code(2) : eval()'d code:6]
#5  eval() called at [/member.php(2868) : eval()'d code:2]
#6  eval() called at [/member.php:2868]
</back_trace>
</error>

<error>
    <dateline>1692365413</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1146 - Table 'hopegrows.mybb_mybb_newpoints_categories' doesn't exist
Query: SELECT * FROM mybb_mybb_newpoints_categories ORDER BY displayorder</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:801]
#3  DB_MySQLi->simple_select() called at [/member.php(2868) : eval()'d code(2) : eval()'d code(6) : eval()'d code(7) : eval()'d code:3]
#4  eval() called at [/member.php(2868) : eval()'d code(2) : eval()'d code(6) : eval()'d code:7]
#5  eval() called at [/member.php(2868) : eval()'d code(2) : eval()'d code:6]
#6  eval() called at [/member.php(2868) : eval()'d code:2]
#7  eval() called at [/member.php:2868]
</back_trace>
</error>

<error>
    <dateline>1692365439</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1146 - Table 'hopegrows.mybb_newpoints_categories' doesn't exist
Query: SELECT * FROM mybb_newpoints_categories ORDER BY displayorder</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:801]
#3  DB_MySQLi->simple_select() called at [/member.php(2868) : eval()'d code(2) : eval()'d code(6) : eval()'d code(7) : eval()'d code:3]
#4  eval() called at [/member.php(2868) : eval()'d code(2) : eval()'d code(6) : eval()'d code:7]
#5  eval() called at [/member.php(2868) : eval()'d code(2) : eval()'d code:6]
#6  eval() called at [/member.php(2868) : eval()'d code:2]
#7  eval() called at [/member.php:2868]
</back_trace>
</error>

<error>
    <dateline>1692365521</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1146 - Table 'hopegrows.mybb_mybb_newpoints_shop_categories' doesn't exist
Query: SELECT * FROM mybb_mybb_newpoints_shop_categories ORDER BY displayorder</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:801]
#3  DB_MySQLi->simple_select() called at [/member.php(2868) : eval()'d code(2) : eval()'d code(6) : eval()'d code(7) : eval()'d code:3]
#4  eval() called at [/member.php(2868) : eval()'d code(2) : eval()'d code(6) : eval()'d code:7]
#5  eval() called at [/member.php(2868) : eval()'d code(2) : eval()'d code:6]
#6  eval() called at [/member.php(2868) : eval()'d code:2]
#7  eval() called at [/member.php:2868]
</back_trace>
</error>

<error>
    <dateline>1692365530</dateline>
    <script></script>
    <line>0</line>
    <type>20</type>
    <friendly_type>MyBB SQL Error</friendly_type>
    <message>SQL Error: 1054 - Unknown column 'displayorder' in 'order clause'
Query: SELECT * FROM mybb_newpoints_shop_categories ORDER BY displayorder</message>
    <back_trace>#0  errorHandler->error() called at [/inc/db_mysqli.php:609]
#1  DB_MySQLi->error() called at [/inc/db_mysqli.php:345]
#2  DB_MySQLi->query() called at [/inc/db_mysqli.php:801]
#3  DB_MySQLi->simple_select() called at [/member.php(2868) : eval()'d code(2) : eval()'d code(6) : eval()'d code(7) : eval()'d code:3]
#4  eval() called at [/member.php(2868) : eval()'d code(2) : eval()'d code(6) : eval()'d code:7]
#5  eval() called at [/member.php(2868) : eval()'d code(2) : eval()'d code:6]
#6  eval() called at [/member.php(2868) : eval()'d code:2]
#7  eval() called at [/member.php:2868]
</back_trace>
</error>
Homepage Suchen
Zitieren
Tini93 Offline
Benutzer
***
Beiträge: 83
Themen: 16
Registriert seit: 04.06.2016
MyBB-Version: 1.8.26
#4
24.08.2023, 20:05
Hallöchen! Ich wollte das Thema hier nochmal pushen. Hat jemand eine Idee, wie ich das Problem lösen kann?
Homepage Suchen
Zitieren
Schnapsnase Offline
Nec scire fas est omnia
*****
Beiträge: 2.267
Themen: 33
Registriert seit: 25.05.2018
MyBB-Version: 1.8.38
#5
25.08.2023, 07:18 (Dieser Beitrag wurde zuletzt bearbeitet: 25.08.2023, 07:28 von Schnapsnase.)
Deine Fehlermeldungen besagen "nur", dass in der Datenbank Tabellen und Spalten fehlen, konkret für die Plugins Accountswitcher und Newpoints.
Da muss also bei der Installation etwas schief gelaufen sein.
Das alles hat aber nichts mit deinem eigentlichen Problem zu tun.
Wenn es sich hier, wie in der Konsole zu sehen, um einen 500er Error handelt, helfen nur die Error-Logdaten des Servers, nicht die von MyBB.
Versuche den Fehler mal aktuell herbei zu führen und schau dir danach die Errorlogs an.

Das Plugin "PHP in Templates" läuft fehlerfrei und ist auch nicht der direkte Verursacher des Problems. Wink
Homepage Suchen
Zitieren


Möglicherweise verwandte Themen…
Thema Verfasser Antworten Ansichten Letzter Beitrag
  Standard-Avatar/Gastansicht kollidiert fearlefish 1 1.130 18.06.2015, 19:20
Letzter Beitrag: fearlefish
  Accountswitcher funktioniert nicht Lava 7 2.216 31.10.2014, 16:12
Letzter Beitrag: Lava
  Erweiterter Accountswitcher und Abwesenheitsnotiz navis 10 3.490 22.06.2014, 13:59
Letzter Beitrag: navis



Foren-Team | Kontakt | MyBB.de | Nach oben | Archiv-Modus | Alle Foren als gelesen markieren | RSS-Synchronisation | Zur mobilen Ansicht