• 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 3.x Series
    • Bug
    • Database error on showwiki.php - New install

    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: Database error on showwiki.php - New install

    • Issue Tools
      • View Changes
    1. issueid=381 February 2, 2009 12:30 PM
      jbade jbade is offline
      Junior Member
      Database error on showwiki.php - New install

      I just installed my VaultWiki Yesterday.

      PHP Version 5.2.8
      FastCGI running on Windows 2008
      vBulletin 3.8.1

      vBulletin is working great.
      But I can't view, http://www.binderplanet.com/forums/s...:Testing+12345
      ShowWiki.php and the Domain manager both had a php "Database Error"

      I followed the instructions and ran the query for the Domain manager and that worked.
      But I am having trouble still with the showwiki.php

      I think I configured everything correctly. Granted I could be wrong.
      With this new server I am also having trouble getting detailed php errors which I know would help this process. I am trying to figure that out.

      Also re-downloaded again today on advice from pegasus.
    Issue Details
    Issue Number 381
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Install / Upgrade
    Status Duplicate
    Priority 5 - Minor Bugs / Small Tweaks
    Affected Version 2.2.0
    Fixed Version (none)
    Milestone (none)
    Software DependencyAny
    Users able to reproduce bug 1
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. February 2, 2009 1:20 PM
      jbade jbade is offline
      Junior Member
      Code:
      Database error in vBulletin 3.8.1:
      
      Invalid SQL:
      
      			SELECT rev.userid, rev.dateline AS dateadded, rev.ipaddress,
      				user.username, user.usergroupid, user.membergroupids,
      				user.email, user.homepage,
      				IF(user.displaygroupid > 0, user.displaygroupid, user.usergroupid) AS displaygroupid
      				
      			FROM vault_revision AS rev
      			LEFT JOIN user AS user ON (user.userid = rev.userid)
      			
      			WHERE rev.threadid = 86177
      				AND rev.pending = 0
      			GROUP BY rev.userid	
      			ORDER BY dateadded ASC;
      
      MySQL Error   : Unknown column 'rev.ipaddress' in 'field list'
      Error Number  : 1054
      Request Date  : Monday, February 2nd 2009 @ 12:17:06 PM
      Error Date    : Monday, February 2nd 2009 @ 12:17:06 PM
      Script        : [url]http://www.binderplanet.com/forums/showwiki.php[/url]
      Referrer      : 
      IP Address    : 
      Username      : Unregistered
      Classname     : vB_Database
      MySQL Version :
      Reply Reply  
    2. February 2, 2009 2:07 PM
      Mokonzi Mokonzi is offline
      Senior Member
      I can confirm the same error. I'm using vBulletin 3.7.4 PL1.
      Reply Reply  
    3. February 2, 2009 2:31 PM
      Selinunte Selinunte is offline
      New Member
      I can confirm the same error. I'm using vBulletin 3.8.0

      Code:
      Database error in vBulletin 3.8.0:
      
      Invalid SQL:
      
      		REPLACE INTO vault_revision
      			(threadid, userid, reason, dateline, pagetext, minor, section, rollback, pending, ipaddress)
      		VALUES
      		(
      			2,
      			1,
      			'',
      			1233602492,
      			'fn\njn\nfgjn\ngjnnjjnhjnj',
      			0,
      			'',
      			0,
      			0,
      			'::1'
      		);
      
      MySQL Error   : Unknown column 'ipaddress' in 'field list'
      Error Number  : 1054
      Request Date  : Monday, February 2nd 2009 @ 08:21:32 PM
      Error Date    : Monday, February 2nd 2009 @ 08:21:32 PM
      Script        : [url]http://localhost:8888/vb4/showwiki.php?title=Default:jjjjjjj&do=edit[/url]
      Referrer      : [url]http://localhost:8888/vb4/showwiki.php?do=create[/url]
      IP Address    : ::1
      Username      : admin
      Classname     : vb_database
      MySQL Version : 5.0.41
      Reply Reply  
    4. February 2, 2009 2:35 PM
      Selinunte Selinunte is offline
      New Member
      Perhaps you should replace "ipaddress" with "revisionid" in the code or "revisionid" with "ipaddress" in the vault_revision column in the database.
      Reply Reply  
    5. February 2, 2009 2:37 PM
      pegasus pegasus is offline
      VaultWiki Team
      Marked as duplicate. Same as: http://crackedeggstudios.com/project.php?issueid=377
      This should have been fixed in the ZIP last night. I am not sure why there are still problems. Hopefully this will be resolved today. The new build install errors have never gone on this long.
      Reply Reply  
    6. February 2, 2009 2:42 PM
      Selinunte Selinunte is offline
      New Member
      I downloaded the last version 15 minutes ago.
      Sorry but you try before you release it?
      Reply Reply  
    7. February 2, 2009 3:08 PM
      Mokonzi Mokonzi is offline
      Senior Member
      I noticed the other thread afterwards, and fixed it as per the instructions. Works fine there.
      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 1:42 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 © 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.