Malformed search query: SQLSTATE[42000]: Syntax error or access violation
- Status
- Closed
- Subject
- Malformed search query: SQLSTATE[42000]: Syntax error or access violation
- Version
- Regression from 26.x to 27.x
- Category
- Regression
- Feature
- Watch (email notifications of changes)
- Resolution status
- Fixed or Solved
- Submitted by
- luci
- Volunteered to solve
- Victor Emanouilov
- Lastmod by
- luci
- Rating
- Description
Bunch of malformed search query errors with some weird REGEX() stuff?
Copy to clipboardMalformed search query: SQLSTATE[42000]: Syntax error or access violation: 1064 P01: syntax error, unexpected identifier, expecting string near 'Array) OR REGEX(stream, Array)) OR REGEX(stream, Array)) OR REGEX(stream, Array)) OR REGEX(stream, Array)) OR REGEX(stream, Array)) OR REGEX(stream, Array)) OR REGEX(stream, Array)) OR REGEX(stream, Array)) OR REGEX(stream, Array)) OR REGEX(stream, Array)) OR REGEX(stream, Array)) OR REGEX(stream, Array)) OR REGEX(stream, Array)) OR REGEX(stream, Array)) OR REGEX(stream, Array)) OR REGEX(stream, Array)) OR REGEX(stream, Array)) OR REGEX(str...
Steps to reproduce:- click on the bell icon next to your logged in username at top right
- Unread Notifications modal appears
- click Show More button
See https://dev.tiki.org/tiki-monitor-stream?from=-30+days&to=now&critical=1&high=1&low=1
- Solution
- Workaround
- Importance
- 5
- Easy to solve?
- 5
- Priority
- 25
- Demonstrate Bug on Tiki 19+
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show2.tiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Demonstrate Bug (older Tiki versions)
-
This bug has been demonstrated on show.tikiwiki.org
Please demonstrate your bug on show.tikiwiki.org
Show.tiki.org is not configured properlyThe public/private keys configured to connect to show.tikiwiki.org were not accepted. Please make sure you are using RSA keys. Thanks.
- Ticket ID
- 8631
- Created
- Monday 13 May, 2024 10:07:49 UTC
by luci - LastModif
- Thursday 20 June, 2024 13:18:10 UTC