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, 2025 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/