About 3CreateStoredProcedures.sql in PostgreSQL 8.3.1

Post here for help with installing or upgrading mojoPortal pre-compiled release packages. When posting in this forum, please provide all relevant details. You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

Post here for help with installation of mojoPortal pre-compiled release packages

When posting in this forum, please try to provide as many relevant details as possible. Particularly the following:

  • What operating system were you running when the bug appeared?
  • What database platform is your site using?
  • What version of mojoPortal are you running?
  • What version of .NET do you use?
  • What steps are necessary to reproduce the issue? Compare expected results vs actual results.

You may also want to review the installation or upgrading documentation.

If you have questions about using the source code or working with mojoPortal in Visual Studio, please post in the Developer forum.

This thread is closed to new posts. You must sign in to post in the forums.
4/28/2008 9:23:24 AM
Romulo
Gravatar
Total Posts 146
View Posts

About 3CreateStoredProcedures.sql in PostgreSQL 8.3.1

Hi Joe!.

Do you know about any trouble about to run this script (3CreateStoredProcedures.sql) with PostgreSQl 8.3.1 on Linux (openSuse)?.

I get this message:

Query result with 1 rows discarded.

ERROR: operator does not exist: integer = character varying
LINE 10874: where mp_users.userid = $1
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.

********** Error **********

ERROR: operator does not exist: integer = character varying
SQL state: 42883
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Character: 234492

Thanks in advance.

(Have a nice day!)

 

 

4/28/2008 9:26:32 AM
Joe Audette
Gravatar
Total Posts 18439
View Posts

Re: About 3CreateStoredProcedures.sql in PostgreSQL 8.3.1

That is a legacy script. On a new install you don't run any scripts manually, those scripts are not needed and are ojnly presentto support upgrading of very old versions of mojoportal.

Start with a clean db, set the connection string and visit siteroot/Setup/Default.aspx and it will run the needed scripta automatically.

Joe

4/28/2008 9:33:54 AM
Romulo
Gravatar
Total Posts 146
View Posts

Re: About 3CreateStoredProcedures.sql in PostgreSQL 8.3.1

Ok!...

Thanks Joe!.

I will do that.

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