+- MyBB.de Forum (https://www.mybb.de/forum)
+-- Forum: Anpassungen (https://www.mybb.de/forum/forum-47.html)
+--- Forum: Plugin-Diskussionen (https://www.mybb.de/forum/forum-38.html)
+--- Thema: php in templates kollidiert mit Accountswitcher (/thread-38818.html)
php in templates kollidiert mit Accountswitcher - Tini93 - 18.08.2023
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
RE: php in templates kollidiert mit Accountswitcher - doylecc - 19.08.2023
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.
RE: php in templates kollidiert mit Accountswitcher - Tini93 - 19.08.2023
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>RE: php in templates kollidiert mit Accountswitcher - Tini93 - 24.08.2023
Hallöchen! Ich wollte das Thema hier nochmal pushen. Hat jemand eine Idee, wie ich das Problem lösen kann?
RE: php in templates kollidiert mit Accountswitcher - Schnapsnase - 25.08.2023
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.
