Home N-13 News Forums Help Search
RegisterForgot password?
How to add image to post necklacesdiscou
Known bugs - 4.0.3 necklacesdiscou

Latest N-13 News 4.0.3

What is N-13 News?
Where can I get help?
Known bugs

Forums Help & Support Problem with installation
Dla86
Posted on 23 Feb 2011, 13:47:27

Access: Member
Total Posts: 21
Joined: 2011-02-10

Hi,
I'm trying to install on line N-13 News, but to the step3 I receive these errors, and many others...

Code:
Error: You have an error in your SQL syntax near '; ' at line 7
Statement: DROP TABLE IF EXISTS `news_access`;
Arguments:

Array
(
)

,Error: You have an error in your SQL syntax near '; ' at line 15
Statement: CREATE TABLE `news_access` ( `name` text NOT NULL, `accounts` int(11) NOT NULL default '0', `accesslevels` int(11) NOT NULL default '0', `sysconfig` int(11) NOT NULL default '0', `newscats` int(11) NOT NULL default '0', `templates` int(11) NOT NULL default '0', `smilies` int(11) NOT NULL default '0', `wordfilters` int(11) NOT NULL default '0', `bannedips` int(11) NOT NULL default '0', `accesslevel` int(11) NOT NULL default '0', `uid` int(11) NOT NULL auto_increment, PRIMARY KEY (`uid`) );
Arguments:

Array
(
)

,Error: You have an error in your SQL syntax near '; ' at line 6
Statement: INSERT INTO `news_access` (`name`, `accounts`, `accesslevels`, `sysconfig`, `newscats`, `templates`, `smilies`, `wordfilters`, `bannedips`, `accesslevel`, `uid`) VALUES ('Gods', 1, 1, 1, 1, 1, 1, 1, 1, 3, 1), ('Mods', 0, 0, 0, 0, 0, 0, 0, 0, 2, 2), ('Members', 0, 0, 0, 0, 0, 0, 0, 0, 1, 3);
Arguments:

Array
(
)

,Error: You have an error in your SQL syntax near '; ' at line 4
Statement: DROP TABLE IF EXISTS `news_cats`;
Arguments:

Array
(
)

,Error: You have an error in your SQL syntax near 'ENGINE=MyISAM DEFAULT CHARSET=latin1; ' at line 5
Statement: CREATE TABLE `news_cats` ( `name` varchar(255) default NULL, `id` int(11) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
Arguments:

Array
(
)

,Error: You have an error in your SQL syntax near '; ' at line 4
Statement: INSERT INTO `news_cats` (`name`, `id`) VALUES ('', 0);
Arguments:

Array
(
)


Why? What I could do? thanks!
#3228
Dla86
Posted on 23 Feb 2011, 15:04:13

Access: Member
Total Posts: 21
Joined: 2011-02-10

I have tryed to install manually sql files... but then I received this error:

Error: You have an error in your SQL syntax near 'SELECT storyid FROM news_groupcats WHERE catid = '1')' at line 1
Statement: SELECT title, story, shortstory, id FROM news_story WHERE id IN (SELECT storyid FROM news_groupcats WHERE catid = ?)
Arguments:

Array
(
[0] => 1
)
#3230
Dla86
Posted on 23 Feb 2011, 15:08:44

Access: Member
Total Posts: 21
Joined: 2011-02-10

also this error in www.mysite./news

Error: You have an error in your SQL syntax near 'SELECT COUNT(id) FROM news_comments WHERE news_comments.pid = news_story.id)' at line 1
Statement: UPDATE news_story SET commentcount = (SELECT COUNT(id) FROM news_comments WHERE news_comments.pid = news_story.id)
Arguments:

Array
(
)
#3231
Dla86
Posted on 23 Feb 2011, 15:29:54

Access: Member
Total Posts: 21
Joined: 2011-02-10

I have founded out the problem... My site has PHP 4 :(
#3232
Chris
Posted on 23 Feb 2011, 15:34:42

Access: Admin
Total Posts: 1395
Joined: 2006-05-19

Quote:
I have founded out the problem... My site has PHP 4 :(

Some hosts allow you to switch between PHP4 & 5. Contact them or check their help section to see if they allow you to do so.
#3233
Network-13.com © 2013