| SQL Error Deleting User [message #4400] |
Thu, 25 July 2002 19:43  |
jhillyerd
Messages: 2
Registered: July 2002
Location: Bothell, WA
Karma: 0
|
Junior Member |
|
|
I get the following error when I try to delete a user:
| Quote: |
query failed: %( UPDATE fud21_forum SET moderators=TRIM(BOTH ' ' FROM REPLACE(moderators, '3 test', '')) )% because %( LAST_ERROR: ERROR: Function 'replace(text, unknown, unknown)' does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts )%Query Failed: UPDATE fud21_forum SET moderators=TRIM(BOTH ' ' FROM REPLACE(moderators, '3 test', ''))
Reason: LAST_ERROR: ERROR: Function 'replace(text, unknown, unknown)' does not exist Unable to identify a function that satisfies the given argument types You may need to add explicit typecasts
|
I am using FUDforum 2.2.3 on PHP 4.2.2 with PostgreSQL 7.2
Thanks for any help you can give me.
-james
|
|
|
|
| Re: SQL Error Deleting User [message #4406 is a reply to message #4400] |
Fri, 26 July 2002 00:07  |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Its a bug, apparently PGSQL does not have a replace function, I'll find an alternative and send you a patch.
FUDforum Core Developer
|
|
|
|
| Re: SQL Error Deleting User [message #4411 is a reply to message #4400] |
Fri, 26 July 2002 03:25 |
Ilia
Messages: 13241
Registered: January 2002
Karma: 0
|
Senior Member
Administrator
Core Developer |
|
|
Replace the file you have with the one attached, rebuild the templates and try again, it should work now.
FUDforum Core Developer
|
|
|
|
|
|
Calendar
Search
Help
Members
Register
Login
Home
]