Errors in connection with test-upgrade of php-fusion.dk: PHPFusion 9 Support

Home
Search

Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.

I have been following the instructions strictly in the read-me-file trying to upgrade our supportsite - so far only on my localhost.
But without success. Last attempt this morning (04/29/2017) ended with this:

Code Download source

Warning: mysqli_fetch_assoc() expects parameter 1 to be mysqli_result, boolean given in C:\xampp\htdocs\fusdk_28042017\includes\classes\PHPFusion\Database\Driver\MySQLi.inc on line 103

Notice: Undefined index: uf_skype in C:\xampp\htdocs\fusdk_28042017\upgrade\9.0.upgrade.inc on line 647

Notice: Undefined index: uf_aim in C:\xampp\htdocs\fusdk_28042017\upgrade\9.0.upgrade.inc on line 650

Notice: Undefined index: uf_icq in C:\xampp\htdocs\fusdk_28042017\upgrade\9.0.upgrade.inc on line 653

Notice: Undefined index: uf_theme in C:\xampp\htdocs\fusdk_28042017\upgrade\9.0.upgrade.inc on line 662

Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\fusdk_28042017\includes\classes\PHPFusion\Database\Configuration.inc on line 39

It says that the indexes in some of the userfields doesn't exist ... but they do. And allthough I earlier changed the memory_limit in my localhost installation (because this created some problems) the upgrade seems to have timed out - as you can see. Now I have run out of ideas. Any advice??

0 replies

Falk

answered 29 Apr 2017 at 09:36 AM

Super Admin

It could be because the script did not have time to finnish, increase the execution time by a lot for a larger site.

Quote

Fatal error: Maximum execution time of 30 seconds exceeded in C:\xampp\htdocs\fusdk_28042017\includes\classes\PHPFusion\Database\Configuration.inc on line 39

0 replies

How much?? I have allready changed another value in php.ini ... memory_limit to 512M. And isn't this a problem, that should be addressed somehow??

0 replies

Falk

answered 29 Apr 2017 at 09:53 AM

Super Admin

From your post it reports that the script exceeded the allowed execution time. Try 90, 120 etc the amount you need is where it ends. Hard to predict in your environment and depends on database etc.
See if you can find default value of max_execution_time.

0 replies

I have done that ... and changed maximum ex-time to 5 minutes (300 seconds) ... that might work. But what about all the BIG sites out there, where the siteowner does not have the the rights to change these values?? And they are there, that's for sure.

0 replies

Falk

answered 29 Apr 2017 at 10:46 AM

Super Admin

:G
There is just no simple way to do it due to possible server / environment limitations.
They will have to tackle it in a clever way. I really don´t have a perfect answer yet.
Perhaps , upgrade users only first, move on to Forums after a complete install etc. It will require a very strong environment for the really large sites, that is for sure.
Let´s see what happens when we start with Main here, 50k+ users and quite a lot of Forum posts.

0 replies

OK ... focus on this because we will see thousands of support requests when this problem emerges ...

0 replies

Falk

answered 29 Apr 2017 at 01:02 PM

Super Admin

If the site owners out grown their environment and the scripts time out, not due to our procedure but rather lack of hardware and resources and / or knowledge in how to tackle larger databases ( it is primarily a database issue ) when it comes to getting it upgraded. I can imagine setting up some service where we help people with it.

0 replies

Maybe ... but maybe also a script, that is able to "analyze" an existing site and warn the owner :

1. If DB is to big ... and what tables are the problem
2. If site is using infusions, that aren't certified
3. If site uses a theme that can give complications
4. If site have other problems ... maybe problems in connection with versions of PHP, MySQL and alike

And give the siteowner some tools to deal with the problems. For example:

1. Delete messages older than ...
2. Depending on the character of the problems different suggestions to deal with them
3. Delete certain parts of the forum-table - or the articles-table - or the news-table

0 replies

Is this the general size of the DB or just some specific tables?

I have previously suceeded in using BigDump http://www.ozerov.de/bigdump/ for large databases. It fucuses on:

Quote

You want to restore the very large backup of your mySQL database into the new or the same mySQL database. You can’t access the server shell and you can’t import the dump using phpMyAdmin or any other scripts due to hard memory resp. runtime limit of the web server.

.
I am not sure this is Janmols issue, but perhaps looking at that might help. Information in the FAQ might also be relevant.

Is this any help?

0 replies

Well ... the problem with a big DB isn't that hard to handle. My DB-tool (Navicat Premium) works fine with databases bigger than the one, we have (dump is on 29 M

. And importing works fine as well. Problem is, that it's necessary to make some structural and format changes in the same process to make an upgraded site work. So a simple import won't do the trick.

I suppose that it's possible to do this manually - it will take a lot of time, but it's possible.

But a lot of users does not have the skills or the access rights to go through this manual process. It should be possible to cut up the upgrade process in "chunks" so that you don't get timeouts or other errors. But as it is right now, this is not an option.

0 replies

Falk

answered 30 Apr 2017 at 09:42 AM

Super Admin

Yes, we will need to monitor the development and see what we need to do if it becomes a problem.
Everything is so situational, it boils down to what resources you sit on vs db sizes.

1, Depends on content from owner. Mostly Forums I guess.
2. Today all but default ones shipped with pack are non certified.
3. Any given non default theme can cause issues
4. We have min requirements, should settle it. Version is PHP 7.1+ ready

There are some tools in the mix for next version that actually contain some "sanitation" options.

0 replies

Category Forum

Upgrading issues - 9

Labels

None yet

Statistics

Views 0 views
Posts 11 posts
Votes 0 votes
Topic users 3 members

3 participants

Notifications

Track thread

You are not receiving notifications from this thread.

Errors in connection with test-upgrade of php-fusion.dk

11 posts

PHPFusion

Resources

Community

Development