01-13-2010, 11:36 AM
libsys
2004-10-20 20:31:18 PDT
I've installed Opendocman under Fedora Core 2, Apache 1.3, Mysql 4, and PHP 4. I have the admin user set up and I can log in with this account.
I have set up a couple of other users, but when I try to update their passwords, I get the following error:
"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"
I've since discovered that this only happens if I have the "admin" option toggled when I update the user.
My colleague has also received sql errors when doing other tasks, although he couldn't remember what he was doing at the time unfortunately. He thinks it may have had something to do with checking in/out documents.
I've made sure the file permissions on the opendoc files/directories are correct, and that they are chowned/chgrped to the apache user and group.
I'm not too sure what the problem is - has anyone else encountered this issue?
Regards,
Guy Knights
benmikael
2005-02-25 02:38:38 PST
Same exact error message for me.
I'm running ODM 1.2p1, PHP 4.3.10, MySQL 4.1.9, Apache 1.3.33, FreeBSD 4.11 on the server; Firefox 1.0, OS X 10.3.8 on the client.
I'm willing to try some other things to help troubleshoot this, if anyone has some good ideas.
Thanks,
MIKA-EL
logart
2005-02-28 08:41:31 PST
I tried to duplicate this issue:
MySQL v4.1.7
php 4.3.10
apache 2.0.51
odm v1.2p1
* I did a clean install
* Added a test user (non-admin).
* Updated the new user's password and check the admin box
* Submit
No problems. Am I doing something different than you were when yoreceived your error?
steve
helmutmk
2005-04-09 08:34:38 PDT
I have the same problem after the installation of 1.2p1. I have use the change logart:
I delete this lines :
// Check to see if user is admin
$query = "SELECT admin FROM admin WHERE id = '" . $_SESSION['uid'] . "' and admin = '1'";
$result = mysql_query($query, $GLOBALS['connection']) or die ("Error in query: $query. " . mysql_error());
if(mysql_num_rows($result) <= 0)
{
header('Location:' . $secureurl->encode('error.php?ec=4'));
exit;
}
I connect as a User
modify the password
select the button update user
Result is
You are not an administrator.back
If I login as admin the program is working fine.
Any body can help?
Best regards
Helmut
logart
2005-04-09 10:07:48 PDT
There is a patch for this issue:
<!-- m --><a class="postlink" href="https://sourceforge.net/tracker/index.php?func=detail&aid=1160981&group_id=69505&atid=524753">https://sourceforge.net/tracker/index.p ... tid=524753</a><!-- m -->
2004-10-20 20:31:18 PDT
I've installed Opendocman under Fedora Core 2, Apache 1.3, Mysql 4, and PHP 4. I have the admin user set up and I can log in with this account.
I have set up a couple of other users, but when I try to update their passwords, I get the following error:
"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"
I've since discovered that this only happens if I have the "admin" option toggled when I update the user.
My colleague has also received sql errors when doing other tasks, although he couldn't remember what he was doing at the time unfortunately. He thinks it may have had something to do with checking in/out documents.
I've made sure the file permissions on the opendoc files/directories are correct, and that they are chowned/chgrped to the apache user and group.
I'm not too sure what the problem is - has anyone else encountered this issue?
Regards,
Guy Knights
benmikael
2005-02-25 02:38:38 PST
Same exact error message for me.
I'm running ODM 1.2p1, PHP 4.3.10, MySQL 4.1.9, Apache 1.3.33, FreeBSD 4.11 on the server; Firefox 1.0, OS X 10.3.8 on the client.
I'm willing to try some other things to help troubleshoot this, if anyone has some good ideas.
Thanks,
MIKA-EL
logart
2005-02-28 08:41:31 PST
I tried to duplicate this issue:
MySQL v4.1.7
php 4.3.10
apache 2.0.51
odm v1.2p1
* I did a clean install
* Added a test user (non-admin).
* Updated the new user's password and check the admin box
* Submit
No problems. Am I doing something different than you were when yoreceived your error?
steve
helmutmk
2005-04-09 08:34:38 PDT
I have the same problem after the installation of 1.2p1. I have use the change logart:
I delete this lines :
// Check to see if user is admin
$query = "SELECT admin FROM admin WHERE id = '" . $_SESSION['uid'] . "' and admin = '1'";
$result = mysql_query($query, $GLOBALS['connection']) or die ("Error in query: $query. " . mysql_error());
if(mysql_num_rows($result) <= 0)
{
header('Location:' . $secureurl->encode('error.php?ec=4'));
exit;
}
I connect as a User
modify the password
select the button update user
Result is
You are not an administrator.back
If I login as admin the program is working fine.
Any body can help?
Best regards
Helmut
logart
2005-04-09 10:07:48 PDT
There is a patch for this issue:
<!-- m --><a class="postlink" href="https://sourceforge.net/tracker/index.php?func=detail&aid=1160981&group_id=69505&atid=524753">https://sourceforge.net/tracker/index.p ... tid=524753</a><!-- m -->