Bug #27712
Some queries SQL does not execute in Postgres
| Status: | Resolved | Start date: | 2011-06-27 | |
|---|---|---|---|---|
| Priority: | Must have | Due date: | ||
| Assignee: | - | % Done: | 0% |
|
| Category: | Bug | |||
| Target version: | - | |||
| Votes: | 0 |
Description
Field author of table tx_t3blog_post is compared to beusers.uid, but data types of this field are different. author is of type varchar(255), uid is of type bigint. This issue leads to database error:
sqlError ERROR: operator does not exist: bigint = character varying
LINE 1: ..."tx_t3blog_post"."pid" = 46 AND "be_users"."uid" = "tx_t3bl...
^
HINT: No operator matches the given name and argument type(s). You might
need to add explicit type casts.
More details can be found in my message to TYPO3 mailing list:
http://lists.typo3.org/pipermail/typo3-english/2011-June/075695.html
Because of this error is is impossible to run t3blog extension on Postgres.
Related issues
| related to T3BLOG - Bug #27617: Non-portable SQL syntax in listFunctions | Resolved | 2011-06-21 |