FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » General » FUDforum in eGroupWare » SQL-Error
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
SQL-Error [message #23015] Fri, 25 February 2005 09:14 Go to next message
yagonna is currently offline  yagonna   Germany
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 Go to previous messageGo to next message
mburr is currently offline  mburr   United States
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 #23472 is a reply to message #23015] Fri, 18 March 2005 09:27 Go to previous messageGo to next message
sanju is currently offline  sanju   India
Messages: 11
Registered: March 2005
Location: Linux World
Karma: 0
Junior Member
me tooo.....
Re: SQL-Error [message #23479 is a reply to message #23472] Fri, 18 March 2005 14:41 Go to previous message
mburr is currently offline  mburr   United States
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?
  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Implementing Fud Forum 2.6.0 in E-GroupWare 1..0.0.006
Next Topic: Attachment problems! Can somebody help?
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Nov 09 16:42:47 GMT 2024

Total time taken to generate the page: 0.02405 seconds