sql syntax error
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 debug Error in config file /etc/amavisd.conf: syntax error at /etc/amavisd.conf line 829, near ' ORDER BY users.priority DESC '; Here are the lines from my /etc/amavisd.conf file: $sql_select_policy = 'SELECT *,users.vuid FROM users,policy_names'. ' WHERE (users.policy=policy_names.id) AND (users.username IN (%k))'. ' ORDER BY users.priority DESC '; Please help! Thanks in advance, Aaron -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Please help with check syntax
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 /etc/my.cnf:
innodb_data_file_path = ibdata1:10M:autoextend
set-variable = innodb_buffer_pool_size=70M
set-variable = innodb_additional_mem_pool_size=10M
set-variable = innodb_log_file_size=20M
set-variable = innodb_log_buffer_size=8M
innodb_flush_log_at_trx_commit=1
The create table statement is below followed by the error.
create table ItemSalesTax (
STYPE integer not null primary key, /* STax Type */
SDESC varchar(35),
SPERC numeric(13,4) zerofill not null /* Percentage */
check(SPERC = 0),
SCONUM integer not null,
SYRNO integer not null,
SLEVEL varchar(4) not null, /* Access Control Level */
constraint staxlevel_ck
check (SLEVEL in ('READ','RW','DENY')),
constraint STax_fk foreign key (SCONUM, SYRNO)
references AccYear(ACONUM, AYEARNO)
);
ERROR 1064: You have an error in your SQL syntax near 'check(SPERC =
0),
SCONUM integer not null,
SYRNO i' at line 9
I am not great w/mysql but gradually learning. I have looked in the
online manual and can't find anything that helps.
I would really like to get this going as soon as possible to
evaluate...any and all help is GREATLY appreciated.
Thanks,
Aaron Martinez
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
upgraded, now nulls act differently
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 something there, i expect the field to be treated as null. Unfortunately when postfix checked the database, the new user had a relocated_to value, even though i left the field blank. The odd thing is..when i upgraded mysql, the null must have stuck from the upgrade, because the problem only presents itself when i add NEW users to the database. Any help as to how i can correct this? Thanks in advance, Aaron Martinez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
can you do this? mysql backend question
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, virtuals_that, vgid_another..etc... What i want to do, is create one table, for originalities sake lets call it master. In master, i want to have all of the fileds that are used in all of my lookup tables for postfix, corier and amavis as well as some 'non-lookup' customer contact info. I'm wondering if there is a way to make it, so that my lookup tables pull their data from the master table and update dynamically when the master has been modified. I'll admidt now, i did look through the manual and did a search on the website, but i was far from exhaustive in my search i'm sure. I'm not looking for someone to spell this out, rather just perhaps a pointer to a particular portion of some document that might explain this. Thanks in advance Aaron Martinez -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
