Hi Joe

I get latest verion(8.3) of postgreSql and install that on windows 2003.I create a new datadase and run run mojoportal with mojoPortal.Data.pgsql but the follwing error apears :

File system permissions ok.
pgsql database connection ok.
database permissions are sufficient to alter schema.
database initial schema needs to be created.
Running script mojoportal-core - 2.2.3.4 - 00:00:06.7343750
Npgsql.NpgsqlException: operator does not exist: integer = character varying Severity: ERROR Code: 42883 Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts. at Npgsql.NpgsqlConnector.CheckErrors() in C:\Users\JoeAudette\devprojects\mojoportal\joesandbox2\npgsql1-0\Npgsql\NpgsqlConnector.cs:line 359 at Npgsql.NpgsqlCommand.ExecuteCommand() in C:\Users\JoeAudette\devprojects\mojoportal\joesandbox2\npgsql1-0\Npgsql\NpgsqlCommand.cs:line 1479 at Npgsql.NpgsqlCommand.ExecuteNonQuery() in C:\Users\JoeAudette\devprojects\mojoportal\joesandbox2\npgsql1-0\Npgsql\NpgsqlCommand.cs:line 460 at mojoPortal.Data.NpgsqlHelper.ExecuteNonQuery(NpgsqlTransaction transaction, CommandType commandType, String commandText, NpgsqlParameter[] commandParameters) in E:\MyProjects\Portals\SamarPortal\mojoPortal.Data.pgsql\NpgsqlHelper.cs:line 426 at mojoPortal.Data.NpgsqlHelper.ExecuteNonQuery(NpgsqlTransaction transaction, CommandType commandType, String commandText) in E:\MyProjects\Portals\SamarPortal\mojoPortal.Data.pgsql\NpgsqlHelper.cs:line 399 at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(String script, String overrideConnectionInfo) in E:\MyProjects\Portals\SamarPortal\mojoPortal.Data.pgsql\dbPortal.cs:line 739 at mojoPortal.Data.DBPortal.DatabaseHelperRunScript(FileInfo scriptFile, String overrideConnectionInfo) in E:\MyProjects\Portals\SamarPortal\mojoPortal.Data.pgsql\dbPortal.cs:line 701 at mojoPortal.Business.DatabaseHelper.RunScript(Guid applicationId, FileInfo scriptFile, String overrideConnectionInfo) in E:\MyProjects\Portals\SamarPortal\mojoPortal.Business\DatabaseHelper.cs:line 313 - 00:03:14.6250000
Note: This page shows some information that is helpful during setup and upgrades but for security it would be best not to show any information when the system is up to date. You can disable setup and suppress all information on this page by setting DisableSetup=true in Web.config. When you need to upgrade, you can set this back to false. If you are logged in as Administrator setup will run and you will be able to see this page even if it is disabled in Web.config so you can easily leave it disabled and just login before upgrading. But if you are not logged in you will need to enable setup in Web.config.

thanks for your helps.

I have the same problem. The language is installed but I have the same error.

Executing the script step by step (folder lagacysql) I have noticed that the error

occur into the script StoredProcedure, and start at the

function  mp_sitepersonalizationperuser_countbyuserpathsince  .... and all

the script were roolbacked.

All the function scripts that I execute before this function are ok.

Where is the problem?????

Thanks

We have discover an error in core script and in all updating sql scripts.

The error is linked to the use of field   "mp_users.userid"   in some function.

This filed is an INTEGER FIELD ... but in some function this field was compared with

a VARCHAR variable .... And this generate the "CAST  bla bla bla ...." error.

 We have patch these scripts ... casting in this manner

    cast(mp_users.userid as VARCHAR) = $1

where $1 was a VARCHAR(36) variable

It's correct?   but it's possible to have the correct script?

Thanks

Hi Joe

Please send this script to me too.

Thanks for help.