Hi there,
it sounds like you updated from a quite old version of Slimstat. Please make sure your table has all the fields listed in this schema:
https://slimstat.freshdesk.com/solution/articles/5000650210-what-is-the-table-schema-used-to-store-all-the-information-
Best,
Camu
Thread Starter
BeNeR1
(@bener1)
Hello camu,
thanks for the fast response. I checked my tables and you are right: my schema is completey different.
So should I just add the new fields listed in your link? and what about for example fields like “ip” which is “ip_num” in my table. should I update the name or just add the new one?!
I dont want to loose all of my old data. so deleting the old tables isnt a good idea?!
Maybe u have a script to do all these changes in the mysql-DB?
Thanks very much.
Hi,
so you only have ip_num but not ip in your table? If that’s the case, you will need to convert the data, after you add the new columns:
ALTER TABLE wp_slim_stats ADD ip VARCHAR(39) DEFAULT NULL AFTER id;
and
ALTER TABLE wp_slim_stats ADD other_ip VARCHAR(39) DEFAULT NULL AFTER ip;
Then
UPDATE wp_slim_stats SET ip = INET_NTOA(ip_num), other_ip = INET_NTOA(other_ip_num);
Add the other missing columns, and wait a few days before dropping ip_num and other_ip_num.
Let us know if it works.
Thread Starter
BeNeR1
(@bener1)
Hello camu, thanks for your reply.
It’s been a while since I have done mysql-querys that “complex”. My table is so different from the new one that I am a bit afraid of doing all the changes on my own.
Isn’t there a script or cant I upload an older version of slimstat and update to the one that does the changes in the mysql db before i update to the newest version?
Thats how my table slim_stats looks right now:
id int(10)
ip_num int(10)
other_ip_num int(10)
user varchar(255)
language varchar(5)
country varchar(16)
domain varchar(255)
referer varchar(2048)
searchterms varchar(2048)
resource varchar(2048)
browser_id smallint(5)
screenres_id mediumint(8)
content_info_id int(10)
plugins varchar(255)
notes varchar(2048)
visit_id int(10)
server_latency int(10)
page_performance int(10)
dt int(10)
and please let me know how I can show my support for you! Can I donate somewhere?
If it’s okay with you, you could send us an export of your table, we’ll convert it and send it back to you.
http://support.wp-slimstat.com/
