Page 2 of 3

Re: Quick question for 3.0.12 to 3.2.x

Posted: Thu Mar 01, 2018 12:12 am
by Furball Zen
Can i leave

Code: Select all

$table_prefix = 
blank?

Re: Quick question for 3.0.12 to 3.2.x

Posted: Thu Mar 01, 2018 1:05 am
by Furball Zen
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.
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.

Copying from another working phpbb install, the config.php looks like this (yes i edited the actual user/pwd)

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);
I suspect it should have to look like this for the blank one

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);
I dont have access to a 3.2.1 generated config.php if that would have made a difference. Thanks guys, its all a learning process.

Re: Quick question for 3.0.12 to 3.2.x

Posted: Thu Mar 01, 2018 1:11 am
by stevemaury
Change 'mysql' to 'mysqli'.

Re: Quick question for 3.0.12 to 3.2.x

Posted: Thu Mar 01, 2018 1:29 am
by Furball Zen
Tried and failed.

Re: Quick question for 3.0.12 to 3.2.x

Posted: Thu Mar 01, 2018 2:47 am
by Furball Zen
Is it possible to change the default style in the db manually? Im pretty much convinced thats the issue at this point.

Re: Quick question for 3.0.12 to 3.2.x

Posted: Thu Mar 01, 2018 4:21 am
by Furball Zen
Continued futzing around, i got 3.0.12 installed, however the backups werent made with phpbb, but rather pulled from the db on the old server, so they wont restore in phpbb.

When i compare them to the tables created by phpbb3, they dont match at all, so im kind of at a loss, still.

Re: Quick question for 3.0.12 to 3.2.x

Posted: Thu Mar 01, 2018 10:39 am
by HiFiKabin
Please keep in mind that we have a six hour bumping rule. All team members and community members here are volunteers, so we ask you to wait at least six hours before bumping your topic or, if no-one has replied to your last post, edit your last post. Thanks!

Re: Quick question for 3.0.12 to 3.2.x

Posted: Thu Mar 01, 2018 1:52 pm
by Furball Zen
I was able to open both backups in Notepad (briefly cause the size almost crashed my PC) and i noticed that while the data wasnt formatted the same, it looked similar. I found a phpbb backup that was 4 months old, but get a white screen when restoring through the ACP. Is there any way to convert the sql dump to a useable db tableset that phpbb recognizes? In phpmyadmin the dump seems to be labled as "ISMA" and phpbb created tables are "InnoDB" (never seen those before).

Re: Quick question for 3.0.12 to 3.2.x

Posted: Thu Mar 01, 2018 2:19 pm
by stevemaury
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?

Re: Quick question for 3.0.12 to 3.2.x

Posted: Thu Mar 01, 2018 2:33 pm
by stevemaury
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.
Look at the styles table. See what the style_id is for prosilver (usually 1 but not always). Let's say it's X.

Then run this query:

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'
Then delete data_global.php from the /cache folder

Re: Quick question for 3.0.12 to 3.2.x

Posted: Thu Mar 01, 2018 4:38 pm
by Furball Zen
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?
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.

From what i can tell, is the backup contains an entire SQL dump in whatever format it was pulled off of the linux box it was on. But not in a format that phpbb recognizes and in phpmyadmin, the tables dont match what phpbb creates when it creates tables.

So, now im down to either using a 4 month old phpbb backup (and the resulting white screen where it obviously fails to restore, the db doesnt change based on watching phpmyadmin) or some how converting the dump to one phpbb will work with.

Re: Quick question for 3.0.12 to 3.2.x

Posted: Thu Mar 01, 2018 4:44 pm
by Lumpy Burgertushie
show us the first 100 or so lines of your database backup file.


robert

Re: Quick question for 3.0.12 to 3.2.x

Posted: Thu Mar 01, 2018 5:24 pm
by Furball Zen
Lumpy Burgertushie wrote:
Thu Mar 01, 2018 4:44 pm
show us the first 100 or so lines of your database backup file.


robert
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.

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'),

Re: Quick question for 3.0.12 to 3.2.x

Posted: Thu Mar 01, 2018 5:34 pm
by stevemaury
That is not the backup of a phpBB database.

Re: Quick question for 3.0.12 to 3.2.x

Posted: Thu Mar 01, 2018 7:24 pm
by canonknipser
stevemaury wrote:
Thu Mar 01, 2018 5:34 pm
That is not the backup of a phpBB database.
At least those tables listed in the first lines are no phpBB-tables - maybe they are further down because OP posted
Furball Zen wrote:
Thu Mar 01, 2018 5:24 pm
i had converted it to phpbb almost 3 years before this dump was made
- so when all those vbulletin tables (see here for a list) have been still in the database, they are also in the backup ...