SQL error when adding friend or foe

bendeb · Post by **bendeb** » Tue Oct 26, 2021 12:14 am

Hello,

Support Request Template
What version of phpBB are you using? phpBB 3.2.11
Who do you host your board with? Ex2 Hosting
How did you install your board? I used the download package from phpBB.com
What is the most recent action performed on your board? Update from a previous version of phpBB3
Is registration required to reproduce this issue? Yes
Do you have any MODs installed? No
Do you have any extensions installed? Yes
What version of phpBB3 did you update from? phpBB 3.1.11
What extensions do you have installed? ACP Style 1.0.0
Advanced BBCode Box 3.1.0
Advanced Polls 1.1.0-b1
Application Form 1.0.7
Auto Groups 2.0.4
Avatars on Memberlist 1.0.3
BBCode Enabled Profile Fields 1.0.1
Display Last Post 1.1.6
External Links Open in New Window 1.0.6
Galerie d'avatars 1.0.0
Lightbox 1.0.4
mChat 2.0.1
phpBB Countdown 1.0.3
phpBB Studio - Dice 2.1.2
PM Name Suggestions 1.1.3
Post Models 1.1.0
Prime note bbcode 1.1.1
Private Message Box Status Bars 2.0.1
SCSS Compiler 1.0.1
Smart Subjects 1.0.0
Tabs BBCode 1.0.1
Topic Preview 2.2.1
Usermap 0.2.4
VigLink 1.0.5
What styles do you currently have installed? elegance
What language(s) is your board currently using? french
Which database type/version are you using? MySQL 5
What is your level of experience? New to PHP but not phpBB
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? After login, go to UCP > "Friends and foes" setting : https://www.donjondudragon.fr/forum/user.html?i=177
Try to add an user as a friend (or foe) and submit
Please describe your problem. When submit, I have an 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 ' NOW(), "", "", 'Friend')' at line 2
Generated by SRT Generator

Thank for your help

Regards

3Di · Post by **3Di** » Tue Oct 26, 2021 12:53 am

bendeb wrote: ↑Tue Oct 26, 2021 12:14 am ...
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? After login, go to UCP > "Friends and foes" setting : https://www.donjondudragon.fr/forum/user.html?i=177
Try to add user "Szass" as a friend (or foe) and submit
Please describe your problem. When submit, I have an 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 ' NOW(), "", "", 'Friend')' at line 2
...

You are using some sort of SEO extension/MOD,
https://www.donjondudragon.fr/forum/user.html?i=177

.html

that could be the issue. Also, are you sure that the user "Szass" exists?

bendeb · Post by **bendeb** » Tue Oct 26, 2021 2:56 am

Thank for your reply.

I use p8pbb bridge : it's a bridge between Joomla and Phpbb, but until last phpbb update (to 3.2.11), friends and foes work correctly with this bridge.

Yes, user "Szass" really exist, it's my username on this forum

You can try it with another user of my forum : "Troumad" for example.

Thank you.

3Di · Post by **3Di** » Tue Oct 26, 2021 3:07 am

bendeb wrote: ↑Tue Oct 26, 2021 2:56 am I use p8pbb bridge

Ask the authors of that bridge version you have if it is compatible with your phpBB version.

bendeb · Post by **bendeb** » Tue Oct 26, 2021 10:22 am

Thank you 3Di, I just asked the developper of the bridge for this problem.
I'll tell you soon.

bendeb · Post by **bendeb** » Wed Oct 27, 2021 4:14 pm

OK sorry, the bug occured because of the bridge, and it's solved now.
Thank you.