sql syntax error

2004-04-20 Thread Aaron P. Martinez
I'm using amavisd-new -20030616p9, RH 3.0 ES and mysql 3.23.58-1 trying to do sql lookups for user prefs. I've done this before and have compared my sql statements and can't figure out the problem. When i start amavisd-new with the debug switch, here's what i get: # /usr/local/sbin/amavisd

Please help with check syntax

2004-01-29 Thread Aaron P. Martinez
I am trying to set up a table from a script that came with some software Value accounting/CRM and i'm getting a few errors, one of which i can't seem to figure out/fix. My system is RH 3.0 ES with mysql-server-3.23.58-1. I have innodb tables configured with the following statement in my

upgraded, now nulls act differently

2003-10-03 Thread Aaron P. Martinez
I am running RH 2.1 ES, i recently upgraded to 3.23.56-1.72. I am using mysql as a backend for postfix MTA. I use webmin to add new users to my database. Today, after upgrading, there was a distinct problem. I added a user, left a field blank, it was the relocate_to feild, which unless i put

can you do this? mysql backend question

2003-06-03 Thread Aaron P. Martinez
i have redhat e. v2.1 mysql v. 3.23.54a-3.72, postfix 2.0.10, courier-1.7.3 and amavisd-new (newest version) and i'm successfully running mysql as the backend for both. My question is this: all of the data for the above programs is all stored in a bunch of different tables. aliases_this,