When attempting to upgrade the Wiki application from a previous version,
the PostgresQL log spits out the following:
ERROR: column “%,_0%” does not exist at character 260
STATEMENT: SELECT *,CASE WHEN wiki_body IS NULL THEN 3 ELSE (CASE
wiki_lang WHEN ‘en’ THEN 0 WHEN ‘’ THEN 1 ELSE 2 END) END AS
lang_priority FROM egw_wiki_pages WHERE
wiki_name=‘TransitRidersAlliance’ AND wiki_lang IN (‘en’,’’) AND (
wiki_id=0 AND (wiki_readable LIKE “%,_0%” OR wiki_readable LIKE
"%,_1%" OR wiki_readable LIKE “%,-5%” ) OR (wiki_writable LIKE
"%,_0%" OR wiki_writable LIKE “%,_1%” OR wiki_writable LIKE “%,-5%”))
AND wiki_supercede=wiki_time ORDER BY lang_priority
Nathan, I can see the change with r34111. Thank you.
I am trying to upgrade the wiki application in setup and am getting
(with r34110 & r34111) the following in the https log:
[Sat Mar 12 17:48:14 2011] [error] PHP Warning: Invalid argument
supplied for foreach() in
/var/www/egroupware/phpgwapi/inc/class.hooks.inc.php on line 61,
referer: https://messinet.com/egroupware/setup/applications.php
[Sat Mar 12 17:48:14 2011] [error] PHP Fatal error: Call to a member
function fetchColumn() on a non-object in
/var/www/egroupware/phpgwapi/inc/class.egw_cache_files.inc.php on line
55, referer: https://messinet.com/egroupware/setup/applications.php
and in the PostgreSQL log:
ERROR: index row size 3880 exceeds maximum 2712 for index
"egw_wiki_pages_body"
HINT: Values larger than 1/3 of a buffer page cannot be indexed.
Consider a function index of an MD5 hash of the value, or use
full text indexing.
STATEMENT: INSERT INTO egw_wiki_pages
(wiki_id,wiki_name,wiki_lang,wiki_version,wiki_time,wiki_supercede,wiki_readable,wiki_writable,wiki_username,wiki_hostname,wiki_comment,wiki_title,wiki_body)
SELEcT DISTINCT
wiki_id,wiki_name,wiki_lang,wiki_version,wiki_time,wiki_supercede,CAST(wiki_readable
AS VARCHAR),CAST(wiki_writable AS
VARCHAR),wiki_username,wiki_hostname,wiki_comment,wiki_title,CAST(wiki_body
AS TEXT) FROM tmp_egw_wiki_pages
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: UPDATE egw_wiki_pages
SET wiki_readable = (
case wiki_readable
WHEN 0 THEN ',_0’
WHEN 1 THEN ‘,_1’
WHEN 2 THEN ‘,_2’
ELSE concat(’,’, wiki_readable)
END),
wiki_writable = (case wiki_writable
WHEN 0 THEN ',_0’
WHEN 1 THEN ‘,_1’
WHEN 2 THEN ‘,_2’
ELSE concat(’,’, wiki_writable)
END)
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: SELECT COUNT() FROM egw_applications WHERE app_name='wiki’
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: INSERT INTO egw_applications
(app_name,app_enabled,app_order,app_tables,app_version,app_index,app_icon,app_icon_app)
VALUES
(‘wiki’,1,11,‘egw_wiki_links,egw_wiki_pages,egw_wiki_rate,egw_wiki_interwiki,egw_wiki_sisterwiki,egw_wiki_remote_pages’,‘1.9.001’,NULL,NULL,NULL)
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: SELECT hook_appname,hook_location,hook_filename FROM
egw_hooks JOIN egw_applications ON hook_appname=app_name ORDER BY app_order
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: DELETE FROM egw_hooks WHERE hook_appname='wiki’
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: SELECT count() FROM egw_hooks WHERE hook_appname='wiki’
AND hook_location='admin’
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: INSERT INTO egw_hooks
(hook_filename,hook_appname,hook_location) VALUES
(‘wiki_hooks::admin’,‘wiki’,‘admin’)
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: SELECT count() FROM egw_hooks WHERE hook_appname='wiki’
AND hook_location='sidebox_menu’
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: INSERT INTO egw_hooks
(hook_filename,hook_appname,hook_location) VALUES
(‘wiki_hooks::sidebox_menu’,‘wiki’,‘sidebox_menu’)
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: SELECT count() FROM egw_hooks WHERE hook_appname='wiki’
AND hook_location='config_validate’
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: INSERT INTO egw_hooks
(hook_filename,hook_appname,hook_location) VALUES
(‘hook_config_validate.inc.php’,‘wiki’,‘config_validate’)
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: SELECT count() FROM egw_hooks WHERE hook_appname='wiki’
AND hook_location='settings’
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: INSERT INTO egw_hooks
(hook_filename,hook_appname,hook_location) VALUES
(‘wiki_hooks::settings’,‘wiki’,‘settings’)
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: SELECT count() FROM egw_hooks WHERE hook_appname='wiki’
AND hook_location='search_link’
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: INSERT INTO egw_hooks
(hook_filename,hook_appname,hook_location) VALUES
(‘wiki_hooks::search_link’,‘wiki’,‘search_link’)
ERROR: current transaction is aborted, commands ignored until end of
transaction block
STATEMENT: SELECT config_value FROM egw_config WHERE
config_app=‘phpgwapi’ AND config_name=‘temp_dir’
–
Anthony - http://messinet.com - http://messinet.com/~amessina/gallery
8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E
