error migrating from 3.0 to 3.2 mysql_connect function does not exist, is mysql extension installed?

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
poliorcetes
Registered User
Posts: 5
Joined: Sat Jun 15, 2019 11:03 am

error migrating from 3.0 to 3.2 mysql_connect function does not exist, is mysql extension installed?

Post by poliorcetes » Sat Jun 15, 2019 11:23 am

Hi all,

After several hours of failed attempts, I'm in a cul-de-sac and I cannot finish my migration. Let me describe my steps

1. Download a SQL dump of my 3.0 phpbb-based forum
2. Download actual set of files of my forum
3. Delete all but config.php, cache, files, store, images/avatars/upload
4. Download a recent version of phpBB3.2
5. delete in new phpBB3.2 this:

Code: Select all

config.php, cache, files, store, images/avatars/upload
, and substitute them with my old files
6. chmod 644, 755 and files, store, images/avatars/upload to 777
7. edit config.php with this values

Code: Select all

<?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql';
$dbhost = 'localhost';
$dbport = '';
$dbname = DBNAME; <- name
$dbuser = DBUSER; <- user
$dbpasswd = DBPASS; <- pass
$table_prefix = 'phpbb3_';
$acm_type = 'file';
$load_extensions = '';
$db_connection_charset = 'utf8';

@define('PHPBB_INSTALLED', true);
// @define('DEBUG', true);
// @define('DEBUG_EXTRA', true);
?>
I use an local lamp installation with php7.2 and php-mysql and php7.2-mysql installed

As you can infer, all the information posted above has been obtained from this forum. My next step would be to replicate the process in my hosting and then redirecting my forum to the new installation

Do you people know what to do in order to run a backup of my forum updated to 3.2 and with the old database?

Thank you people in advance

User avatar
kinerity
Community Team Member
Community Team Member
Posts: 2249
Joined: Mon Sep 01, 2014 1:00 am
Location: sudo rm -rf /
Name: Kailey Truscott
Contact:

Re: error migrating from 3.0 to 3.2 mysql_connect function does not exist, is mysql extension installed?

Post by kinerity » Sat Jun 15, 2019 12:15 pm

poliorcetes wrote:
Sat Jun 15, 2019 11:23 am

Code: Select all

$dbms = 'mysql';
Change this to $dbms = 'mysqli';
Kailey Truscott - Community Team

poliorcetes
Registered User
Posts: 5
Joined: Sat Jun 15, 2019 11:03 am

Re: error migrating from 3.0 to 3.2 mysql_connect function does not exist, is mysql extension installed?

Post by poliorcetes » Sat Jun 15, 2019 12:21 pm

Actually, after opening install/app.php/update I obtain this error message

Code: Select all

The installer detected a timeout
The installer has detected a timeout, you may try to refresh the page, which may lead to data corruption. We suggest that you either increase your timeout settings or try to use the CLI.
I have been using hints from this thread

viewtopic.php?f=556&t=2401371&start=15

And I tried all its methods including this one

viewtopic.php?p=14713461#p14713461
5. When you get timeout message don't delete anything from the files such as lock file.
6. Don't reload that TAB before error about timeout appears (this is very crucial)
7. Wait for error to appear then reload the tab. It might take 10 times, it might take 200 times but it will work eventually.
error message appears reload after reload. I'm stuck

User avatar
kinerity
Community Team Member
Community Team Member
Posts: 2249
Joined: Mon Sep 01, 2014 1:00 am
Location: sudo rm -rf /
Name: Kailey Truscott
Contact:

Re: error migrating from 3.0 to 3.2 mysql_connect function does not exist, is mysql extension installed?

Post by kinerity » Sat Jun 15, 2019 12:26 pm

Did you make the change I suggested above?
Kailey Truscott - Community Team

poliorcetes
Registered User
Posts: 5
Joined: Sat Jun 15, 2019 11:03 am

Re: error migrating from 3.0 to 3.2 mysql_connect function does not exist, is mysql extension installed?

Post by poliorcetes » Sat Jun 15, 2019 1:02 pm

kinerity wrote:
Sat Jun 15, 2019 12:26 pm
Did you make the change I suggested above?
Sorry, I didn't see it.

After making that change, update database starts and then, a new error message appears

Code: Select all

General Error:SQL ERROR [ mysqli ]BLOB/TEXT column 'post_username' used in key specification without a key length [1170]SQLALTER TABLE phpbb3_posts ADD INDEX post_username (post_username) in file /var/www/html/ptmya/phpbb/db/driver/driver.php on line 997BACKTRACEFILE: (not given by php)LINE: (not given by php)CALL: installer_msg_handler()FILE: [ROOT]/phpbb/db/driver/driver.phpLINE: 997CALL: trigger_error()FILE: [ROOT]/phpbb/db/driver/mysqli.phpLINE: 193CALL: phpbb\db\driver\driver->sql_error()FILE: [ROOT]/phpbb/db/tools/tools.phpLINE: 1064CALL: phpbb\db\driver\mysqli->sql_query()FILE: [ROOT]/phpbb/db/tools/tools.phpLINE: 1551CALL: phpbb\db\tools\tools->_sql_run_sql()FILE: [ROOT]/phpbb/db/tools/tools.phpLINE: 671CALL: phpbb\db\tools\tools->sql_create_index()FILE: (not given by php)LINE: (not given by php)CALL: phpbb\db\tools\tools->perform_schema_changes()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 714CALL: call_user_func_array()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 661CALL: phpbb\db\migrator->run_step()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 400CALL: phpbb\db\migrator->process_data_step()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 288CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 241CALL: phpbb\db\migrator->update_do()FILE: [ROOT]/phpbb/install/module/update_database/task/update.phpLINE: 160CALL: phpbb\db\migrator->update()FILE: [ROOT]/phpbb/install/module_base.phpLINE: 149CALL: phpbb\install\module\update_database\task\update->run()FILE: [ROOT]/phpbb/install/installer.phpLINE: 219CALL: phpbb\install\module_base->run()FILE: [ROOT]/phpbb/install/controller/update.phpLINE: 133CALL: phpbb\install\installer->run()FILE: [ROOT]/vendor/symfony/http-foundation/StreamedResponse.phpLINE: 111CALL: phpbb\install\controller\update->phpbb\install\controller\{closure}()FILE: [ROOT]/vendor/symfony/http-foundation/Response.phpLINE: 384CALL: Symfony\Component\HttpFoundation\StreamedResponse->sendContent()FILE: [ROOT]/install/app.phpLINE: 62CALL: Symfony\Component\HttpFoundation\Response->send()
Image

and updating process is stuck at 15%

poliorcetes
Registered User
Posts: 5
Joined: Sat Jun 15, 2019 11:03 am

Re: error migrating from 3.0 to 3.2 mysql_connect function does not exist, is mysql extension installed?

Post by poliorcetes » Mon Jun 17, 2019 9:06 am

Could anybody direct me to a solution of the problem?

User avatar
canonknipser
Registered User
Posts: 1995
Joined: Thu Sep 08, 2011 4:16 am
Location: Germany
Name: Frank Jakobs
Contact:

Re: error migrating from 3.0 to 3.2 mysql_connect function does not exist, is mysql extension installed?

Post by canonknipser » Mon Jun 17, 2019 3:09 pm

on a vanilla installation, column post_username in table posts is varchar(255), not text or blob as mentioned in your error message. So maybe the table structure of your installation has been modified. Change the column back to varchar(255)
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

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

Re: error migrating from 3.0 to 3.2 mysql_connect function does not exist, is mysql extension installed?

Post by Lumpy Burgertushie » Mon Jun 17, 2019 3:19 pm

start again and follow this exactly and in order and you should be fine.

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

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?

poliorcetes
Registered User
Posts: 5
Joined: Sat Jun 15, 2019 11:03 am

Re: error migrating from 3.0 to 3.2 mysql_connect function does not exist, is mysql extension installed?

Post by poliorcetes » Mon Jun 17, 2019 10:07 pm

canonknipser wrote:
Mon Jun 17, 2019 3:09 pm
on a vanilla installation, column post_username in table posts is varchar(255), not text or blob as mentioned in your error message. So maybe the table structure of your installation has been modified. Change the column back to varchar(255)
Thanks a lot! database migration progressed to 52% and then another new mistake:
General Error: in file /var/www/html/ptmya/phpbb/db/driver/driver.php on line 994BACKTRACEFILE: (not given by php)LINE: (not given by php)CALL: installer_msg_handler()FILE: [ROOT]/phpbb/db/driver/driver.phpLINE: 994CALL: trigger_error()FILE: [ROOT]/phpbb/db/driver/mysqli.phpLINE: 193CALL: phpbb\db\driver\driver->sql_error()FILE: [ROOT]/phpbb/db/driver/driver.phpLINE: 656CALL: phpbb\db\driver\mysqli->sql_query()FILE: [ROOT]/phpbb/db/driver/factory.phpLINE: 377CALL: phpbb\db\driver\driver->sql_multi_insert()FILE: [ROOT]/phpbb/db/sql_insert_buffer.phpLINE: 138CALL: phpbb\db\driver\factory->sql_multi_insert()FILE: [ROOT]/phpbb/db/migration/profilefield_base_migration.phpLINE: 224CALL: phpbb\db\sql_insert_buffer->flush()FILE: (not given by php)LINE: (not given by php)CALL: phpbb\db\migration\profilefield_base_migration->convert_user_field_to_custom_field()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 714CALL: call_user_func_array()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 661CALL: phpbb\db\migrator->run_step()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 436CALL: phpbb\db\migrator->process_data_step()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 351CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 288CALL: phpbb\db\migrator->try_apply()FILE: [ROOT]/phpbb/db/migrator.phpLINE: 241CALL: phpbb\db\migrator->update_do()FILE: [ROOT]/phpbb/install/module/update_database/task/update.phpLINE: 160CALL: phpbb\db\migrator->update()FILE: [ROOT]/phpbb/install/module_base.phpLINE: 149CALL: phpbb\install\module\update_database\task\update->run()FILE: [ROOT]/phpbb/install/installer.phpLINE: 219CALL: phpbb\install\module_base->run()FILE: [ROOT]/phpbb/install/controller/update.phpLINE: 133CALL: phpbb\install\installer->run()FILE: [ROOT]/vendor/symfony/http-foundation/StreamedResponse.phpLINE: 111CALL: phpbb\install\controller\update->phpbb\install\controller\{closure}()FILE: [ROOT]/vendor/symfony/http-foundation/Response.phpLINE: 384CALL: Symfony\Component\HttpFoundation\StreamedResponse->sendContent()FILE: [ROOT]/install/app.phpLINE: 62CALL: Symfony\Component\HttpFoundation\Response->send()
I have tried seriously to make sense of the problem, but for no avail.

@LumpyBurgertushie, my problem is that I'm working against a SQL dump of phpBB database and a copy of the files of phpBB installation, migrated and substitued as is shown on the thread you pointed out.

I don't know what can I do in order to uninstall the themes and mods in my backup phpBB installation. I'm too afraid of messing with production database and script and destroy 14 years of conversation in my community

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

Re: error migrating from 3.0 to 3.2 mysql_connect function does not exist, is mysql extension installed?

Post by Lumpy Burgertushie » Mon Jun 17, 2019 10:34 pm

make copies and work on them instead. that way if it all goes sideways you haven't lost anything.

you can install it all on your computer if you install something like xamp or wamp server on it first.

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?

Post Reply

Return to “[3.2.x] Support Forum”