Page 1 of 1
Problem with Forum/PhpBB plugin
Posted: Wed Nov 28, 2007 11:23 pm
by 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??
Re: Problem with Forum/PhpBB plugin
Posted: Thu Nov 29, 2007 1:35 pm
by garvinhicking
Hi!
Can you check if the serendipity_forum database table was created?
Regards,
Garvin
Re: Problem with Forum/PhpBB plugin
Posted: Thu Nov 29, 2007 2:17 pm
by hgoor
garvinhicking wrote: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?
Re: Problem with Forum/PhpBB plugin
Posted: Thu Nov 29, 2007 2:19 pm
by garvinhicking
Hi!
Sorry, the table is called serendipity_dma_forum_boards, _threads, _posts.
Regards,
Garvin
Re: Problem with Forum/PhpBB plugin
Posted: Thu Nov 29, 2007 2:22 pm
by hgoor
garvinhicking wrote:Hi!
Sorry, the table is called serendipity_dma_forum_boards, _threads, _posts.
Regards,
Garvin
Nope, no sign of those either.....
Re: Problem with Forum/PhpBB plugin
Posted: Thu Nov 29, 2007 2:23 pm
by garvinhicking
Hi!
Hm...and you installed the plugin as usual through the s9y panel, right? Which MySQL version are you using?
Regards,
Garvin
Re: Problem with Forum/PhpBB plugin
Posted: Thu Nov 29, 2007 2:36 pm
by hgoor
garvinhicking wrote: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
Re: Problem with Forum/PhpBB plugin
Posted: Thu Nov 29, 2007 4:48 pm
by 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
Re: Problem with Forum/PhpBB plugin
Posted: Thu Nov 29, 2007 5:30 pm
by hgoor
garvinhicking wrote: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!!
Re: Problem with Forum/PhpBB plugin
Posted: Thu Nov 29, 2007 11:12 pm
by hgoor
garvinhicking wrote: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?
Re: Problem with Forum/PhpBB plugin
Posted: Thu Nov 29, 2007 11:17 pm
by hgoor
hgoor wrote:
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?
Re: Problem with Forum/PhpBB plugin
Posted: Fri Nov 30, 2007 5:03 pm
by 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
Re: Problem with Forum/PhpBB plugin
Posted: Sun Dec 02, 2007 10:38 am
by hgoor
garvinhicking wrote: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...
Re: Problem with Forum/PhpBB plugin
Posted: Sun Dec 02, 2007 4:12 pm
by garvinhicking
Hi!
whats your forum url?
regards,
garvin