Here's what I figured out. I did some searching online for MetaTraffic and a lot of people didn't have their databases secured. I e-mailed a couple of them and told them to secure them.
The following is how I migrated my old stats pretty much step-by-step. Some of the details are a little fuzzy because it's been a couple of weeks since I did this...so here goes.
:|
====================================
Anyways, I downloaded a 1.3 (I think) version of the MetaTraffic database. Since there is an upgrade from this version in 2.23, I took my old data (IPs, page hits, etc.) and pasted them into the appropriate columns in the 1.3 database.
The only problem I had was trying to upgrade it kept giving me an error. I tracked it down to line 1369 (I think) on the page "Setup.asp". I changed the line from:
That narrowed it down for me to show me that my sessions under "pl_sessionid" were not long enough to be imported and causing errors. It took me a couple of hours to figure out why I was getting errors upgrading, so I wanted to save someone else the trouble and time :D
After that, the upgrade ran successfully and worked great. The stats were a little skewed of course because all I had been keeping track of previously were dates, page hits, and IPs.
============================
Thanks for a great piece of software. I'm using for a church site, so I don't have the pro version. Anyways, I hope this helps someone else.
Also, Chad you might want to consider having a place on the website to download a version of the 1.3 database to copy and paste their old stats into. For people like me who are picky enough and care enough to migrate all the old data :)
Migrate Stats
You are going to need to describe more specifically what you are trying to do. What are your old stats?
Migrate Stats
Here's what I figured out. I did some searching online for MetaTraffic and a lot of people didn't have their databases secured. I e-mailed a couple of them and told them to secure them.
The following is how I migrated my old stats pretty much step-by-step. Some of the details are a little fuzzy because it's been a couple of weeks since I did this...so here goes.
:|
====================================
Anyways, I downloaded a 1.3 (I think) version of the MetaTraffic database. Since there is an upgrade from this version in 2.23, I took my old data (IPs, page hits, etc.) and pasted them into the appropriate columns in the 1.3 database.
The only problem I had was trying to upgrade it kept giving me an error. I tracked it down to line 1369 (I think) on the page "Setup.asp". I changed the line from:
"WHERE s_id = " & intSessionID
to
"WHERE s_id = " & intSessionID
Response.Write("" & strSql & " =================== ")
That narrowed it down for me to show me that my sessions under "pl_sessionid" were not long enough to be imported and causing errors. It took me a couple of hours to figure out why I was getting errors upgrading, so I wanted to save someone else the trouble and time :D
After that, the upgrade ran successfully and worked great. The stats were a little skewed of course because all I had been keeping track of previously were dates, page hits, and IPs.
============================
Thanks for a great piece of software. I'm using for a church site, so I don't have the pro version. Anyways, I hope this helps someone else.
Also, Chad you might want to consider having a place on the website to download a version of the 1.3 database to copy and paste their old stats into. For people like me who are picky enough and care enough to migrate all the old data :)
-J