I have tried to update from the standard forums to forums plus,
I copied the files across but am unsure how to update my sql tables.
I now have a database error when i try to post, as expected as the tables have not been changed.

any assistance in this matter would be greatly appreciated

Just use the same standard procedure for upgrading any module.

Downloads: Editor's Note wrote:

Install: Copy all files within the download, upgrade module through admin » modules.

There are some other notes within that section that you should also observe.

it now wants to install and but i get a data base error

includes/db/db.php

CMS Warning line 75: On /admin.php?op=modules&install=Forums While executing query "CREATE TABLE scout_cms_bbauth_access ( group_id mediumint(9) NOT NULL default "0", forum_id smallint(6) unsigned NOT NULL default "0", auth_view tinyint(1) NOT NULL default "0", auth_read tinyint(1) NOT NULL default "0", auth_post tinyint(1) NOT NULL default "0", auth_reply tinyint(1) NOT NULL default "0", auth_edit tinyint(1) NOT NULL default "0", auth_delete tinyint(1) NOT NULL default "0", auth_sticky tinyint(1) NOT NULL default "0", auth_announce tinyint(1) NOT NULL default "0", auth_vote tinyint(1) NOT NULL default "0", auth_pollcreate tinyint(1) NOT NULL default "0", auth_attachments tinyint(1) NOT NULL default "0", auth_mod tinyint(1) NOT NULL default "0", auth_download TINYINT(1) NOT NULL DEFAULT "0", KEY group_id (group_id), KEY forum_id (forum_id)) TYPE=MyISAM DEFAULT CHARSET=utf8" the following error occured: Table 'scout_cms_bbauth_access' already exists In: /home/warillas/public_html/includes/classes/installer.php on line: 61

ForumsPlus isn't the problem, at this point of your install.

Your issue is in DF 9.1.2.1 because you're running PHP 5.3 which has dropped ereg().

However, once you get past the installer you will begin to have the same issue with several modules.

You would also have problems with DF 9.2.1 since it still uses the ereg() function.

Thanks for you fast reply. What version of php would you recommend?

Well, usually never the latest because of possible bugs.

In this instance, it must be less than 5.3 since that is when the ereg() issue started. 5.2.11 is stable and safe to use.

We'll have to do something about DF 9.2.1 since that will have issues for people on servers where PHP5 >= 5.3.

I currently use DF10 so no issues, and didn't pick it up prior to that since my servers are on 5.2.11.

Thanks again I will see if my server provider can change my PHP. One thing though I have been running 9.2.1 for a while with this site an this was the first real isssue.

I guess to get the forums back in the mean time I need to roll back to the standard CPG-BB.

Thanks again for your quick assistance

I'm puzzled why you got the error about
Table 'scout_cms_bbauth_access' already exists

ForumsPlus is only an upgrade - it doesn't provide any code that affects, let alone installs, that table - that error would only happen if you were attempting a fresh install over an existing database

The option I have in my admin page is only install no upgrade. I try to go back and uninstall and I can't. Admin page still wants to install.

I copied all the files from 9.2.1. I uploaded a back up of data base and emptied both site and browse cache and still wants to install "Forums CPG Bulletin Board by CPG-Nuke Dev Team and based on phpBB 2.0.x which is released under the GNU GPL"

Not sure what went wrong here?

When you say "uploaded a back up" did you mean the whole database or just forums tables?

The whole database

It's making no sense at all.

If you first restore the original 9.2.1 forum files, then restore your database, it should pick up your original setup, provided you do it in that order.

Thanks, I will try again.

Perhaps your cache is conflicting?
1. maintenance mode
2. restore 9.2.1 forum files
3. restore database
4. delete cache files (aside from htaccess)

After trying again, I have the same results as before.