This is the first issue I have faced with this wonderful looking piece of hard work.
I am not able to create a new forum in forum administration. In firefox it just prompts me to download index2.php and in IE it takes me to the home of joomla administration page.

I have no clue how to deal with it.
Admin, can you please offer some help. Though you advised that it should not be used on production site but I just could not resist it.

thanks in advance for any hint. I have fair knowledge of php and javascript and a small hint to point me in right direction might help me sort it out quickly.

thanks again
joomlafreak

Ok I looked into the database tabele and it seems the auto increment for id is not working. Meaning to say the id is set to 0. I changed the id to the next value in the table and it will let me create one more forum but again will give it an id of 0. So I have to go to database again and give it the next Id. This should be set to auto increment I think.

I will look into the sql query.
Many many thanks again for this beautiful work. I know how much time it takes to write a simple code and for making such a nice component you and your whole team deserve a big hug and and bucks.

Post edited by: joomlafreak, at: 2007/04/19 04:19

Ok found the issue in sql query. The primary key is not defined in sql query along with auto_increment.

I modified the sql query in myphp admin and it is everything under control

Anybody having thhis issue may try this. I take no responsibility if this does screw up your installation so the golder words when dealing with mysql. Make a backup.

Here is what I did. The bold is where I made the changes
CREATE TABLE `jos_fb_categories` (
`id` int(11) NOT NULL auto_increment,
`parent` int(11) default '0',
`name` tinytext,
`cat_emoticon` tinyint(4) NOT NULL default '0',
`locked` tinyint(4) NOT NULL default '0',
`alert_admin` tinyint(4) NOT NULL default '0',
`moderated` tinyint(4) NOT NULL default '0',
`moderators` varchar(15) default NULL,
`pub_access` tinyint(4) default '1',
`pub_recurse` tinyint(4) default '1',
`admin_access` tinyint(4) default '0',
`admin_recurse` tinyint(4) default '1',
`ordering` tinyint(4) NOT NULL default '0',
`future2` int(11) default '0',
`published` tinyint(4) NOT NULL default '0',
`checked_out` tinyint(4) NOT NULL default '0',
`checked_out_time` datetime NOT NULL default '0000-00-00 00:00:00',
`review` tinyint(4) NOT NULL default '0',
`hits` int(11) NOT NULL default '0',
`description` text NOT NULL,
`image` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

May be admin can look into this.

Thanks

Post edited by: joomlafreak, at: 2007/04/19 04:17

O boy. The same problem of auto increment and primary key is there is message table and it cause all the messages to be from the same author on any page.

Solved for me now but I guess admin should look into this ASAP.

Hm... Can you please add it to the tracker. I guess we will go for a quick release

Hi
I did that.
BTW why the forum on your site also keeps showing it as new even though I have read this post before. I have cookie enabled on my notebook. I saw it on my installation on my site also.

These two problems are exactly what I've been having. I couldn't add a new category or forum in admin, it gives me an index2.php error. Now it's making every post look like it's from the same author. Also I started a new thread and it went in the wrong forum and it's mixed with other posts from another. It's a mess.

Yes, I have same problem with Read/Unread posts...after some time all threads are automaticly marked as unread

There is a sql fix for tables, if you have upgraded from JB
please search the forum for it.

it seems you have released a fix as I got message from joomlacode.org on this bug tracker I submitted. I am using it on live site and have posts being made since I installed it. What I am thinking of doing is backup the present FB tables. Uninstall it > reinstall it > change the query in the backup of tables and run this query in mysql. Do you think it would be fine. I am sure you would think...Hey! it should be fine but I take no responsibility. I understand that and I only expect to hear if there is any foreseeable reason you think that this may not be a good way.
Thanks