Welcome to Pandora FMS Community › Forums › Community support › MYSQL Error
-
MYSQL Error
Posted by mkaylor on July 16, 2008 at 15:03I’m new to Pandora. Had a lot of things that I was confused on so I decided to start over. Did a fresh install and I get this error from the pandora_console.
get_db_all_rows_sql (“SELECT nivel FROM `tusuario` WHERE `id_usuario` = ‘admin’ LIMIT 1 LIMIT 1”) :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 ‘LIMIT 1’ at line 1
Can someone point me to the right direction. I have blown away the database and reinstalled it about 20 times with no luck.
I’m trying to install 1.3.1 on an Ubuntu 8.04 Server.
Thanks for the help,
Mikemanu replied 16 years, 7 months ago 3 Members · 6 Replies -
6 Replies
-
-
-
::
Thanks for the help!!!
I did use the trunk version of 1.3.1. I thought that was the one to use. I will go back and try the other. As far as were I see it on the screen, it says it 7 times under the Operations Menu.
Even though it logs me in OK, It also says this at the bottom of the page:
You don’t have access to this page
No access
Access to this page is restricted to authorized users only, please contact system administrator if you need assistance.
Please know that all attempts to access this page are recorded in security logs of Pandora System Database -
-
-
::
I’m glad you sorted it out!
The trunk version is pretty stable I have to say, but since we’re committing new changes everyday, database schema might change as well as other console things, therefore if you wanna use the trunk version to have the latest things you gotta be careful.Enjoy PandoraFMS!
Manu