After I have installed mudbag and try to log in for the first time, I get the following message:
Error in query: select dbname, dblongname, mb_db.db_id from mb_db join mb_user_db using(db_id) where role_id = 1 and user_id = 1 order by dblongname. You have an error in your SQL syntax near 'using(db_id) where role_id = 1 and user_id = 1 order by dblongname' at line 3 (1064)
fix MB_DB.db_query_ext to put this message in a queue
Can anone shed any light on this or do you need more info before identify the problem?
Thanks,
Mike
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
After I have installed mudbag and try to log in for the first time, I get the following message:
Error in query: select dbname, dblongname, mb_db.db_id from mb_db join mb_user_db using(db_id) where role_id = 1 and user_id = 1 order by dblongname. You have an error in your SQL syntax near 'using(db_id) where role_id = 1 and user_id = 1 order by dblongname' at line 3 (1064)
fix MB_DB.db_query_ext to put this message in a queue
Can anone shed any light on this or do you need more info before identify the problem?
Thanks,
Mike
The usual basic info would help immensely: OS and version, MySQL version, PHP version.
Also, one thing to try is to re-install.
I haven't seen this particular problem before, so I'm guessing that it is a configuration or installation issue, rather than a bug in Mudbag itself.
--Marc Rochkind