Fatal Error Migrating existing forum to PHP 7 host

Post by **Kailey** » Fri Jan 19, 2018 12:45 pm

UXgizmo wrote: ↑Fri Jan 19, 2018 5:36 am Ok now I'm getting the error below when i go to update database via the install/directory

General Error:SQL ERROR [ mysqli ]Unknown column 'style_path'...

Is that the complete error? Also, if your old board was 3.0, try running the Support Toolkit database cleaner before you update.

UXgizmo · Post by **UXgizmo** » Fri Jan 19, 2018 1:41 pm

@kinerity thanks for following up I appreciate your time and Yes it’s a really old board 3.0.

Yes error message was much longer and super angry looking to say the least. should I post it? I was just worried it had too much server info on it

Since I already ran it and it errored do I need to delete and reupload the site or just the install files with the support kit?

Post by **Kailey** » Fri Jan 19, 2018 2:58 pm

UXgizmo wrote: ↑Fri Jan 19, 2018 1:41 pm Yes error message was much longer and super angry looking to say the least. should I post it? I was just worried it had too much server info on it

You can leave out IP addresses, domain names, usernams and passwords.

UXgizmo wrote: ↑Fri Jan 19, 2018 1:41 pm Since I already ran it and it errored do I need to delete and reupload the site or just the install files with the support kit?

Just to be on the safe side, I would re-upload the old files and database, then run the STK.

UXgizmo · Post by **UXgizmo** » Sat Jan 20, 2018 12:19 am

kinerity wrote: ↑Fri Jan 19, 2018 12:45 pm
UXgizmo wrote: ↑Fri Jan 19, 2018 5:36 am Ok now I'm getting the error below when i go to update database via the install/directory

General Error:SQL ERROR [ mysqli ]Unknown column 'style_path'...
Is that the complete error? Also, if your old board was 3.0, try running the Support Toolkit database cleaner before you update.

@Kinerity I get this error when I run the database_cleaner
HTTP ERROR 500

Post by **Kailey** » Sat Jan 20, 2018 12:20 am

You'll have to look in the server's error log as to why you're getting that error. If you don't have access, your host will have to do it for you.

Lumpy Burgertushie · Post by **Lumpy Burgertushie** » Sat Jan 20, 2018 12:23 am

just to be clear, his advice to run the STK was only if you had reverted back to your 3.0 board files and database. the STK does not work on 3.1 or 3.2

robert

UXgizmo · Post by **UXgizmo** » Sat Jan 20, 2018 12:36 am

kinerity wrote: ↑Sat Jan 20, 2018 12:20 am You'll have to look in the server's error log as to why you're getting that error. If you don't have access, your host will have to do it for you.

Below are the errors log from the ROOT and from the STK file
--------------------------------------------
Error log from forum root

Code: Select all

[12-Oct-2010 09:18:19] PHP Warning:  Cannot modify header information - headers already sent by

Then a long list of these

Code: Select all

[09-Nov-2010 21:48:45] PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/imagick.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/imagick.so: cannot open shared object file: No such file or directory in Unknown on line 0
[09-Nov-2010 21:48:45] PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so: cannot open shared object file: No such file or directory in Unknown on line 0
[09-Nov-2010 21:48:45] PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0
[09-Nov-2010 21:48:45] PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0
[09-Nov-2010 21:48:45] PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0
[09-Nov-2010 21:48:45] PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/ixed.5.2.lin' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/ixed.5.2.lin: cannot open shared object file: No such file or directory in Unknown on line 0
[09-Nov-2010 21:48:45] PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/magickwand.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/magickwand.so: cannot open shared object file: No such file or directory in Unknown on line 0
[09-Nov-2010 21:48:45] PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/imagick.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/imagick.so: cannot open shared object file: No such file or directory in Unknown on line 0
[09-Nov-2010 21:48:45] PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo.so: cannot open shared object file: No such file or directory in Unknown on line 0
[09-Nov-2010 21:48:45] PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0
[09-Nov-2010 21:48:45] PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/sqlite.so: cannot open shared object file: No such file or directory in Unknown on line 0
[09-Nov-2010 21:48:45] PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/pdo_mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0
[09-Nov-2010 21:48:45] PHP Warning:  PHP Startup: Unable to load dynamic library '/usr/local/lib/php/extensions/no-debug-non-zts-20060613/ixed.5.2.lin' - /usr/local/lib/php/extensions/no-debug-non-zts-20060613/ixed.5.2.lin: cannot open shared object file: No such file or directory in Unknown on line 0

Then more 

[24-Nov-2016 17:30:16 America/Denver] PHP Strict Standards:  Non-static method acp_styles::load_css_file() should not be called statically 
[20-Jan-2018 00:20:10 UTC] PHP Parse error:  syntax error, unexpected 'new' (T_NEW)
[24-Nov-2016 16:51:59 America/Denver] PHP Strict Standards:  Non-static method acp_styles::db_theme_data() should not be called statically in /home5//public_html/phpBB3/style.php on line 200
[24-Nov-2016 16:51:59 America/Denver] PHP Strict Standards:  Non-static method acp_styles::load_css_file() should not be called statically in /home5//public_html/phpBB3/includes/acp/acp_styles.php on line 2542
[24-Nov-2016 17:14:25 America/Denver] PHP Warning:  Unterminated comment starting line 686 in /home5//public_html/phpBB3/includes/functions_display.php on line 686
[24-Nov-2016 17:14:25 America/Denver] PHP Parse error:  syntax error, unexpected 'moderators' (T_STRING) in /home5//public_html/phpBB3/includes/functions_display.php on line 687
[24-Nov-2016 17:30:16 America/Denver] PHP Strict Standards:  Non-static method acp_styles::db_theme_data() should not be called statically in /home5//public_html/phpBB3/style.php on line 189
[24-Nov-2016 17:30:16 America/Denver] PHP Strict Standards:  Non-static method acp_styles::load_css_file() should not be called statically in /home5//public_html/phpBB3/includes/acp/acp_styles.php on line 2717
[20-Jan-2018 00:20:10 UTC] PHP Parse error:  syntax error, unexpected 'new' (T_NEW) in /home//public_html//includes/captcha/plugins/phpbb_captcha_gd_plugin.php on line 55'

---------------------------
Error log from root of STK directory

Code: Select all

[20-Jan-2018 00:14:58 UTC] PHP Parse error:  syntax error, unexpected 'new' (T_NEW) in /home//public_html//includes/captcha/plugins/phpbb_captcha_qa_plugin.php on line 104
[20-Jan-2018 00:15:10 UTC] PHP Parse error:  syntax error, unexpected 'new' (T_NEW) in /home//public_html//includes/captcha/plugins/phpbb_captcha_qa_plugin.php on line 104
[20-Jan-2018 00:17:20 UTC] PHP Parse error:  syntax error, unexpected 'new' (T_NEW) in /home/public_html//includes/captcha/plugins/phpbb_captcha_qa_plugin.php on line 104

UXgizmo · Post by **UXgizmo** » Sat Jan 20, 2018 12:38 am

Lumpy Burgertushie wrote: ↑Sat Jan 20, 2018 12:23 am just to be clear, his advice to run the STK was only if you had reverted back to your 3.0 board files and database. the STK does not work on 3.1 or 3.2

robert

Yes I reuploaded the old files and database before I ran the stk file

Post by **Kailey** » Sat Jan 20, 2018 12:42 am

UXgizmo wrote: ↑Sat Jan 20, 2018 12:36 am

Code: Select all

[20-Jan-2018 00:20:10 UTC] PHP Parse error:  syntax error, unexpected 'new' (T_NEW) in /home//public_html//includes/captcha/plugins/phpbb_captcha_gd_plugin.php on line 55'

---------------------------
Error log from root of STK directory

Code: Select all

[20-Jan-2018 00:14:58 UTC] PHP Parse error:  syntax error, unexpected 'new' (T_NEW) in /home//public_html//includes/captcha/plugins/phpbb_captcha_qa_plugin.php on line 104
[20-Jan-2018 00:15:10 UTC] PHP Parse error:  syntax error, unexpected 'new' (T_NEW) in /home//public_html//includes/captcha/plugins/phpbb_captcha_qa_plugin.php on line 104
[20-Jan-2018 00:17:20 UTC] PHP Parse error:  syntax error, unexpected 'new' (T_NEW) in /home/public_html//includes/captcha/plugins/phpbb_captcha_qa_plugin.php on line 104

These right here are your problem. Can you upload a new phpbb_captcha_gd_plugin.php file from a fresh 3.0 download?

UXgizmo · Post by **UXgizmo** » Sat Jan 20, 2018 12:48 am

These right here are your problem. Can you upload a new phpbb_captcha_gd_plugin.php file from a fresh 3.0 download?
[/quote]

Where might I find a fresh 3.0 download? Any recommendations?

UXgizmo · Post by **UXgizmo** » Sat Jan 20, 2018 12:52 am

UXgizmo wrote: ↑Sat Jan 20, 2018 12:48 am
... file from a fresh 3.0 download?

Sorry to clarify I meant finding a fresh 3.0 download?

Post by **Kailey** » Sat Jan 20, 2018 12:57 am

phpBB 3.0.14 directly from phpBB.

UXgizmo · Post by **UXgizmo** » Sat Jan 20, 2018 1:09 am

kinerity wrote: ↑Sat Jan 20, 2018 12:42 am

UXgizmo wrote: ↑Sat Jan 20, 2018 12:36 am

Code: Select all

[20-Jan-2018 00:20:10 UTC] PHP Parse error:  syntax error, unexpected 'new' (T_NEW) in /home//public_html//includes/captcha/plugins/phpbb_captcha_gd_plugin.php on line 55'

---------------------------
Error log from root of STK directory

Code: Select all

[20-Jan-2018 00:14:58 UTC] PHP Parse error:  syntax error, unexpected 'new' (T_NEW) in /home//public_html//includes/captcha/plugins/phpbb_captcha_qa_plugin.php on line 104
[20-Jan-2018 00:15:10 UTC] PHP Parse error:  syntax error, unexpected 'new' (T_NEW) in /home//public_html//includes/captcha/plugins/phpbb_captcha_qa_plugin.php on line 104
[20-Jan-2018 00:17:20 UTC] PHP Parse error:  syntax error, unexpected 'new' (T_NEW) in /home/public_html//includes/captcha/plugins/phpbb_captcha_qa_plugin.php on line 104

These right here are your problem. Can you upload a new phpbb_captcha_gd_plugin.php file from a fresh 3.0 download?

After replacing the captcha file I'm still seeing these errors using the database cleaner

Post by **Kailey** » Sat Jan 20, 2018 1:19 am

I'm at a loss. Those errors should have gone away with the file replacement. Try replacing the entire package (keeping your config.php file obviously).

UXgizmo · Post by **UXgizmo** » Sat Jan 20, 2018 2:06 am

kinerity wrote: ↑Sat Jan 20, 2018 1:19 am I'm at a loss. Those errors should have gone away with the file replacement. Try replacing the entire package (keeping your config.php file obviously).

So I'm replacing the entire phpbb with the fresh 3.0.x package keeping the config file? or are you saying I'm replacing the files with the old forum again?