"Too many values to unpack" using Django 1.6

[8one6]

Hi. Just tried this out on Django 1.6 and started getting ValueError Too many values to unpack all over the place. Downgrading to Django 1.5 fixed the issue.

Any sense of how core the source of the error is? I can try to provide more context if necessary, but needed to just "fix it" tonight, which I did by downgrading Django.

[dlo]

Thanks for the heads-up...I can't think off the top of my head what could be the source of this issue, but I can look into it. Did you happen to save a traceback?

[benmehlman]

I am currently trying to get it to work on 1.6.. The error you got is due to the following code in compiler.py

ordering, ordering_group_by = self.get_ordering()

In django 1.6, get_ordering() returns three values. I fixed that error by changing all the calls to get_ordering(), to this (in django_pyodbc/compiler.py)

ordering, o_params, ordering_group_by = self.get_ordering()

I do not know what o_params is for, I just ignore it.. which isn't good. But I'm hoping that pyodbc doesn't need it :)

But unfortunately, that's not the only problem. Now I am hung up on the next problem.. also in compiler.py, there are quite a few references to:

self.query.ordering_aliases

The query object in 1.6 has no ordering_aliases property.

Going off a hint I found online, I tried to change this to:

self.ordering_aliases

But that is a long shot.. and it still doesn't work. I really don't know what ordering_aliases are or where they come from.. and it will take me a long time to figure out. I'm an experienced programmer (30+ years) but only 6+ weeks with python and django.. so have not really had the time to learn how the db backend works too much.

But as far as the first problem goes, I'm pretty confident that my solution is ok.

-Ben

[benmehlman]

I should mention.. isql works, manage.py inspectdb works.. so the driver is loading, everything's configured correctly.. it just blows up when you try to do a query.

[vidz1979]

benmehlman... fork the project on github and upload your work, so other people can help you on this.

[dlo]

@benmehlman if you're interested in contributing, I can just give you the commit bit to this repo. I just don't have the time right now to dig into the problem in more detail.

[tax]

I believe this can also be closed. If not please reopen.