Hi
We are having som trouble with the ip/mactracker. Running nav on debian 6.0.7, current nav versjon 3.14.1592653. Suspect the problems came a few versions back. Hopefully someone has a suggestion on what could be wrong. If we search for a mac we get the follow error :
Environment:
Request Method: GET Request URL: http://xxx.karmoy.kommune.no/machinetracker/mac/?mac=000ab7448360&days=7 Django Version: 1.2.3 Python Version: 2.6.6 Installed Applications: ['nav.django'] Installed Middleware: ('django.middleware.common.CommonMiddleware', 'django.contrib.messages.middleware.MessageMiddleware')
Traceback: File "/usr/lib/pymodules/python2.6/django/core/handlers/base.py" in get_response 100. response = callback(request, *callback_args, **callback_kwargs) File "/usr/lib/pymodules/python2.6/nav/web/machinetracker/views.py" in mac_search 164. return mac_do_search(request) File "/usr/lib/pymodules/python2.6/nav/web/machinetracker/views.py" in mac_do_search 216. ip_count = len(arp_result) File "/usr/lib/pymodules/python2.6/django/db/models/query.py" in __len__ 81. self._result_cache = list(self.iterator()) File "/usr/lib/pymodules/python2.6/django/db/models/query.py" in iterator 829. for row in self.query.get_compiler(self.db).results_iter(): File "/usr/lib/pymodules/python2.6/django/db/models/sql/compiler.py" in results_iter 672. for rows in self.execute_sql(MULTI): File "/usr/lib/pymodules/python2.6/django/db/models/sql/compiler.py" in execute_sql 727. cursor.execute(sql, params) File "/usr/lib/pymodules/python2.6/django/db/backends/util.py" in execute 15. return self.cursor.execute(sql, params) File "/usr/lib/pymodules/python2.6/django/db/backends/postgresql_psycopg2/base.py" in execute 44. return self.cursor.execute(query, args)
Exception Type: DatabaseError at /machinetracker/mac/ Exception Value: function array_agg(character varying) does not exist LINE 1: SELECT (SELECT array_to_string(array_agg(DISTINCT name),', '... ^ HINT: No function matches the given name and argument types. You might need to add explicit type casts.
Hilsen Jostein Berge It-konsulent Karmøy Kommune