MySQLTalk.org

Tony · Guest

Tried installing the new beta 2 on the site and keep on getting
An Error Was Found

*Details: BLOB/TEXT column 'sup_to' can't have a default value*

when setting up eventum.

I'm currently running eventum 1.7.x on th same computer using mysql
database and thats working fine, would just love to give this beta a go
since the developers really fixed a lot of issues i'm havinging with 1.7.x.

Any help would be welcomed.

************************************************************************
This email is intended only for the use of the individual or entity
named above and may contain information that is confidential and
privileged. If you are not the intended recipient, you are hereby
notified that any dissemination, distribution or copying of this email
is strictly prohibited. Opinions, conclusions and other information in
this message that do not relate to the official business of our firm
shall be understood as neither given nor endorsed by it.
************************************************************************

Bryan Alsdorf · Guest

Hi,

Tony wrote:

Srivathsan, M IN BLR SIS · Guest

Hi Bryan,

I am also getting the same error (details below) on fresh install of
2.0.1 (just downloaded). The version of MySQL I have is "MySQL
5.0.27-community-nt via TCP/IP".

I even tried installing 1.7.1 and then upgrade to 2.0.1. I get a blank
page after clicking the "Perform Database changes" link (under
<eventum-url>/misc/v1.7.1_v2.0). I guess that this is also related to
the same error.

What is the solution? Please help.

Thanks and rgds,
Watson

-----Original Message-----
From: Bryan Alsdorf [mailto:bryan (AT) mysql (DOT) com]
Sent: Thursday, 22-Feb-2007 23:18
To: Tony
Cc: eventum-users (AT) lists (DOT) mysql.com
Subject: Re: beta 2.

Hi,

Tony wrote:

Srivathsan, M IN BLR SIS · Guest

Hi all,

I am having a working installation of 1.7.1. But while trying to do a
fresh install of 2.0.1, the setup fails - please refer to my earlier
posting below. While I could see that quite a few of you have got 2.x
up and running, I have not found any other posting with a solution for
this in the discussion list. Please help.

Thanks and rgds,
Watson

-----Original Message-----
From: Srivathsan, M IN BLR SISL [mailto:M.Srivathsan (AT) siemens (DOT) com]
Sent: Wednesday, 18-Apr-2007 10:05
To: Bryan Alsdorf
Cc: eventum-users (AT) lists (DOT) mysql.com
Subject: RE: beta 2.

Hi Bryan,

I am also getting the same error (details below) on fresh install of
2.0.1 (just downloaded). The version of MySQL I have is "MySQL
5.0.27-community-nt via TCP/IP".

I even tried installing 1.7.1 and then upgrade to 2.0.1. I get a blank
page after clicking the "Perform Database changes" link (under
<eventum-url>/misc/v1.7.1_v2.0). I guess that this is also related to
the same error.

What is the solution? Please help.

Thanks and rgds,
Watson

-----Original Message-----
From: Bryan Alsdorf [mailto:bryan (AT) mysql (DOT) com]
Sent: Thursday, 22-Feb-2007 23:18
To: Tony
Cc: eventum-users (AT) lists (DOT) mysql.com
Subject: Re: beta 2.

Hi,

Tony wrote:

Jostein Martinsen · Guest

I think the problem might be related to your version of MySQL.
Thats why Bryan asked you about which version you are using.

We have had some problems with declarations like "NOT NULL DEFAULT
NULL" in sql-statements (when creating or altering tables).
Maybe '' is treaded like null in your db...

Anyhow, I went trough the installer this morning without any problems
at all!
It's on MySQL server version: 5.0.38

On Mon, 23 Apr 2007 07:54:59 +0530
"Srivathsan, M IN BLR SISL" <M.Srivathsan (AT) siemens (DOT) com> wrote:

Srivathsan, M IN BLR SIS · Guest

Hi Jostein,

Thanks a lot for your email. Before I got it, I did the following:
1. Edited the <eventum-2.0.1>/setup/schema.sql and removed the "DEFAULT
''"
for the sup_to column (Line 428 in the file)
2. The setup went through fine but when I attempt the first login
(using admin (AT) example (DOT) com), I get a blank page

I have upgraded my MySQL to 5.0.37-nt community edition, just today. My
O/s is
WinXP SP2, with Apache 2.2.4 and PHP 5.2.1. Although the setup is
through,
(with my tweaking, ofcourse) I am not able to proceed beyond that.

I have to observe that the installation / upgradation was a breeze with
Versions 1.6.1, 1.7.0 and 1.7.1. 2.0.x is really irritating and
surprisingly I find the forum somewhat less responsive recently which is
quite
disappointing. Now I really appreciate Microsoft for their fantasitc
"setups".

Sorry for pouring my heart out but once again, Thanks for your help.

Thanks and rgds,
Watson

-----Original Message-----
From: Jostein Martinsen [mailto:jostein.martinsen (AT) redpill (DOT) se]
Sent: Monday, 23-Apr-2007 11:47
To: eventum-users (AT) lists (DOT) mysql.com
Subject: Re: Eventum 2.0.1 Installation failing

I think the problem might be related to your version of MySQL.
Thats why Bryan asked you about which version you are using.

We have had some problems with declarations like "NOT NULL DEFAULT NULL"
in sql-statements (when creating or altering tables).
Maybe '' is treaded like null in your db...

Anyhow, I went trough the installer this morning without any problems at
all!
It's on MySQL server version: 5.0.38

On Mon, 23 Apr 2007 07:54:59 +0530
"Srivathsan, M IN BLR SISL" <M.Srivathsan (AT) siemens (DOT) com> wrote:

Andrew Coghlan · Guest

This may help;

I upgraded our 1.7.1 installation this morning. It all seemed to go
smoothly, except that when I clicked on an issue I got a blank page.

I tracked it down to a clause on view.php where the system was looking for
whether or not we have the workflow integration; it was detecting that we
had workflow set on that project, and was then failing. In fact, whilst I
had toyed with workflow a couple of times, we do not have workflow set up on
the project.

I went into the administration screen, edited the project and without making
any changes, I saved the configuration as it was. This obviously overwrote
the workflow setting in the DB because everything started working properly
after that.

Andrew

-----Original Message-----
From: Srivathsan, M IN BLR SISL [mailto:M.Srivathsan (AT) siemens (DOT) com]
Sent: 23 April 2007 08:28
To: Jostein Martinsen; eventum-users (AT) lists (DOT) mysql.com
Subject: RE: Eventum 2.0.1 Installation failing

Hi Jostein,

Thanks a lot for your email. Before I got it, I did the following:
1. Edited the <eventum-2.0.1>/setup/schema.sql and removed the "DEFAULT
''"
for the sup_to column (Line 428 in the file)
2. The setup went through fine but when I attempt the first login
(using admin (AT) example (DOT) com), I get a blank page

I have upgraded my MySQL to 5.0.37-nt community edition, just today. My
O/s is
WinXP SP2, with Apache 2.2.4 and PHP 5.2.1. Although the setup is
through,
(with my tweaking, ofcourse) I am not able to proceed beyond that.

I have to observe that the installation / upgradation was a breeze with
Versions 1.6.1, 1.7.0 and 1.7.1. 2.0.x is really irritating and
surprisingly I find the forum somewhat less responsive recently which is
quite
disappointing. Now I really appreciate Microsoft for their fantasitc
"setups".

Sorry for pouring my heart out but once again, Thanks for your help.

Thanks and rgds,
Watson

-----Original Message-----
From: Jostein Martinsen [mailto:jostein.martinsen (AT) redpill (DOT) se]
Sent: Monday, 23-Apr-2007 11:47
To: eventum-users (AT) lists (DOT) mysql.com
Subject: Re: Eventum 2.0.1 Installation failing

I think the problem might be related to your version of MySQL.
Thats why Bryan asked you about which version you are using.

We have had some problems with declarations like "NOT NULL DEFAULT NULL"
in sql-statements (when creating or altering tables).
Maybe '' is treaded like null in your db...

Anyhow, I went trough the installer this morning without any problems at
all!
It's on MySQL server version: 5.0.38

On Mon, 23 Apr 2007 07:54:59 +0530
"Srivathsan, M IN BLR SISL" <M.Srivathsan (AT) siemens (DOT) com> wrote:

Stefano Rosanelli · Guest

Alle 04:24, lunedì 23 aprile 2007, Srivathsan, M IN BLR SISL ha scritto:

Srivathsan, M IN BLR SIS · Guest

Hi Andrew,

I tried a fresh install of 1.7.1 (successful) and tried upgrading to
2.0.1. I got a blank page while running the "Perform Database changes"
script. After that, I am not even getting the opening logon page.
Hence there is no way by which I could go to the Admin pages - atleast
to my knowledge.

Also, I have not attached any workflow to the only "Default" project
available in 1.7.1

Thanks and rgds,
Watson

-----Original Message-----
From: Andrew Coghlan [mailto:acoghlan (AT) churchworks (DOT) com]
Sent: Monday, 23-Apr-2007 16:08
To: eventum-users (AT) lists (DOT) mysql.com
Subject: RE: Eventum 2.0.1 Installation failing

This may help;

I upgraded our 1.7.1 installation this morning. It all seemed to go
smoothly, except that when I clicked on an issue I got a blank page.

I tracked it down to a clause on view.php where the system was looking
for whether or not we have the workflow integration; it was detecting
that we had workflow set on that project, and was then failing. In
fact, whilst I had toyed with workflow a couple of times, we do not have
workflow set up on the project.

I went into the administration screen, edited the project and without
making any changes, I saved the configuration as it was. This obviously
overwrote the workflow setting in the DB because everything started
working properly after that.

Andrew

-----Original Message-----
From: Srivathsan, M IN BLR SISL [mailto:M.Srivathsan (AT) siemens (DOT) com]
Sent: 23 April 2007 08:28
To: Jostein Martinsen; eventum-users (AT) lists (DOT) mysql.com
Subject: RE: Eventum 2.0.1 Installation failing

Hi Jostein,

Thanks a lot for your email. Before I got it, I did the following:
1. Edited the <eventum-2.0.1>/setup/schema.sql and removed the "DEFAULT
''"
for the sup_to column (Line 428 in the file) 2. The setup went
through fine but when I attempt the first login
(using admin (AT) example (DOT) com), I get a blank page

I have upgraded my MySQL to 5.0.37-nt community edition, just today. My
O/s is WinXP SP2, with Apache 2.2.4 and PHP 5.2.1. Although the setup
is through, (with my tweaking, ofcourse) I am not able to proceed beyond
that.

I have to observe that the installation / upgradation was a breeze with
Versions 1.6.1, 1.7.0 and 1.7.1. 2.0.x is really irritating and
surprisingly I find the forum somewhat less responsive recently which is
quite disappointing. Now I really appreciate Microsoft for their
fantasitc "setups".

Sorry for pouring my heart out but once again, Thanks for your help.

Thanks and rgds,
Watson

-----Original Message-----
From: Jostein Martinsen [mailto:jostein.martinsen (AT) redpill (DOT) se]
Sent: Monday, 23-Apr-2007 11:47
To: eventum-users (AT) lists (DOT) mysql.com
Subject: Re: Eventum 2.0.1 Installation failing

I think the problem might be related to your version of MySQL.
Thats why Bryan asked you about which version you are using.

We have had some problems with declarations like "NOT NULL DEFAULT NULL"
in sql-statements (when creating or altering tables).
Maybe '' is treaded like null in your db...

Anyhow, I went trough the installer this morning without any problems at
all!
It's on MySQL server version: 5.0.38

On Mon, 23 Apr 2007 07:54:59 +0530
"Srivathsan, M IN BLR SISL" <M.Srivathsan (AT) siemens (DOT) com> wrote:

Srivathsan, M IN BLR SIS · Guest

Hi Jostein,

I upgraded my MySQL DB to the latest 5.0.37-nt community edition. Still
no breakthrough.

Thanks and rgds,
Watson

-----Original Message-----
From: Jostein Martinsen [mailto:jostein.martinsen (AT) redpill (DOT) se]
Sent: Monday, 23-Apr-2007 11:47
To: eventum-users (AT) lists (DOT) mysql.com
Subject: Re: Eventum 2.0.1 Installation failing

I think the problem might be related to your version of MySQL.
Thats why Bryan asked you about which version you are using.

We have had some problems with declarations like "NOT NULL DEFAULT NULL"
in sql-statements (when creating or altering tables).
Maybe '' is treaded like null in your db...

Anyhow, I went trough the installer this morning without any problems at
all!
It's on MySQL server version: 5.0.38

On Mon, 23 Apr 2007 07:54:59 +0530
"Srivathsan, M IN BLR SISL" <M.Srivathsan (AT) siemens (DOT) com> wrote: