Problem with Forum/PhpBB plugin

[hgoor]

Hi,

I have installed the Forum/phpBB plugin, but somehow I can not create a forum; I do get the option to do so, but after I submit it, it does not create it, instead it says again "No boards defined!"

How can I solve this??

[garvinhicking]

Hi!

Can you check if the serendipity_forum database table was created?

Regards,
Garvin

[hgoor]

Hi!

Can you check if the serendipity_forum database table was created?

Regards,
Garvin

Just had a look using PHP MyAdmin and I do not see this table at all. So it seems it's not created somehow.

I have used other plugins that create their own databases (download manager plugin for instance)....

What should I do? Create it by hand?

[garvinhicking]

Hi!

Sorry, the table is called serendipity_dma_forum_boards, _threads, _posts.

Regards,
Garvin

[hgoor]

Hi!

Sorry, the table is called serendipity_dma_forum_boards, _threads, _posts.

Regards,
Garvin

Nope, no sign of those either.....

[garvinhicking]

Hi!

Hm...and you installed the plugin as usual through the s9y panel, right? Which MySQL version are you using?

Regards,
Garvin

[hgoor]

Hi!

Hm...and you installed the plugin as usual through the s9y panel, right? Which MySQL version are you using?

Regards,
Garvin

Yes I used SPARTACUS (best invention ever!!).. MySQL version is 4.1.22

[garvinhicking]

Can you try to run this SQL in phpmyadmin:

Code: Select all

CREATE TABLE serendipity_dma_forum_boards (
                        boardid int(11) not null auto_increment primary key                ,
                        name                    varchar(80) NOT NULL    default '',
                        description             varchar(250) NOT NULL   default '',
                        sortorder               int(10)         NOT NULL        default '0',
                        threads                 int(10)         NOT NULL        default '0',
                        posts                   int(10)         NOT NULL        default '0',
                        views                   int(10)         NOT NULL        default '0',
                        flag                    int(1)          NOT NULL        default '0',
                        lastauthorid    int(10)         NOT NULL        default '0',
                        lastauthorname  varchar(48)     NOT NULL        default '',
                        lastthreadid    int(10)         NOT NULL        default '0',
                        lastpostid              int(10)         NOT NULL        default '0',
                        lastposttime    int(10)         NOT NULL        default '0'
                )

Regards,
Garvin

[hgoor]

Can you try to run this SQL in phpmyadmin:
Regards,
Garvin

Will try that later tonight and let you know what happens: thank you VERY much for the assistance!!

[hgoor]

Can you try to run this SQL in phpmyadmin:
Regards,
Garvin

Garvin, thanks a lot: you're the best!

I ran your code and that did the trick; any idea why the installation didn't do this on it's own? Other plugins I used never failed to create the necessary tables?

[hgoor]

Garvin, thanks a lot: you're the best!

I ran your code and that did the trick; any idea why the installation didn't do this on it's own? Other plugins I used never failed to create the necessary tables?

Oops.. too soon: I get this error when I click "New thread"

Fatal error: Cannot use string offset as an array in /home/vandegoo/public_html/plugins/serendipity_event_forum/serendipity_event_forum.php on line 1461

btw: How do I attach a screenshot of my database?

[garvinhicking]

Hi!

Yes, you are missing more than one table. The forum plugin creates more than one table. You'll need to create the other missing ones as well. I don't know why they didn'T created for you, it worked here for me. Maybe you earlier had the forum plugin installed and removed it at some point or dropped the tables?

Anyways, the SQL statements you need are inside serendipity_event_forum. I have no time now to convert them to pure SQL code (it contains variables), but if you don't manage it on your own I'll help you next Monday or Tuesday.

To attach a screenshot here you need to upload it at a place like flickr or other public image hosting services...

Regards,
Garvin

[hgoor]

Hi!

Yes, you are missing more than one table. The forum plugin creates more than one table. You'll need to create the other missing ones as well. I don't know why they didn'T created for you, it worked here for me. Maybe you earlier had the forum plugin installed and removed it at some point or dropped the tables?

Anyways, the SQL statements you need are inside serendipity_event_forum. I have no time now to convert them to pure SQL code (it contains variables), but if you don't manage it on your own I'll help you next Monday or Tuesday.

To attach a screenshot here you need to upload it at a place like flickr or other public image hosting services...

Regards,
Garvin

Garvin,

I solved this in another way; just deinstalled and re-installed the plugin and for whatever reason it worked then and created all tables including a "test" table with a test forum.

However; yet again I stumbled upon a problem with this plugin: I can not post anything because it keeps telling me the captcha I entered was invalid (which it wasn't). It's very annoying.

Just to clarify why I am messing around with it: I want to host another S9y blog for a friend of mine who runs a semi-political organization and especially the integration of the blog with phpBB2 is interesting because a discussion forum has so much better tools for discussions than a blog (also in terms of moderation etc).

But first I want to be able to run this plugin without a link to phpBB...

[garvinhicking]

Hi!

whats your forum url?

regards,
garvin