error retreiving the JSON data - always worked before|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
error retreiving the JSON data - always worked before
March 15, 2012
11:52 am
Avatar
Lee
Member
Members
Forum Posts: 3
Member Since:
March 12, 2012
sp_UserOfflineSmall Offline

Hi I would appreciate your help if possible.

I have using this component and it has been working fine for a long time now but all of a sudden I can’t perform a backup and I get the following error:

Error(Mar 2, 2012 @ 12:16:41) - Invalid query: The 'SHOW PROFILE' feature is disabled; you need MySQL built with 'enable-profiling' to have it working
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/fhlinux147/f/fmestates.com/user/htdocs/administrator/components/com_xcloner-backupandrestore/classes/mysqlBackup.class.php on line 246

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

Details: parsererror -- Invalid JSON: Error(Mar 2, 2012 @ 12:16:46) - Invalid query: The 'SHOW PROFILE' feature is disabled; you need MySQL built with 'enable-profiling' to have it working {"endDump":1,"tableName":"","databaseName":"","totalRecords":null,"startAtLine":82,"startAtRecord":0,"dumpfile":"\/home\/fhlinux147\/f\/fmestates.com\/user\/htdocs\/administrator\/backups\/information_schema-sql.sql","dbbackup_comp":"","dbbackup_drop":"1"}

JSON url: index2.php?task=recurse_database&nohtml=1&dbbackup_comp=&dbbackup_drop=1&startAtLine=65&startAtRecord=0&dumpfile=/home/fhlinux147/f/fmestates.com/user/htdocs/administrator/backups/information_schema-sql.sql’


I asked the hosting company if any settings had changed on their end and they said nothing had changed, and I havn’t changed any settings on my end.

your help would be much appreciated.

Many Thanks

Lee

March 16, 2012
7:27 am
Avatar
Ovidiu Liuta
Member
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Hi Lee, the backup process is failling due to this mysql error

 

Invalid query: The 'SHOW PROFILE' feature is disabled; you need MySQL built with 'enable-profiling' to have it working

 

 you need to contact your hosting support to enable it. 

 

Ovidiu

March 16, 2012
3:11 pm
Avatar
Lee
Member
Members
Forum Posts: 3
Member Since:
March 12, 2012
sp_UserOfflineSmall Offline

Hi Ovidiu

 

Thank you for your promt response, I have just been in touch with my Hosting company (fasthosts) and unfortunately they dont enable the show 'show profile' setting on shared databases 🙁

 

I have been using this component for a couple of years now, is it only in the new versions that you need the 'show profile' setting enabled?
is there anyway I can still use this great component?

 

Thanks you again for your help

Lee

March 17, 2012
7:35 pm
Avatar
Ovidiu Liuta
Member
Forum Posts: 2484
Member Since:
September 26, 2010
sp_UserOfflineSmall Offline

Try switching the Backup Mode to Normal in your XCloner Config->System tab and see if it helps!

 

Ovidiu

March 19, 2012
10:48 am
Avatar
Lee
Member
Members
Forum Posts: 3
Member Since:
March 12, 2012
sp_UserOfflineSmall Offline

That worked, thank you very much for your help 🙂

Forum Timezone: America/Chicago
Most Users Ever Online: 867
Currently Online:
Guest(s) 4
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