Hi,

I accidentally upgraded to master instead of latest 3.1 ;-) anyway I got the following error:
---
Dec 05 21:25:31 HiveTwoB dbmail-imapd[28770]: [0x7f447dc16000] Notice:[server] server_run(+776): starting main service loop for [IMAP] Dec 05 21:25:31 HiveTwoB dbmail-imapd[28770]: [0x7f447dc16000] Error:[db] check_upgrade_step(+920): SQLException: Dec 05 21:25:31 HiveTwoB dbmail-imapd[28770]: [0x7f447dc16000] Error:[db] check_upgrade_step(+920): SQLException: Dec 05 21:25:31 HiveTwoB dbmail-imapd[28770]: [0x7f447dc16000] Error:[db] db_exec(+388): SQLException: Commands out of sync; you can't run this command now Dec 05 21:25:31 HiveTwoB dbmail-imapd[28770]: [0x7f447dc16000] Error:[db] db_exec(+389): failed query [
BEGIN;
DROP VIEW IF EXISTS dbmail_subjectfield;
CREATE VIEW dbmail_subjectfield AS
   SELECT physmessage_id, headervalue AS subjectfield, sortfield
   FROM dbmail_messages m
   JOIN dbmail_header h USING (physmessage_id)
   JOIN dbmail_headername n ON h.headername_id = n.id
   JOIN dbmail_headervalue v ON h.headervalue_id = v.id
WHERE n.headername = 'subject';

INSERT INTO dbmail_upgrade_steps (from_version, to_version, applied) values (32001, 32002, now());
COMMIT;

]
Dec 05 21:25:31 HiveTwoB dbmail-imapd[28770]: [0x7f447dc16000] Warning:[db] db_check_version(+1033): Schema version incompatible [-1]. Bailing out Dec 05 21:25:31 HiveTwoB dbmail-imapd[28770]: [0x7f447dc16000] Error:[server] server_run(+780): could not connect to database Dec 05 21:26:53 HiveTwoB dbmail-imapd[28842]: [0x7f9476016000] Notice:[server] server_run(+776): starting main service loop for [IMAP] Dec 05 21:26:54 HiveTwoB dbmail-imapd[28842]: [0x7f9476016000] Error:[db] check_upgrade_step(+920): SQLException: Dec 05 21:26:54 HiveTwoB dbmail-imapd[28842]: [0x7f9476016000] Error:[db] db_exec(+388): SQLException: Commands out of sync; you can't run this command now Dec 05 21:26:54 HiveTwoB dbmail-imapd[28842]: [0x7f9476016000] Error:[db] db_exec(+389): failed query [
BEGIN;
ALTER TABLE dbmail_users ADD COLUMN spasswd VARCHAR(130) DEFAULT '' NOT NULL;
ALTER TABLE dbmail_users ADD COLUMN saction SMALLINT DEFAULT '0' NOT NULL;
ALTER TABLE dbmail_users ADD COLUMN active SMALLINT DEFAULT '1' NOT NULL;

INSERT INTO dbmail_upgrade_steps (from_version, to_version, applied) values (32001, 32004, now());
COMMIT;
]
Dec 05 21:26:54 HiveTwoB dbmail-imapd[28842]: [0x7f9476016000] Warning:[db] db_check_version(+1033): Schema version incompatible [-1]. Bailing out Dec 05 21:26:54 HiveTwoB dbmail-imapd[28842]: [0x7f9476016000] Error:[server] server_run(+780): could not connect to database Dec 05 21:27:48 HiveTwoB dbmail-imapd[28879]: [0x7f6138816000] Notice:[server] server_run(+776): starting main service loop for [IMAP] Dec 05 21:27:48 HiveTwoB dbmail-imapd[28879]: [0x7f6138816000] Notice:[server] server_run(+790): starting main service loop for [IMAP]
---

Maybe my tables have different indexes but it should not be a problem for these changes

--
Harald Leithner

ITronic
Wiedner Hauptstraße 120-124/5.1, 1050 Wien, Austria
Tel: +43-1-545 0 604
Fax: +43-1-786 23 88 26
Mobil: +43-699-123 78 4 78
Mail: [email protected] | itronic.at
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail

Reply via email to