• Register
    • Help

    striker  0 Items
    Currently Supporting
    • Home
    • News
    • Forum
    • Wiki
    • Support
      • Manage Subscriptions
      • FAQ
      • Support For
        • VaultWiki 4.x Series
        • VaultWiki.org Site
    • What's New?
    • Buy Now
    • Manual
    • 
    • Support
    • VaultWiki 4.x Series
    • Bug
    • Xenforo Error Upgrading - Zend Opcache

    1. Welcome to VaultWiki.org, home of the wiki add-on for vBulletin and XenForo!

      VaultWiki allows your existing forum users to collaborate on creating and managing a site's content pages. VaultWiki is a fully-featured and fully-supported wiki solution for vBulletin and XenForo.

      The VaultWiki Team encourages you to join our community of forum administrators and check out VaultWiki for yourself.

    Issue: Xenforo Error Upgrading - Zend Opcache

    • Issue Tools
      • View Changes
    1. issueid=4448 November 14, 2015 4:11 AM
      Mart456 Mart456 is offline
      Junior Member
      Xenforo Error Upgrading - Zend Opcache

      This is the second time i have posted this the first post, has for some reason not shown up...


      I keep getting this error upgrading,

      "Zend Opcache is enabled by php.ini, but uses an unsafe configuration. PHP files can still read from the cache during upgrades. This behavior can result in unintended database damage."


      I have read other posts about turning off Opcache and making sure some of the setting are correct, i have tried various cobinations of settings the php.ini and nothing seems to work

      This is the current opcahce settings:

      Code:
      [opcache]
      
      
      ; Determines if Zend OPCache is enabled
      opcache.enable=1
      
      ; Determines if Zend OPCache is enabled for the CLI version of PHP
      opcache.enable_cli=1
      
      ; The OPcache shared memory storage size.
      opcache.memory_consumption=128
      
      ; The amount of memory for interned strings in Mbytes.
      opcache.interned_strings_buffer=8
      
      ; The maximum number of keys (scripts) in the OPcache hash table.
      ; Only numbers between 200 and 100000 are allowed.
      opcache.max_accelerated_files=5000
      
      ; The maximum percentage of "wasted" memory until a restart is scheduled.
      ;opcache.max_wasted_percentage=5
      
      ; When this directive is enabled, the OPcache appends the current working
      ; directory to the script key, thus eliminating possible collisions between
      ; files with the same name (basename). Disabling the directive improves
      ; performance, but may break existing applications.
      ;opcache.use_cwd=1
      
      ; When disabled, you must reset the OPcache manually or restart the
      ; webserver for changes to the filesystem to take effect.
      opcache.validate_timestamps=1
      
      ; How often (in seconds) to check file timestamps for changes to the shared
      ; memory storage allocation. ("1" means validate once per second, but only
      ; once per request. "0" means always validate)
      opcache.revalidate_freq=2
      
      ; Enables or disables file search in include_path optimization
      ;opcache.revalidate_path=0
      
      ; If disabled, all PHPDoc comments are dropped from the code to reduce the
      ; size of the optimized code.
      ;opcache.save_comments=1
      
      ; If disabled, PHPDoc comments are not loaded from SHM, so "Doc Comments"
      ; may be always stored (save_comments=1), but not loaded by applications
      ; that don't need them anyway.
      ;opcache.load_comments=1
      
      ; If enabled, a fast shutdown sequence is used for the accelerated code
      ;opcache.fast_shutdown=0
      
      ; Allow file existence override (file_exists, etc.) performance feature.
      ;opcache.enable_file_override=0
      
      ; A bitmask, where each bit enables or disables the appropriate OPcache
      ; passes
      ;opcache.optimization_level=0xffffffff
      
      ;opcache.inherited_hack=1
      ;opcache.dups_fix=0
      
      ; The location of the OPcache blacklist file (wildcards allowed).
      ; Each OPcache blacklist file is a text file that holds the names of files
      ; that should not be accelerated. The file format is to add each filename
      ; to a new line. The filename may be a full path or just a file prefix
      ; (i.e., /var/www/x  blacklists all the files and directories in /var/www
      ; that start with 'x'). Line starting with a ; are ignored (comments).
      ;opcache.blacklist_filename=
      
      ; Allows exclusion of large files from being cached. By default all files
      ; are cached.
      ;opcache.max_file_size=0
      
      ; Check the cache checksum each N requests.
      ; The default value of "0" means that the checks are disabled.
      ;opcache.consistency_checks=0
      
      ; How long to wait (in seconds) for a scheduled restart to begin if the cache
      ; is not being accessed.
      opcache.force_restart_timeout=180
      
      ; OPcache error_log file name. Empty string assumes "stderr".
      ;opcache.error_log=
      
      ; All OPcache errors go to the Web server log.
      ; By default, only fatal errors (level 0) or errors (level 1) are logged.
      ; You can also enable warnings (level 2), info messages (level 3) or
      ; debug messages (level 4).
      ;opcache.log_verbosity_level=1
      
      ; Preferred Shared Memory back-end. Leave empty and let the system decide.
      ;opcache.preferred_memory_model=
      
      ; Protect the shared memory from unexpected writing during script execution.
      ; Useful for internal debugging only.
      ;opcache.protect_memory=0
    Issue Details
    Issue Number 4448
    Issue Type Bug
    Project VaultWiki 4.x Series
    Category Install / Upgrade
    Status Fixed
    Priority 3 - Loss of Functionality
    Affected Version 4.0.7
    Fixed Version 4.0.8
    Milestone (none)
    Software DependencyAny
    License TypePaid
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. November 14, 2015 8:46 AM
      pegasus pegasus is offline
      VaultWiki Team
      The settings you posted here are correct. If turning off opcache in this file does not work, then I believe you have another php.ini file somewhere that is being used instead of this one. If PHP is running as a CGI or FastCGI process (common these days), you may also need to restart the PHP process via the shell before any changes to PHP.ini take effect.

      If Zend Opcache is enabled, the following must be true to meet the opcache requirement:
      opcache.validate_timestamps=1
      opcache.revalidate_freq < 10
      Reply Reply
    2. November 15, 2015 9:35 PM
      pegasus pegasus is offline
      VaultWiki Team
      What PHP version are you using? There may be other ways around this which we can add in a new version that would help users with PHP 5.5 or higher avoid this message.

      Unfortunately for users with PHP 5.4 and lower with Zend Opcache, the current way is the only way. I don't think it's possible to have Zend Opcache without shell access before 5.5, so I think the current way is acceptable for that case.
      Reply Reply
    3. November 16, 2015 12:48 PM
      pegasus pegasus is offline
      VaultWiki Team
      Made this change in the next release. If PHP is 5.5.0 or higher, the Zend Opcache will be cleared automatically when the installer runs, rather than showing this message. If PHP is 5.4 or lower, this message will appear, and the opcache settings will need to be fixed manually.
      Reply Reply
    4. November 25, 2015 5:45 AM
      Mart456 Mart456 is offline
      Junior Member
      Thanks Pegasus,

      I am now able to run the script however i am getting the following error
      Code:
      Upgrading to 4.0.7
      Step 7
      
      Updating data in table: xf_search_index
      An exception occurred: Database Error: SELECT `l`.*,`ch`.*,`c`.*,`i`.*,`r`.*,`page`.*,`likes`.`likes`,`likes`.`like_users`, IF(`sub`.`userid`, 1, 0) AS `issubscribed`,`mk`.`readtime`,`l`.`userid` AS `translate_userid`,`ch`.`userid` AS `chapter_userid`,`r`.`dateline` AS `edit_dateline`,`r`.`flags` + 0 AS `flags`,`r`.`parentid` AS `edit_parentid`,`page`.`pageid` FROM `vw_page` `page` LEFT JOIN `vw_route` `i` ON (`page`.`pageid` = `i`.`itemid` AND `i`.`itemtypeid` = 1) LEFT JOIN `vw_counter` `c` ON (`c`.`pageid` = `page`.`pageid`) 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_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_likes` `likes` ON (`likes`.`itemtypeid` = 1 AND `likes`.`itemid` = `page`.`pageid`) WHERE `page`.`areaid` = 0 Mysqli prepare error: Unknown column 'c.pageid' in 'on clause' in /var/www/html/overlandsphere/overland-forum/vault/core/controller/db/xf.php on line 171
      vw_DB_Controller_XF->throw_error() in vault/core/controller/db/xf.php at line 185
      vw_DB_Controller_XF->query_read() in vault/core/model/db/mysql/vw.php at line 29
      vw_DB_MySQL_Model->select() in vault/core/controller/fetch/vw.php at line 211
      vw_Fetch_Controller->get() in vault/core/controller/fetch/vw.php at line 493
      vw_Fetch_Controller->get_index() in vault/core/controller/fetch/vw.php at line 308
      vw_Fetch_Controller->return_the_index() in vault/core/controller/fetch/vw.php at line 123
      vw_Fetch_Controller->get() in library/vw/XenForo/Search/DataHandler/Base.php at line 60
      vw_XenForo_Search_DataHandler_Base->_insertIntoIndex() in library/vw/XenForo/Search/DataHandler/vwPage.php at line 49
      vw_XenForo_Search_DataHandler_vwPage->_insertIntoIndex() in library/XenForo/Search/DataHandler/Abstract.php at line 275
      XenForo_Search_DataHandler_Abstract->insertIntoIndex() in vault/core/controller/install/upgradepath/steps/4/0/7/C/xf.php at line 157
      vw_Install_UpgradePath_Steps_407_C_Controller_XF->{closure}() in vault/core/controller/install/upgradepath/vw.php at line 63
      vw_Install_UpgradePath_Controller->call() in vault/core/controller/cp/install/vw.php at line 361
      vw_CP_Install_Controller->exec_step() in vault/core/controller/cp/install/vw.php at line 326
      vw_CP_Install_Controller->upgrade_type() in vault/core/controller/cp/install/vw.php at line 263
      vw_CP_Install_Controller->upgrade() in vault/core/controller/cp/install/vw.php at line 59
      vw_CP_Install_Controller->execute() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 113
      vw_XenForo_ControllerAdmin_Wiki->actionIndex() in library/vw/XenForo/ControllerAdmin/Wiki.php at line 170
      vw_XenForo_ControllerAdmin_Wiki->actionUpgrade() in library/XenForo/FrontController.php at line 351
      XenForo_FrontController->dispatch() in library/XenForo/FrontController.php at line 134
      XenForo_FrontController->run() in admin.php at line 13
      Reply Reply
    5. November 25, 2015 7:47 AM
      pegasus pegasus is offline
      VaultWiki Team
      Previous version was before 4.0.4?

      In vault/core/controller/install/upgradepath/steps/4/0/7/C/xf.php, find:
      Code:
      while ($route = vw_DB::get()->func()->fetch_array($routes))
      Before that line, add this:
      Code:
      vw_Hard_Core::model('Settings')->set('vw_version_string', '4.0.7');
      Reply Reply
    6. November 27, 2015 6:58 AM
      Mart456 Mart456 is offline
      Junior Member
      That worked, thank you
      Reply Reply
    + Reply

    Assigned Users
    Loading Please Wait
    Tags
    Loading Please Wait
    • Contact Us
    • License Agreement
    • Privacy
    • Terms
    • Top
    All times are GMT -4. The time now is 12:47 PM.
    This site uses cookies to help personalize content, to tailor your experience, and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Learn more… Accept Remind me later
  • striker
    Powered by vBulletin® Version 4.2.5 Beta 2
    Copyright © 2023 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2023 DragonByte Technologies Ltd.
    Copyright © 2008 - 2013 VaultWiki Team, Cracked Egg Studios, LLC.