OpenSIS安装错误

Question

In step 2 of the OpenSIS installation I face with this 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 '(0) , start_date date, end_date date, published_profiles characte' at line 9

What can I do?

Answer 1

http://forums.mysql.com/read.php?10,494735,494845#msg-494845

Removing the "(0)" from "Timestamp (0)" fixed the problem.

Thank you.

Look for:

CREATE TABLE PORTAL_NOTES( 

id NUMERIC NOT NULL , 
school_id NUMERIC, 
syear NUMERIC( 4, 0 ) , 
title CHARACTER VARYING( 255 ) , 
content CHARACTER VARYING( 5000 ) , 
sort_order NUMERIC, 
published_user NUMERIC, 
published_dateTIMESTAMP( 0 ) , 
start_date DATE, 
end_date DATE, 
published_profiles CHARACTER VARYING( 255 ) 
);