Version 4 Upload/install error

[Barlee]

Hi,

I have just uploaded the files and immediately get a page error before I can even do anything, what am i doing wrong. Basically I uploaded the files that I got from the Client area, that is all so far

 

[Rhett]

You need to actually run the upgrade after uploading the files  /admin/upgrade

 

 

[Barlee]

Thank you, I never realised that, I thought it would redirect me to an install page, let me try again.

[Barlee]

Thanks, I did get it started and i got to a point when it wanted to convert the database to IPS UTF8 and it is now sitting at this point and has been for about 30 minutes

Processing reputation_cache (Total: 50.42%)

Is this normal?

[Marcher Technologies]

how many rows are in that table? It is just a cache, might be easiest to truncate that table, the reputation_index is there for a reason.

the web converter itself will happily continue where it left off if you refresh by design IIRC.

[Barlee]

Hi Marcher,

1179, I would have no idea on how to do what you are suggesting

[Marcher Technologies]

That seems... rather small to be giving issue. Have you tried just refreshing? That does not seem normal. Likely worth a ticket(and revert of your db and files from backup) if that doesn't help, you may need to have a tech review your database and advise if a few config option constants are needing set to convert to UTF-8 correctly.

[Barlee]

Shoot, never did a backup..ooops! forgot, only backed up my files

[Marcher Technologies]

Put in a ticket to have it looked at. It's your best bet to get the conversion pushed through, or for that matter as you haven't been able to finish it yet, reverted to the original tables for closer inspection with your site able to be online while it's figured out.

[Barlee]

Hi Marcher,

How do I revert to original tables?

[Marcher Technologies]

Hi Marcher,

How do I revert to original tables?​

Put in a ticket to have it looked at.

​If you wouldn't know where to begin truncating a table, it really would be best(safest) to let them handle it. The converter makes a backup of the original tables before doing anything with a prefix of orig_. Support should be able to work with that to investigate the issue and assist.

[Barlee]

Hi Marcher,

I switched over to the Tools tab and there was an option to repair, i ran that and once done when back to the conversion and it all happened. So that is nice, they have covered for my issue within the upgrade

[Barlee]

Hi Marcher,

What does this mean?

[Marcher Technologies]

Hi Marcher,

What does this mean?

​it means you have a large enough amount of rows in that table that it is not advisable to run that query through a web interface as it is likely to time out(not good mid upgrade), and need to run the query provided via ssh against your mysql database before continuing.

 

[Barlee]

Is this correct?

[Barlee]

Or this one?

[Marcher Technologies]

the latter should be fine.

IIRC, the query will still continue to run even if that window times out, if it does time out, you can run

SHOW FULL PROCESSLIST;

in another to check if it's finished then proceed with the upgrade when it is.

This is prompted here to avoid the upgrade itself timing out.

[Barlee]

All done Marcher,, thank you for your assistance..

[Barlee]

Hi Marcher,

One thing during upgrade I noticed this and it never totally made sense but how do i returrn this to post topic instead of this ask a question stuff.

[Marcher Technologies]

Hi Marcher,

One thing during upgrade I noticed this and it never totally made sense but how do i returrn this to post topic instead of this ask a question stuff.

​Edit the given forum from your ACP -> Community -> Forums -> Forums and change the 'Type' to 'Discussions'.

That was probably a Q&A-enabled forum in 3.x.

[Barlee]

Thank you