Data.pgsql error upgrading

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

Please do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.

This forum is for discussing mojoPortal development

This forum is only for questions or discussions about working with the mojoPortal source code in Visual Studio, obtaining the source code from the repository, developing custom features, etc. If your question is not along these lines this is not the right forum. Please try to post your question in the appropriate forum.

You can monitor commits to the repository from this page. We also recommend developers to subscribe to email notifications in the developer forum as occasionally important things are announced.

Before posting questions here you might want to review the developer documentation.

Do not post questions about design, CSS, or skinning here. Use the Help With Skins Forum for those questions.
This thread is closed to new posts. You must sign in to post in the forums.
2/12/2011 9:52:27 AM
Gravatar
Total Posts 70

Data.pgsql error upgrading

Hi Joe,

Long time no see !!! When upgrading today I got an error during setup. The problem was on dbPageSettings.cs (line 1022). There is a TAB (\t) on the SQL (between FROM and mp_pages). You need to close the bracket on line 1026 and also  remove the ";" on line 1028. The buggy SQL was: SELECT  Count(*) FROM\tmp_pages WHERE siteid = :siteid AND ((ispending = false) OR (includepending = true) ;

After the fix, the setup went as expected.

edit: includepending is not a field but a param. You are missing the ":" before it.

Regards !!

2/12/2011 12:30:30 PM
Gravatar
Total Posts 18439

Re: Data.pgsql error upgrading

Hi Bruno,

Thanks for the bug report. I've fixed this and patched the pgsql packages for the 2.3.6.2 release with a new mojoPortal.Data.dll that includes the fix.

The fix is also in the source code repository.

Best,

Joe

You must sign in to post in the forums. This thread is closed to new posts.