Installation problem

[stanfield]

Hi there !
I really want to give codefight a try, but I got a problem during the installation !
I use XAMPP as a server, I created a database named "codefight", login "root", password "[empty]". When I click "submit", I got the error :

Code: Select all

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 'CREATE TABLE IF NOT EXISTS `cf_banners` ( `banners_id` int(11) NOT NULL AUTO_I' at line 2You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `cf_banners_history` ( `banners_history_id` int(11)' at line 2You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `cf_forms_groups` ( `form_groups_id` int(11) NOT NU' at line 2You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `cf_forms_items` ( `form_item_id` int(11) NOT NULL ' at line 2You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `cf_forms_items_to_groups` ( `form_groups_id` int(1' at line 2You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `cf_groups` ( `groups_id` int(11) NOT NULL AUTO_INC' at line 2Table 'codefight.cf_groups' doesn't existYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `cf_menus` ( `menus_id` int(11) NOT NULL AUTO_INCRE' at line 2Table 'codefight.cf_menus' doesn't existYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `cf_ontheweb` ( `id` int(11) NOT NULL AUTO_INCREMEN' at line 2You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `cf_pages` ( `pages_id` int(11) NOT NULL AUTO_INCRE' at line 2Table 'codefight.cf_pages' doesn't existYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `cf_pages_access` ( `pages_id` int(11) NOT NULL, ' at line 2Table 'codefight.cf_pages_access' doesn't existYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `cf_pages_comments` ( `pages_comments_id` int(11) N' at line 2You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `cf_pages_tags` ( `pages_id` int(11) NOT NULL, `t' at line 2Table 'codefight.cf_pages_tags' doesn't existYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `cf_sessions` ( `session_id` varchar(40) NOT NULL D' at line 2Table 'codefight.cf_sessions' doesn't existYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `cf_settings` ( `settings_id` int(11) NOT NULL AUTO' at line 2Table 'codefight.cf_settings' doesn't existYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `cf_tags_cloud` ( `tag` varchar(255) NOT NULL, `t' at line 2Table 'codefight.cf_tags_cloud' doesn't existYou have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'CREATE TABLE IF NOT EXISTS `cf_users` ( `users_id` int(11) NOT NULL AUTO_INCRE' at line 2Table 'codefight.cf_users' doesn't exist


And of course, nothing's written in the database...

What am I doing wrong ?

Any reply is more than appreciated !

[dbashyal]

Sorry for late reply. Can you try uploading this to database, probably installer didn't worked for you.

Code: Select all

================
--
-- Table structure for table `cf_banners`
--

CREATE TABLE `cf_banners` (
  `banners_id` int(11) NOT NULL AUTO_INCREMENT,
  `banners_title` varchar(64) NOT NULL DEFAULT '',
  `banners_url` varchar(255) NOT NULL DEFAULT '',
  `banners_image` varchar(64) NOT NULL DEFAULT '',
  `banners_group` varchar(255) NOT NULL DEFAULT '',
  `banners_html_text` text,
  `expires_impressions` int(7) DEFAULT '0',
  `expires_clicks` int(7) DEFAULT '0',
  `expires_date` datetime DEFAULT NULL,
  `date_scheduled` datetime DEFAULT NULL,
  `date_added` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  `date_status_change` datetime DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`banners_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `cf_banners`
--


-- --------------------------------------------------------

--
-- Table structure for table `cf_banners_history`
--

CREATE TABLE `cf_banners_history` (
  `banners_history_id` int(11) NOT NULL AUTO_INCREMENT,
  `banners_id` int(11) NOT NULL DEFAULT '0',
  `banners_shown` int(5) NOT NULL DEFAULT '0',
  `banners_clicked` int(5) NOT NULL DEFAULT '0',
  `banners_history_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
  PRIMARY KEY (`banners_history_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Dumping data for table `cf_banners_history`
--


-- --------------------------------------------------------

--
-- Table structure for table `cf_forms_groups`
--

CREATE TABLE `cf_forms_groups` (
  `form_groups_id` int(11) NOT NULL AUTO_INCREMENT,
  `form_groups_name` varchar(25) DEFAULT NULL,
  `form_groups_identifier` varchar(35) DEFAULT NULL,
  `form_groups_send_to` text,
  PRIMARY KEY (`form_groups_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `cf_forms_groups`
--


-- --------------------------------------------------------

--
-- Table structure for table `cf_forms_items`
--

CREATE TABLE `cf_forms_items` (
  `form_item_id` int(11) NOT NULL AUTO_INCREMENT,
  `form_item_name` varchar(50) NOT NULL,
  `form_item_label` varchar(50) NOT NULL,
  `form_item_input_type` varchar(15) NOT NULL,
  `form_item_validations` varchar(200) NOT NULL,
  `form_item_default_value` varchar(200) NOT NULL,
  `form_item_parameters` varchar(200) NOT NULL,
  PRIMARY KEY (`form_item_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `cf_forms_items`
--


-- --------------------------------------------------------

--
-- Table structure for table `cf_forms_items_to_groups`
--

CREATE TABLE `cf_forms_items_to_groups` (
  `form_groups_id` int(11) NOT NULL,
  `form_item_id` int(11) NOT NULL,
  `form_item_sort` int(11) NOT NULL,
  KEY `form_groups_id` (`form_groups_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cf_forms_items_to_groups`
--


-- --------------------------------------------------------

--
-- Table structure for table `cf_groups`
--

CREATE TABLE `cf_groups` (
  `groups_id` int(11) NOT NULL AUTO_INCREMENT,
  `groups_title` varchar(255) NOT NULL,
  `groups_description` text NOT NULL,
  `groups_sort` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`groups_id`),
  UNIQUE KEY `groups_title` (`groups_title`),
  KEY `groups_sort` (`groups_sort`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

--
-- Dumping data for table `cf_groups`
--

INSERT INTO `cf_groups` (`groups_id`, `groups_title`, `groups_description`, `groups_sort`) VALUES
(1, 'Administrator', 'Users who have admin access rights go to this group.', 0),
(2, 'Public', 'General users go to this group.', 1),
(3, 'Registered User', 'Registered User Group.', 2);

-- --------------------------------------------------------

--
-- Table structure for table `cf_menus`
--

CREATE TABLE `cf_menus` (
  `menus_id` int(11) NOT NULL AUTO_INCREMENT,
  `menus_active` int(1) NOT NULL DEFAULT '0',
  `menus_parent_id` int(11) DEFAULT '0',
  `menus_link` varchar(255) DEFAULT NULL,
  `menus_title` varchar(255) NOT NULL,
  `menus_type` varchar(255) NOT NULL DEFAULT 'pages',
  `menus_meta_title` varchar(70) DEFAULT NULL,
  `menus_meta_keywords` varchar(200) DEFAULT NULL,
  `menus_meta_description` varchar(150) DEFAULT NULL,
  `menus_sort` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`menus_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=66 ;

--
-- Dumping data for table `cf_menus`
--

INSERT INTO `cf_menus` (`menus_id`, `menus_active`, `menus_parent_id`, `menus_link`, `menus_title`, `menus_type`, `menus_meta_title`, `menus_meta_keywords`, `menus_meta_description`, `menus_sort`) VALUES
(1, 1, 0, 'http://www.codefight.org/', 'Home', 'pages', NULL, NULL, NULL, 0),
(24, 1, 0, 'codeigniter', 'Codeigniter', 'blog-categories', NULL, NULL, NULL, 4),
(18, 1, 0, 'http://www.codefight.org/page/18/35/contact-us.html', 'Contact Us', 'pages', NULL, NULL, NULL, 10),
(40, 1, 0, 'http://twitter.com/codefight', 'Twitter', 'favourite-links', NULL, NULL, NULL, 2),
(41, 1, 0, 'http://www.linkedin.com/in/codefight', 'Linked In', 'favourite-links', NULL, NULL, NULL, 3),
(43, 1, 0, 'http://www.tenthweb.com/forums/viewforum.php?f=49', 'Forum', 'pages', NULL, NULL, NULL, 1),
(65, 1, 0, 'codefight', 'Codefight', 'blog-categories', NULL, NULL, NULL, 0);

-- --------------------------------------------------------

--
-- Table structure for table `cf_ontheweb`
--

CREATE TABLE `cf_ontheweb` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) DEFAULT NULL,
  `meta_title` varchar(255) DEFAULT NULL,
  `meta_keywords` text,
  `meta_description` text,
  `link` varchar(255) DEFAULT NULL,
  `link_external` varchar(255) DEFAULT NULL,
  `content` text,
  `views` int(11) NOT NULL DEFAULT '0',
  `timestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `is_adult` varchar(1) NOT NULL DEFAULT '0',
  `is_locked` varchar(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=5653 ;

--
-- Dumping data for table `cf_ontheweb`
--


-- --------------------------------------------------------

--
-- Table structure for table `cf_pages`
--

CREATE TABLE `cf_pages` (
  `pages_id` int(11) NOT NULL AUTO_INCREMENT,
  `pages_active` int(11) NOT NULL,
  `pages_title` varchar(255) DEFAULT NULL,
  `pages_blurb` text,
  `pages_blurb_length` int(11) NOT NULL,
  `pages_body` text,
  `menu_id` varchar(255) NOT NULL DEFAULT '0',
  `pages_author` varchar(255) NOT NULL,
  `show_author` int(1) NOT NULL DEFAULT '0',
  `pages_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `pages_date_modified` datetime DEFAULT NULL,
  `show_date` int(1) NOT NULL DEFAULT '0',
  `pages_tags` varchar(255) NOT NULL,
  `allow_comments` int(1) NOT NULL DEFAULT '0',
  `pages_type` varchar(255) NOT NULL DEFAULT 'pages',
  `pages_view` int(11) DEFAULT '0',
  `pages_meta_title` varchar(70) DEFAULT NULL,
  `pages_meta_keywords` varchar(200) DEFAULT NULL,
  `pages_meta_description` varchar(150) DEFAULT NULL,
  `pages_sort` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pages_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=50 ;

--
-- Dumping data for table `cf_pages`
--

INSERT INTO `cf_pages` (`pages_id`, `pages_active`, `pages_title`, `pages_blurb`, `pages_blurb_length`, `pages_body`, `menu_id`, `pages_author`, `show_author`, `pages_date`, `pages_date_modified`, `show_date`, `pages_tags`, `allow_comments`, `pages_type`, `pages_view`, `pages_meta_title`, `pages_meta_keywords`, `pages_meta_description`, `pages_sort`) VALUES
(49, 1, 'Installation successful.', 'This post means you installed successfully.', 0, 'This post means you installed successfully.', ',65,', 'Damodar Bashyal', 1, '2009-11-21 23:33:26', NULL, 1, 'codefight, codefight cms, codeigniter, codeigniter cms', 1, 'blog', 0, 'Installation successful. - codefight', 'codefight, codefight cms, codeigniter, codeigniter cms', 'codefight, codefight cms, codeigniter, codeigniter cms', 0);

-- --------------------------------------------------------

--
-- Table structure for table `cf_pages_access`
--

CREATE TABLE `cf_pages_access` (
  `pages_id` int(11) NOT NULL,
  `groups_id` varchar(255) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pages_id`,`groups_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cf_pages_access`
--

INSERT INTO `cf_pages_access` (`pages_id`, `groups_id`) VALUES
(49, '1_2');

-- --------------------------------------------------------

--
-- Table structure for table `cf_pages_comments`
--

CREATE TABLE `cf_pages_comments` (
  `pages_comments_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL,
  `email` varchar(255) NOT NULL,
  `comment` text NOT NULL,
  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `url` varchar(255) NOT NULL,
  `pages_id` int(11) NOT NULL,
  `pages_url` varchar(300) DEFAULT NULL,
  `pages_comments_status` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`pages_comments_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=39 ;

--
-- Dumping data for table `cf_pages_comments`
--


-- --------------------------------------------------------

--
-- Table structure for table `cf_pages_tags`
--

CREATE TABLE `cf_pages_tags` (
  `pages_id` int(11) NOT NULL,
  `tags` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cf_pages_tags`
--

INSERT INTO `cf_pages_tags` (`pages_id`, `tags`) VALUES
(49, 'codefight'),
(49, 'codefight-cms'),
(49, 'codeigniter'),
(49, 'codeigniter-cms');

-- --------------------------------------------------------

--
-- Table structure for table `cf_sessions`
--

CREATE TABLE `cf_sessions` (
  `session_id` varchar(40) NOT NULL DEFAULT '0',
  `ip_address` varchar(16) NOT NULL DEFAULT '0',
  `user_agent` varchar(50) NOT NULL,
  `last_activity` int(10) unsigned NOT NULL DEFAULT '0',
  `user_data` text NOT NULL,
  PRIMARY KEY (`session_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;


-- --------------------------------------------------------

--
-- Table structure for table `cf_settings`
--

CREATE TABLE `cf_settings` (
  `settings_id` int(11) NOT NULL AUTO_INCREMENT,
  `settings_key` varchar(50) NOT NULL,
  `settings_value` varchar(300) NOT NULL,
  `settings_info` varchar(100) NOT NULL,
  `settings_form` varchar(25) NOT NULL,
  `settings_options` varchar(250) NOT NULL,
  PRIMARY KEY (`settings_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=14 ;

--
-- Dumping data for table `cf_settings`
--

INSERT INTO `cf_settings` (`settings_id`, `settings_key`, `settings_value`, `settings_info`, `settings_form`, `settings_options`) VALUES
(1, 'site_enabled', '1', 'Site Enabled', 'radio', '1=YES|0=NO'),
(2, 'site_comments', '0', 'Registration required to post comments', 'radio', '1=YES|0=NO'),
(3, 'meta_title', 'codefight.org', 'Default Meta Title', 'textbox', 'codefight.org'),
(4, 'meta_keyword', 'codefight, code fight, content, management, system, free, php, download', 'Default Meta Keywords', 'textbox', 'codefight, code fight, content, management, system, free, php, download'),
(5, 'meta_description', 'download free content management system built with codeigniter free php framework.', 'Default Meta Description', 'textarea', 'download free content management system built with codeigniter free php framework.'),
(6, 'default_template', '3columns', 'Default Template', 'select', ''),
(7, 'email_sender', 'noreply@codefight.org', 'From Email Address', 'textbox', 'noreply@codefight.org'),
(8, 'site_name', 'CodeFight', 'Website Name', 'textbox', 'CodeFight'),
(9, 'combine_css', '1', 'Combine CSS Files', 'radio', '1=YES|0=NO'),
(10, 'minify_css', '1', 'Minify CSS', 'radio', '1=YES|0=NO'),
(11, 'minify_html', '1', 'Minify html source code', 'radio', '1=YES|0=NO'),
(12, 'pagination_page_links', '2', 'Display Total Pagination Page Links', 'textbox', '2'),
(13, 'pagination_per_page', '3', 'Display Total Articles Per Page', 'textbox', '5');

-- --------------------------------------------------------

--
-- Table structure for table `cf_tags_cloud`
--

CREATE TABLE `cf_tags_cloud` (
  `tag` varchar(255) NOT NULL,
  `title` varchar(255) NOT NULL,
  `count` int(11) NOT NULL DEFAULT '1',
  `type` varchar(15) NOT NULL DEFAULT 'page',
  KEY `count` (`count`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cf_tags_cloud`
--

INSERT INTO `cf_tags_cloud` (`tag`, `title`, `count`, `type`) VALUES
('codefight', 'codefight', 1, 'page'),
('codefight-cms', ' codefight cms', 1, 'page'),
('codeigniter', ' codeigniter', 1, 'page'),
('codeigniter-cms', ' codeigniter cms', 1, 'page');

-- --------------------------------------------------------

--
-- Table structure for table `cf_users`
--

CREATE TABLE `cf_users` (
  `users_id` int(11) NOT NULL AUTO_INCREMENT,
  `active` char(1) NOT NULL DEFAULT '',
  `email` varchar(255) NOT NULL DEFAULT '',
  `password` varchar(34) NOT NULL DEFAULT '',
  `firstname` varchar(100) NOT NULL DEFAULT '',
  `lastname` varchar(100) NOT NULL DEFAULT '',
  `groups_id` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`users_id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=16 ;

--
-- Dumping data for table `cf_users`
--

INSERT INTO `cf_users` (`users_id`, `active`, `email`, `password`, `firstname`, `lastname`, `groups_id`) VALUES
(11, '1', 'test@test.com', '098f6bcd4621d373cade4e832627b4f6', 'test', 'test', 1);



[dbashyal]

Also, Check these and setup manually if installer fails.

Code: Select all

app/admin/config/config.php:
app/frontend/config/config.php:
       $config['base_url'] = “http://www.your-website.com/“

app/admin/config/database.php:
app/frontend/config/database.php:
1-
$db['default']['username'] = “database username“;

2-
$db['default']['password'] = “database password“;

3-
$db['default']['database'] = “database name“;