SQL-Error [message #23015] |
Fri, 25 February 2005 09:14 |
|
yagonna
Messages: 3 Registered: February 2005
Karma: 0
|
Junior Member |
|
|
Hi folks,
we are using eGW 1.0.0.006 and having a problem, trying to access the fudforum. This problem occurs not for all of our users, but for some of them. If they try to access the forum, the get an empty (blank) page. No error message and no output. In the SQL-Error-Log I can see the following:
(/var/lib/egroupware/fudforum/work/index.php:131
/var/lib/egroupware/fudforum/work/index.php:205
/var/lib/egroupware/fudforum/work/index.php:274
/var/lib/egroupware/fudforum/work/index.php:392
) 1064: 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 ' '36791cc9c72eaf147a4c6d9ef7562c76', 1109321627)' at line 1
Query: INSERT INTO phpgw_fud_ses (user_id, ses_id, time_sec) VALUES(, '36791cc9c72eaf147a4c6d9ef7562c76', 1109321627)
Server Version: 4.0.23_Debian-1-log
While searching for the users, that cannot access, using the Moderator/User Manager in fudforum, I can't find them.
Any hints, how to fix this problem are welcome.
TIA
YaGonna
|
|
|
Re: SQL-Error [message #23470 is a reply to message #23015] |
Fri, 18 March 2005 03:51 |
mburr
Messages: 2 Registered: March 2005
Karma: 0
|
Junior Member |
|
|
I'd love to know the solution to this. I have exactly the same problem.
Using Debian Sarge with:
egroupware-core 1.0.00.006-1.dfsg-1
egroupware-fudforum 1.0.00.006-1.dfsg-1
postgresql 7.4.7-2
Using pam authentication for egroupware against a Windows domain, with winbind.
The users that I created while egroupware was configured to authenticate against the local postgresql database can access fudforum.
Help.
[Updated on: Fri, 18 March 2005 03:52] Report message to a moderator
|
|
|
|
Re: SQL-Error [message #23479 is a reply to message #23472] |
Fri, 18 March 2005 14:41 |
mburr
Messages: 2 Registered: March 2005
Karma: 0
|
Junior Member |
|
|
The only thing I can determine so far is that "egrw_fud_users" (not exaclty the table name), does not get populated with PAM authenticated users. The trick I think is getting that table populated. I still haven't figured out how that is supposed to happen... for any users PAM authenticated or otherwise.
Let me know if you find anything out. I'm considering submitting a bug to the package maintainer. Are you using Debian Sarge?
|
|
|