Login to download the latest version of Mint and your favorite Pepper, purchase additional licenses, or post in the Forum. Don't have an account? Create one!

In Partnership with Media Temple

Mint Forum

Upgrade SQL Issues

Silent7
Minted
Posted on Mar 17, '07 at 10:20 pm

I have searched the forum for these errors with no luck?

MySQL Error (from Geo Mint): Unknown column ‘ip_long’ in ‘field list’. (1054) Query: SELECT ip_long, dt FROM mint_visit GROUP BY ip_long ORDER BY dt DESC LIMIT 0, 10 MySQL Error (from Geo Mint): Unknown column ‘mint_visit.ip_long’ in ‘field list’. (1054) Query: SELECT ip, country, country_abrv, city, latitude, longitude, dt, mint_visit.ip_long, MAX(mint_visit.dt) AS dt_max FROM mint_visit INNER JOIN mint_geo ON mint_visit.ip_long = mint_geo.ip WHERE city ” GROUP BY ip_long HAVING dt_max > 1173579394 ORDER BY dt_max DESC LIMIT 0 , 10 MySQL Error (from Location): Unknown column ‘ip_long’ in ‘field list’. (1054) Query: SELECT ip_long, dt FROM mint_visit ORDER BY dt DESC LIMIT 0,0 MySQL Error (from XXX Strong Mint): Unknown column ‘ip_long’ in ‘field list’. (1054) Query: SELECT ip_long, COUNT(‘ip_long’) AS total, MAX(dt) AS dt, MAX(xxx_proxy_ip) AS xxx_proxy_ip, MAX(xxx_hostname) AS xxx_hostname, MAX(xxx_proxy_hostname) AS xxx_proxy_hostname FROM mint_visit GROUP BY ip_long ORDER BY dt DESC LIMIT 0, 19

clupprich
Third-Party Pepper Developer
Posted on Mar 19, '07 at 07:07 am

Secret Crush installed?

You must be logged in to reply. Login above or create an account