• 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
    • Install errors

    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: Install errors

    • Issue Tools
      • View Changes
    1. issueid=3267 July 30, 2013 5:48 PM
      Hostboard Hostboard is offline
      Junior Member
      Install errors

      Just renewed my members access and downloaded the latest. Hung at 5%

      Code:
      Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in [path]/global.php(29) : eval()'d code on line 93
      
      Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in [path]/global.php(29) : eval()'d code on line 97
          
      Installing VaultWiki v4.0.0 Beta 4
      Step 1
      
      Creating table: vw_area
      
      Creating table: vw_attachment
      
      Creating table: vw_attachmentedit
      
      Creating table: vw_attachmentfile
      
      Creating table: vw_attachmentthumb
      
      Creating table: vw_attachmenttype
      
      Creating table: vw_block
      
      Creating table: vw_blockcache
      
      Creating table: vw_blockcacherelation
      
      Creating table: vw_book
      
      Creating table: vw_category
      
      Creating table: vw_categoryitem
      
      Creating table: vw_chapter
      
      Creating table: vw_comment
      
      Creating table: vw_counter
      
      Creating table: vw_discussion
      
      Creating table: vw_flood
      
      Creating table: vw_group
      
      Creating table: vw_groupitem
      
      Creating table: vw_help
      
      Creating table: vw_integrate
      
      Creating table: vw_island
      
      Creating table: vw_itemview
      
      Creating table: vw_langgroup
      
      Creating table: vw_langitem
      
      Creating table: vw_language
      
      Creating table: vw_lastupdate
      
      Creating table: vw_link
      
      Creating table: vw_log
      
      Creating table: vw_markread
      
      Creating table: vw_moderator
      
      Creating table: vw_nodetype
      
      Creating table: vw_options
      
      Creating table: vw_page
      
      Creating table: vw_parsed
      
      Creating table: vw_path
      
      Creating table: vw_permission
      
      Creating table: vw_ping
      
      Creating table: vw_poll
      
      Creating table: vw_pollitem
      
      Creating table: vw_pollvote
      
      Creating table: vw_prefix
      
      Creating table: vw_protect
      
      Creating table: vw_rate
      
      Creating table: vw_redirect
      
      Creating table: vw_replacement
      
      Creating table: vw_replacementset
      
      Creating table: vw_report
      
      Creating table: vw_revision
      
      Creating table: vw_route
      
      Creating table: vw_search
      
      Creating table: vw_searchresult
      
      Creating table: vw_searchtext
      
      Creating table: vw_special
      
      Creating table: vw_subscribe
      
      Creating table: vw_subscribefolder
      
      Creating table: vw_tagged
      
      Creating table: vw_template
      
      Creating table: vw_templateusage
      
      Creating table: vw_topic
      
      Creating table: vw_upgradelog
      
      Creating table: vw_usercount
      Reran in FF (thought IE was an issue as it general is). Got past step 2 then BOOM
      Code:
      Step 3
      
      Adding data to table: bbcode
      
      Adding data to table: vw_nodetype
      
      Adding data to table: product
      
      Adding data to table: productcode
      
      Adding data to table: productdependency
      
      Warning: mysqli_query(): (42000/1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM `vw_` WHERE = 1' at line 1 in [path]/includes/class_core.php on line 1391
      
      Database error in vBulletin 4.2.1:
      
      Invalid SQL:
      SELECT  FROM `vw_` WHERE  = 1;
      
      MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM `vw_` WHERE  = 1' at line 1
      Error Number  : 1064
      Request Date  : Tuesday, July 30th 2013 @ 09:45:03 PM
      Error Date    : Tuesday, July 30th 2013 @ 09:45:03 PM
      Script        : http://www/forums/vault/install/index.php
      Referrer      : http://www/forums/vault/install/index.php
      IP Address    : IP Address
      Username      : UserID
      Classname     : vB_Database_MySQLi
      MySQL Version : 5.5.22-0ubuntu1
    Issue Details
    Issue Number 3267
    Issue Type Bug
    Project VaultWiki 4.x Series
    Category Install / Upgrade
    Status Fixed
    Priority 2 - Fatal / Database Errors
    Affected Version 4.0.0 Beta 4
    Fixed Version 4.0.0 Beta 5
    Milestone VaultWiki 4 Beta X
    Software DependencyvBulletin 4.x w/ ckEditor
    License TypePaid
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. July 30, 2013 6:18 PM
      pegasus pegasus is offline
      VaultWiki Team
      I need more information about the error above, so please do the following. In vault/core/controller/install/full/steps/vb3.php, find:
      Code:
      	public function __construct()
      	{
      Add after:
      Code:
      $GLOBALS['vbulletin']->debug = true;
      This should run the installer in debug mode so that we get a backtrace from wherever that query is.

      Sometimes this happens if you had an earlier Alpha of VaultWiki 4 installed that you tried uninstalling it in the past. There was a problem with the uninstaller in earlier versions. If you are noticing problems now throughout your forum or you can't get the installer to continue, you may have to run the following queries against your database in order to remove data from the old install:
      Code:
      DELETE FROM plugin WHERE product = 'vaultwiki';
      DELETE FROM setting WHERE product = 'vaultwiki';
      DELETE FROM phrasetype WHERE product = 'vaultwiki';
      Afterwards, you can rebuild caches by disabling and re-enabling another add-on product you use.
      Reply Reply  
    2. July 30, 2013 6:54 PM
      Hostboard Hostboard is offline
      Junior Member
      ok...

      Going here: http://www.???.com/forums/vault/install/index.php

      Yeilds (sorry would not let me copy it from the web page directly):
      Code:
      Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in [path]/global.php(29) : eval()'d code on line 93
      
      Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in [path]/global.php(29) : eval()'d code on line 97
      I login and BOOM. Did not like the edit...
      Code:
      Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in [path]/global.php(29) : eval()'d code on line 93
      
      Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in [path]/global.php(29) : eval()'d code on line 97
       Parse error: syntax error, unexpected T_VARIABLE, expecting ';' or '{' in /www/.com/wwwroot/forums/vault/core/controller/install/full/steps/vb3.php on line 23
      Code:
      <?php
      /************************************************************************\
       *
       * VaultWiki
       * Version 4.0.0 Beta 4
       * License #
       *
       * Copyright ©2008-2013 Cracked Egg Studios, LLC. All Rights Reserved.
       * This file may not be redistributed in whole or significant part.
       * 
       * VAULTWIKI IS NOT FREE SOFTWARE
       * https://www.vaultwiki.org/
       * https://www.vaultwiki.org/pages/Info:License-Agreement
       *
      \************************************************************************/
      
      require_once(vw_Hard_Core::get_dir() . '/controller/install/full/steps/vw.php');
      
      class vw_Install_Full_Steps_Controller_vB3 extends vw_Install_Full_Steps_Controller
      {
      	public function __construct()
      
      $GLOBALS['vbulletin']->debug = true;
      
      	{
      		parent::__construct();
      
      		if (VAULT_40X_COMPAT)
      		{
      Reply Reply  
    3. July 30, 2013 6:57 PM
      pegasus pegasus is offline
      VaultWiki Team
      The code insert must go after the curly brace {

      Should look like:
      Code:
      public function __construct()
      {
      	$GLOBALS['vbulletin']->debug = true;
      Reply Reply  
    4. July 30, 2013 7:16 PM
      Hostboard Hostboard is offline
      Junior Member
      Picked up at step 4 and continued without any issues.
      I still have the eval errors a the top of the control panel screen.
      I am concerned that the prior steps did not in fact complete properly.
      Reply Reply  
    5. July 30, 2013 7:45 PM
      pegasus pegasus is offline
      VaultWiki Team
      Those eval errors are from another modification that uses one of the global_* hooks.

      If the steps did not complete properly, there will be more errors later on. But I think it was an issue with expired cache entries from a prior installation, and when you restarted the cache was reset.

      I have added a primer step to vB full installs as of Beta 5 which might get around the cache issue for certain leftover entries. Unfortunately vBulletin does not provide an adequate method to clear Xcache/APC/Memcached, so until we write our own abstraction layer there may still be issues when performing full re-installs.
      Reply Reply  
    6. July 30, 2013 10:25 PM
      Hostboard Hostboard is offline
      Junior Member
      Sorry but my site has had zero bugs for many moons. Only since I loaded Wiki have there now been any issues.

      Next it seems to have put a button in my NAV bar. Ok, not that I wanted as I have the wiki nav bar tab position disabled. But when I click on it I get

      Configuration error: wiki_index.php was called by another PHP script.
      This can cause an infinite loop if the calling script is the same as the DEFAULT_SCRIPT.

      I also get lots of errors when accessing my ACP They all disappear once the screen fully loads.

      Also I can not access the Wiki control panel via IE10 Nothing opens up when i click on a menu option. Works in FF

      I have the errors on my site's main page as well:
      Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in [path]/global.php(29) : eval()'d code on line 93
      Warning: mysql_free_result() expects parameter 1 to be resource, boolean given in [path]/global.php(29) : eval()'d code on line 97

      I disabled the Wiki via your control panel but I still get the wiki in the nav bar. I had to disable it in the manage products page.
      Reply Reply  
    7. July 31, 2013 7:42 AM
      pegasus pegasus is offline
      VaultWiki Team
      global.php(29) is hook global_start. VaultWiki doesn't use this hook. You would have to look at the other products you have installed and see what uses this hook. You probably had errors hidden before, which is why you believed your site had "zero bugs". You can hide the errors again, but they will still be there. In vault/config.php, find:
      Code:
      @ini_set('display_errors', 1);
      Replace with:
      Code:
      //@ini_set('display_errors', 1);
      If you have problems with the Beta release, though, hiding the errors will make it very difficult to debug. In general, fixing errors is advisable to hiding them.

      In vBulletin 4.2 the wiki doesn't use the Wiki NavBar Tab Position setting anymore, since there is a more powerful option available. The setting is for earlier vBulletin versions. To disable the tab in vB 4.2, you should use AdminCP > Settings > Navigation Manager, and uncheck "Active" for the Wiki tab.

      For the Configuration error, are you using vBSEO? If so, make sure you made changes to your .htaccess like so: https://www.vaultwiki.org/manual/vau...les-like-vBSEO
      But only if you have set vbseo.php as the VW_DEFAULT_SCRIPT in vault/config.php.
      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 11:12 AM.
    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 © 2025 vBulletin Solutions Inc. All rights reserved.
    Search Engine Optimisation provided by DragonByte SEO (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
    Copyright © 2008 - 2024 VaultWiki Team, Cracked Egg Studios, LLC.