JSON error | Wordpress 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_Feed Topic RSSsp_TopicIcon
JSON error
March 22, 2012
12:07 am
Avatar
Guest
Guests

Just installed xcloner, on first attempt to generate backup get this error:

 

Error(Mar 21, 2012 @ 19:04:22) - Invalid query: Access denied; you need the PROCESS,SUPER privilege for this operation 
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/gotwick/public_html/vinceandsonpainting.friendnet.us/wp-content/plugins/xcloner-backup-and-restore/classes/mysqlBackup.class.php on line 246
Error(Mar 21, 2012 @ 19:04:24) - Invalid query: Access denied; you need the PROCESS,SUPER privilege for this operation 
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/gotwick/public_html/vinceandsonpainting.friendnet.us/wp-content/plugins/xcloner-backup-and-restore/classes/mysqlBackup.class.php on line 246
Error(Mar 21, 2012 @ 19:04:24) - Invalid query: Access denied; you need the PROCESS,SUPER privilege for this operation 
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/gotwick/public_html/vinceandsonpainting.friendnet.us/wp-content/plugins/xcloner-backup-and-restore/classes/mysqlBackup.class.php on line 246

Initializing backup...

Backup /home/...../public_html/.......friendnet.us/administrator/backups/vince-old.tar created, we may continue!

Database backup...

[....wrdp14] 25 tables (1.46 MB) 
[information_schema] 0 tables

There was an error retrieving the JSON data from the server, try again or contact the developers!

Details: parsererror -- Invalid JSON: Error(Mar 21, 2012 @ 19:04:25) - Invalid query: Access denied; you need the PROCESS,SUPER privilege for this operation Error(Mar 21, 2012 @ 19:04:26) - Invalid query: Access denied; you need the PROCESS,SUPER privilege for this operation Error(Mar 21, 2012 @ 19:04:26) - Invalid query: Access denied; you need the PROCESS,SUPER privilege for this operation {"endDump":1,"tableName":"","databaseName":"","totalRecords":null,"startAtLine":62,"startAtRecord":0,"dumpfile":"\/home\/gotwick\/public_html\/vinceandsonpainting.friendnet.us\/administrator\/backups\/information_schema-sql.sql","dbbackup_comp":"","dbbackup_drop":""}

JSON url: index2.php?task=recurse_database&nohtml=1&dbbackup_comp=&dbbackup_drop=&startAtLine=29&startAtRecord=0&dumpfile=/home/gotwick/public_html/vinceandsonpainting.friendnet.us/administrator/backups/information_schema-sql.sql 

March 22, 2012
11:54 am
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

The error you have is related to the mysql user which doesn't have enough permissions to read and backup the database structure, try and give it full permissions, then try again!

 

Ovidiu

March 22, 2012
11:51 pm
Avatar
Guest
Guests

Ok, noticed it was doing ok until it hit the schema table, so I did all but that, and it went through.

 

Now the problem is that when I click on the link that says click here to continue, nothing happens except it opens the supposedly cloned website in the admin frame, but it is not cloned!

 

btw, this is the url of the link: http://www.vince-and.....Cloner.php

March 23, 2012
12:24 pm
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

I am presuming you are trying to restore the backup? If so, please follow this restore quide /wiki/index.php/Restore_Backup#Restore_Backup_.E2.80.93_Manually , it should help!

 

Ovidiu

March 23, 2012
4:18 pm
Avatar
Guest
Guests

What is the point of having this plugin if I always have to do it manually?

March 25, 2012
6:25 am
Avatar
Ovidiu Liuta
Admin
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

As explained in that restore wiki, you simply need to move the backup archive and restore script to the new location so you are able to continue the restore process!

 

Hope it helps!

March 28, 2012
2:06 am
Avatar
Guest
Guests

You are missing the point. I use the plugin supposedly to do an automatic backup, but I end up having to do things manually. That is the whole point of having the plugin, to NOT do things manually!!!!!! I might as well not use the plugin and save the server space/memory usage!!!!

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:
ISIDORO ILARDO
Moderators: TriP: 0, Steve Burge: 0
Administrators: Ovidiu Liuta: 2484, Victor Drover: 1, Valentin Barbu: 0