0001955: resin-3.1.s070710, drupal 5.2, postgres

Notes
(0002230) gjvc 08-24-07 05:19	[ workaround (which might help debugging) ] If I create the database in postgres like this: ${POSTGRES_HOME}/bin/createdb --owner=u_drupal --username=u_postgresql --encoding=UTF8 db_drupal (as opposed to UNICODE as specified in the docs) and set the encoding in the drupal/WEB-INF/resin-web.xml file as <servlet-mapping url-pattern="*.php" servlet-class="com.caucho.quercus.servlet.QuercusServlet"> <init> <compile>true</compile> <database>jdbc/postgres/drupal</database> <script-encoding>UTF8</script-encoding> </init> </servlet-mapping> the site works, but I (predictably) get this exception. Hope this helps. 13:14:18.365 com.caucho.quercus.QuercusRuntimeException: java.io.CharConversionException: illegal utf8 encoding at 0x2d 13:14:18.365 at com.caucho.quercus.env.BinaryValue.appendTo(BinaryValue.java:191) 13:14:18.365 at com.caucho.quercus.env.BinaryValue.toUnicodeValue(BinaryValue.java:170) 13:14:18.365 at com.caucho.quercus.lib.RegexpModule$PCREPattern.<init>(RegexpModule.java:2220) 13:14:18.365 at com.caucho.quercus.lib.RegexpModule.preg_match(RegexpModule.java:199) 13:14:18.365 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 13:14:18.365 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 13:14:18.365 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 13:14:18.365 at java.lang.reflect.Method.invoke(Method.java:597) 13:14:18.365 at com.caucho.quercus.module.StaticFunction.invoke(StaticFunction.java:105) 13:14:18.365 at com.caucho.quercus.env.JavaInvoker.call(JavaInvoker.java:613) 13:14:18.365 at com.caucho.quercus.env.JavaInvoker.call(JavaInvoker.java:486) 13:14:18.365 at com.caucho.quercus.env.JavaInvoker.call(JavaInvoker.java:472) 13:14:18.365 at com.caucho.quercus.expr.FunctionExpr.evalImpl(FunctionExpr.java:182) 13:14:18.365 at com.caucho.quercus.expr.FunctionExpr.eval(FunctionExpr.java:126) 13:14:18.365 at com.caucho.quercus.expr.Expr.evalBoolean(Expr.java:449) 13:14:18.365 at com.caucho.quercus.program.IfStatement.execute(IfStatement.java:74) 13:14:18.365 at com.caucho.quercus.program.BlockStatement.execute(BlockStatement.java:99) 13:14:18.365 at com.caucho.quercus.program.Function.callImpl(Function.java:334) 13:14:18.365 at com.caucho.quercus.program.Function.call(Function.java:274) 13:14:18.365 at com.caucho.quercus.expr.FunctionExpr.evalImpl(FunctionExpr.java:182) 13:14:18.365 at com.caucho.quercus.expr.FunctionExpr.eval(FunctionExpr.java:126) 13:14:18.365 at com.caucho.quercus.expr.ListExpr.eval(ListExpr.java:86) 13:14:18.365 at com.caucho.quercus.program.ExprStatement.execute(ExprStatement.java:64) 13:14:18.365 at com.caucho.quercus.program.Function.callImpl(Function.java:334) 13:14:18.365 at com.caucho.quercus.program.Function.call(Function.java:274) 13:14:18.365 at com.caucho.quercus.expr.FunctionExpr.evalImpl(FunctionExpr.java:182) 13:14:18.365 at com.caucho.quercus.expr.FunctionExpr.eval(FunctionExpr.java:126) 13:14:18.365 at com.caucho.quercus.program.ExprStatement.execute(ExprStatement.java:64) 13:14:18.365 at com.caucho.quercus.program.BlockStatement.execute(BlockStatement.java:99) 13:14:18.365 at com.caucho.quercus.program.Function.callImpl(Function.java:334) 13:14:18.365 at com.caucho.quercus.program.Function.call(Function.java:274) 13:14:18.365 at com.caucho.quercus.expr.FunctionExpr.evalImpl(FunctionExpr.java:182) 13:14:18.365 at com.caucho.quercus.expr.FunctionExpr.eval(FunctionExpr.java:126) 13:14:18.365 at com.caucho.quercus.program.ExprStatement.execute(ExprStatement.java:64) 13:14:18.365 at com.caucho.quercus.program.BlockStatement.execute(BlockStatement.java:99) 13:14:18.365 at com.caucho.quercus.program.SwitchStatement.execute(SwitchStatement.java:87) 13:14:18.365 at com.caucho.quercus.program.BlockStatement.execute(BlockStatement.java:99) 13:14:18.365 at com.caucho.quercus.program.Function.callImpl(Function.java:334) 13:14:18.365 at com.caucho.quercus.program.Function.call(Function.java:274) 13:14:18.365 at com.caucho.quercus.expr.FunctionExpr.evalImpl(FunctionExpr.java:182) 13:14:18.365 at com.caucho.quercus.expr.FunctionExpr.eval(FunctionExpr.java:126) 13:14:18.365 at com.caucho.quercus.program.ExprStatement.execute(ExprStatement.java:64) 13:14:18.365 at com.caucho.quercus.program.BlockStatement.execute(BlockStatement.java:99) 13:14:18.365 at com.caucho.quercus.program.WhileStatement.execute(WhileStatement.java:60) 13:14:18.365 at com.caucho.quercus.program.BlockStatement.execute(BlockStatement.java:99) 13:14:18.365 at com.caucho.quercus.program.Function.callImpl(Function.java:334) 13:14:18.365 at com.caucho.quercus.program.Function.call(Function.java:274) 13:14:18.365 at com.caucho.quercus.expr.FunctionExpr.evalImpl(FunctionExpr.java:182) 13:14:18.365 at com.caucho.quercus.expr.FunctionExpr.eval(FunctionExpr.java:126) 13:14:18.365 at com.caucho.quercus.program.ExprStatement.execute(ExprStatement.java:64) 13:14:18.365 at com.caucho.quercus.program.BlockStatement.execute(BlockStatement.java:99) 13:14:18.365 at com.caucho.quercus.program.QuercusProgram.execute(QuercusProgram.java:239) 13:14:18.365 at com.caucho.quercus.page.InterpretedPage.execute(InterpretedPage.java:61) 13:14:18.365 at com.caucho.quercus.page.QuercusPage.executeTop(QuercusPage.java:119) 13:14:18.365 at com.caucho.quercus.servlet.ResinQuercusServlet.service(ResinQuercusServlet.java:123) 13:14:18.365 at com.caucho.quercus.servlet.QuercusServlet.service(QuercusServlet.java:350) 13:14:18.365 at javax.servlet.http.HttpServlet.service(HttpServlet.java:91) 13:14:18.365 at com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:103) 13:14:18.365 at com.caucho.server.webapp.WebAppFilterChain.doFilter(WebAppFilterChain.java:175) 13:14:18.365 at com.caucho.server.dispatch.ServletInvocation.service(ServletInvocation.java:240) 13:14:18.365 at com.caucho.server.http.HttpRequest.handleRequest(HttpRequest.java:263) 13:14:18.365 at com.caucho.server.port.TcpConnection.run(TcpConnection.java:481) 13:14:18.365 at com.caucho.util.ThreadPool$Item.runTasks(ThreadPool.java:685) 13:14:18.365 at com.caucho.util.ThreadPool$Item.run(ThreadPool.java:607) 13:14:18.365 at java.lang.Thread.run(Thread.java:619)

(0002499) mo 11-16-07 12:44	After much searching, it turns out that this problem was caused by a buggy implementation of pg_escape_bytea. Added the following regression tests: php/432b.qa php/432c.qa

(0002501) mo 11-16-07 18:25	This problem has been verified as fixed. Just tested with drupal 5.2 under win32. DB setup and initial login worked as expected.

Issue History
Date Modified	Username	Field	Change
08-20-07 15:24	gjvc	New Issue
08-20-07 17:14	nam	Status	new => assigned
08-20-07 17:14	nam	Assigned To	=> nam
08-21-07 06:05	gjvc	Issue Monitored: gjvc
08-22-07 10:04	nam	Assigned To	nam =>
08-22-07 10:04	nam	Status	assigned => new
08-24-07 05:19	gjvc	Note Added: 0002230
11-13-07 12:43	mo	Status	new => assigned
11-13-07 12:43	mo	Assigned To	=> mo
11-16-07 12:44	mo	Note Added: 0002499
11-16-07 18:25	mo	Status	assigned => closed
11-16-07 18:25	mo	Note Added: 0002501
11-16-07 18:25	mo	Resolution	open => fixed
11-16-07 18:25	mo	Fixed in Version	=> 3.1.4

Relationships