Elxis CMS Forum

Support => Database => Topic started by: forgetms on November 10, 2010, 10:58:12

Title: Error with 2009.2 with PostgreSQL (2)
Post by: forgetms on November 10, 2010, 10:58:12

Hi!

When I was trying to link autonomous page to main menu, I got the following error:

Mosmenu:store

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 ( 'mainmenu','Contact Us','index.php?option=com_content&task=view&id=10','content_typed','1','10','0','9999','0','29','menu_image=-1
   menu_image_only=0','chinese_traditional' )

Regards,
CN

Title: Re: Error with 2009.2 with PostgreSQL (2)
Post by: rentasite on November 11, 2010, 08:00:46

someone merge this topic with this http://bit.ly/axBbfH plz  ::)

Title: Re: Error with 2009.2 with PostgreSQL (2)
Post by: datahell on November 11, 2010, 08:18:08

Elxis 2009.2 is not 100% compatible to postgreSQL. I suggest you to use mysql for now.
Elxis will become again fully compatible with postgreSQL on version 2011.0.

Title: Re: Error with 2009.2 with PostgreSQL (2)
Post by: forgetms on November 12, 2010, 10:47:02

Quote from: datahell on November 11, 2010, 08:18:08

Elxis 2009.2 is not 100% compatible to postgreSQL. I suggest you to use mysql for now.
Elxis will become again fully compatible with postgreSQL on version 2011.0.

Thank you for the explanation!

Since I stick only to PostgreSQL and I can't wait for version 2011.0, I replaced all "GROUP BY" with "ORDER BY". Now the annoying errors are gone although I do not know what side effects will be resulted. ::)