[peterb123]

Guten Morgen,
ich würde gerne MyFacebook Connect einrichten und habe probleme diesen API Schlüssel richtig ein zu stellen kann mir jemand erklären was ich auf der Facebookseite alles eintragen muss damit diese richtig und aktiv werden?

[Jockl]

In den zugehörigen Support-Thread verschoben.....

[sneha]

@peterb123 , assuming that you are comfortable with English,
see instructions available at plugin coder's site : How to install MyFacebook Connect

[MyBB.de Bot]

Eine neue Version wurde veröffentlicht: MyFacebook Connect 3.5

[Lordikon30]

Gibts dazu evtl. ne deutsche Anleitung.In der englischen blicke ich leider nicht so ganz durch und hänge jetzt bei Punkt 4 "While staying in App Review page, click on Start a submission." fest.
THX vorab
Greets
Lordikon30

[MyBB.de Bot]

Eine neue Version wurde veröffentlicht: MyFacebook Connect 3.6

[TheStoryteller]

Ich habe Probleme mit diesem Plug-in

Meine MyBB Version: 1.8.26
PHP:7.4.14
MySQLi: 5.7.28

Das Anmelden und Registrieren funktioniert einwandfrei, doch wenn die User etwas in ihrem Foren-Profil anpassen wollen, erhalten sie diese Fehlermeldung:

Code:

Type: 20
File:  (Line no. 0)
Message
SQL Error: 1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near 'WHERE
uid=22' at line 1
Query: UPDATE yg98z_users SET bl_view= WHERE uid=22
Back Trace: #0  errorHandler->email_error(20, SQL Error: 1064 - You have an error
in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near 'WHERE uid=22' at line 1
Query: UPDATE yg98z_users SET bl_view= WHERE uid=22 , , 0) called at
[/www/htdocs/w01ae00a/the-storyteller.eu/inc/class_error.php:195]
#1  errorHandler->error(20, Array ([error_no] => 1064,[error] => You have an
error in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near 'WHERE uid=22' at line 1,[query] =>
UPDATE yg98z_users SET bl_view= WHERE uid=22 )) called at
[/www/htdocs/w01ae00a/the-storyteller.eu/inc/db_mysqli.php:597]
#2  DB_MySQLi->error(UPDATE yg98z_users SET bl_view= WHERE uid=22 ) called at
[/www/htdocs/w01ae00a/the-storyteller.eu/inc/db_mysqli.php:337]
#3  DB_MySQLi->query(UPDATE yg98z_users SET bl_view= WHERE uid=22 ) called at
[/www/htdocs/w01ae00a/the-storyteller.eu/inc/plugins/blacklistAlert.php:807]
#4  blacklistAlert_edit_profile_do() called at
[/www/htdocs/w01ae00a/the-storyteller.eu/inc/class_plugins.php:142]
#5  pluginSystem->run_hooks(Array ([function] =>
blacklistAlert_edit_profile_do,[file] => )) called at
[/www/htdocs/w01ae00a/the-storyteller.eu/usercp.php:154]

Zeitgleich habe ich auch einmalig diesen Fehler bekommen:

Code:

Type: 20
File:  (Line no. 0)
Message
SQL Error: 1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use near ')
                  AND p.dateline > IFNULL(fr.dateline,)
                  AN' at line 8
Query: SELECT 1
                FROM yg98z_posts p
                INNER JOIN yg98z_threads t ON (p.tid = t.tid)
                LEFT JOIN yg98z_threadsread tr ON (tr.uid = 0 AND t.tid = tr.tid)
               
                LEFT JOIN yg98z_forumsread fr ON (fr.uid = 0 AND t.fid = fr.fid)
                WHERE p.visible = 1
                  AND t.visible = 1 AND t.fid NOT IN
                  ('4','17','57','3','5','6','13','16','7','8','9','10','11','12','62','14','15','18','24','22','19','20','21','32','34','40','41','42','43','44','48','58','59','60','61')
                  AND p.dateline > IFNULL(tr.dateline,)
                  AND p.dateline > IFNULL(fr.dateline,)
                  AND p.dateline >
                LIMIT 501
Back Trace: #0  errorHandler->email_error(20, SQL Error: 1064 - You have an error
in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near ')
                  AND p.dateline > IFNULL(fr.dateline,)
                  AN' at line 8
Query: SELECT 1
                FROM yg98z_posts p
                INNER JOIN yg98z_threads t ON (p.tid = t.tid)
                LEFT JOIN yg98z_threadsread tr ON (tr.uid = 0 AND t.tid = tr.tid)
               
                LEFT JOIN yg98z_forumsread fr ON (fr.uid = 0 AND t.fid = fr.fid)
                WHERE p.visible = 1
                  AND t.visible = 1 AND t.fid NOT IN
                  ('4','17','57','3','5','6','13','16','7','8','9','10','11','12','62','14','15','18','24','22','19','20','21','32','34','40','41','42','43','44','48','58','59','60','61')
                  AND p.dateline > IFNULL(tr.dateline,)
                  AND p.dateline > IFNULL(fr.dateline,)
                  AND p.dateline >
                LIMIT 501, , 0) called at
                [/www/htdocs/w01ae00a/the-storyteller.eu/inc/class_error.php:195]
#1  errorHandler->error(20, Array ([error_no] => 1064,[error] => You have an
error in your SQL syntax; check the manual that corresponds to your MySQL server
version for the right syntax to use near ')
                  AND p.dateline > IFNULL(fr.dateline,)
                  AN' at line 8,[query] => SELECT 1
                FROM yg98z_posts p
                INNER JOIN yg98z_threads t ON (p.tid = t.tid)
                LEFT JOIN yg98z_threadsread tr ON (tr.uid = 0 AND t.tid = tr.tid)
               
                LEFT JOIN yg98z_forumsread fr ON (fr.uid = 0 AND t.fid = fr.fid)
                WHERE p.visible = 1
                  AND t.visible = 1 AND t.fid NOT IN
                  ('4','17','57','3','5','6','13','16','7','8','9','10','11','12','62','14','15','18','24','22','19','20','21','32','34','40','41','42','43','44','48','58','59','60','61')
                  AND p.dateline > IFNULL(tr.dateline,)
                  AND p.dateline > IFNULL(fr.dateline,)
                  AND p.dateline >
                LIMIT 501)) called at
                [/www/htdocs/w01ae00a/the-storyteller.eu/inc/db_mysqli.php:597]
#2  DB_MySQLi->error(SELECT 1
                FROM yg98z_posts p
                INNER JOIN yg98z_threads t ON (p.tid = t.tid)
                LEFT JOIN yg98z_threadsread tr ON (tr.uid = 0 AND t.tid = tr.tid)
               
                LEFT JOIN yg98z_forumsread fr ON (fr.uid = 0 AND t.fid = fr.fid)
                WHERE p.visible = 1
                  AND t.visible = 1 AND t.fid NOT IN
                  ('4','17','57','3','5','6','13','16','7','8','9','10','11','12','62','14','15','18','24','22','19','20','21','32','34','40','41','42','43','44','48','58','59','60','61')
                  AND p.dateline > IFNULL(tr.dateline,)
                  AND p.dateline > IFNULL(fr.dateline,)
                  AND p.dateline >
                LIMIT 501) called at
                [/www/htdocs/w01ae00a/the-storyteller.eu/inc/db_mysqli.php:337]
#3  DB_MySQLi->query(SELECT 1
                FROM yg98z_posts p
                INNER JOIN yg98z_threads t ON (p.tid = t.tid)
                LEFT JOIN yg98z_threadsread tr ON (tr.uid = 0 AND t.tid = tr.tid)
               
                LEFT JOIN yg98z_forumsread fr ON (fr.uid = 0 AND t.fid = fr.fid)
                WHERE p.visible = 1
                  AND t.visible = 1 AND t.fid NOT IN
                  ('4','17','57','3','5','6','13','16','7','8','9','10','11','12','62','14','15','18','24','22','19','20','21','32','34','40','41','42','43','44','48','58','59','60','61')
                  AND p.dateline > IFNULL(tr.dateline,)
                  AND p.dateline > IFNULL(fr.dateline,)
                  AND p.dateline >
                LIMIT 501) called at
                [/www/htdocs/w01ae00a/the-storyteller.eu/inc/plugins/unreadPosts.php:583]
#4  unreadPosts::modifyOutput

Ich bin gerade dabei mich an PHP heranzutasten, von MySQL ganz zu schweigen.

Könnte mir jemand "übersetzen", was es mit diesen Fehlern auf sich hat und vielleicht auch, wie ich sie lösen kann?

Danke und LG

[TheStoryteller]

Edit: hat sich erledigt, es war eine fehlende Variable im mobile Theme und hatte nichts mit dem Plugin MyFacebook zu tun.