Need Help to Run PHPBB on Local system

Get help with installation and running phpBB 3.0.x here. Please do not post bug reports, feature requests, or MOD-related questions here.
Ideas Centre
Forum rules
END OF SUPPORT: 1 January 2017 (announcement)
Locked
sandraken
Registered User
Posts: 21
Joined: Thu Mar 24, 2016 3:52 pm

Need Help to Run PHPBB on Local system

Post by sandraken »

Hi,

I need to run a PHPBB3 Forum on to my local system, running in to issues , appreciate if someone can help me or guide me how to fix that, what I have done so far is ,

1) Installed Xamp
2) Xamp is Running , Apache and MYSQL running and showing green
3) using FTP client copied the whole web site in to c:\xamp\httpdocs\site1 " successfull"
4) backup the current mysql database from the PHPBB \Maintenance tab " successfull"
5) created new local Database name"testdb" " successfull" - roots
6) created new user "dbuser" with password "root" with fill permissions.
7) import backed up database to "testdb" " successfull"
8) changed the config.php

<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = '';
$dbport = '';
$dbname = 'testdb';
$dbuser = 'dbuser';
$dbpasswd = 'root';
$table_prefix = 'bbddb_';
$acm_type = 'file';
$load_extensions = ' ';

@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
?>


----------------------------------- Error --------------------------

in browser address localhost\site1

getting this error
SQL ERROR [ mysql4 ]

mysql_connect function does not exist, is mysql extension installed? []

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.

User avatar
david63
Registered User
Posts: 17384
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Need Help to Run PHPBB on Local system

Post by david63 »

If that is your congif.php file then you are missing an entry for $dbhost. It should work with $dbhost = 'localhost';.

P.S. - if you are running on your local machine you do not need to ftp the files you can just copy them with file explorer
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

sandraken
Registered User
Posts: 21
Joined: Thu Mar 24, 2016 3:52 pm

Re: Need Help to Run PHPBB on Local system

Post by sandraken »

Thanks David,

Its the same error even after adding localhost to $dbhost :(


<?php

$dbms = 'mysql';
$dbhost = 'localhost';
$dbport = '';
$dbname = 'testdb';
$dbuser = 'dbuser';
$dbpasswd = 'root';
$table_prefix = 'bbddb_';
$acm_type = 'file';
$load_extensions = ' ';
@define('PHPBB_INSTALLED', true);

?>

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51984
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Need Help to Run PHPBB on Local system

Post by Brf »

Which version of phpBB are you trying to run? You have posted in the 3.1 support forum, but you are using a 3.0 config.php.

User avatar
david63
Registered User
Posts: 17384
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Need Help to Run PHPBB on Local system

Post by david63 »

After changing the config did you delete everything from the cache folder except .htaccess and index.htm?
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

sandraken
Registered User
Posts: 21
Joined: Thu Mar 24, 2016 3:52 pm

Re: Need Help to Run PHPBB on Local system

Post by sandraken »

Just Deleted everything excepet .htaccess and index.html , restarted Apache and MYsql .

same error ..

On the WEB the site is running 3.1.2

User avatar
Brf
Support Team Member
Support Team Member
Posts: 51984
Joined: Tue May 10, 2005 7:47 pm
Location: {postrow.POSTER_FROM}
Contact:

Re: Need Help to Run PHPBB on Local system

Post by Brf »

That is not a proper config.php for 3.1.x

sandraken
Registered User
Posts: 21
Joined: Thu Mar 24, 2016 3:52 pm

Re: Need Help to Run PHPBB on Local system

Post by sandraken »

sorry my mistake board version is 3.0.12

User avatar
david63
Registered User
Posts: 17384
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Need Help to Run PHPBB on Local system

Post by david63 »

Going back to the original problem - it is saying that
sandraken wrote:mysql_connect function does not exist, is mysql extension installed? []
which would indicate that you do not have that extension installed on your Xampp - change $dbms to mysqli
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored

Slackervaara
Registered User
Posts: 195
Joined: Thu Feb 28, 2008 7:46 am

Re: Need Help to Run PHPBB on Local system

Post by Slackervaara »

Sometimes localhost does not work and I use 127.0.0.1 instead of localhost.

Locked

Return to “[3.0.x] Support Forum”