[Netarchivesuite-users] Example configurationforasingle-sitesetup

[nicolas.giraud at bnf.fr]

Hi,

Yes I am using the correct script, but I have modified the schema name, ie 
replace 'fullhddb' by 'netarchivesuite'. I have created a netarchivesuite 
schema and a user with full privileges on that schema.  I am using MySQL 
5.0.67, and executing the script in SQuirreL SQL client. I use the 
supplied JDBC connector, and I am connected as netarchivesuite on the 
netarchivesuite database schema (URL is 
jdbc:mysql://localhost:3306/netarchivesuite?autoReconnect=true): 

The error occurs when creating the second table 'domains'. Here is the 
full trace : 

Warning:   You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use near 
'domain_id bigint not null primary key AUTO_INCREMENT,
    name varchar(300) not ' at line 2
SQLState:  42000
ErrorCode: 1064

Query 1 of 56 elapsed time (seconds) - Total: 0.001, SQL query: 0.001, 
Building output: 0
Warning:   You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use near 
'domain_id bigint not null primary key AUTO_INCREMENT,
    name varchar(300) not ' at line 2
SQLState:  42000
ErrorCode: 1064

Query 2 of 56 elapsed time (seconds) - Total: 0.001, SQL query: 0.001, 
Building output: 0
Warning:   Table 'schemaversions' already exists
SQLState:  42S01
ErrorCode: 1050

Query 3 of 56 elapsed time (seconds) - Total: 0.001, SQL query: 0.001, 
Building output: 0
1 Row(s) Inserted
Query 4 of 56 elapsed time (seconds) - Total: 0.002, SQL query: 0.002, 
Building output: 0
1 Row(s) Inserted
Query 5 of 56 elapsed time (seconds) - Total: 0.008, SQL query: 0.008, 
Building output: 0
1 Row(s) Inserted
Query 6 of 56 elapsed time (seconds) - Total: 0.002, SQL query: 0.002, 
Building output: 0
1 Row(s) Inserted
Query 7 of 56 elapsed time (seconds) - Total: 0.002, SQL query: 0.002, 
Building output: 0
1 Row(s) Inserted
Query 8 of 56 elapsed time (seconds) - Total: 0.005, SQL query: 0.005, 
Building output: 0
1 Row(s) Inserted
Query 9 of 56 elapsed time (seconds) - Total: 0.008, SQL query: 0.008, 
Building output: 0
1 Row(s) Inserted
Query 10 of 56 elapsed time (seconds) - Total: 0.001, SQL query: 0.001, 
Building output: 0
1 Row(s) Inserted
Query 11 of 56 elapsed time (seconds) - Total: 0.004, SQL query: 0.004, 
Building output: 0
1 Row(s) Inserted
Query 12 of 56 elapsed time (seconds) - Total: 0.002, SQL query: 0.002, 
Building output: 0
1 Row(s) Inserted
Query 13 of 56 elapsed time (seconds) - Total: 0.003, SQL query: 0.003, 
Building output: 0
1 Row(s) Inserted
Query 14 of 56 elapsed time (seconds) - Total: 0.005, SQL query: 0.005, 
Building output: 0
1 Row(s) Inserted
Query 15 of 56 elapsed time (seconds) - Total: 0.007, SQL query: 0.007, 
Building output: 0
1 Row(s) Inserted
Query 16 of 56 elapsed time (seconds) - Total: 0.002, SQL query: 0.002, 
Building output: 0
1 Row(s) Inserted
Query 17 of 56 elapsed time (seconds) - Total: 0.004, SQL query: 0.004, 
Building output: 0
1 Row(s) Inserted
Query 18 of 56 elapsed time (seconds) - Total: 0.007, SQL query: 0.007, 
Building output: 0
1 Row(s) Inserted
Query 19 of 56 elapsed time (seconds) - Total: 0.001, SQL query: 0.001, 
Building output: 0
Error: You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use near 
'domain_id bigint not null primary key AUTO_INCREMENT,
    name varchar(300) not ' at line 6
SQLState:  42000
ErrorCode: 1064
Error occured in:
# 
*****************************************************************************
# Area: Domains
# 
*****************************************************************************

# create table IF NOT EXISTS domains (
    domain_id bigint not null primary key AUTO_INCREMENT,
    name varchar(300) not null unique, 
    comments varchar(30000),
    defaultconfig bigint not null, 
    crawlertraps varchar(1000),
    edition bigint not null, 
    alias bigint, 
    lastaliasupdate datetime 
)
Press F3 to go to next result. Press Ctrl+Shift+F7 to toggle highlight 
search.




Avant d'imprimer, pensez à l'environnement. 
Consider the environment before printing this mail.   
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://ml.sbforge.org/pipermail/netarchivesuite-users/attachments/20090304/0c2d09cc/attachment-0002.html>