Error: upgrade WHMCS 7.0.1 to 7.4.2,

[LukeDouglas]

When attempting to upgrade WHMCS 7.0.1 to 7.4.2, I get this error message:

Update Failed
An error occurred that prevented the update from completing successfully.

Unable to complete incremental updates: Unable to import the 7.1.0 Beta1 database file. Unable to import /home/xxxxxxxx/public_html/billing/resources/sql/upgrade710beta1.sql: SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'xxxxxxxx_xxxxxxx'@'localhost' to database 'xxxxxxxx_whmcs_xxxxxxxxxx'
Please try again and if the issue persists, please contact support.

If I click the Configure Settings on the update page, I get this error:

 

An error occurred while communicating with the server. Please try again.

 

PHPINFO - core:

Core
PHP Version	7.0.27
Directive	Local Value	Master Value
allow_url_fopen	On	On
allow_url_include	On	On
arg_separator.input	&	&
arg_separator.output	&	&
auto_append_file	no value	no value
auto_globals_jit	On	On
auto_prepend_file	no value	no value
browscap	no value	no value
default_charset	UTF-8	UTF-8
default_mimetype	text/html	text/html
disable_classes	no value	no value
disable_functions	no value	no value
display_errors	On	Off
display_startup_errors	Off	Off
doc_root	no value	no value
docref_ext	no value	no value
docref_root	no value	no value
enable_dl	Off	Off
enable_post_data_reading	On	On
error_append_string	no value	no value
error_log	error_log	error_log
error_prepend_string	no value	no value
error_reporting	32759	32759
exit_on_timeout	Off	Off
expose_php	Off	Off
extension_dir	/opt/cpanel/ea-php70/root/usr/lib64/php/modules	/opt/cpanel/ea-php70/root/usr/lib64/php/modules
file_uploads	On	On
highlight.comment	#FF8000	#FF8000
highlight.default	#0000BB	#0000BB
highlight.html	#000000	#000000
highlight.keyword	#007700	#007700
highlight.string	#DD0000	#DD0000
html_errors	On	On
ignore_repeated_errors	Off	Off
ignore_repeated_source	Off	Off
ignore_user_abort	Off	Off
implicit_flush	Off	Off
include_path	.:/opt/cpanel/ea-php70/root/usr/share/pear	.:/opt/cpanel/ea-php70/root/usr/share/pear
input_encoding	no value	no value
internal_encoding	no value	no value
log_errors	On	On
log_errors_max_len	1024	1024
mail.add_x_header	On	On
mail.force_extra_parameters	no value	no value
mail.log	no value	no value
max_execution_time	90	30
max_file_uploads	20	20
max_input_nesting_level	64	64
max_input_time	60	60
max_input_vars	1000	1000
memory_limit	384M	64M
open_basedir	no value	no value
output_buffering	no value	no value
output_encoding	no value	no value
output_handler	no value	no value
post_max_size	64M	10M
precision	14	14
realpath_cache_size	4096K	4096K
realpath_cache_ttl	120	120
register_argc_argv	On	On
report_memleaks	On	On
report_zend_debug	On	On
request_order	GP	GP
sendmail_from	no value	no value
sendmail_path	/usr/sbin/sendmail -t -i	/usr/sbin/sendmail -t -i
serialize_precision	100	100
short_open_tag	On	On
SMTP	localhost	localhost
smtp_port	25	25
sql.safe_mode	Off	Off
sys_temp_dir	no value	no value
track_errors	Off	Off
unserialize_callback_func	no value	no value
upload_max_filesize	63M	10M
upload_tmp_dir	no value	no value
user_dir	no value	no value
user_ini.cache_ttl	300	300
user_ini.filename	.user.ini	.user.ini
variables_order	GPCS	GPCS
xmlrpc_error_number	0	0
xmlrpc_errors	Off	Off
zend.assertions	-1	-1
zend.detect_unicode	On	On
zend.enable_gc	On	On
zend.multibyte	Off	Off
zend.script_encoding	no value	no value

This is an AutoSSL secured site.  I'm not sure if that is the issue.

I need some feedback on what is the issue.

 

[natanet]

sometime i also face error during upgrade..

and the solution need to create folder whmcs in /path/to/whmcs/vendor/ and create whmcs folder

 

thanks