Database Migration Error updating 3.0.11 to 3.2.0

Get help with installation and running phpBB 3.2.x here. Please do not post bug reports, feature requests, or extension related questions here.
Post Reply
ejosterberg
Registered User
Posts: 1
Joined: Sun Jan 29, 2017 9:41 am

Database Migration Error updating 3.0.11 to 3.2.0

Post by ejosterberg » Sun Jan 29, 2017 9:53 am

I followed the instructions here: https://www.phpbb.com/support/documents ... pdate30_31 and https://www.phpbb.com/support/documents ... n=3#update

It seems there's a table I'm missing completely from my 3.0.10 installation. seems I'm missing phpbb_config_text

I receive the following error when attempting the database update from the command line.

[root@SERVERNAME html]# php ./bin/phpbbcli.php db:migrate --safe-mode
PHP Fatal error: SQL ERROR [ mysql4 ]<br /><br />Table 'DATABASENAME.phpbb_config_text' doesn't exist [1146]<br /><br />An SQL error occurred while fetching this page. Please contact the <a href="mailto:admin@DOMAINNAME.com">Board Administrator</a> if this problem persists. in /var/www/html/phpbb/db/driver/driver.php on line 999

[root@SERVERNAME www]# cat /etc/redhat-release
CentOS Linux release 7.3.1611 (Core)

Thank you for any assistance troubleshooting my issue.

User avatar
Lumpy Burgertushie
Registered User
Posts: 66818
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Database Migration Error updating 3.0.11 to 3.2.0

Post by Lumpy Burgertushie » Sun Jan 29, 2017 2:51 pm

Those instructions are not for going from 3.0 to 3.2

try again using this:
Upgrading from phpbb 3.0.x to phpbb 3.2.x
  • Your server must be running at least PHP 5.4
  • MODs for 3.0.x are incompatible with 3.2.x and their functionality will be removed in the update process.
  • Styles for 3.0.x cannot be installed or used on 3.2.x.
  1. Backup up your board's files and database
  2. Download the Support Toolkit. Install it and run the database cleaner to remove all old MODs from the database.
  3. Deactivate all styles except for prosilver
  4. Ensure that the activated spambot countermeasure is one of the standard phpBB plugins (Simple image, GD image, GD 3D image, Q&A, reCaptacha).
  5. Set British English as the only language pack
  6. Delete all of your phpBB 3.0.x files EXCEPT for the following:
    • The config.php file
    • The /images/ directory
    • The /files/ directory
  7. Download the 3.2.x Full Package to your computer and unzip it.
  8. Delete the blank config.php file from it. (Note: you don't want to overwrite your original config.php file)
  9. Upload all the remaining files/folders to your server where your old board was.
  10. Browse to yourdomain.com/yourphpbb/install/ then click the update tab. Click update database only. This could take a long time on a large board, maybe hours.
  11. Delete the folder named /install/
  12. Hold one foot in the air and spin around in a circle three times saying "I am a phpbb guru".

robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

grdlock
Registered User
Posts: 17
Joined: Fri Feb 24, 2012 4:03 pm

Re: Database Migration Error updating 3.0.11 to 3.2.0

Post by grdlock » Fri Feb 24, 2017 5:36 am

Not that I'm arguing, since I'm having the exact same issue... but the official documentation for upgrading from 3.0 to 3.2 specifically mentions running that command. Do they need to fix their documentation then?

https://www.phpbb.com/support/docs/en/3 ... /upgrade3/

User avatar
Lumpy Burgertushie
Registered User
Posts: 66818
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Database Migration Error updating 3.0.11 to 3.2.0

Post by Lumpy Burgertushie » Fri Feb 24, 2017 6:52 am

if you notice, it says
Tip

For large boards, you may wish to update via the command line instead of using a web browser. From your board's root, execute the following command: php ./bin/phpbbcli.php db:migrate --safe-mode
I don't think most people that are using standard shared hosting will even have command line access must less know how to use it.

have you tried the method I showed above? that works just fine 99% of the time.

luck,
robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

grdlock
Registered User
Posts: 17
Joined: Fri Feb 24, 2012 4:03 pm

Re: Database Migration Error updating 3.0.11 to 3.2.0

Post by grdlock » Fri Feb 24, 2017 3:48 pm

I'm not sure what qualifies as a large board really. I have a 1.5GB SQL database. I do run my own server so I have full command line access and am very familiar with working in linux. I have indeed tried your method, twice now without success. Every time the Update Database progress bar gets to 100%, but I never see a completed successfully message. Each time I just monitor the MySQL process until the CPU usage drops, and when it does I still don't see a completed successfully message. (takes a few hours). Once I rename the install directory, try to load my board, the login screen comes up. Once I login I get a HTTP 500 error. Examining the apache error logs I see this:

[Fri Feb 24 09:41:57.627195 2017] [:error] [pid 19355] [client 38.122.193.210:7510] PHP Fatal error: Uncaught exception 'InvalidArgumentException' with message 'Invalid scheme name ''' in /var/www/boardnametest/vendor/s9e/text-formatter/src/Configurator.php:8898\nStack trace:\n#0 /var/www/boardnametest/vendor/s9e/text-formatter/src/Configurator.php(8524): s9e\\TextFormatter\\Configurator\\Collections\\SchemeList->normalizeValue('')\n#1 /var/www/boardnametest/vendor/s9e/text-formatter/src/Configurator.php(8559): s9e\\TextFormatter\\Configurator\\Collections\\NormalizedList->append('')\n#2 /var/www/boardnametest/vendor/s9e/text-formatter/src/Configurator.php(7739): s9e\\TextFormatter\\Configurator\\Collections\\NormalizedList->offsetSet(NULL, '')\n#3 /var/www/boardnametest/phpbb/textformatter/s9e/factory.php(214): s9e\\TextFormatter\\Configurator\\UrlConfig->allowScheme('')\n#4 /var/www/boardnametest/phpbb/textformatter/s9e/factory.php(376): phpbb\\textformatter\\s9e\\factory->get_configurator()\n#5 /var/www/boardnametest/phpbb/textformatter/s9e/renderer.php(97): phpbb\\textformatter\\s9e\\factory->regenerate()\n#6 /var/www/boardnametest/cache/production/container_4335734bbdd20f586549a in /var/www/boardnametest/vendor/s9e/text-formatter/src/Configurator.php on line 8898, referer: http://test.domain.com/

User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact:

Re: Database Migration Error updating 3.0.11 to 3.2.0

Post by RMcGirr83 » Fri Feb 24, 2017 3:54 pm

Use the CLI to update the forum.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored

grdlock
Registered User
Posts: 17
Joined: Fri Feb 24, 2012 4:03 pm

Re: Database Migration Error updating 3.0.11 to 3.2.0

Post by grdlock » Fri Feb 24, 2017 4:30 pm

That's how I found this thread initially, as the first thing I tried was the CLI method, and I got the same error message as the OP did when doing it that way.

User avatar
Lumpy Burgertushie
Registered User
Posts: 66818
Joined: Mon May 02, 2005 3:11 am
Contact:

Re: Database Migration Error updating 3.0.11 to 3.2.0

Post by Lumpy Burgertushie » Fri Feb 24, 2017 6:47 pm

not sure why but your update seems to be looking for the config_text table . that does not exist in 3.0 but it does exists in 3.1 and 3.2

what I think this means is that your update is not starting far enough back in the versions.

try this, using your ftp, find the store folder, delete all the files that say "migration" in the file name.

make sure that there is no file with the name install_config in their either.

then, start your update process again.


robert
I'm baaaaaccckkkk. still doing work on donation basis. PM your needs.

Premium phpBB 3.2 Styles by PlanetStyles.net

If a tree falls in the forest and nobody is there, does it make a sound?

Bootstrap
Registered User
Posts: 47
Joined: Mon Aug 17, 2009 7:30 pm

Re: Database Migration Error updating 3.0.11 to 3.2.0

Post by Bootstrap » Tue Mar 21, 2017 7:36 pm

Did anyone figure out how to create that table? I'm facing the same problem.

elist
Registered User
Posts: 10
Joined: Tue Apr 06, 2010 1:06 pm

Re: Database Migration Error updating 3.0.11 to 3.2.0

Post by elist » Wed Jul 19, 2017 10:40 am

Yeah I've got this same issue now, was going from 3.0.14 though.

Anyone find a way forward?

d_lindenberger
Registered User
Posts: 1
Joined: Thu Feb 24, 2011 5:40 am

Re: Database Migration Error updating 3.0.11 to 3.2.0

Post by d_lindenberger » Wed Aug 16, 2017 12:36 am

I believe the issue is that install/schemas/schema_data.sql tries to insert data into phpbb_config_text but doesn't know what to do if the table doesn't exist.

Installing a new copy of 3.2.1 and doing SHOW CREATE phpbb_config_text I get:
CREATE TABLE `phpbb_config_text` (
`config_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`config_value` mediumtext COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`config_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin


Adding that to my 3.0.x database seemed to do the trick.

andreszs
Registered User
Posts: 16
Joined: Sat Aug 19, 2017 11:05 pm

Re: Database Migration Error updating 3.0.11 to 3.2.0

Post by andreszs » Thu Nov 02, 2017 2:20 pm

d_lindenberger wrote:
Wed Aug 16, 2017 12:36 am
CREATE TABLE `phpbb_config_text` (
`config_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`config_value` mediumtext COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`config_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin
I strongly suggest adding that query to the 3.0 to 3.2 Update Guide, otherwise conversion will inevitably fail via CLI.

As for the STK, on a 3.0.14 board it only serves the purpose of showing this nice error message on the index page:
Undefined index: style_path
Click here to reload the STK
In other words, the STK does not solve anything and does not even work at all in this case.

Paul
Infrastructure Team Leader
Infrastructure Team Leader
Posts: 25454
Joined: Sat Dec 04, 2004 3:44 pm
Location: The netherlands.
Name: Paul Sohier
Contact:

Re: Database Migration Error updating 3.0.11 to 3.2.0

Post by Paul » Fri Nov 03, 2017 6:47 am

If you use the CLI that is in the install folder, then it should work perfectly fine.
Knock knock
Race condition
Who's there?

My BlogMy Photosmy phpBB Extensionscustom phpBB work & Development

POilf
Registered User
Posts: 14
Joined: Mon Nov 05, 2001 7:44 am
Contact:

Re: Database Migration Error updating 3.0.11 to 3.2.0

Post by POilf » Wed Nov 13, 2019 9:09 am

d_lindenberger wrote:
Wed Aug 16, 2017 12:36 am
I believe the issue is that install/schemas/schema_data.sql tries to insert data into phpbb_config_text but doesn't know what to do if the table doesn't exist.

Installing a new copy of 3.2.1 and doing SHOW CREATE phpbb_config_text I get:
CREATE TABLE `phpbb_config_text` (
`config_name` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT '',
`config_value` mediumtext COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`config_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin


Adding that to my 3.0.x database seemed to do the trick.
Thank you so much for posting a solution that just works!

Post Reply

Return to “[3.2.x] Support Forum”