Just a couple of questions regarding the "Reset all data" function under "Settings".
As I like to delete old data from time to time, just for my database's size sake, I've been using this function a couple of times. There's a few things that strike me each time.
The user data is kept; I have to go into the database to reset the user statistics. When I say delete all old data it should delete all old collected data, right?
The goals will also be deleted; is this right in the logic of "delete all old data"; though one could argue whether this one is right to be deleted. Could be that a lot of manual work is in this one from the admin-user.
So for this case there's the goal export function. If it works that is. I get an xml file out of it BUT when I try to import after the reset I get an error
"1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 's Visit'' at line 1 SQL=select name from j3_extrawatch_goals where name = 'XXXXX' "
Ok so I ven tried to set the index within my MySql database to zero. Now I don't get the message, but the import actually still doesn't get the data back into my database.
Any chance you might have a look into these things. Would be lovely.
I use the latest version of joomla 3.3.6 and extra Watch 2.3.2234 but actually I had this before.