disable opcache.fast_shutdown

[Alfa1]

While trying to upgrade to the latest version I get this error:

Failed to Meet Minimum Requirements

The Zend Opcache configuration directive opcache.fast_shutdown is currently enabled by php.ini (default: disabled).

This directive has known bugs that affect the reliability of communication between web server processes, which has been documented to trigger failures in VaultWiki's installation process. This directive must be disabled to continue. Due to the properties of opcache.fast_shutdown, it may only be possible to disable via the master php.ini file for your server.

This is probably caused by a debian 8 upgrade. Is there a way to disable it by htaccess so that I can complete the upgrade and bring my wiki back online?

[pegasus]

You can try any location where you normally put php.ini configuration; however, it might only work in the main configuration file. This error message will continue to appear as long as the variable is detected as on.

For reference, the issue in Zend: https://github.com/zendtech/ZendOpti...lus/issues/146
I thought I had posted it somewhere else, but I couldn't find it.

Are you using PHP 7.2? php.net claims that opcache.fast_shutdown was removed in that version.

[Alfa1]

No, php 5.4 on that server. Cant update it due to other software being incompatible with php7.

[Eden Genesis]

I have similar issue, in order to keep using vBulletin 4, I had to downgrade to php 5. I had no problem with the previous version of Vault Wiki but once I paid and upgraded to the last version I got the following error message :

Failed to Meet Minimum Requirements
The Zend Opcache configuration directive opcache.fast_shutdown is currently enabled by php.ini (default: disabled).
This directive has known bugs that affect the reliability of communication between web server processes, which has been documented to trigger failures in VaultWiki's installation process. This directive must be disabled to continue. Due to the properties of opcache.fast_shutdown, it may only be possible to disable via the master php.ini file for your server.

How am I supposed to solve this on a php 5 forum?

[pegasus]

Probably when you downgraded PHP, the php.ini it came with has opcache.fast_shutdown. Since the default is disabled, this error message only shows when PHP is reporting it as turned on. You will need to find which php.ini file on your server has turned this on (probably the main one for your PHP installation), disable that line, and restart your PHP process manager (such as php_fpm).

PHP devs removed opcache.fast_shutdown in PHP 7.2 partly because it was buggy and they found a better way to do it. So you probably have not seen this error message before if you were using PHP 7.2.

[Eden Genesis]

Probably when you downgraded PHP, the php.ini it came with has opcache.fast_shutdown. Since the default is disabled, this error message only shows when PHP is reporting it as turned on. You will need to find which php.ini file on your server has turned this on (probably the main one for your PHP installation), disable that line, and restart your PHP process manager (such as php_fpm).

PHP devs removed opcache.fast_shutdown in PHP 7.2 partly because it was buggy and they found a better way to do it. So you probably have not seen this error message before if you were using PHP 7.2.

Thanks to my web hosting, I was able to upgrade the Vault Wiki script, however, after the script was upgraded, the following issue occured :

PHP Warning: mysqli_query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '*,`pageid`,`index`.`title` AS `title` FROM `vw_` LEFT JOIN `vw_page` `page` ...' at line 1 in ..../includes/class_core.php on line 1386

Database error in vBulletin 4.2.5:

Invalid SQL:
SELECT `di`.*,`gi`.*,`l`.*,`ch`.*,`c`.*,`i`.*,`r`.*,`page `.*,`iplog2`.`ip` AS `ipaddress`,`iplog`.`ip` AS `creatorip`,`rv`.`vote` AS `myrating`,`rv`.`reason` AS `myratingreason`,`nk`.`readtime` AS `cascadetime`,`sub`.`subscribeid` AS `issubscribed`,`sub`.`notifytype` AS `subscribetype`,`sub`.`options` AS `subscribeoptions`,`mk`.`readtime`,`di`.`userid` AS `disambig_userid`,`gi`.`userid` AS `group_userid`,`l`.`userid` AS `translate_userid`,`ch`.`userid` AS `chapter_userid`,`t`.`discussionid` AS `discussionid`,`t`.`comments` AS `commentcount`,`r`.`dateline` AS `edit_dateline`,`r`.`flags` + 0 AS `flags`,`r`.`parentid` AS `edit_parentid`,*,`pageid`,`index`.`title` AS `title` FROM `vw_` LEFT JOIN `vw_page` `page` ON (`page`.`pageid` = `pageid`)
LEFT JOIN `vw_route` `i` ON (`page`.`pageid` = `i`.`itemid` AND `i`.`itemtypeid` = 1)
LEFT JOIN `vw_counter` `c` ON (`c`.`routeid` = `i`.`routeid`)
LEFT JOIN `vw_revision` `r` ON (`r`.`revisionid` = `page`.`revisionid`)
LEFT JOIN `vw_chapter` `ch` ON (`page`.`pageid` = `ch`.`pageid`)
LEFT JOIN `vw_langitem` `l` ON (`page`.`pageid` = `l`.`pageid`)
LEFT JOIN `vw_disambigitem` `di` ON (`page`.`pageid` = `di`.`contentid` AND `di`.`contenttypeid` = 1)
LEFT JOIN `vw_discussion` `t` ON (`t`.`contentid` = `page`.`pageid` AND `t`.`displayorder` = 0 AND `t`.`contenttypeid` = 1)
LEFT JOIN `vw_teamitem` `gi` ON (`page`.`pageid` = `gi`.`pageid`)
LEFT JOIN `vw_markread` `mk` ON (`mk`.`itemtypeid` = 1 AND `mk`.`itemid` = `page`.`pageid` AND `mk`.`userid` = 1)
LEFT JOIN `vw_subscribe` `sub` ON (`sub`.`nodetypeid` = 1 AND `sub`.`nodeid` = `page`.`pageid` AND `sub`.`userid` = 1)
LEFT JOIN `vw_noderead` `nk` ON (`nk`.`nodeid` = `page`.`pageid` AND `nk`.`nodetypeid` = 1 AND `nk`.`userid` = 1)
LEFT JOIN `vw_rate` `rv` ON (`rv`.`contenttypeid` = 7 AND `rv`.`contentid` = `page`.`revisionid` AND `rv`.`userid` = 1)
LEFT JOIN `ipdata` `iplog` ON (`iplog`.`ipid` = `page`.`creator_ip_id`)
LEFT JOIN `ipdata` `iplog2` ON (`iplog2`.`ipid` = `r`.`ip_id`) WHERE 0 < `` LIMIT 1;

MySQL Error : You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '*,`pageid`,`index`.`title` AS `title` FROM `vw_` LEFT JOIN `vw_page` `page` ...' at line 1
Error Number : 1064
Request Date : Tuesday, August 1st 2023 @ 08:08:49 PM
Error Date : Tuesday, August 1st 2023 @ 08:08:50 PM
Script : http://forum.edengenesis.ws/
Referrer : http://forum.edengenesis.ws/admincp/index.php?do=head
IP Address : 62.85.131.25
Username : Eden
Classname : vB_Database_MySQLi
MySQL Version : 10.6.14-MariaDB-cll-lve
Server : 199.87.211.101
User Agent :


Check the error message on the following link :
http://forum.edengenesis.ws/

I hope you can help me solve this issue that occured just after I runned the script and installed Vault Wiki...

[pegasus]

This is usually caused by a bad cache entry after upgrading. Please try the following MySQL query:

DELETE FROM datastore
WHERE title = 'vw_nodetypes'

[Eden Genesis]

This is usually caused by a bad cache entry after upgrading. Please try the following MySQL query:

DELETE FROM datastore
WHERE title = 'vw_nodetypes'

Hello,

My Web hosting told me they couldn't do it for me.

What exactly do I have to do to do what you're asking?
I'm not very good at coding and handling this sort of thing, so the more you can tell me, the better I'll be able to do this task.

Thanks in advance for your help!

Best regards,
Ben

[Eden Genesis]

Hello,

My Web hosting told me they couldn't do it for me.

What exactly do I have to do to do what you're asking?
I'm not very good at coding and handling this sort of thing, so the more you can tell me, the better I'll be able to do this task.

Thanks in advance for your help!

Best regards,
Ben

Thanks, I managed to run an sql query by writing what you said and it worked like a charm! Thanks for all your help!