Simple Subforums

[fpscops.com]

I've tried this mod... but it keeps giving be this error...
And Line 500 controls only the error message ^^;

Couldn't insert row in forums table

DEBUG MODE

SQL Error : 1136 Column count doesn't match value count at row 1

INSERT INTO phpbb_forums (forum_id, forum_name, cat_id, forum_parent, forum_desc, forum_order, forum_status, forum_external, forum_redirect_url, forum_ext_newwin, forum_ext_image, prune_enable, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_sticky, auth_announce, auth_vote, auth_pollcreate) VALUES ('18', 'PC ed Internet', 1, 'Discussioni sul mondo della Tecnologia', 90, 0, 0, '', 0, '', 0, 0, 0, 0, 0, 1, 1, 3, 3, 1, 1)

Line : 500
File : admin_forums.php

Post/pm your admin_forums to me. I'll have a look.

Let me see your index body tiku000990

More than likely just wrong edits.

[DrTofu]

Post/pm your admin_forums to me. I'll have a look.
Let me see your index body tiku000990
More than likely just wrong edits.

Done... and thanks for the help.

I've Forgot some data here...

PhpBB: 2.0.19
PHP: 4.4.2-dev
MySQL: 4.0.26-standard-log
Template: SubSilver

I hope they're just wrong edits so...

[~Mamma_J~]

Thank you this works perfectly.

One small thing. I don't want the subforums at the top of the page of the main forum. What would I need to do to get it at the bottom?

[~Mamma_J~]

Ok I got the modcp too. And one of my mods were going in there to check things out and she got this....

Code: Select all

Couldn not obtain forums information 

DEBUG MODE 

SQL Error : 1109 Unknown table 'f' in field list 

SELECT forum_id, forum_name, f.forum_parent FROM phpbb2_forums ORDER BY cat_id, forum_order 

Line : 38 
File : functions_admin.php 

What do I need to change? It seems to work fine for me.

[groundfighter]

Did you run the sql queries?

[~Mamma_J~]

Yeah, I used easymod. But it works for me and I have moved a few of the forums around. Maybe it is a ModCP issue?

[groundfighter]

I would go check

Line : 38
File : functions_admin.php

see what edits might correspond to the install file.

[walhanharja]

hi people
this is a very very cool mode, but i have a problem, this is my forum

Category 1
-Forum1
--SubForum1
--SubForum2
--SubForum3
-Forum2
--SubForum4
--SubForum5
--SubForum6
-Forum3
--SubForum7
--SubForum8
--SubForum9
-SubForum1
-SubForum2
-SubForum3
-SubForum4
-SubForum5
-SubForum6
-SubForum7
-SubForum8
-SubForum9


understud my problem?

I am install that mode
http://files.phpbbstyles.com/ca/subforu ... ms.004.zip

Im try istall manual, but is big :S

Im think the problem is on index.php or index_body.php, but i dont know

Anyone can help me?
Tanks

I have the same problem, anyone have a fix.

Im running 2.19 with newest version sub-forums 1.01

Here is an example. Everything works great im just getting duplicate categories on my forums index.

http://fpscops.com/forums.php


[edit]

Fixed! Missed a small bit of code.

Code: Select all

#
#-----[ OPEN ]------------------------------------------
#
templates/subSilver/index_body.tpl


#
#-----[ FIND ]------------------------------------------
#
  <!-- BEGIN forumrow -->


#
#-----[ AFTER, ADD ]------------------------------------------
#
  <!-- IF ! forumrow.PARENT -->

[/edit]

I've got the same problem, and i checked your bug fixing, but it seemed to be correct with my forum.
<!-- IF ! forumrow.PARENT --> was there where it was supposed to be
Could there be an other solution ?

[jaygee]

This has probably already been discussed, but Ive been having this problem with this step (the first one).

Code: Select all

#
#-----[ SQL ]------------------------------------------
#
ALTER TABLE phpbb_forums ADD forum_parent INT NOT NULL DEFAULT '0';

I have never altered SQL tables before, but have done plenty of MODs. I just wanted to know what the easiest way to do this would be.

[jaygee]

This has probably already been discussed, but Ive been having this problem with this step (the first one).

Code: Select all

#
#-----[ SQL ]------------------------------------------
#
ALTER TABLE phpbb_forums ADD forum_parent INT NOT NULL DEFAULT '0';

I have never altered SQL tables before, but have done plenty of MODs. I just wanted to know what the easiest way to do this would be.

basically i just dont understand what the 'INT NOT NULL DEFAULT '0'; means

[groundfighter]

You have to go to your mysql database and run the query.

[jaygee]

You have to go to your mysql database and run the query.

alright, that doesnt really help me with my issue...

when i put in forum_parent, what Type/Length/Collation/Attributes/Null/Extra do I put down?

[groundfighter]

You simply copy and paste it into your mysql database and run the query. How does that not help you with your problem?

[jaygee]

You simply copy and paste it into your mysql database and run the query. How does that not help you with your problem?

alright, now im lost... i thought i had to go through phpmyadmin and put in a new table called forum_parent...

this is quite irritating...

[Lord Kestrel]

I'm trying to install this mod for subblack, and it does not contain the " <!-- BEGIN forumrow -->" language anywhere. In fact, it's index_body.tpl looks pretty different from subsilver. Umm what do I do?

Thanks in advance