Barlee Posted March 22, 2015 Share Posted March 22, 2015 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 Link to comment Share on other sites More sharing options...
Rhett Posted March 22, 2015 Share Posted March 22, 2015 You need to actually run the upgrade after uploading the files /admin/upgrade Link to comment Share on other sites More sharing options...
Barlee Posted March 22, 2015 Author Share Posted March 22, 2015 Thank you, I never realised that, I thought it would redirect me to an install page, let me try again. Link to comment Share on other sites More sharing options...
Barlee Posted March 22, 2015 Author Share Posted March 22, 2015 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 minutesProcessing reputation_cache (Total: 50.42%)Is this normal? Link to comment Share on other sites More sharing options...
Marcher Technologies Posted March 22, 2015 Share Posted March 22, 2015 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. Link to comment Share on other sites More sharing options...
Barlee Posted March 22, 2015 Author Share Posted March 22, 2015 Hi Marcher,1179, I would have no idea on how to do what you are suggesting Link to comment Share on other sites More sharing options...
Marcher Technologies Posted March 22, 2015 Share Posted March 22, 2015 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. Link to comment Share on other sites More sharing options...
Barlee Posted March 22, 2015 Author Share Posted March 22, 2015 Shoot, never did a backup..ooops! forgot, only backed up my files Link to comment Share on other sites More sharing options...
Marcher Technologies Posted March 22, 2015 Share Posted March 22, 2015 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. Link to comment Share on other sites More sharing options...
Barlee Posted March 22, 2015 Author Share Posted March 22, 2015 Hi Marcher,How do I revert to original tables? Link to comment Share on other sites More sharing options...
Marcher Technologies Posted March 22, 2015 Share Posted March 22, 2015 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. Link to comment Share on other sites More sharing options...
Barlee Posted March 22, 2015 Author Share Posted March 22, 2015 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 Link to comment Share on other sites More sharing options...
Barlee Posted March 22, 2015 Author Share Posted March 22, 2015 Hi Marcher, What does this mean? Link to comment Share on other sites More sharing options...
Marcher Technologies Posted March 22, 2015 Share Posted March 22, 2015 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. Link to comment Share on other sites More sharing options...
Barlee Posted March 22, 2015 Author Share Posted March 22, 2015 Is this correct? Link to comment Share on other sites More sharing options...
Barlee Posted March 22, 2015 Author Share Posted March 22, 2015 Or this one? Link to comment Share on other sites More sharing options...
Marcher Technologies Posted March 22, 2015 Share Posted March 22, 2015 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 runSHOW 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. Link to comment Share on other sites More sharing options...
Barlee Posted March 22, 2015 Author Share Posted March 22, 2015 All done Marcher,, thank you for your assistance.. Link to comment Share on other sites More sharing options...
Barlee Posted March 22, 2015 Author Share Posted March 22, 2015 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. Link to comment Share on other sites More sharing options...
Marcher Technologies Posted March 22, 2015 Share Posted March 22, 2015 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. Link to comment Share on other sites More sharing options...
Barlee Posted March 22, 2015 Author Share Posted March 22, 2015 Thank you Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.