[Phpmyadmin-devel] Error when opening phpmyadmin db
Whenever I try to browse the phpmyadmin db i get the following error: SELECT tracking_active FROM.WHERE `db_name` = 'phpmyadmin' AND `table_name` = 'pma_bookmark' ORDER BY version DESC MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `db_name` = 'phpmyadmin' AND `table_name` = 'pma_bookmark' ORDER BY vers' at line 1 --- Now I looked into the code and saw the culprit is Tracker.class.php in function init() where self::$pma_table is set. At that point $GLOBALS['cfg']['Server']['pmadb'] and ['tracking'] is just empty. Anyone know why?
Tyron Madlener a écrit :
Whenever I try to browse the phpmyadmin db i get the following error:
Tyron, what do you mean "browse the phpmyadmin db"? Go on its structure page? Browse a table in it? I have no problem doing this, on master (my server or demo) or my copy of your tree.
SELECT tracking_active FROM.WHERE `db_name` = 'phpmyadmin' AND `table_name` = 'pma_bookmark' ORDER BY version DESC
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `db_name` = 'phpmyadmin' AND `table_name` = 'pma_bookmark' ORDER BY vers' at line 1
--- Now I looked into the code and saw the culprit is Tracker.class.php in function init() where self::$pma_table is set. At that point $GLOBALS['cfg']['Server']['pmadb'] and ['tracking'] is just empty. Anyone know why?
-- Marc Delisle http://infomarc.info
On Fri, Jul 29, 2011 at 2:34 PM, Marc Delisle <marc@infomarc.info> wrote:
Tyron Madlener a écrit :
Whenever I try to browse the phpmyadmin db i get the following error:
Tyron, what do you mean "browse the phpmyadmin db"? Go on its structure page? Browse a table in it?
I have no problem doing this, on master (my server or demo) or my copy of your tree.
Yes the structure. It's when I click on the phpmyadmin db in the navigation frame. And yea I forgot to mention that I have the problem only on my local pma installation, on the demo server it works fine. I just updated & merged my repo again and the problem still persists. Got any clues how I could find the problem?
SELECT tracking_active FROM.WHERE `db_name` = 'phpmyadmin' AND `table_name` = 'pma_bookmark' ORDER BY version DESC
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `db_name` = 'phpmyadmin' AND `table_name` = 'pma_bookmark' ORDER BY vers' at line 1
--- Now I looked into the code and saw the culprit is Tracker.class.php in function init() where self::$pma_table is set. At that point $GLOBALS['cfg']['Server']['pmadb'] and ['tracking'] is just empty. Anyone know why?
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Tyron Madlener a écrit :
On Fri, Jul 29, 2011 at 2:34 PM, Marc Delisle <marc@infomarc.info> wrote:
Tyron Madlener a écrit :
Whenever I try to browse the phpmyadmin db i get the following error: Tyron, what do you mean "browse the phpmyadmin db"? Go on its structure page? Browse a table in it?
I have no problem doing this, on master (my server or demo) or my copy of your tree.
Yes the structure. It's when I click on the phpmyadmin db in the navigation frame. And yea I forgot to mention that I have the problem only on my local pma installation, on the demo server it works fine.
I just updated & merged my repo again and the problem still persists. Got any clues how I could find the problem?
Do you also have the problem on your local server with origin/master (the sourceforge.net repo) ? Did you try closing all browser windows and start again?
SELECT tracking_active FROM.WHERE `db_name` = 'phpmyadmin' AND `table_name` = 'pma_bookmark' ORDER BY version DESC
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `db_name` = 'phpmyadmin' AND `table_name` = 'pma_bookmark' ORDER BY vers' at line 1
--- Now I looked into the code and saw the culprit is Tracker.class.php in function init() where self::$pma_table is set. At that point $GLOBALS['cfg']['Server']['pmadb'] and ['tracking'] is just empty. Anyone know why?
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
------------------------------------------------------------------------------ Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Marc Delisle http://infomarc.info
On Fri, Jul 29, 2011 at 7:55 PM, Marc Delisle <marc@infomarc.info> wrote:
Tyron Madlener a écrit :
On Fri, Jul 29, 2011 at 2:34 PM, Marc Delisle <marc@infomarc.info> wrote:
Tyron Madlener a écrit :
Whenever I try to browse the phpmyadmin db i get the following error: Tyron, what do you mean "browse the phpmyadmin db"? Go on its structure page? Browse a table in it?
I have no problem doing this, on master (my server or demo) or my copy of your tree.
Yes the structure. It's when I click on the phpmyadmin db in the navigation frame. And yea I forgot to mention that I have the problem only on my local pma installation, on the demo server it works fine.
I just updated & merged my repo again and the problem still persists. Got any clues how I could find the problem?
Do you also have the problem on your local server with origin/master (the sourceforge.net repo) ?
Did you try closing all browser windows and start again?
Yes, this seems to have fixed it. Thanks.
SELECT tracking_active FROM.WHERE `db_name` = 'phpmyadmin' AND `table_name` = 'pma_bookmark' ORDER BY version DESC
MySQL said:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `db_name` = 'phpmyadmin' AND `table_name` = 'pma_bookmark' ORDER BY vers' at line 1
--- Now I looked into the code and saw the culprit is Tracker.class.php in function init() where self::$pma_table is set. At that point $GLOBALS['cfg']['Server']['pmadb'] and ['tracking'] is just empty. Anyone know why?
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
------------------------------------------------------------------------------ Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
-- Marc Delisle http://infomarc.info
------------------------------------------------------------------------------ Got Input? Slashdot Needs You. Take our quick survey online. Come on, we don't ask for help often. Plus, you'll get a chance to win $100 to spend on ThinkGeek. http://p.sf.net/sfu/slashdot-survey _______________________________________________ Phpmyadmin-devel mailing list Phpmyadmin-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/phpmyadmin-devel
Hi Dne Mon, 1 Aug 2011 18:53:43 +0300 Tyron Madlener <tyronx@gmail.com> napsal(a):
On Fri, Jul 29, 2011 at 7:55 PM, Marc Delisle <marc@infomarc.info> wrote:
Did you try closing all browser windows and start again?
Yes, this seems to have fixed it. Thanks.
All pmadb related things are cached in session causing occasionally such problems. I think there is even bug report for such behavior. -- Michal Čihař | http://cihar.com | http://blog.cihar.com
participants (3)
-
Marc Delisle -
Michal Čihař -
Tyron Madlener