Updating from 8.11 to 8.13 automatic update error

[zitu4life]

Hello there

Trying automatic update via browser from 8.11 to 8.13 and stuck on this SQL error.

What could be next steps to fix this

 

SQLSTATE[42S02]: Base table or view not found: 1146 Table 'my_sql_database.tblticketactions' doesn't exist (SQL: select * from `tblticketactions` where `action` = AssignTicket order by `tblticketactions`.`id` asc limit 1000 offset 0)

 

My configuration before start installation

regards

[zitu4life]

Now got this

Unable to complete incremental updates: Unable to import the 8.12.0 database file. Unable to import /home/my_folder_name/public_html/resources/sql/upgrade8120release1.sql: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'upsell_from_products' in 'tblhosting'

 

I suspect this issue is related to fact I did not upgrade to 8.12 before going to 8.13, if that is the case WHMCS needs to adress this before General public release of v8.13

Edited May 9 by zitu4life

[zitu4life]

already opened a ticket Ticket #VNK-093034 and provide access to the instaltion for further look
PS: I have a monthly license

[WHMCS John]

Hi @zitu4life,

I've tested an auto-update from 8.11 to 8.13 and it completed successfully. These errors indicate that the schema modifications for 8.12 weren't completed.

To recover from this position I recommend:

1. Restore your pre-upgrade database backup
2. Download the 8.13.0 full release zip file from https://download.whmcs.com
3. Upload and unzip the files, ensuring all files extract successfully, paying particular attention to the /resources/sql/upgrade8120rc1.sql and upgrade8120beta1.sql files.
4. Then visit /install/install.php to run the update script.

Related help guide:https://docs.whmcs.com/8-13/troubleshooting/general-troubleshooting/down-for-maintenance-errors/