• 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
    • Installation Error

    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: Installation Error

    • Issue Tools
      • View Changes
    1. issueid=3304 August 17, 2013 4:11 PM
      Replicators Replicators is offline
      Junior Member
      Installation Error
      MySQL Error : You have an error in your SQL syntax

      Step 4

      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
      Database Error Database error
      The ***** database has encountered a problem.
      Please try the following:

      Load the page again by clicking the Refresh button in your web browser.
      Open the www.*****.com home page, then try to open another page.
      Click the Back button to try another link.

      The www.*****.com forum technical staff have been notified of the error, though you may contact them if the problem persists.

      We apologise for any inconvenience.

      Code:
      Database error in vBulletin 4.2.1:
      
      Invalid SQL:
      SELECT  FROM `px_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 `px_vw_` WHERE  = 1' at line 1
      Error Number  : 1064
      Request Date  : Saturday, August 17th 2013 @ 04:03:14 PM
      Error Date    : Saturday, August 17th 2013 @ 04:03:16 PM
      Script        : http://www.*****.com/vault/install/index.php?step=4&nostyle=1
      Referrer      : http://www.*****.com/vault/install/index.php?step=3&nostyle=1
      IP Address    : **.**.**.**
      Username      : *****
      Classname     : vB_Database
      MySQL Version : 5.0.91-log
      
      Stack Trace:
      
      #0 vB_Database->halt() called in [path]/includes/class_core.php on line 426
      #1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 503
      #2 vB_Database->query_first() called in [path]/vault/core/controller/db/vb3.php on line 202
      #3 vw_DB_Controller_vB3->query_first() called in [path]/vault/core/model/db/mysql/vw.php on line 29
      #4 vw_DB_MySQL_Model->select() called in [path]/vault/core/controller/dm/route/vw.php on line 71
      #5 vw_DM_Route_Controller->verify_itemid() called in [path]/vault/core/controller/dm/route/vb3.php on line 63
      #6 vw_DM_Route_Controller_vB3->verify_itemid() called in [path]/includes/class_dm.php on line 495
      #7 vB_DataManager->verify() called in [path]/includes/class_dm.php on line 343
      #8 vB_DataManager->set() called in [path]/vault/core/controller/dm/vb3.php on line 209
      #9 vw_DM_Controller_vB3->set() called in [path]/vault/core/controller/dm/base/routable/vw.php on line 416
      #10 vw_DM_Base_Routable_Controller->save_path() called in [path]/vault/core/controller/dm/special/vw.php on line 61
      #11 vw_DM_Special_Controller->post_save_each() called in [path]/vault/core/controller/dm/special/vb3.php on line 53
      #12 vw_DM_Special_Controller_vB3->post_save_each() called in [path]/includes/class_dm.php on line 917
      #13 vB_DataManager->save() called in [path]/vault/core/controller/dm/vb3.php on line 384
      #14 vw_DM_Controller_vB3->save() called in [path]/vault/core/controller/install/db/insert/vw.php on line 153
      #15 vw_Install_DB_Insert_Controller->execute_dm() called in [path]/vault/core/controller/install/db/insert/vw.php on line 73
      #16 vw_Install_DB_Insert_Controller->execute() called in [path]/vault/core/controller/install/full/steps/vb3.php on line 56
      #17 {closure}() called in [path]/vault/core/controller/progress/vw.php on line 80
      #18 vw_Progress_Controller->call() called in [path]/vault/core/controller/cp/progress/vw.php on line 39
      #19 vw_CP_Progress_Controller->process() called in [path]/vault/core/controller/cp/install/vw.php on line 143
      #20 vw_CP_Install_Controller->install() called in [path]/vault/core/controller/cp/install/vw.php on line 74
      #21 vw_CP_Install_Controller->execute() called in [path]/vault/cp/global.php on line 72
      #22 require_once([path]/vault/cp/global.php) called in [path]/vault/install/index.php on line 40
      This is on a complete fresh install too.
    Issue Details
    Issue Number 3304
    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
    License TypePaid
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. August 18, 2013 9:28 AM
      pegasus pegasus is offline
      VaultWiki Team
      The installer was running one of the steps twice. This should be fixed now in the current ZIP. Simply replace vault/core/controller/install/full/steps/vb3.php, reload the page and click "Continue."
      Reply Reply  
    2. August 18, 2013 11:50 AM
      Replicators Replicators is offline
      Junior Member
      Seem's to work now, but ran into a problem.

      Now i am getting

      Code:
      Warning: session_start(): open(/var/php_sessions/sess_b40c3a52c3834d05b51a99c73a1b4ff6, O_RDWR) failed: No such file or directory (2) in [path]/includes/facebook/facebook.php on line 37
      
      Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at [path]/includes/class_core.php:5698) in [path]/includes/facebook/facebook.php on line 37
      I noticed this on the install script but disregarded and installed anyways, and now it displays on the top of my webpage and seems to slow down my web browser a bit. I don't know if this has to do with vaultwiki, or if vaultwiki triggered a anomaly or something with facebook.
      Reply Reply  
    3. August 18, 2013 11:53 AM
      pegasus pegasus is offline
      VaultWiki Team
      vBulletin's Facebook integration is not related to VaultWiki. You might want to look up this error on vBulletin's site.
      Reply Reply  
    4. August 18, 2013 12:14 PM
      Replicators Replicators is offline
      Junior Member
      It's definitely vaultwiki which is causing it as i disabled vaultwiki and the error went away. I disabled all hooks through vbulletins config file and it all worked perfect, i disabled vaultwiki and then re-enabled all other mods and still worked perfectly. I just re-enabled vaultwiki and i get this error.

      Warning: session_start(): open(/var/php_sessions/sess_d50cc566ad25f1b72b9a4c5ab1672607, O_RDWR) failed: No such file or directory (2) in /path/www/includes/facebook/facebook.php on line 37 Warning: session_start(): Cannot send session cache limiter - headers already sent (output started at /path/www/includes/facebook/facebook.php:37) in /path/www/includes/facebook/facebook.php on line 37
      I don't get it either, i don't know how vaultwiki would interfere with facebook but it is.
      Reply Reply  
    5. August 18, 2013 7:13 PM
      pegasus pegasus is offline
      VaultWiki Team
      Check the permissions on the VaultWiki files you uploaded. It's possible the files were uploaded by a different FTP user or the folder doesn't have the same permissions as the other vBulletin files, which might be causing issues when the Facebook integration attempts to create a session file from a different user/permissions context.

      If this doesn't apply to your situation, when I have access to the dev server again tomorrow I will see if this is a general conflict between VaultWiki 4 and vBulletin 4's Facebook implementation, but I remember tests during the private Alpha where it worked fine.
      Reply Reply  
    6. August 19, 2013 9:00 PM
      Replicators Replicators is offline
      Junior Member
      I can tell you it's definitely a conflict with vaultwiki and facebook, i installed vaultwiki on a fresh install, no other mods with facebook platform off, ran into no problems at all during install and after until i enabled facebook and now getting that code at top of screen again.
      Reply Reply  
    7. August 20, 2013 12:47 AM
      pegasus pegasus is offline
      VaultWiki Team
      I enabled Facebook integration here for a short while today, and there were no issues. So it is likely a server configuration or file permissions issue. Since you already ruled out file permissions, please PM me the contents of your .htaccess file to review. It's possible VaultWiki is not superceding vBSEO, which it must in order to work properly.
      Reply Reply  
    8. August 20, 2013 6:19 PM
      Replicators Replicators is offline
      Junior Member
      I am not using vbseo, as i said, i tried it on a fresh install of vbulletin with no other mods. I am also not using a .htaccess yet.
      Reply Reply  
    9. August 22, 2013 10:20 AM
      pegasus pegasus is offline
      VaultWiki Team
      I have added a free service to your account. Please fill it out and I will see if I can resolve the facebook issue.
      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 9:30 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.