Problems updating from 3.0.14 to 3.3.15

[corleoner]

Support Request Template
What version of phpBB are you using? phpBB 3.3.15
What is your board's URL? http://raiderstation.com
Who do you host your board with? hostarmada
How did you install your board? I used a tool provided by my host
What is the most recent action performed on your board? Fresh Install
Is registration required to reproduce this issue? No
Do you have any MODs installed? No
Do you have any extensions installed? No
What styles do you currently have installed? No answer given
What language(s) is your board currently using? No answer given
Which database type/version are you using? I Don't Know
What is your level of experience? Please select your answer
What actions did you take (updating your board; installing a MOD, style or extension; etc.) prior to this problem becoming noticeable? Installed clean phpbb.3.3.15 on new domain.
Transferred db tables from old db (only transferred tables that I want to add to this board, did not transfer any mods).
Attempted to update DB through phpbb install and received this error
Please describe your problem. Received this error upon updated through phpbb install

The database update was successful.
General Error:SQL ERROR [ mysqli ]Unknown column 'user_last_active' in 'field list' [1054]SQLUPDATE phpbb_users SET user_last_active = 1746491638 WHERE user_id = 1 in file /home2/raiderst/public_html/phpbb/db/driver/driver.php on line 1031
Skip ???installer.update_filesystem.download_updated_files??? task
Skip ???installer.update_filesystem.update_files??? task
Skip ???installer.update_filesystem.show_file_status??? task
Skip ???installer.update_filesystem.diff_files??? task
Skip ???installer.update_filesystem.check_task??? task
Skip ???installer.obtain_data.update_ftp_settings??? task
Skip ???installer.obtain_data.update_files??? task
Skip ???installer.obtain_data.file_updater_method??? task
Generated by SRT Generator



I have an old forum on 3.0.14. I am going to switch to 3.3.15 on a new domain but the same forum (just want a new domain name and will eventually add extensions).

Have tried several methods and nothing has worked. Besides just adding the selective tables I need and trying to update, I've also added the entire db from my 3.0.14 database, I'm able to convert that, but it then redirects me to my old domain after I log in.

Just looking for the simplest method to add my tables from my old 3.0.14 forum, to the new 3.3.15, which will be on a new domain with new host.

[rxu]

Just in case, is nginx the webserver phpBB is running on?

[corleoner]

Just in case, is nginx the webserver phpBB is running on?

I am through hostarmada with the Speed Reaper shared hosting plan which has LiteSpeed as its web server, not NGINX

[rxu]

LiteSpeed as its web server, not NGINX

Not familiar with the LiteSpeed, but does it use phpBB's standard .htaccess of some own rewrite rules set? Wondering this because the error can be caused by webserver rewrite rules misconfiguration.

[corleoner]

LiteSpeed as its web server, not NGINX

Not familiar with the LiteSpeed, but does it use phpBB's standard .htaccess of some own rewrite rules set? Wondering this because the error can be caused by webserver rewrite rules misconfiguration.

Here's my .htaccess

Code: Select all

<IfModule mod_rewrite.c>
RewriteEngine on

#
# Uncomment the statement below if URL rewriting doesn't
# work properly. If you installed phpBB in a subdirectory
# of your site, properly set the argument for the statement.
# e.g.: if your domain is test.com and you installed phpBB
# in http://www.test.com/phpBB/index.php you have to set
# the statement RewriteBase /phpBB/
#
#RewriteBase /

#
# Uncomment the statement below if you want to make use of
# HTTP authentication and it does not already work.
# This could be required if you are for example using PHP via Apache CGI.
#
#RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization},L]

#
# The following 3 lines will rewrite URLs passed through the front controller
# to not require app.php in the actual URL. In other words, a controller is
# by default accessed at /app.php/my/controller, but can also be accessed at
# /my/controller
#
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^(.*)$ app.php [QSA,L]

#
# If symbolic links are not already being followed,
# uncomment the line below.
# http://anothersysadmin.wordpress.com/2008/06/10/mod_rewrite-forbidden-403-with-apache-228/
#
#Options +FollowSymLinks
</IfModule>

# Apache content negotation tries to interpret non-existent paths as files if
# MultiViews is enabled. This will however cause issues with paths containg
# dots, e.g. for the cron tasks
<IfModule mod_negotiation.c>
	Options -MultiViews
</IfModule>

# With Apache 2.4 the "Order, Deny" syntax has been deprecated and moved from
# module mod_authz_host to a new module called mod_access_compat (which may be
# disabled) and a new "Require" syntax has been introduced to mod_authz_host.
# We could just conditionally provide both versions, but unfortunately Apache
# does not explicitly tell us its version if the module mod_version is not
# available. In this case, we check for the availability of module
# mod_authz_core (which should be on 2.4 or higher only) as a best guess.
<IfModule mod_version.c>
	<IfVersion < 2.4>
		<Files "config.php">
			Order Allow,Deny
			Deny from All
		</Files>
		<Files "common.php">
			Order Allow,Deny
			Deny from All
		</Files>
	</IfVersion>
	<IfVersion >= 2.4>
		<Files "config.php">
			Require all denied
		</Files>
		<Files "common.php">
			Require all denied
		</Files>
	</IfVersion>
</IfModule>
<IfModule !mod_version.c>
	<IfModule !mod_authz_core.c>
		<Files "config.php">
			Order Allow,Deny
			Deny from All
		</Files>
		<Files "common.php">
			Order Allow,Deny
			Deny from All
		</Files>
	</IfModule>
	<IfModule mod_authz_core.c>
		<Files "config.php">
			Require all denied
		</Files>
		<Files "common.php">
			Require all denied
		</Files>
	</IfModule>
</IfModule>

Not looking for anything fancy, just a way to transfer the tables over to a new phpbb 3.3.15 install and wasn't expecting this many problems. Had AI helping me for several hours, but seems AI is definitely not all it's cracked up to be sometimes lol.

[rxu]

Is there probably some backtrace for the relevant error in webserver's error log? It would help to track down the issue.