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!','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.