• 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
    • Problems on Categories installation

    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: Problems on Categories installation

    • Issue Tools
      • View Changes
    1. issueid=208 August 28, 2008 4:55 AM
      vimto vimto is offline
      Regular Member
      Problems on Categories installation
      Mysql error on importing product

      I've just tried installing the categories addon but run into a problem.

      I uploaded all the files into the correct directories and then proceeded to import the product as mentioned in the readme file. this is the error I received:

      Code:
      Database error in vBulletin 3.7.2:
      
      Invalid SQL:
      
      	CREATE TABLE IF NOT EXISTS vault_category
      	(
      		entryid INT(11) UNSIGNED NOT NULL  AUTO_INCREMENT,
      		title VARCHAR(255) NOT NULL DEFAULT '',
      		threadid INT(11) UNSIGNED NOT NULL DEFAULT '0',
      		PRIMARY KEY (entryid)
      		UNIQUE undupify (threadid, title)
      		INDEX threadid (threadid)
      		INDEX title (title)
      	);
      
      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 'UNIQUE undupify (threadid, title)
      		INDEX threadid (threadid)
      		INDEX title (t' at line 7
      Error Number  : 1064
      Request Date  : Thursday, August 28th 2008 @ 09:45:52 AM
      Error Date    : Thursday, August 28th 2008 @ 09:45:52 AM
      Script        : http://www.bluedragons.co.uk/forums/admin/plugin.php?do=productimport
      Referrer      : http://www.bluedragons.co.uk/forums/admin/plugin.php?do=productadd
      IP Address    : xx.xxx.xx.xxx
      Username      : xxxxxxx
      Classname     : vB_Database
      MySQL Version : 4.1.20-log
    Issue Details
    Issue Number 208
    Issue Type Bug
    Project VaultWiki 3.x Series
    Category Categories
    Status Fixed
    Priority 4 - Warnings / Script Errors
    Affected Version 2.0.1
    Fixed Version 2.0.2
    Milestone VaultWiki 2.1.0
    Software DependencyAny
    Users able to reproduce bug 0
    Users unable to reproduce bug 0
    Attachments 0
    Assigned Users (none)
    Tags (none)




    1. August 28, 2008 11:56 AM
      pegasus pegasus is offline
      VaultWiki Team
      Fixed and ZIP updated. It just needed some commas.
      Reply Reply  
    2. August 30, 2008 9:49 PM
      Home Alone Home Alone is offline
      Junior Member
      Just an FYI -- when I installed the categories module today I had to manually run the query to create the vault_category table. It was not created during the installation. I downloaded the zip file today.
      Reply Reply  
    3. August 31, 2008 1:06 AM
      pegasus pegasus is offline
      VaultWiki Team
      Do you know why? The only thing I found was an extra space in the installcode, but that seems a little obsurd to have been the problem. Also, once installed, Categories will not work unless your vault_link table contains the templateusage column.
      Reply Reply  
    4. August 31, 2008 12:41 PM
      ILTK ILTK is offline
      Junior Member
      I'm getting something that I think is related. I didn't get any errors when installing, but as soon as I try adding a category and saving the article vb bombs telling me the "vault_category" table doesn't exist.

      I looked in the product xml and I have the latest version where the missing commas was fixed.

      If I grab the sql and run it via phpmyadmin on the vb db it works fine so I'm not sure what's going on.
      Reply Reply  
    5. September 3, 2008 1:19 PM
      pegasus pegasus is offline
      VaultWiki Team
      Apparently I changed something in the XML on 8/31, probably fixing the second iteration of this bug. If you downloaded the product after this time, there should be no more issues with the table.
      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:14 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.