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

Home » General » FUDforum in eGroupWare » SQL-Error
Show: Today's Messages :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
Switch to threaded view of this topic Create a new topic Submit Reply
SQL-Error [message #23015] Fri, 25 February 2005 04:14 Go to next message
yagonna is currently offline  yagonna   Germany
Messages: 3
Registered: February 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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] Thu, 17 March 2005 22:51 Go to previous messageGo to next message
mburr is currently offline  mburr   United States
Messages: 2
Registered: March 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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: Thu, 17 March 2005 22:52]

Report message to a moderator

Re: SQL-Error [message #23472 is a reply to message #23015] Fri, 18 March 2005 04: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
add to buddy list
ignore all messages by this user
me tooo.....
Re: SQL-Error [message #23479 is a reply to message #23472] Fri, 18 March 2005 09:41 Go to previous message
mburr is currently offline  mburr   United States
Messages: 2
Registered: March 2005
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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?
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Fri Oct 20 12:21:08 EDT 2017

Total time taken to generate the page: 0.00536 seconds