Forum Replies Created

Viewing 2 replies - 1 through 2 (of 2 total)
  • 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?

    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.

Viewing 2 replies - 1 through 2 (of 2 total)