[Netarchivesuite-users] Exampleconfigurationforasingle-sitesetup

[Søren Vejrup Carlsen]

That is interesting.

I can create a fresh database perfectly using Mysql 5.0.27!

Can you send me your modified script, so I can test it locally.

 

/Søren

 

Fra: netarchivesuite-users-bounces at lists.gforge.statsbiblioteket.dk [mailto:netarchivesuite-users-bounces at lists.gforge.statsbiblioteket.dk] På vegne af nicolas.giraud at bnf.fr
Sendt: 4. marts 2009 16:47
Til: netarchivesuite-users at lists.gforge.statsbiblioteket.dk
Emne: Re: [Netarchivesuite-users] Exampleconfigurationforasingle-sitesetup

 


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://lists.gforge.statsbiblioteket.dk/pipermail/netarchivesuite-users/attachments/20090304/4ce516f5/attachment-0001.html