enterprise MySQL Create tables causes err
Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6059
Printed Date: 03 July 2025 at 3:24am
Topic: enterprise MySQL Create tables causes err
Posted By: hookjd
Subject: enterprise MySQL Create tables causes err
Date Posted: 06 May 2007 at 1:31am
|
I have just upgraded to enterprise edition and have attempted to run the Create / Check Database Tables command. I get many SQL errors. There are many different errors, but this is the first one: ******* Error:[MySQL][ODBC 3.51 Driver][mysqld-4.1.19-community-nt]BLOB/TEXT column 'email' used in key specification without a key length The others are less specific. I checked the tables and while they were created, they had no data in them at all. So I have reverted to Standard mode until I can understand how to address this problem. Is it possible to maybe get the raw SQL so I can see what might be causing this? Or do you have an idea of what it might be? |
Replies:
Posted By: WebGuyz
Date Posted: 06 May 2007 at 10:05am
|
MySQL has to be 5.x minimum. ------------- http://www.webguyz.net |
Posted By: hookjd
Date Posted: 06 May 2007 at 8:14pm
|
Thanks for the reply. I upgraded mysql to the latest stable 5 version and it appears that all tables were created successfully, but I still get a lot of errors and there isn't any data in my tables. Here's an error I am getting right now. Any ideas? ******* Error:[MySQL][ODBC 3.51 Driver][mysqld-5.0.37-community-nt]Can't create table '.\filter\#sql-e50_21.frm' (errno: 121) |
Posted By: LogSat
Date Posted: 06 May 2007 at 10:43pm
|
Can you try to delete the entire schema (database) and create a new one? It's possible you have leftover tables/constraints from the previous attempt, and SpamFilter is not able to create new objects over the existing ones.
------------- Roberto Franceschetti http://www.logsat.com" rel="nofollow - LogSat Software http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP |
Posted By: hookjd
Date Posted: 07 May 2007 at 12:59am
|
It looks like that did it. It certainly wasn't a seamless transition. I had to restart the app multiple times before it built the tables based on the text files that I have had in place for a long time. But it does seem to have done it all correctly and is now working. Thanks for the assistance and for the continued development of this great product. Cheers. |
Posted By: hookjd
Date Posted: 08 May 2007 at 1:19am
|
I have discovered a potential error in the transition to enterprise. I had my spf set to: neutral: pass softfail: pass hardfail: fail After the upgrade to enterprise, my spf filters were reversed. LIke this: neutral: fail softfail: fail hardfail: pass You might want to look into that. |
Posted By: vitalhosting
Date Posted: 07 September 2007 at 6:11pm
hookjk did you find a solution for this error? I got same error
|
hookjd wrote:Posted By: hookjd
Date Posted: 10 September 2007 at 1:47pm
| when I dumped the entire db schema as suggested by LogSat, the tables were rebuilt correctly the next time. |