Issue: Problems on Categories installation

Issue Tools
- View Changes

August 28, 2008 4:55 AM

vimto

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)

August 28, 2008 11:56 AM

pegasus

VaultWiki Team

Fixed and ZIP updated. It just needed some commas.

Reply
August 30, 2008 9:49 PM

Home Alone

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
August 31, 2008 1:06 AM

pegasus

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
August 31, 2008 12:41 PM

ILTK

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
September 3, 2008 1:19 PM

pegasus

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

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

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

Issue: Problems on Categories installation

Issue Tools