Creating temporary table redirects to nothing
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://
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://
(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).
Changed in chive: | |
milestone: | 1.0.4 → 1.1 |
Changed in chive: | |
milestone: | 1.1 → none |
Ah, yep, there is something weird going on.
Have to check that for the next bugfix release, thanks for the report.