* This is the modus mailing list * Peter,
Thank you. I found the schema at the Add-on and added the two fields and it's ok now. http://www.vircom.com/downloads/others/Modus3ExtendedDB.zip -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Lakanen Sent: Wednesday, November 12, 2003 12:37 PM To: [EMAIL PROTECTED] Subject: [Modus] Extended database problem after upgrade to Modus 3 * This is the modus mailing list * Adil: I haven't installed M3 yet, but I thought I remembered seeing this stuff covered in the list previously. In the original notice from Vircom there was this note: FOR EXTENDED DATABASE USERS: The new SQL script and Access DB are available in the add-on section, BUT BE CAREFUL: The new script DELETES the old tables and replaces it with the new one. IF YOU ARE UPGRADING, ONLY USE THE SQL SCRIPT AS A REFERENCE FOR ADDING NEW COLUMNS, DO NOT RUN THE SCRIPT. BACKUP YOUR TABLES FIRST. I'm guessing the new columsn are covered in there. Someone also posted this but I do not see a response to them: SCANSIEVELEVEL - We've had a few users opt-out of scanning for various reasons. Which field do we need to match this up with from previous releases so the customers are still "opted-out?" SCANSIEVELEVELCATEGORIES - From the docs, I assume if we default this to NULL we'll be ok to start with. Yes or No? Also I noticed a discrepancy between the docs and the sample script Vircom released. The script has 550 as the length and the docs has 255. Which should it be? Good luck! I'm going to bed - been up late. -peter Adil wrote: > * This is the modus mailing list * > > I have a working installation of Modusmail v2.1 using extended > database (SQL2000). Today I upgraded to version 3. After upgrade the > server is not authenticating users, I get the error "Logon Failed" for > POP3 access. When I go to the modus administrator and try to open user > properties, the following popup error is displayed: > > There is a problem opening the User(s). (0xE110FFFF) > > Invalid column name 'SCANSIEVELEVEL'. > Invalid column name 'SCANSIEVELEVELCATEGORIES' > Statement(s) could not be prepared. > State:S0022,Native:207,Origin:[Microsoft][ODBC SQL Server Driver][SQL > Server] > State:S0022,Native:207,Origin:[Microsoft][ODBC SQL Server Driver][SQL > Server] > State:37000,Native:8180,Origin:[Microsoft][ODBC SQL Server > Driver][SQL Server] > > I don't have those columns in my vopmail table, I scripted the table > and searched for them but couldn't find any. I also searched in the > schema that came along with modus 3.0 but there are no such columns. > What could be wrong? > > Thanks > > Adil A. Ahmed > > ** > To unsubscribe, send an Email to: [EMAIL PROTECTED] with the > word "UNSUBSCRIBE" in the body or subject line. > -- Peter Lakanen [EMAIL PROTECTED] Platinum Web Development http://www.platinumweb.com 1320 Terrace Street Tallahassee, FL 32303 850.508.4518 FAX: 850.681.1930 ** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line. ** To unsubscribe, send an Email to: [EMAIL PROTECTED] with the word "UNSUBSCRIBE" in the body or subject line.
