Forum module development

[alby]

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

[zappodrom]

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

[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

[alby]

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

[alby]

I split this topic because is OT.
For SelfRegistration and PostgreSQL there is a new topic here

Alby

[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

[alby]

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

[urbanroute]

Thanks Alby, I've got version 0.9.0, time for me to upgrade.