Menu
▾
▴
#2790 (ok 3.1.1) Re-login causes PMA to forget its current table
1. Use cookie authentication
2. Log in, browse to a table, wait for session to expire.
3. Click on 'insert' tab, re-login
4. enter data to be inserted, and submit
5. PMA forgets which table its working with, resulting in queries like INSERT INTO `dbname`.``(....
Using: Firefox 3.0
Apache/2.2.8 (Win32)
MySQL 5.0.51a
Confirmed.
For 3.0.0, incomplete INSERT statement.
For trunk (revision 11705), incomplete SHOW FULL FIELDS FROM statement
Incomplete queries are due to lines 111-113 of /tbl_replace.php, after relogging $GLOBALS['goto'] == 'db_sql.php' and therefore $GLOBALS['table'] is set to the empty string. Removing line 112 fixed this problem in my test setup, without causing any noticable side effects, however I assume it was put there for a reason at some point, so perhaps this is not the best way to fix this.
Thanks for the hint. I did not touch this code but instead what was incorrectly setting $GLOBALS['goto'] to 'db_sql.php'.