Support > Database

Error with 2009.2 with PostgreSQL (2)

(1/1)

forgetms:
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

rentasite:

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

datahell:
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.

forgetms:

--- 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.

--- End quote ---

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. ::)

Navigation

[0] Message Index