The free forums are no longer in use. It remains available as read-only archive.
11:58 am
July 18, 2012
Hello
I have developed site localy on xamp. Now I want to transfer it to server with xcloner. Problems is when importing database. I get several errors. (tried sql drop and no drop version already)
First error
#
# Table structure for table `kd91n_usergroups`
#
CREATE TABLE `kd91n_usergroups` (
`id` int(10)
unsigned NOT NULL AUTO_INCREMENT COMMENT
'Primary Key',
`parent_id` int(10)
unsigned NOT NULL DEFAULT '0' COMMENT 'Adjacency List Reference Id',
`lft` int(11) NOT
NULL DEFAULT '0' COMMENT 'Nested set lft.',
`rgt` int(11) NOT
NULL DEFAULT '0' COMMENT 'Nested set rgt.',
`title` varchar(100)
NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
UNIQUE KEY
`idx_usergroup_parent_title_lookup` (`parent_id`,`title`),
KEY
`idx_usergroup_title_lookup` (`title`),
KEY
`idx_usergroup_adjacency_lookup` (`parent_id`),
KEY
`idx_usergroup_nested_set_lookup` (`lft`,`rgt`) USING BTREE
) ENGINE=MyISAM AUTO_INCREMENT=9
DEFAULT CHARSET=utf8
seccond error
#
# End Structure for table `kd91n_usergroups`
#
#
# Dumping data for table `kd91n_usergroups`
#
INSERT INTO `kd91n_usergroups` VALUES ('1', '0', '1', '20',
'Public')
third error
INSERT INTO `kd91n_usergroups` VALUES ('2', '1', '6', '17',
'Registered')
fourth error
INSERT INTO `kd91n_usergroups` VALUES ('3', '2', '7', '14',
'Author')
fifth error
INSERT INTO `kd91n_usergroups` VALUES ('4', '3', '8', '11',
'Editor')
and so on...
INSERT INTO `kd91n_usergroups` VALUES ('5', '4', '9', '10',
'Publisher')
INSERT INTO `kd91n_usergroups` VALUES ('6', '1', '2', '5',
'Manager')
INSERT INTO `kd91n_usergroups` VALUES ('7', '6', '3', '4',
'Administrator')
INSERT INTO `kd91n_usergroups` VALUES ('8', '1', '18', '19',
'Super Users')
when I press skip option I go to the end. Now frontpage working ok, backend not working. When i try to logon
500 - An error has occurred.
What is the matter? Please help.
1 Guest(s)