| operator '*' for types 'numeric' and 'double precision' [message #9048] |
Sun, 09 March 2003 18:09  |
mikeraz
Messages: 3
Registered: March 2003
Location: Portland, Oregon
Karma: 0
|
Junior Member |
|
|
FUD code execution on a newly installed FUDforum2_20030306 running against Postgres v7.2.2 on RedHat 8.
Full error message generated when I attempt to test forum consistency from admin interface:
Warning: pg_query() query failed: ERROR: Unable to identify an operator '*' for types 'numeric' and 'double precision' You will have to retype this query using an explicit cast in /var/www/fud/include/theme/default/db.inc on line 127
Warning: pg_result_error() expects parameter 1 to be resource, boolean given in /var/www/fud/include/theme/default/db.inc on line 128
Very similar error when a user attempts to create a new topic:
Warning: pg_query() query failed: ERROR: Unable to identify an operator '*' for types 'numeric' and 'double precision' You will have to retype this query using an explicit cast in /var/www/html/fud/index.php on line 131
Warning: pg_result_error() expects parameter 1 to be resource, boolean given in /var/www/html/fud/index.php on line 132
Fatal error: SQL Error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /var/www/fud/include/theme/default/err.inc on line 102
[Updated on: Sun, 09 March 2003 23:22] Report message to a moderator |
|
|
|
|
|
| Re: operator '*' for types 'numeric' and 'double precision' [message #9163 is a reply to message #9048] |
Thu, 13 March 2003 20:16  |
mikeraz
Messages: 3
Registered: March 2003
Location: Portland, Oregon
Karma: 0
|
Junior Member |
|
|
Hopefully you meant the error log browser:
Error Description
Sun Mar 9 17:09:06 GMT 2003 (t=post) :
Query: INSERT INTO fud23_thread_view (thread_id,forum_id,page,pos) SELECT thread_id,forum_id,CEIL(pos/40.0),(pos-(CEIL(pos/40.0)-1)*40.0) FROM fud23_ftvt_1777296083
Server Version:
[Referring Page] http://dawg.patch.com/fud/index.php?t=post
Sun Mar 9 17:10:42 GMT 2003 (t=post) :
Query: INSERT INTO fud23_thread_view (thread_id,forum_id,page,pos) SELECT thread_id,forum_id,CEIL(pos/40.0),(pos-(CEIL(pos/40.0)-1)*40.0) FROM fud23_ftvt_1449892045
Server Version:
[Referring Page] http://dawg.patch.com/fud/index.php?t=post
Sun Mar 9 17:51:37 GMT 2003 () :
Query: INSERT INTO fud23_thread_view (thread_id,forum_id,page,pos) SELECT thread_id,forum_id,CEIL(pos/40.0),(pos-(CEIL(pos/40.0)-1)*40.0) FROM fud23_ftvt_158447622
Server Version:
[Referring Page] http://dawg.patch.com/fud/adm/consist.php?rid=1&S=bdabdd96dc561d2081d77 c27b3bfe0cb
Sun Mar 9 18:07:41 GMT 2003 (t=post) :
Query: INSERT INTO fud23_thread_view (thread_id,forum_id,page,pos) SELECT thread_id,forum_id,CEIL(pos/40.0),(pos-(CEIL(pos/40.0)-1)*40.0) FROM fud23_ftvt_298275464
Server Version:
[Referring Page] http://dawg.patch.com/fud/index.php?t=post&returnto=http%3A%2F%2Fdawg.p atch.com%2Ffud%2Findex.php%3Ft%3Dthread%26amp%3Bfrm_id%3D1%26amp%3Brid%3D2% 26amp%3BS%3D7a2c89faa0645444df74f09fc073e799&frm_id=1&rid=2&S=7 a2c89faa0645444df74f09fc073e799
|
|
|
|
|
|
|
|
| Re: operator '*' for types 'numeric' and 'double precision' [message #9343 is a reply to message #9337] |
Mon, 24 March 2003 17:27 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Yeah this is PostgreSQL specific. The fix will change the query to
,(pos-(CEIL(pos/40.0)-1)*40), which should work, I'll test it, but a patch will definately be in the upcomming release (1-2 day timeline).
FUDforum Core Developer
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]