Perhaps stupid question ...
I try to upgrade the port with portupgrade ... and i get

bash-2.05b# portupgrade -b -r -i dbmail-mysql
--->  Session started at: Thu, 15 Sep 2005 12:32:27 -0300
** No need to upgrade 'dbmail-mysql-2.0.4_1' (>= dbmail-mysql-2.0.4_1). (specify -f to force)
--->  Listing the results (+:done / -:ignored / *:skipped / !:failed)
       - mail/dbmail (dbmail-mysql-2.0.4_1)
--->  Packages processed: 0 done, 1 ignored, 0 skipped and 0 failed
--->  Session ended at: Thu, 15 Sep 2005 12:32:28 -0300 (consumed 00:00:01)

its ok ? ..

Steven Lynn wrote:

That is what I had figured on. I was just wondering cause I ran the
script and got that error...

Thank you.

On Wed, 2005-09-14 at 08:46 +0200, Paul J Stevens wrote:
Steven,

The create script has been running virtually unchanged since 2.0.0

This is very likely something specific to mysql-5.

Steven Lynn wrote:
Has anybody run the mysql_create_innodb.sql script on MySQL 5?

I get an error on:

CREATE TABLE dbmail_pbsp (
  idnr bigint(21) NOT NULL auto_increment,
  since datetime default '0' not null,
  ipnumber varchar(40) NOT NULL,
  PRIMARY KEY (idnr),
  UNIQUE INDEX ipnumber_index (ipnumber),
  INDEX since_index (since)
) TYPE=InnoDB;

Column 'since' has the wrong default value for datetime... If someone
has run on mysql 4.x and has had no problems, let me know and I will
stop talking. ;)

--
Steven Lynn
   [EMAIL PROTECTED]

Paul J Stevens wrote:


Dbmail 2.0.7 released

This is a bugfix release only.

* Removed all unsafe code from the signal handlers. This should
mostly benefit FreeBSD users which may have suffered from unreliable
behaviour in the process pool code.
* Added 'ON UPDATE CASCADE' to all foreign key restraints in the
MySQL (InnoDB) and Postgresql create_table files.
* POP3 AUTH command no longer returns list of supported
authentication mechanisms when issued without arguments.


_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail


------------------------------------------------------------------------

_______________________________________________
Dbmail mailing list
Dbmail@dbmail.org
https://mailman.fastxs.nl/mailman/listinfo/dbmail

Reply via email to