Update 1.14 to 1.18

PavelH

When updating from 1.14.1 to 1.18, the email_id column should be added to the thread_entry_email table.
After running update, the thread_entry_email_new table is created but not filled with data. Updater is waiting.

I realize this is an update to version 1.15 and I don't want to waste time with this problem. I can create the required table myself. Therefore, I would just like to ask: what data should the email_id column be filled with?
When I look at the SQL query that is executed during the update, I have the feeling that the column will remain empty.
// Insert rows into the new table starting at the start and stopping at the end id $sql = "INSERT INTO ". THREAD_ENTRY_EMAIL_NEW_TABLE ." SELECT B.id, B.thread_entry_id, NULL, B.mid, B.headers FROM ". THREAD_ENTRY_EMAIL_TABLE . " B WHERE B.id >= ".$info['start']." AND B.id < ". $info['end'];
Are data added to the email_id column until after the update?

KevinTheJedi

PavelH

Even if you create it yourself it won't work. This is only a temporary table that all the data from the original table gets put into, then the og table is deleted, and lastly the new table is renamed to the og name to replace the old table. You need to just keep polling the upgrader until it finishes (ie. refresh the page and click Upgrade Now again). You may be running into an issue with server timeouts or even MySQL timeouts.

Cheers.

PavelH

Thank you for answer.
Yes, I know the process of renaming tables.
If the thread_entry_email_new table is not filled with data, the resulting table will also be empty after renaming.
Therefore, I want to fill it manually, comment out the code for creating and filling the table. Then I can run the upgrade.
I just want to avoid unfunctionally filling the table with data.

The only thing I'm missing is the content of the email_id column. Therefore, I would like to repeat the questions: What data should the email_id column be filled with? Are data added to the email_id column until after the update?

KevinTheJedi refresh the page and click Upgrade Now again

Refresh doesn't work. The page keeps loading but never loads.
Additionally, it would show an error that the table thread_entry_email_new already exists.

KevinTheJedi

PavelH

Then it definitely sounds like timeout issues or something similar. If you don’t want to fix the root issue and just want to do all of this manually you can find the relevant patch file, grab the first part of the file name (the hash-hash part), find the associated Task and Cleanup files with the same hash names in the beginning (eg. 1234567-9876543.task.sql) to see how it repopulates and cleans up everything, and then run those manually.

Cheers.