18-10-2011, 17:17
Instaluje teraz system newsow Axel News Engine. Stworzylem baze mysql i zminilem chmody. ale jak juz chce zakonczyc instalacje pojawia sie blad ze stworzyl czesc tabelek w bazie a czesc nie
news1_user - Table successfully created
news1_groups - Table successfully created
news1_avatar - Table successfully created
a tutaj ten blad:
Query fatal error:
Query: CREATE TABLE news1_news ( newsid int(11) NOT NULL auto_increment, headline text NOT NULL, hometext text NOT NULL, newstext text NOT NULL, catid int(11) NOT NULL default '0', published int(1) NOT NULL default '0', comments_allowed int(1) NOT NULL default '0', newsdate int(11) NOT NULL default '0', news_enddate int(11) default NULL, pic_n int(1) NOT NULL default '0', pic_name varchar(255) NOT NULL default '', userid varchar(255) NOT NULL default '', news_links int(1) NOT NULL default '0', reads int(3) NOT NULL default '0', PRIMARY KEY (newsid), KEY catid (catid), KEY userid (userid) )
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 'reads int(3) NOT NULL default '0', PRIMARY KEY (newsid), KEY catid (c' at line 15
gdy chce to stworzyc bezposrednio przez baze to wyskakuje:
#1064 - 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 'reads int(3) NOT NULL default '0', PRIMARY KEY (newsid), KEY catid (catid), KEY ' at line 1
jak to zrobic zeby to dzialalo i stworzylo brakujace tabele?
news1_user - Table successfully created
news1_groups - Table successfully created
news1_avatar - Table successfully created
a tutaj ten blad:
Query fatal error:
Query: CREATE TABLE news1_news ( newsid int(11) NOT NULL auto_increment, headline text NOT NULL, hometext text NOT NULL, newstext text NOT NULL, catid int(11) NOT NULL default '0', published int(1) NOT NULL default '0', comments_allowed int(1) NOT NULL default '0', newsdate int(11) NOT NULL default '0', news_enddate int(11) default NULL, pic_n int(1) NOT NULL default '0', pic_name varchar(255) NOT NULL default '', userid varchar(255) NOT NULL default '', news_links int(1) NOT NULL default '0', reads int(3) NOT NULL default '0', PRIMARY KEY (newsid), KEY catid (catid), KEY userid (userid) )
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 'reads int(3) NOT NULL default '0', PRIMARY KEY (newsid), KEY catid (c' at line 15
gdy chce to stworzyc bezposrednio przez baze to wyskakuje:
#1064 - 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 'reads int(3) NOT NULL default '0', PRIMARY KEY (newsid), KEY catid (catid), KEY ' at line 1
jak to zrobic zeby to dzialalo i stworzylo brakujace tabele?