Bug #611
1.6 pm search issue with PostgreSQL
| Status: | Closed | Start date: | 12/22/2009 | |
|---|---|---|---|---|
| Priority: | Normal | Due date: | ||
| Assignee: | Tom Moore | % Done: | 100% |
|
| Category: | Private Messages | |||
| Target version: | 1.6.0 Beta | |||
| Reproducibility: | Always | Database Type: | PostgreSQL | |
| Reported In MyBB Version: | 1.6.0 | Database Version: | PostgreSQL 8.4 | |
| PHP Version: | SQA assignments: | |||
| Browser: |
Description
In MyBB 1.6, when trying to search for a private message with PostgreSQL a SQL error is returned:
MyBB has experienced an internal SQL error and cannot continue.
SQL Error:
22P02 - ERROR: invalid input syntax for integer: "" LINE 4: VALUES ('93b32c97d6e07a1eaefc0b5424898c19','1','','1','',... ^
Query:
INSERT INTO mybb_searchlog (sid,uid,dateline,ipaddress,threads,posts,resulttype,querycache,keywords) VALUES ('93b32c97d6e07a1eaefc0b5424898c19','1','','1','','','pmmessages','5,7','mybb')
To reproduce:
1) Create a couple of private messages
2) Search from private.php
Associated revisions
Fixes pm search issue with PostgreSQL (fixes:611)
History
#1 Updated by Tom Moore over 2 years ago
- Status changed from New to Resolved
- % Done changed from 0 to 100
Applied in changeset r4644.
#2 Updated by Tom Moore over 2 years ago
- Assignee set to Tom Moore
- Target version set to 1.6.0 Beta
#3 Updated by Chris W. B. over 2 years ago
- Status changed from Resolved to Closed