01-13-2010, 12:41 PM
lbelloeil
2005-02-22 06:55:14 PST
After I setup opendocman, I wanted to update admin password and, validating the form, the following message appeared :
Error in query: INSERT INTO dept_reviewer (dept_id,user_id) VALUES('A', )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 ')' at line 1
Where is the second value (user_id) gone ?
logart
2005-02-22 07:55:28 PST
That is a bit strange, since the dept_id should not be set to 'A'. it should be some sort of integer value.
Is this version 1.2p1? Clean install or upgrade?
Can you tell me the exact steps you take to get this error?
lbelloeil
2005-02-22 08:23:05 PST
OpenDocMan v1.2p1
Windows 2003
<!-- m --><a class="postlink" href="http://www.mbu.dyndns.org/phpinfo.php">http://www.mbu.dyndns.org/phpinfo.php</a><!-- m -->
lbelloeil
2005-02-22 08:23:34 PST
New install of OpenDocMan v1.2p1
Windows 2003
<!-- m --><a class="postlink" href="http://www.mbu.dyndns.org/phpinfo.php">http://www.mbu.dyndns.org/phpinfo.php</a><!-- m -->
lbelloeil
2005-02-22 08:26:23 PST
Oups, double post! sorry...
good address is ...":81/phpinfo.php"
lbelloeil
2005-02-22 13:10:54 PST
After a search in the forum it seems to be a session_path problem.
In php.ini :
session_path is m:\PHP\sessiondata
and
TEMP is C:\WINDOWS\TEMP
I need to keep these setting because another php application uses them.
Do Ii have to change them or can I keep these setting?
lbelloeil
2005-02-22 13:59:55 PST
What I did :
Copy files->ok
launch setup. php->ok
iniate database->ok, then return to login page
login as admin without passwd->ok
! menu pictures doesn't appear !!!
edit config.php and set : 'base_url' => '/docman'
-> pictures OK
menu admin/user/update/admin-modify user/
enter new password then update -> Error in query: INSERT INTO dept_reviewer (dept_id,user_id) VALUES('A', )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 ')' at line 1
Here is my story. Do you have a happy end ?
logart
2005-02-28 08:43:37 PST
Please see <!-- m --><a class="postlink" href="https://sourceforge.net/forum/message.php?msg_id=3021196">https://sourceforge.net/forum/message.p ... id=3021196</a><!-- m -->
gahunda
2007-10-11 03:53:28 PDT
Sorry, I can't seem to figure out what's wrong but....
After a new/fresh install, I can't see the menu when I login as admin.
Then I change the url to .../opendocman/out.php and the menu is displayed. I suspect something is wrong with index.php but not sure.
Could someone help me out please!
Thanks.
2005-02-22 06:55:14 PST
After I setup opendocman, I wanted to update admin password and, validating the form, the following message appeared :
Error in query: INSERT INTO dept_reviewer (dept_id,user_id) VALUES('A', )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 ')' at line 1
Where is the second value (user_id) gone ?
logart
2005-02-22 07:55:28 PST
That is a bit strange, since the dept_id should not be set to 'A'. it should be some sort of integer value.
Is this version 1.2p1? Clean install or upgrade?
Can you tell me the exact steps you take to get this error?
lbelloeil
2005-02-22 08:23:05 PST
OpenDocMan v1.2p1
Windows 2003
<!-- m --><a class="postlink" href="http://www.mbu.dyndns.org/phpinfo.php">http://www.mbu.dyndns.org/phpinfo.php</a><!-- m -->
lbelloeil
2005-02-22 08:23:34 PST
New install of OpenDocMan v1.2p1
Windows 2003
<!-- m --><a class="postlink" href="http://www.mbu.dyndns.org/phpinfo.php">http://www.mbu.dyndns.org/phpinfo.php</a><!-- m -->
lbelloeil
2005-02-22 08:26:23 PST
Oups, double post! sorry...
good address is ...":81/phpinfo.php"
lbelloeil
2005-02-22 13:10:54 PST
After a search in the forum it seems to be a session_path problem.
In php.ini :
session_path is m:\PHP\sessiondata
and
TEMP is C:\WINDOWS\TEMP
I need to keep these setting because another php application uses them.
Do Ii have to change them or can I keep these setting?
lbelloeil
2005-02-22 13:59:55 PST
What I did :
Copy files->ok
launch setup. php->ok
iniate database->ok, then return to login page
login as admin without passwd->ok
! menu pictures doesn't appear !!!
edit config.php and set : 'base_url' => '/docman'
-> pictures OK
menu admin/user/update/admin-modify user/
enter new password then update -> Error in query: INSERT INTO dept_reviewer (dept_id,user_id) VALUES('A', )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 ')' at line 1
Here is my story. Do you have a happy end ?
logart
2005-02-28 08:43:37 PST
Please see <!-- m --><a class="postlink" href="https://sourceforge.net/forum/message.php?msg_id=3021196">https://sourceforge.net/forum/message.p ... id=3021196</a><!-- m -->
gahunda
2007-10-11 03:53:28 PDT
Sorry, I can't seem to figure out what's wrong but....
After a new/fresh install, I can't see the menu when I login as admin.
Then I change the url to .../opendocman/out.php and the menu is displayed. I suspect something is wrong with index.php but not sure.
Could someone help me out please!
Thanks.