Problems restoring site | Joomla Support | Forum Archive

The free forums are no longer in use. It remains available as read-only archive.

Avatar
Lost password?
Advanced Search
Forum Scope


Match



Forum Options



Minimum search word length is 3 characters - maximum search word length is 84 characters
The forums are currently locked and only available for read only access
sp_TopicIcon
Problems restoring site
July 18, 2012
11:58 am
Avatar
boris
Member
Members
Forum Posts: 4
Member Since:
July 18, 2012
sp_UserOfflineSmall Offline

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.

July 18, 2012
8:15 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

I don't see the exact mysql error, could you copy/paste the full mysql error output?

 

Ovidiu

July 19, 2012
7:54 am
Avatar
boris
Member
Members
Forum Posts: 4
Member Since:
July 18, 2012
sp_UserOfflineSmall Offline

Hello

 

This is what I get from xcloner (it asks to replace this syntax from one below, I clicked skip) ..  I do not know where to get full mysql error output.

July 19, 2012
9:47 am
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Could you attach a screenshot here with the output you get there? Ovidiu

July 20, 2012
4:35 pm
Avatar
boris
Member
Members
Forum Posts: 4
Member Since:
July 18, 2012
sp_UserOfflineSmall Offline

Hello here are my screnshoots…   Thanks  Boris

Image Enlarger

Image Enlarger

Image Enlarger

Image Enlarger

Image Enlarger

Image Enlarger

Image Enlarger

Image Enlarger

Image Enlarger

July 20, 2012
6:05 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Can you try and import the mysql backup administrator/backups/database-sql.sql file through phpmyadmin and see if it helps?

 

Regards, Ovidiu

July 21, 2012
7:53 pm
Avatar
boris
Member
Members
Forum Posts: 4
Member Since:
July 18, 2012
sp_UserOfflineSmall Offline

Hello

tried and no luck... still 500 error

Any new ideas?

Regards

 

Boris

July 21, 2012
9:17 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Hi Boris, i would suggest checking with your hosting support, you might run into a server limit which they might be able to increase....

 

If you like, feel free to open a support ticket as well and send me the site phpmyadmin access details to see if i can help more!

 

Ovidiu

Forum Timezone: America/Chicago
Most Users Ever Online: 867
Currently Online:
Guest(s) 1
Currently Browsing this Page:
1 Guest(s)
Top Posters:
mlguru: 30
Django29: 29
D: 21
Andy: 21
Marcus: 20
Jamie F: 19
Member Stats:
Guest Posters: 738
Members: 10052
Moderators: 2
Admins: 3
Forum Stats:
Groups: 3
Forums: 7
Topics: 2397
Posts: 8236
Newest Members:
piotr K
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0