Can you please post your model?
On Oct 2, 9:20 am, Sundar <suns...@gmail.com> wrote: > I have a similar situation. > > My table, say, Purchase Order contains two fields: client, endclient. > The client ID from the Clients table is the foreign key for both. > > For the above table, when I try AppAdmin, I get the broken reference > error. > > I think that two fields in a single table both referring to another > table could cause this problem. > > In fact, even my select (db().select()) on this table, with > appropriate with_alias causes the same error if I try a view. Do you > know how I solve that? I create the db().select() and capture the > lastsql and execute it as direct sql and that seems to work! > > Any inputs are welcome. I think you can quickly recreate the > situation. If you need the full code from me, let me know. > > Regards. > > Sundar > > On Sep 26, 11:16 pm, weheh <richard_gor...@verizon.net> wrote: > > > Massimo, as I said, there are 2 processes. The background process is a > > queueing engine. The queue is doing stuff like you describe: creating > > and deleting records and writing out to a log file. However, the queue > > is running just fine and doesn't have the "print a.xxx" statement that > > you flag as the culprit above. > > > The problem is with the "show()" controller function that outputs to > > the browser a display of the current status of the queue. All it does > > is create an SQLTable from a query and then display the results in a > > view. The queue and show processes are completely separate. > > > Any more thoughts? > > > On Sep 26, 9:57 am, mdipierro <mdipie...@cs.depaul.edu> wrote: > > > > somehow you are doing something like this > > > > a=db.mytable.insert(myfield='xxx') > > > del db.mytable[a] > > > print a.xxx ### <<< your error > > > > The problem should only exist if the three statements happen in the > > > same process because of transactions. > > > > On Sep 26, 3:38 am, weheh <richard_gor...@verizon.net> wrote: > > > > > File "C:\web2py\gluon\sql.py", line 1501, in __allocate > > > > raise RuntimeError, "Using a recursive select but encountered a > > > >brokenreference" > > > > RuntimeError: Using a recursive select but encountered abroken > > > >reference > > > > > I encountered this problem trying to do a select and display in the > > > > browser, while simultaneously running a background job that updates > > > > the db. If I refresh the browser, sometimes I get the error and > > > > sometimes I don't. Seems like a locking problem. I am not using a cron > > > > task. I am running a separate python web2py.py using the -S -M and -R > > > > options. > >