I'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, Mike
MYSQL Error
mkaylor · 16 jul 2008, 15:03 · 7 mensajes · 63 visitas
- Inicio del debate
Is that the official 1.3.1 tar.gz or it is the trunk/ version?
I have searched in ALL the code the "LIMIT 1 LIMIT 1" string and haven't found anything, so, I don't know why it is duplicated. Where do you see the
get_db_all_rows_sql ("SELECT nivel FROM `tusuario` WHERE `id_usuario` = 'admin' LIMIT 1 LIMIT 1"):....Error?
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
Hi, Keep in mind we're working everyday in the trunk version (for instance today several commits have been done), so you might want to "svn update" or just download the official and stable 1.3.1 and play with it till the 2.0 is released. You choose :-)
I think that was my mistake. I downloaded the stable version, reinstalled and it all works now. I thought the trunk version was the stable version. Thanks for the help!! Please keep up the great work!! Mike
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
Entra en tu cuenta para publicar.
