adam/Piwigo
1
0 Fork 0
mirror of https://github.com/Piwigo/Piwigo.git synced 2026-10-30 21:52:00 +01:00
Code Issues 657 Packages Projects Releases Wiki Activity

"@" in quick search causes SQL error #1047

New Issue
Open
opened 2026-10-05 00:29:34 +02:00 by adam · 0 comments
adam commented 2026-10-05 00:29:34 +02:00
Owner
Copy link
Copy source

Hi!

I would like to report an issue I discovered while using Piwigo. As the title says if you use "@" character in quick search, Piwigo stops with SQL error:

PHP message: PHP Warning: [mysql error 1064] syntax error, unexpected '@', expecting $end

SELECT * FROM piwigo_tags
WHERE (MATCH(name) AGAINST( '@xxxx @xxx' IN BOOLEAN MODE)) in /xxx/include/dblayer/functions_mysqli.inc.php...

Piwigo is the last official version.

I hope it will be easy to fix.

Thanks!

PS: Thank you for this great software :-)

UPDATE: I think I found the reason, I'm using InnoDB and @ is reserved in fulltext search. Anyway is there some way how to fix it and still using InnoDB?

Hi! I would like to report an issue I discovered while using Piwigo. As the title says if you use "@" character in quick search, Piwigo stops with SQL error: PHP message: PHP Warning: [mysql error 1064] syntax error, unexpected '@', expecting $end SELECT * FROM piwigo_tags WHERE (MATCH(name) AGAINST( '@xxxx @xxx' IN BOOLEAN MODE)) in /xxx/include/dblayer/functions_mysqli.inc.php... Piwigo is the last official version. I hope it will be easy to fix. Thanks! PS: Thank you for this great software :-) UPDATE: I think I found the reason, I'm using InnoDB and @ is reserved in fulltext search. Anyway is there some way how to fix it and still using InnoDB? <!-- github-sync-id:677913896 -->
Sign in to join this conversation.
No Branch/Tag Specified
Labels
No items
No labels
Milestone
No items
No Milestone
Projects
Clear projects
No projects
Assignees
Clear assignees
adam (Adam Wojcieszonek)
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: adam/Piwigo#1047