I'm running Drupal 4.7.1 on PostgreSQL 8.0.8. It's configured for UTF-8 encoding.

I've installed jstools and activated all the modules.

I get the following errors in the logs:

Message: pg_query() [function.pg-query]: Query failed: ERROR: invalid byte sequence for encoding "UNICODE": 0xe96472 in /vdocs/olo.org.pl/dr/includes/database.pgsql.inc on line 84.
Severity: error

Additionally, when e.g. posting new content, the sections in the forms don't work - there are only their names visible as static HTML, and they cannot be expanded to reveal their contents.

Comments

olo’s picture

olo commented

Actually, it's seemingly not related to wforms, as the message in syslog indicates. The problem's probably in the Description of the module "columns", which contains an invalid character (in the name of module's author) that causes the "invalid byte sequence for encoding UNICODE" SQL error on INSERT:

Jun 2 14:52:09 ab httpd: PHP Warning: pg_query() [function.pg-query]: Query failed: ERROR: invalid byte sequence for encoding "UNICODE": 0xe96472 in /vdocs/olo.org.pl/dr/includes/database.pgsql.inc on line 84
Jun 2 14:52:09 ab httpd: PHP Warning: ERROR: invalid byte sequence for encoding "UNICODE": 0xe96472 query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (1, 'php', ' query: INSERT INTO system (name, description, type, filename, status, throttle, bootstrap) VALUES ('columns', 'Enables multi-column layout, based on the css3-multi-column.js library by C\M-idric Savarese.', 'module', &

olo’s picture

olo commented
Component: wForms » Columns

Chaging component.

The non-ASCII character from "C?dric Savarese" on the columns module description needs to be removed.

The problem with forms not working is a different one, and I'll open a different bug.

olo’s picture

olo commented
Title: wforms/lib/wforms-jsonly.css pg_query() error » non-ASCII character in "columns" module description causes PostgreSQL error

changing bug title.

nedjo’s picture

nedjo
he/him/his
Primary language English
commented
Status: Active » Fixed

Thanks, now fixed.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)