innodb i spamassassin

Thread View: pl.comp.bazy-danych

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by K Sat, 31 Jan 2015 00:05

#194230

Author: K
Date: Sat, 31 Jan 2015 00:05

41 lines
2175 bytes

witam,
probuje utworzyc tabele dla spamassassina ze zrodla, jednak:

MariaDB [spamassassin]> source spamassassin-db.sql;
ERROR 1064 (42000) at line 1 in file: 'spamassassin-db.sql': You have an 
error in your SQL syntax; check the manual that corresponds to your 
MariaDB server version for the right syntax to use near 'TYPE=InnoDB' at 
line 9
...
ERROR 1064 (42000) at line 51 in file: 'spamassassin-db.sql': You have 
an error in your SQL syntax; check the manual that corresponds to your 
MariaDB server version for the right syntax to use near 'TYPE=InnoDB' at 
line 14

odkomentowalem w skrypcie startowym:
# Uncomment the next line to use Oracle's InnoDB plugin instead of the 
included XtraDB
INNODB="--ignore-builtin-innodb --plugin-load=innodb=ha_innodb.so"

oraz:
MariaDB [spamassassin]> SHOW VARIABLES LIKE 'have_innodb';
+---------------+-------+
| Variable_name | Value |
+---------------+-------+
| have_innodb   | YES   |
+---------------+-------+
1 row in set (0.00 sec)

samo zrodlo dla np awl, wyglada tak:
CREATE TABLE awl (
   username varchar(100) NOT NULL default '',
   email varchar(255) NOT NULL default '',
   ip varchar(40) NOT NULL default '',
   count int(11) NOT NULL default '0',
   totscore float NOT NULL default '0',
   signedby varchar(255) NOT NULL default '',
   PRIMARY KEY (username,email,signedby,ip)
) TYPE=InnoDB;


co jest nie tak?

Re: innodb i spamassassin

#194231

Author: K
Date: Sat, 31 Jan 2015 11:03

12 lines
1369 bytes

On 31/01/2015 00:05, K wrote:
> witam,
> probuje utworzyc tabele dla spamassassina ze zrodla, jednak:
>
> MariaDB [spamassassin]> source spamassassin-db.sql;
> ERROR 1064 (42000) at line 1 in file: 'spamassassin-db.sql': You have an
> error in your SQL syntax; check the manual that corresponds to your
> MariaDB server version for the right syntax to use near 'TYPE=InnoDB' at
> line 9

wystarczylo zmienic TYPE=InnoDB na ENGINE=InnoDB. napisalem wystarczylo 
bo udalo sie zaladowac tabele, a czy bedzie to dzialac to sie dopiero okaze.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads