Creating temporary table redirects to nothing

Bug #958537 reported by Karl Macklin
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
chive
Confirmed
Low
Unassigned

Bug Description

I have a database, 'vgmc_eu'.
I have a table, "user_song_fav".

Table contents the result of this:

insert into user_song_fav values (1, 'A'), (1, 'B'), (1, 'C');
insert into user_song_fav values (2, 'A'), (2, 'B'), (2, 'C'), (2,'D');
insert into user_song_fav values (3, 'X'), (3, 'Y'), (3, 'C'), (3,'Z');
insert into user_song_fav values (4, 'W'), (4, 'Q'), (4, 'C'), (4,'Z');

Is probably irrelevant, however.

Anywho, trying to run this SQL:

CREATE TEMPORARY TABLE test_temporary AS (SELECT * FROM user_song_fav);

But the result is that I get redirected back to the same page, something weird happens redirection-wise.

Using httpfox to capture everything it looks something like this http://pastebin.com/BRjbe0Ug
I can provide more info on a specific post if it helps, I looked through the first suspicious ones and couldn't get any wiser from it.

I first noticed this when I was getting weird Ajax errors, after trying to run a query that first creates a temporary table and then selects stuff from it.
After taking away part by part from the query, it seems a temporary table causes this redirect??

Tried in Firefox and Chrome.
Running Chive on Nginx/PHP-FPM on Debian Squeeze 32bit.

The Nginx server config:
http://pastebin.com/MtZuPSZp
(Sorry that is is not complete in that it doesn't show the included files or any other server configs, but everything else works Nginx/PHP-wise).

Revision history for this message
David Roth (davrot) wrote :

Ah, yep, there is something weird going on.
Have to check that for the next bugfix release, thanks for the report.

Changed in chive:
importance: Undecided → Low
milestone: none → 1.0.4
status: New → Confirmed
David Roth (davrot)
Changed in chive:
milestone: 1.0.4 → 1.1
David Roth (davrot)
Changed in chive:
milestone: 1.1 → none
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.