Quick question for 3.0.12 to 3.2.x

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
User avatar
Furball Zen
Registered User
Posts: 381
Joined: Thu Oct 18, 2007 9:38 pm

Re: Quick question for 3.0.12 to 3.2.x

Post by Furball Zen »

Can i leave

Code: Select all

$table_prefix = 
blank?
I am the almighty Furball Zen. Hear me fluff.

Site Admin: too many to list ;)
Port 80 is for your server, port 3306 is for your db :)
If your forum displays correctly in IE, it needs to be fixed :)
User avatar
Furball Zen
Registered User
Posts: 381
Joined: Thu Oct 18, 2007 9:38 pm

Re: Quick question for 3.0.12 to 3.2.x

Post 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.
I am the almighty Furball Zen. Hear me fluff.

Site Admin: too many to list ;)
Port 80 is for your server, port 3306 is for your db :)
If your forum displays correctly in IE, it needs to be fixed :)
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52767
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Quick question for 3.0.12 to 3.2.x

Post by stevemaury »

Change 'mysql' to 'mysqli'.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
User avatar
Furball Zen
Registered User
Posts: 381
Joined: Thu Oct 18, 2007 9:38 pm

Re: Quick question for 3.0.12 to 3.2.x

Post by Furball Zen »

Tried and failed.
I am the almighty Furball Zen. Hear me fluff.

Site Admin: too many to list ;)
Port 80 is for your server, port 3306 is for your db :)
If your forum displays correctly in IE, it needs to be fixed :)
User avatar
Furball Zen
Registered User
Posts: 381
Joined: Thu Oct 18, 2007 9:38 pm

Re: Quick question for 3.0.12 to 3.2.x

Post 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.
I am the almighty Furball Zen. Hear me fluff.

Site Admin: too many to list ;)
Port 80 is for your server, port 3306 is for your db :)
If your forum displays correctly in IE, it needs to be fixed :)
User avatar
Furball Zen
Registered User
Posts: 381
Joined: Thu Oct 18, 2007 9:38 pm

Re: Quick question for 3.0.12 to 3.2.x

Post 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.
I am the almighty Furball Zen. Hear me fluff.

Site Admin: too many to list ;)
Port 80 is for your server, port 3306 is for your db :)
If your forum displays correctly in IE, it needs to be fixed :)
User avatar
HiFiKabin
Community Team Member
Community Team Member
Posts: 6669
Joined: Wed May 14, 2014 9:10 am
Location: Swearing at the PC, UK
Name: James
Contact:

Re: Quick question for 3.0.12 to 3.2.x

Post 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!
User avatar
Furball Zen
Registered User
Posts: 381
Joined: Thu Oct 18, 2007 9:38 pm

Re: Quick question for 3.0.12 to 3.2.x

Post 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).
I am the almighty Furball Zen. Hear me fluff.

Site Admin: too many to list ;)
Port 80 is for your server, port 3306 is for your db :)
If your forum displays correctly in IE, it needs to be fixed :)
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52767
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Quick question for 3.0.12 to 3.2.x

Post 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?
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52767
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Quick question for 3.0.12 to 3.2.x

Post 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
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
User avatar
Furball Zen
Registered User
Posts: 381
Joined: Thu Oct 18, 2007 9:38 pm

Re: Quick question for 3.0.12 to 3.2.x

Post 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.
I am the almighty Furball Zen. Hear me fluff.

Site Admin: too many to list ;)
Port 80 is for your server, port 3306 is for your db :)
If your forum displays correctly in IE, it needs to be fixed :)
User avatar
Lumpy Burgertushie
Registered User
Posts: 69223
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Quick question for 3.0.12 to 3.2.x

Post by Lumpy Burgertushie »

show us the first 100 or so lines of your database backup file.


robert
Premium phpBB 3.3 Styles by PlanetStyles.net

I am pleased to announce that I have completed the first item on my bucket list. I have the bucket.
User avatar
Furball Zen
Registered User
Posts: 381
Joined: Thu Oct 18, 2007 9:38 pm

Re: Quick question for 3.0.12 to 3.2.x

Post 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'),
I am the almighty Furball Zen. Hear me fluff.

Site Admin: too many to list ;)
Port 80 is for your server, port 3306 is for your db :)
If your forum displays correctly in IE, it needs to be fixed :)
User avatar
stevemaury
Support Team Member
Support Team Member
Posts: 52767
Joined: Thu Nov 02, 2006 12:21 am
Location: The U.P.
Name: Steve
Contact:

Re: Quick question for 3.0.12 to 3.2.x

Post by stevemaury »

That is not the backup of a phpBB database.
I can stop all your spam. I can upgrade or update your Board. PM or email me. (Paid support)
User avatar
canonknipser
Registered User
Posts: 2096
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: Quick question for 3.0.12 to 3.2.x

Post 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 ...
Greetings, Frank
phpbb.de support team member
English is not my native language - no support via PM or mail
New arrival - Extensions and scripts for phpBB
Post Reply

Return to “[3.2.x] Support Forum”