Restore not work|Joomla Support|Forum Archive|XCloner

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
Restore not work
May 23, 2012
4:52 pm
Avatar
Ervin
Member
Members
Forum Posts: 17
Member Since:
May 27, 2011
sp_UserOfflineSmall Offline

I'm backup my live site (joomla 2.5) and restore into localhost, but not work. Display error is:

 

XCloner Automatic Restore! - 127.0.0.1

###MYSQL error

Duplicate entry '2-0' for key 'submission_id_form_id'

###On Query:


INSERT INTO `rqyh4_form_submission_trackings` VALUES ('2','0','2','','127.0.0.1','Mozilla/5.0 (Windows NT 5.1) AppleWebKit/536.5 (KHTML, like Gecko) Chrome/19.0.1084.46 Safari/536.5','2012-05-20 04:00:00')

 

I don't know why? I'm backup to localhost site and restore into live server, but error is equal.

May 25, 2012
9:28 am
Avatar
Ovidiu Liuta
Member
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Seems to be a general mysql error, try excluding the rqyh4_form_submission_trackings table from your backup and see it helps!

 

Ovidiu

May 25, 2012
9:45 am
Avatar
Ervin
Member
Members
Forum Posts: 17
Member Since:
May 27, 2011
sp_UserOfflineSmall Offline

Hello!

 

I'm testing phpmyadmin export and import and work propertly, without error.

May 25, 2012
4:27 pm
Avatar
Ovidiu Liuta
Member
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Great, then i see no problem on using phpmyadmin to import the mysql database in case you have similar issues, unfortunatelly the above error relates still to the mysql server processing and not XCloner

 

Ovidiu

May 25, 2012
5:34 pm
Avatar
Ervin
Member
Members
Forum Posts: 17
Member Since:
May 27, 2011
sp_UserOfflineSmall Offline

I don't know, but if I use phpmyadmin for export is OK. Import work in server and localhost. If I use xcloner for backup, this database is useless for import with xcloner or phpmyadmin.

May 27, 2012
9:34 am
Avatar
Ervin
Member
Members
Forum Posts: 17
Member Since:
May 27, 2011
sp_UserOfflineSmall Offline

Hello!

I'm repair this problem. Open database and delete one duplicate record.

May 28, 2012
12:01 pm
Avatar
Ovidiu Liuta
Member
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Awesome,thanks for sharing the fix!

Forum Timezone: America/Chicago
Most Users Ever Online: 867
Currently Online:
Guest(s) 3
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: 10080
Moderators: 2
Admins: 3
Forum Stats:
Groups: 3
Forums: 7
Topics: 2397
Posts: 8236
Newest Members:
Manuele Freddo_1
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0