| Author |
Message |
Chapter 24
Board Member
Joined: 30 Dec 2008
Posts: 48
|
 Posted: Sat Apr 04, 2009 11:06 pm
Post subject: Re: moving forum hosting |
|
|
| rapidyellow wrote: |
Now, users of my "old" forum will no doubt have set it to their favourites, currently that forum is set as "disabled" from the configuration page, apart from a link on the main site that the forum is to do with, how do I let them all know the address has changed?
A "mass" PM/Email? to members?
|
What I did is to hide all of the forums and create a new category/forum entitled "We Have Moved" or something like that and for the description you can say "please visit us at our new location" and include the new URL. You can also post a clickable link to the new location in a locked topic inside that forum.
I left it like that for several months (also made it so no new members could sign up there by putting an asterisk * in the "disallow names" field in the configuration section.
If you are sure you won't be needing that old forum again, you could also simply delete all of the forum sections along with the memberlist (except for yourself, of course  ), so that the only thing left there is the locked "we have moved" forum which will redirect everyone to the new location.
The RAC MOD is great. It's all you will need to stop spam bots. It allows you to set up your registration form with a question that is easy for a human to answer, but the bots can't get past it. |
|
| Back to top |
|
|
rapidyellow
Board Member
Joined: 30 Mar 2009
Posts: 65
Location: cheshire, UK
|
Posted: Sat Apr 04, 2009 11:33 pm
Post subject: Re: moving forum hosting |
|
|
noted  had enough for this weekend so will do some more on monday
_________________
struggling |
|
| Back to top |
|
|
rapidyellow
Board Member
Joined: 30 Mar 2009
Posts: 65
Location: cheshire, UK
|
Posted: Sun Apr 05, 2009 10:48 pm
Post subject: Re: moving forum hosting |
|
|
Tell me where to find the RAC Mod.. many thanks to everyone for assistance so far.
Nik 
_________________
struggling |
|
| Back to top |
|
|
Chapter 24
Board Member
Joined: 30 Dec 2008
Posts: 48
|
|
| Back to top |
|
|
Red Dog
Board Member
Joined: 06 Mar 2009
Posts: 41
|
Posted: Sun Apr 12, 2009 7:20 pm
Post subject: Re: moving forum hosting |
|
|
What's the difference between this and The Humanizer?  |
|
| Back to top |
|
|
itconstruct
Board Member
Joined: 31 Mar 2009
Posts: 17
Location: Australia
|
Posted: Mon Apr 13, 2009 2:28 am
Post subject: Re: moving forum hosting |
|
|
| Red Dog wrote: |
What's the difference between this and The Humanizer? |
The Humanizer aska a question within the registration page that the user can answer straight away. the one from the phpBB website implements a key that is inserted in the description of the first forum and then asks you to place this key into the appropriate field on the registration page. |
|
| Back to top |
|
|
lumpy burgertushie
Board Member
Joined: 19 Nov 2008
Posts: 224
|
Posted: Sun May 03, 2009 5:02 am
Post subject: Re: moving forum hosting |
|
|
| itconstruct wrote: | | Red Dog wrote: |
What's the difference between this and The Humanizer? |
The Humanizer aska a question within the registration page that the user can answer straight away. the one from the phpBB website implements a key that is inserted in the description of the first forum and then asks you to place this key into the appropriate field on the registration page. |
actually the RAC MOD simply allows you to create a "key" that is required to be entered into a new box on the registration form.
you can make that "key" the answer to a question, or tell them to look on a certain page for it, or just put it right there on the registration page.
the object of the whole thing is that the spammer bots never see the registration page, so they will not know that there is a new required field to be filled out and the registration will fail at that point.
robert |
|
| Back to top |
|
|
rapidyellow
Board Member
Joined: 30 Mar 2009
Posts: 65
Location: cheshire, UK
|
Posted: Fri Jul 24, 2009 10:27 pm
Post subject: Re: moving forum hosting |
|
|
Right , Had a system fail on my hosting service, so have had to reinstall
well I would if I could, I cant quite remember what to do with bigdump.php
I have a backup of my database, uploaded it via ftp to a dump folder, with big dump.php in, attempted to run it and am getting the following message:
MySQL: Access denied for user 'buxtonr1_forum'@'localhost' to database 'buxtonra_buxtonforum'
buxtonra was the old host name, and buxtonr1 is the new, but its tripping up over, its possibly very simple but I am stuck - can anyone point me in the right direction to restore my data?
many thanks
_________________
struggling |
|
| Back to top |
|
|
itconstruct
Board Member
Joined: 31 Mar 2009
Posts: 17
Location: Australia
|
Posted: Fri Jul 24, 2009 11:32 pm
Post subject: Re: moving forum hosting |
|
|
| rapidyellow wrote: | MySQL: Access denied for user 'buxtonr1_forum'@'localhost' to database 'buxtonra_buxtonforum'
|
This user does not have access to your databases.
You need to be using the MYSQL user account with full access to this database when using bigdump.
This error states you do not have enough permissions to complete this action.
If you still are having issues please let us know. |
|
| Back to top |
|
|
rapidyellow
Board Member
Joined: 30 Mar 2009
Posts: 65
Location: cheshire, UK
|
Posted: Sat Jul 25, 2009 6:52 am
Post subject: Re: moving forum hosting |
|
|
I set the new database up with full permissions
Do I run the bigdump before I try to install the forum in any way?
as an aside, just before the hosting failed I made a back up of all my forum files which had mods installed, as well as the sql database, can I reuse all those files to save me reinstalling mods again?
_________________
struggling |
|
| Back to top |
|
|
itconstruct
Board Member
Joined: 31 Mar 2009
Posts: 17
Location: Australia
|
Posted: Sat Jul 25, 2009 7:15 am
Post subject: Re: moving forum hosting |
|
|
| rapidyellow wrote: | I set the new database up with full permissions
Do I run the bigdump before I try to install the forum in any way?
as an aside, just before the hosting failed I made a back up of all my forum files which had mods installed, as well as the sql database, can I reuse all those files to save me reinstalling mods again? |
Sorry Let's make this clearer!
To upload your database via bigdump you must edit the bigdump.php file with Notepad++ or your favourite editor (NOT NOTEPAD) and specify the database name that this database will be uploaded to and the user and password to complete this command.
If you need more help trying to get this working let us know. |
|
| Back to top |
|
|
rapidyellow
Board Member
Joined: 30 Mar 2009
Posts: 65
Location: cheshire, UK
|
Posted: Sat Jul 25, 2009 8:04 am
Post subject: Re: moving forum hosting |
|
|
I have put the details into bigdump that the database is called buxtonr1_forumdb as follows
$db_server = 'localhost';
$db_name = 'buxtonr1_forumdb';
$db_username = 'buxtonr1_forum';
$db_password = '*******';
and am getting the error [in big dump]
Error at the line 21: CREATE DATABASE `buxtonra_buxtonforum` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
Query: --
--
CREATE DATABASE `buxtonra_buxtonforum` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
MySQL: Access denied for user 'buxtonr1_forum'@'localhost' to database 'buxtonra_buxtonforum'
any ideas? sorry if I am a pain, I just dont know very much, I managed it first time round at the start of this topic but just seem to be struggling with the basics again 
Nik
_________________
struggling |
|
| Back to top |
|
|
itconstruct
Board Member
Joined: 31 Mar 2009
Posts: 17
Location: Australia
|
Posted: Sat Jul 25, 2009 8:14 am
Post subject: Re: moving forum hosting |
|
|
| rapidyellow wrote: | I have put the details into bigdump that the database is called buxtonr1_forumdb as follows
$db_server = 'localhost';
$db_name = 'buxtonr1_forumdb';
$db_username = 'buxtonr1_forum';
$db_password = '*******';
and am getting the error [in big dump]
Error at the line 21: CREATE DATABASE `buxtonra_buxtonforum` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
Query: --
--
CREATE DATABASE `buxtonra_buxtonforum` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
MySQL: Access denied for user 'buxtonr1_forum'@'localhost' to database 'buxtonra_buxtonforum'
any ideas? sorry if I am a pain, I just dont know very much, I managed it first time round at the start of this topic but just seem to be struggling with the basics again
Nik |
Change this line : CREATE DATABASE `buxtonra_buxtonforum` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
to this one :
CREATE DATABASE `buxtonr1_forumdb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
Please try that and let us know how you go! |
|
| Back to top |
|
|
Jim_UK
Board Member
Joined: 19 Nov 2008
Posts: 551
Location: North West UK
|
Posted: Sat Jul 25, 2009 8:44 am
Post subject: Re: moving forum hosting |
|
|
If the database already exists then remove the section from the sql file that is the command to create.
Often systems will barf at the "create" command.
If the empty database does not exist then use your cpanel tool to create the empty (no tables) database and then run the sql file minus that bit for the create.
That error is quite common when the sql file calls for "creation" of a database.
Trust me.
Jim |
|
| Back to top |
|
|
rapidyellow
Board Member
Joined: 30 Mar 2009
Posts: 65
Location: cheshire, UK
|
Posted: Sat Jul 25, 2009 8:54 am
Post subject: Re: moving forum hosting |
|
|
| itconstruct wrote: |
Change this line : CREATE DATABASE `buxtonra_buxtonforum` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
to this one :
CREATE DATABASE `buxtonr1_forumdb` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
Please try that and let us know how you go! |
I cant change that as its an error message, and not text in the file bigdump.php
_________________
struggling |
|
| Back to top |
|
|
|
This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area.
