+- Community Support for OpenDocMan (Deprecated) (https://forum.opendocman.com)
+-- Forum: OpenDocMan Community Discussion (https://forum.opendocman.com/forum-5.html)
+--- Forum: OpenDocMan Support - Community Based (https://forum.opendocman.com/forum-6.html)
+--- Thread: MySQL error after new install (/thread-15.html)
MySQL error after new install - Stephen - 01-12-2010
Hi,
I have installed this on a Linux server but it is a remotely hosted server. I don't have SSH access to it but I do have various GUIs I can use. For example, phpMyAdmin and cPanel File Manager.
I had to create the DB manually but there are no tables in there or anything and I have no idea where to start. I have gotten so far as having the initial logon screen, where I'm meant to enter "Admin" as the username but when I do, I get the following error returned:
Error in query: SELECT id, username, password FROM user WHERE username = 'admin' AND password = password(''). Table 'basedesi_opendocman.user' doesn't exist
My database is called "basedesi_opendocman".
If anyone can help me out with this, it would be much appreciated.
Kind regards,
Luke
Re: MySQL error after new install - Stephen - 01-12-2010
Hi,
Exactly the same problem here.
I also would appreciated it much if some could get me back on track.
Thanks in advance.
Kind regards,
Peter
Re: MySQL error after new install - Stephen - 01-12-2010
If I understand your message, it sounds like you manually created the Database; but not the Tables? ODM ships a file named "database.sql" which contains all the SQL commands needed to create the needed tables.
Based on your hosting setup, I don't know if you can run the script or have to use a GUI to create the tables?
jonathanwminer
Re: MySQL error after new install - Stephen - 01-12-2010
Thanks it is up and running
electron7