I just downloaded and installed the Locations v2.37 Pepper (using Mint 2.16). The Most Common pane is fine, but the Most Recent pane is completely blank. Does anyone have any ideas?
Locations 2.37 "Most Recent" Problem
Disable “Stagger Pane Loading”, select the “Most Recent Tab” and then try using the ?error query command.
Hi Till,
I didn’t even have to use the ?error command. After disabling “Stagger Pane Loading”, I returned to the main Mint panel and had the following error message at the top:
MySQL Error (from Locations): 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 ’ country_code FROM mint_visit ORDER BY dt DESC LIMIT 0, 18’ at line 1. (1064) Query: SELECT dt, ip_long,, country_code FROM mint_visit ORDER BY dt DESC LIMIT 0, 18
I encountered the exact same problem as Mark.
There seems to be a syntax error in this SQL query (double commas):
SELECT dt, ip_long,, country_code FROM mint_visit ORDER BY dt DESC LIMIT 0, 18
I did run the ?errors query and this is what I got:
Notice: Undefined index: 20 in /home/veron/public_html/mint/app/lib/mint.php on line 1791
Notice: Undefined index: 20 in /home/veron/public_html/mint/app/lib/mint.php on line 1792
Notice: Undefined index: 20 in /home/veron/public_html/mint/app/lib/mint.php on line 1793
Notice: Undefined index: 21 in /home/veron/public_html/mint/app/lib/mint.php on line 1791
Notice: Undefined index: 21 in /home/veron/public_html/mint/app/lib/mint.php on line 1792
Notice: Undefined index: 21 in /home/veron/public_html/mint/app/lib/mint.php on line 1793
any help would be much appreciated! Thanks in advance.
You must be logged in to reply. Login above or create an account