Hi Massimo, Solved the issue.
The new widget / ajax is looking for a ID in the table. I just added the id to the view, and it works fine! regards Martin On Thu, Nov 17, 2011 at 2:45 PM, Massimo Di Pierro <massimo.dipie...@gmail.com> wrote: > Can you helps us debug? Use chrome, check out the callback url, call > it directly, does it return a ticket? > > On Nov 17, 1:53 am, Ole Martin Maeland <olemael...@gmail.com> wrote: >> Hi Massimo, >> >> upgrade from version 1.89.5 (2010-11-21), so old version. >> >> I have tried to substitute the built in autocomplete with s-cubism >> suggest_widget. It works the same way - no function when I try to read >> from db view, but works fine when directly from db. >> >> regards >> Martin >> >> On Thu, Nov 17, 2011 at 7:47 AM, Massimo Di Pierro >> >> >> >> >> >> >> >> >> >> <massimo.dipie...@gmail.com> wrote: >> > what did you upgrade from? >> >> > On Nov 16, 3:07 pm, Ole Martin Maeland <olemael...@gmail.com> wrote: >> >> Hi, >> >> >> I upgraded web2py to latest version. everything works fine exept the >> >> autocomplete widget >> >> >> I use MySQL as my database. >> >> >> The autocomplete is reading from a db VIEW. The reason for this is >> >> that I have 2 columns in a db: >> >> >> short_name and ISIN that is the name, and ISIN that is the ID. By >> >> doing union select it worked fine until I upgraded. >> >> >> after the upgrade to the latest version it is not recognising the VIEW >> >> as a DB. in my db setup I have set it to be a DB with migrate=False. >> >> >> I have tried to use the widget directly with a DB, and then it works fine. >> >> >> Initially I thought the problem were due to new adapter: pymysql, but >> >> I have changed it using: >> >> >> import MySQLdb >> >> from gluon.dal import MySQLAdapter >> >> MySQLAdapter.driver = MySQLdb >> >> >> but that is not the problem. >> >> >> It does not read the VIEW as a DB anymore.. >> >> >> I have several VIEW's in my DB and it works fine for all other queries.. >> >> >> any idea how to fix it ? >> >> >> regards >> >> martin >> >> -- >> Hilsen >> Ole Martin >> Mob: 95227471 -- Hilsen Ole Martin Mob: 95227471
