PostgreSQL error @ svn r34110

[Leithoff_Klaus]

Check the content of wiki_readable and wiki_writeable.
if it is still numbers only and the above mentioned columns are varchar columns should be updated using:
Be sure to use each/match numeric found in your columns in your case statement.

UPDATE egw_wiki_pages SET wiki_readable = ( case wiki_readable WHEN ‘0’ THEN ‘,_0,’ WHEN ‘1’ THEN ‘,_1,’ WHEN ‘2’ THEN ‘,_2,’ END);
UPDATE egw_wiki_pages SET wiki_writable = ( case wiki_writable WHEN ‘0’ THEN ‘,_0,’ WHEN ‘1’ THEN ‘,_1,’ WHEN ‘2’ THEN ‘,_2,’ END);

[Anthony_Messina]

Check the content of wiki_readable and wiki_writeable.
if it is still numbers only and the above mentioned columns are varchar columns should be updated using:
Be sure to use each/match numeric found in your columns in your case statement.

UPDATE egw_wiki_pages SET wiki_readable = ( case wiki_readable WHEN ‘0’ THEN ‘,_0,’ WHEN ‘1’ THEN ‘,_1,’ WHEN ‘2’ THEN ‘,_2,’ END);
UPDATE egw_wiki_pages SET wiki_writable = ( case wiki_writable WHEN ‘0’ THEN ‘,_0,’ WHEN ‘1’ THEN ‘,_1,’ WHEN ‘2’ THEN ‘,_2,’ END);

Thank you Klaus. While I couldn’t get the ‘case’ statement to work, I
was able to update the values, and now the Wiki is working properly.

I do appreciate the help. Thank you all very much. -A

–
Anthony - http://messinet.com - http://messinet.com/~amessina/gallery
8F89 5E72 8DF0 BCF0 10BE 9967 92DC 35DC B001 4A4E