MAILBEE POP3 SMTP WEBMAIL IMAP4 POP IMAP EMAIL COMPONENT VB ASP ACTIVEX COM VBA OCX NET .NET C# VB.NET ASP.NET DOWNLOAD QUEUE SSL SECURITY CENSOR ACCESS PARSER C++ DLL CONTROL LIBRARY MIME INTERFACE

AfterLogic WebMail Lite 7

AfterLogic Forum : AfterLogic WebMail Lite 7

Topic: Upgrading from v.7.4 to v.7.5

Author

Message

<< Prev Topic | Next Topic >>

webdbase2
Valued Community Member

Joined: 25 March 2015
Location: Bulgaria
Online Status: Offline
Posts: 81

Posted: 26 March 2015 at 12:40pm \| IP Logged

Code:

1054

Unknown column 'social_email' in 'field list' [42S22]

So I cannot use the old DB without modifications?
http://www.afterlogic.com/wiki/Upgrading_instructions_(WebMail_Lite) says:

Quote:

5. WebMail Lite should get all the settings from the previous WebMail Lite installation, you just need to update WebMail Lite database format by clicking "Update Tables" button in Database Settings screen.

There is no "Update Tables" button in Database Settings screen.
There is a "Create Database Tables" checkbox. It comes pre-checked.
If checked, there is a red message "The data tables already exist. To proceed, specify another prefix or delete the existing tables."
If not checked, the installation process goes smoothly to the end, but there still is no column 'social_email'.

EDIT

Code:

ALTER TABLE `awm_accounts` ADD `social_email` VARCHAR( 255 ) NOT NULL ;

Nice, isn't it?

Code:

1054

Unknown column 'def_identity' in 'field list' [42S22]

I was waiting for that one! Since changelog.txt says
[+] Default identity setting

And here comes the other one

Code:

ALTER TABLE `awm_identities` ADD `def_identity` BOOLEAN NOT NULL DEFAULT FALSE AFTER `id_acct` ;

webdbase2
Valued Community Member

Joined: 25 March 2015
Location: Bulgaria
Online Status: Offline
Posts: 81

Posted: 26 March 2015 at 2:51pm \| IP Logged

Then I followed my own instructions to restore sound notifications, and guess what?

I found a little mistake, which is corrected now.
It's good I wrote them down, so I could follow them later.

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

Printable version

Forum Jump

.NET Components

ActiveX Components

Web scripts

Solutions

AfterLogic WebMail Lite 7