Page 5 of 5

Re: Forum module development

Posted: Tue Apr 29, 2008 11:46 am
by alby
zappodrom wrote:
alby wrote:
Tomorrow I check FMS module and I say you which files you must edit after other modules, you must test this patchs and report  :)

Alby
No problem. :)

Perhaps  I'm on vacation for two days. So don't worry for a delay of my answers.
Rename attach file from .mpg to .zip
Uncompress file and from Forum folder apply patch:
patch < /path/Forum.diff

Alby

Re: Forum module development

Posted: Wed Apr 30, 2008 6:06 am
by zappodrom
alby wrote:
Rename attach file from .mpg to .zip
Uncompress file and from Forum folder apply patch:
patch < /path/Forum.diff

Alby
Hi Alby,

I did apply the patch and in the backend everything seems to be ok. But joining the forum at the frontend in debug mode offers me this errormessage:

Code: Select all

Debug: (0,909444) - (10353256)

<br>
(postgres7): SELECT * FROM module_feusers_belongs WHERE userid='f'<br>
 Error (ERROR:  invalid input syntax for integer: "f"): ERROR:  invalid input syntax for integer: "f"<br>
It seems to be a bug in the FEU module. Is there a chance to get this solved? Maybe it's better to open a new thread for this Problem?

Regards
Zappodrom

Re: Forum module development

Posted: Wed Apr 30, 2008 9:31 am
by zappodrom
Hi alby, me again :)

Some other error I discoverd after logged into the frontend to show the forums.

Code: Select all

Debug: (3,011592) - (11846196)

<br>
(postgres7): SELECT f.id, f.name, f.description, COUNT(t.id) as topic_count
  FROM module_forum_forums f LEFT JOIN module_forum_topics t ON f.id = t.forum_id
  GROUP BY f.id, f.name, f.description
  ORDER BY f.position, f.name<br>
 Error (ERROR:  column "f.position" must appear in the GROUP BY clause or be used in an aggregate function): ERROR:  column "f.position" must appear in the GROUP BY clause or be used in an aggregate function<br>
No forum will be displayed on the frontend until I substitute

Code: Select all

$sql = "SELECT f.id, f.name, f.description, COUNT(t.id) as topic_count
        FROM ".cms_db_prefix()."module_forum_forums f LEFT JOIN ".cms_db_prefix()."module_forum_topics t ON f.id = t.forum_id
        GROUP BY f.id, f.name, f.description
        ORDER BY f.position, f.name";
with

Code: Select all

$sql = "SELECT f.id, f.name, f.description, COUNT(t.id) as topic_count
        FROM ".cms_db_prefix()."module_forum_forums f LEFT JOIN ".cms_db_prefix()."module_forum_topics t ON f.id = t.forum_id
        GROUP BY f.id, f.name, f.description, f.position
        ORDER BY f.position, f.name";
So, the forums displayed on the frontend. But adding a new topic fails! Here's the message that occured:

Code: Select all

Debug: (2,553122) - (11779564)

<br>
(postgres7): INSERT INTO module_forum_topics
  (id, forum_id, last_post_id, poster_id, subject, closed, sticky, views)
  VALUES ('2',1,-1,'3','Endlich wieder Offroad&#33;','f',0,0)<br>
 Error (ERROR:  invalid input syntax for integer: "f"): ERROR:  invalid input syntax for integer: "f"<br>
Regards,
Christian

Re: Forum module development

Posted: Wed Apr 30, 2008 10:12 am
by alby
zappodrom wrote: Hi alby, me again :)
Backup your Forum module folder and substitute with this version

For

Code: Select all

Debug: (0,909444) - (10353256)

<br>
(postgres7): SELECT * FROM module_feusers_belongs WHERE userid='f'<br>
 Error (ERROR:  invalid input syntax for integer: "f"): ERROR:  invalid input syntax for integer: "f"<br>
perhaps due to a lack of control


Alby

Re: Forum module development

Posted: Fri May 02, 2008 8:37 am
by alby
I split this topic because is OT.
For SelfRegistration and PostgreSQL there is a new topic here

Alby

Re: Forum module development

Posted: Mon Jun 02, 2008 5:30 pm
by urbanroute
Hi everyone,

I see that form made simple allows captcha when signing in and signing up through Front End users but what about on each post? I'd like to reduce the spam messages by using captcha on each post / reply. Anyone know how this is done?

I was also interested in turning off 'allow guest posting' but that seems to turn the entire forum private vs forcing users to sign in before posting.

Thanks,
Ryan

Re: Forum module development

Posted: Mon Jun 02, 2008 9:43 pm
by alby
urbanroute wrote: I see that form made simple allows captcha when signing in and signing up through Front End users but what about on each post? I'd like to reduce the spam messages by using captcha on each post / reply. Anyone know how this is done?
5 June come out 0.9.2 with:
- Report to moderator
- Full moderator: published post on approve from moderator only

Alby

Re: Forum module development

Posted: Mon Jun 02, 2008 9:46 pm
by urbanroute
Thanks Alby, I've got version 0.9.0, time for me to upgrade.