Bug (2): PostgreSQL 8

[forgetms]

Hitting "Save" gets the following error:

ERROR:  column "browserNav" of relation "menu" does not exist at character 98
STATEMENT:  INSERT INTO menu ( "menutype","name","link","type","published","componentid","parent","ordering","browserNav","access","params","language" ) VALUES ( 'topmenu','Contact Us','index.php?option=com_contact&task=view&contact_id=1','contact_item_link','1','1','0','9999','0','29','menu_image=-1
   menu_image_only=0
   pageclass_sfx=
   page_title=1
   header=','chinese_taiwan' )

[forgetms]

Removing the double quotes from column "browserNav" appears to fix the problem:

INSERT INTO menu ( "menutype","name","link","type","published","componentid","parent","ordering",browserNav,"access","params","language" ) VALUES (...)

I am unable to find the PHP code that builds this SQL :-(

PostgreSQL's manual states:

Quoting an identifier also makes it case-sensitive, whereas unquoted names are always folded to lower case. For example, the identifiers FOO, foo, and "foo" are considered the same by PostgreSQL, but "Foo" and "FOO" are different from these three and each other. (The folding of unquoted names to lower case in PostgreSQL is incompatible with the SQL standard, which says that unquoted names should be folded to upper case. Thus, foo should be equivalent to "FOO" not "foo" according to the standard. If you want to write portable applications you are advised to always quote a particular name or never quote it.)

[datahell]

includes/Core/elxis.php
The problem is with "browserNav".
Elxis 2009.1 has not been checked with postgreSQL. I advice you to use MySQL.
We will make Elxis again full postgreSQL compatible on version 2009.2.

[forgetms]

I have fell back to 2008.1 with PostgreSQL.

I have no idea if this bug is PostgreSQL specific. Pardon me if I should stop reporting PostgreSQL related bugs all together.

I hit "Remove" button in FrontPage Manager trying to delete an item, then I got this error from PostgreSQL:

Code:

ERROR:  null value in column "mask" violates not-null constraint
UPDATE content SET "title"='SEO PRO',"seotitle"='seo-pro',"introtext"='Feel the power of Elxis <strong>SEO PRO</strong>. Search engine friendly URLs where never so easy and powerful. Just enable SEO PRO, add the nessesary htaccess file to your root directory, stand back and enjoy! Elxis will do all the hard work for you.',"state"='1',"sectionid"='1',"mask"=NULL,"catid"='1',"created"='2008-07-04 20:25:19',"created_by"='62',"modified"='2008-07-04 20:25:19',"modified_by"='62',"checked_out"='0',"checked_out_time"='1979-12-19 00:00:00',"publish_up"='1979-12-19 00:00:00',"publish_down"='2060-01-01 00:00:00',"attribs"='pageclass_sfx=
textclass_sfx=
back_button=
item_title=1
link_titles=
introtext=1
section=0
section_link=0
category=0
category_link=0
rating=
author=
createdate=
modifydate=
pdf=
rtf=
print=
email=
keyref=',"version"='1',"parentid"='0',"ordering"='5',"metakey"='seo pro, search engine friendly, seo optimization, sef url',"metadesc"='Search engine friendly URLs with Elxis SEO PRO',"access"='29',"hits"='0',"language"='english' WHERE id='9'

[forgetms]

Another bug in 2008.1. After I select
MODULES -> SITE MUDLES -> Newsflash
I get this:

Code:

ERROR:  operator does not exist: integer = character varying at character 103
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.
STATEMENT:  SELECT c.id AS value, s.title||' / '||c.title AS text
FROM categories c
LEFT JOIN sections s ON s.id=c.section
WHERE c.published='1' AND s.scope='content'
ORDER BY c.title

The attachment shows the column data types of tables "categories" and "sections".

Regards,
CN