Can't create table 'mojoportal.mp

Can't create table 'mojoportal.mp_sites' (errno: 150)

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.

12/11/2008 1:35:58 PM

Walter

Total Posts 13

View Posts

Can't create table 'mojoportal.mp_sites' (errno: 150)

Hi Joe,
I'm experiencing some problems with a new installation of mojoportal. I'm sure it is not a bug but maybe a trivial problem that I'm not able to solve at the moment. I know you are very busy, but if you could give a quick look to what I wrote below perhaps you would be able to address me to the right way or to give me some hints.

Recently I started a new project from scratch by downloading revision n. 4548 from SVN. I opted for MySql as DB and according to your suggestions in the documentation I created an empty DB and an user with full permissions to this DB and put the string connection in a user.config file.

Starting the web site, after a while I see the following message on the web page:

Probing system...
File system permissions ok.
MySQL database connection ok.
database permissions are sufficient to alter schema.
database initial schema needs to be created.
Running script mojoportal-core - 2.2.7.8 - 00:00:00.1560000
MySql.Data.MySqlClient.MySqlException: Can't create table 'mojoportal.mp_sites' (errno: 150) in MySql.Data.MySqlClient.MySqlStream.OpenPacket() in MySql.Data.MySqlClient.NativeDriver.ReadResult(UInt64& affectedRows, Int64& lastInsertId) in .... [...]

I tried various workarounds in order to skip the problem unsuccessfully; for instance I tried to put the content of 2.2.7.8 file in an SQL file and imported it directly into the MySQL DB, it worked well but when I tried afterwards to start the site another message said me that the setup wasn't able to duplicate another table because it was already there.

I'm quite sure it does not depend from the DB user right because if I erase the content of the 2.2.7.8 config file and I put a very simply SQL statement like "CREATE TABLE pippo..." the table pippo will be created.

My environment actually is the following:

Windows Vista (I'm using an administrator user with UAC disabled... I know.. I'm a bad boy..)
VS Studio 2008
MySQL version 5.1.30-community
IIS 7

many thanks in advance

ciao
Walter

12/11/2008 2:17:31 PM

Joe Audette

Total Posts 18439

View Posts

Re: Can't create table 'mojoportal.mp_sites' (errno: 150)

Hi Walter,

MySql 5.1 just came out as an official release. Several times while it was in beta and release candidate mode people reported problems like this. I never reported it to them but hoped they would have it fixed before the final release. Possibly you could check if there is a newer version of the MySql connector for .NET and maybe that will fix it and maybe not, but the easiest thing would be to uninstall MySql 5.1 and install 5.0. I am pretty sure that will solve it.

Best,

Joe

12/11/2008 4:01:13 PM

Walter

Total Posts 13

View Posts

Re: Can't create table 'mojoportal.mp_sites' (errno: 150)

Ok,
I installed MySql release 5.067 and now the site is working :-)
previously I also tried a more recent version of MySql connector without success.

It seems that MySql 5.1 release is too young at the moment :-(

many thanks Joe

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