Code: Select all
$table_prefix =
Code: Select all
$table_prefix =
Can you be a little more specific? Ive tried a myriad of configurations and have no idea what to put in there and i just keep getting the timeout settings error and i even increased them in php.ini and did the mysqli and nothing works.Lumpy Burgertushie wrote: ↑Wed Feb 28, 2018 8:56 pm
edit the blank config.php file to point to the 3.0 database you just created.
Code: Select all
<?php
// phpBB 3.2.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'phpbb\\db\\driver\\mysql';
$dbhost = 'localhost';
$dbport = '';
$dbname = 'mysql';
$dbuser = 'user';
$dbpasswd = 'userpwd';
$table_prefix = 'pcm_';
$phpbb_adm_relative_path = 'adm/';
$acm_type = 'phpbb\\cache\\driver\\file';
@define('PHPBB_INSTALLED', true);
// @define('PHPBB_DISPLAY_LOAD_TIME', true);
@define('PHPBB_ENVIRONMENT', 'production');
// @define('DEBUG_CONTAINER', true);
Code: Select all
<?php
// phpBB 3.2.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'phpbb\\db\\driver\\mysql';
$dbhost = 'localhost';
$dbport = '';
$dbname = 'mysql';
$dbuser = 'user';
$dbpasswd = 'userpwd';
$table_prefix = ''; <--blank because the empty db doesnt have a prefix, or can i add it in phpmyadmin?
$phpbb_adm_relative_path = 'adm/';
$acm_type = 'phpbb\\cache\\driver\\file';
@define('PHPBB_INSTALLED', false); <--- because its NOT installed?
// @define('PHPBB_DISPLAY_LOAD_TIME', true);
@define('PHPBB_ENVIRONMENT', 'production'); <-----not sure if this has any bearing on it
// @define('DEBUG_CONTAINER', true);
Look at the styles table. See what the style_id is for prosilver (usually 1 but not always). Let's say it's X.Furball Zen wrote: ↑Thu Mar 01, 2018 2:47 am Is it possible to change the default style in the db manually? Im pretty much convinced thats the issue at this point.
Code: Select all
UPDATE phpbb_config SET config_value = X WHERE config_name = 'default_style';
UPDATE phpbb_config SET config_value = 1 WHERE config_name = 'override_user_style'
No, i edited it and it still failed, one of the many things i mentioned i tried (too many to list). I even changed the timeout in php.ini and it didnt help. I had to follow something i found and edited a php file in phypbb3 to ignore the http setting to force the install.stevemaury wrote: ↑Thu Mar 01, 2018 2:19 pm Your table prefix can be blank, but what is it in your backup? And don't open backups (or .php files) with Notepad. Use Notepad++ (free, Google).
When you say you tried and failed to edit "mysql" to "mysqli", do you mean you were unable to edit the file, or something else? And if something else, what happened? Cannot connect? Timeout?
Im seeing references to vBulletin and i had converted it to phpbb almost 3 years before this dump was made, is that a possible issue? This file is huge, Notepad++ wont even open it and this took almost 5 mins to highlight and then copy, and my machine is no slouch.Lumpy Burgertushie wrote: ↑Thu Mar 01, 2018 4:44 pm show us the first 100 or so lines of your database backup file.
robert
Code: Select all
-- MySQL dump 10.13 Distrib 5.1.72, for redhat-linux-gnu (x86_64)
--
-- Host: localhost Database: xoxideforums
-- ------------------------------------------------------
-- Server version 5.1.71-ius
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
-- Table structure for table `access`
--
DROP TABLE IF EXISTS `access`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `access` (
`userid` int(10) unsigned NOT NULL DEFAULT '0',
`forumid` smallint(5) unsigned NOT NULL DEFAULT '0',
`accessmask` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`userid`,`forumid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `access`
--
LOCK TABLES `access` WRITE;
/*!40000 ALTER TABLE `access` DISABLE KEYS */;
INSERT INTO `access` VALUES (19098,32,0),(19098,44,0),(19098,55,0),(19098,87,0),(19098,86,0),(19098,85,0),(19098,84,0),(19098,41,0),(19098,21,0),(19098,29,0),(19098,23,0),(19098,24,0),(19098,20,0),(19098,22,0),(19098,42,0),(19098,36,0),(19098,19,0),(19098,18,0),(19098,81,0),(19098,80,0),(19098,82,0),(19098,79,0),(19098,88,0),(19098,77,0),(19098,76,0),(19098,75,0),(19098,74,0),(19098,43,0),(19098,27,0),(19098,73,0),(19098,100,0),(19098,12,0),(19098,11,0),(19098,67,0),(19098,68,0),(19098,64,0),(19098,33,0),(19098,26,0),(19098,94,0),(19098,93,0),(19098,92,0),(19098,101,0),(19098,63,0),(19098,62,0),(19098,61,0),(19098,59,0),(19098,60,0),(19098,35,0),(19098,6,0),(19098,58,0),(19098,95,0),(19098,5,0),(19098,45,0),(19098,4,0),(19098,89,0),(19098,17,0),(19098,15,0),(19098,28,0),(19098,14,0),(19098,91,0),(19098,3,0),(19098,13,0),(19098,31,0),(19098,7,0),(19098,56,0),(19098,54,0),(19098,53,0),(19098,52,0),(19098,97,0),(19098,25,0),(19098,51,0),(19098,37,0),(19098,30,0),(19098,40,0),(19098,49,0),(19098,8,0),(19098,57,0),(19098,50,0),(19098,83,0),(19098,96,0),(19098,99,0),(19098,38,0),(19098,39,0),(19098,9,0),(19098,10,0),(19098,46,0),(19098,47,0),(19098,48,0),(19098,90,0),(19098,98,0),(19101,57,0),(19101,8,0),(19101,49,0),(19101,40,0),(19101,30,0),(19101,37,0),(19101,51,0),(19101,25,0),(19101,97,0),(19101,52,0),(19101,53,0),(19101,54,0),(19101,56,0),(19101,7,0),(19101,31,0),(19101,13,0),(19101,3,0),(19101,91,0),(19101,14,0),(19101,28,0),(19101,15,0),(19101,17,0),(19101,89,0),(19101,4,0),(19101,45,0),(19101,5,0),(19101,95,0),(19101,58,0),(19101,6,0),(19101,35,0),(19101,60,0),(19101,59,0),(19101,61,0),(19101,62,0),(19101,63,0),(19101,101,0),(19101,92,0),(19101,93,0),(19101,94,0),(19101,26,0),(19101,33,0),(19101,64,0),(19101,68,0),(19101,67,0),(19101,11,0),(19101,12,0),(19101,100,0),(19101,73,0),(19101,27,0),(19101,43,0),(19101,74,0),(19101,75,0),(19101,76,0),(19101,77,0),(19101,88,0),(19101,79,0),(19101,82,0),(19101,80,0),(19101,81,0),(19101,18,0),(19101,19,0),(19101,36,0),(19101,42,0),(19101,22,0),(19101,20,0),(19101,24,0),(19101,23,0),(19101,29,0),(19101,21,0),(19101,41,0),(19101,84,0),(19101,85,0),(19101,86,0),(19101,87,0),(19101,55,0),(19101,44,0),(19101,32,0),(19101,50,0),(19101,83,0),(19101,96,0),(19101,99,0),(19101,38,0),(19101,39,0),(19101,9,0),(19101,10,0),(19101,46,0),(19101,47,0),(19101,48,0),(19101,90,0),(19101,98,0);
/*!40000 ALTER TABLE `access` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `adminhelp`
--
DROP TABLE IF EXISTS `adminhelp`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `adminhelp` (
`adminhelpid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`script` varchar(50) NOT NULL DEFAULT '',
`action` varchar(25) NOT NULL DEFAULT '',
`optionname` varchar(100) NOT NULL DEFAULT '',
`displayorder` smallint(5) unsigned NOT NULL DEFAULT '1',
`volatile` smallint(5) unsigned NOT NULL DEFAULT '0',
`product` varchar(25) NOT NULL DEFAULT '',
PRIMARY KEY (`adminhelpid`),
UNIQUE KEY `phraseunique` (`script`,`action`,`optionname`)
) ENGINE=MyISAM AUTO_INCREMENT=9788 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `adminhelp`
--
LOCK TABLES `adminhelp` WRITE;
/*!40000 ALTER TABLE `adminhelp` DISABLE KEYS */;
INSERT INTO `adminhelp` VALUES (9679,'usergroup','add,edit','canseeothersrep',780,1,'vbulletin'),(9678,'usergroup','add,edit','canhiderep',770,1,'vbulletin'),(9677,'usergroup','add,edit','canseeownrep',760,1,'vbulletin'),(9676,'usergroup','add,edit','canuserep',750,1,'vbulletin'),(9675,'usergroup','add,edit','cannegativerep',750,1,'vbulletin'),(9674,'usergroup','add,edit','cancontrolpanel',740,1,'vbulletin'),(9673,'usergroup','add,edit','ismoderator',730,1,'vbulletin'),(9671,'usergroup','add,edit','caneditownusernotes',710,1,'vbulletin'),(9672,'usergroup','add,edit','canbeusernoted',720,1,'vbulletin'),(9670,'usergroup','add,edit','canpostothersusernotes',700,1,'vbulletin'),(9669,'usergroup','add,edit','canmanageothersusernotes',690,1,'vbulletin'),(9668,'usergroup','add,edit','canviewothersusernotes',680,1,'vbulletin'),(9667,'usergroup','add,edit','canpostownusernotes',670,1,'vbulletin'),(9666,'usergroup','add,edit','canmanageownusernotes',660,1,'vbulletin'),(9665,'usergroup','add,edit','canviewownusernotes',650,1,'vbulletin'),(9664,'usergroup','add,edit','canwhosonlinelocation',640,1,'vbulletin'),(9663,'usergroup','add,edit','canwhosonlinebad',630,1,'vbulletin'),(9662,'usergroup','add,edit','canwhosonlineip',620,1,'vbulletin'),(9661,'usergroup','add,edit','canwhosonlinefull',610,1,'vbulletin'),(9660,'usergroup','add,edit','canwhosonline',600,1,'vbulletin'),(9659,'usergroup','add,edit','canviewothersevent',590,1,'vbulletin'),(9658,'usergroup','add,edit','candeleteevent',580,1,'vbulletin'),(9657,'usergroup','add,edit','caneditevent',570,1,'vbulletin'),(9655,'usergroup','add,edit','canviewcalendar',550,1,'vbulletin'),(9656,'usergroup','add,edit','canpostevent',560,1,'vbulletin'),(9653,'usergroup','add,edit','candenypmreceipts',530,1,'vbulletin'),(9654,'usergroup','add,edit','pmsendmax',540,1,'vbulletin'),(9650,'usergroup','add,edit','pmquota',510,1,'vbulletin'),(9651,'usergroup','add,edit','canignorequota',515,1,'vbulletin'),(9652,'usergroup','add,edit','cantrackpm',520,1,'vbulletin'),
At least those tables listed in the first lines are no phpBB-tables - maybe they are further down because OP posted
- so when all those vbulletin tables (see here for a list) have been still in the database, they are also in the backup ...Furball Zen wrote: ↑Thu Mar 01, 2018 5:24 pm i had converted it to phpbb almost 3 years before this dump was made