Still looking at the language chooser and vBadvanced bugs.
yonglvnv - It's not reading the permissions for some reason. Did you still have includes/xml/bitfield_quoteit.xml on the server?
soulface - That's right. The date wasn't stored in earlier versions so it uses the date you installed it as the default date.
Alien - I was afraid of that. I have no idea what your problem is, but it's not modifying or adding columns. I'll keep searching for the reason behind that, but until then you have two options: Try and get your host to upgrade MySQL (I'm not sure if that will help) or modify the tables yourself through phpMyAdmin. Here's the structure for each table (column name is on the left, definition after the =>):
quotes
Code:
quoteid => INT (10) UNSIGNED NOT NULL AUTO_INCREMENT
quote => MEDIUMTEXT NOT NULL
author => VARCHAR (100) DEFAULT NULL
userid => INT (10) UNSIGNED NOT NULL DEFAULT 0
approved => TINYINT (1) UNSIGNED NOT NULL DEFAULT 0
votes => INT (10) UNSIGNED NOT NULL DEFAULT 0
rating => INT (10) NOT NULL DEFAULT 0
average => FLOAT (3, 2) NOT NULL DEFAULT 0.00
context => VARCHAR (250) DEFAULT NULL
date => INT (10) UNSIGNED NOT NULL DEFAULT 0
views => INT (10) UNSIGNED NOT NULL DEFAULT 0
categoryid => INT (10) UNSIGNED DEFAULT NULL
postid => INT (10) UNSIGNED DEFAULT NULL
quoteratings
Code:
userid => INT (10) UNSIGNED NOT NULL
quoteid => INT (10) UNSIGNED NOT NULL
rating => TINYINT (1) NOT NULL
guestquoteratings
Code:
ip => VARCHAR (15) NOT NULL
quoteid => INT (10) UNSIGNED NOT NULL
date => INT (10) UNSIGNED NOT NULL
rating => TINYINT (1) NOT NULL
quotecategories
Code:
categoryid => INT (10) UNSIGNED NOT NULL AUTO_INCREMENT
title => VARCHAR (64) NOT NULL
description => VARCHAR (250) DEFAULT NULL
public => TINYINT (1) NOT NULL DEFAULT 1
displayorder => SMALLINT (5) SIGNED NOT NULL DEFAULT 0
Here are the keys (table name on the left, keys after the =>):
Code:
quotes => PRIMARY KEY (quoteid), KEY (approved), KEY (rating), KEY (average)
quoteratings => PRIMARY KEY (quoteid, userid)
guestquoteratings => PRIMARY KEY (quoteid, ip)
quotecategories => PRIMARY KEY (categoryid)
And finally, these columns need to be added to other tables:
user
Code:
quoteitoptions => INT(10) UNSIGNED NOT NULL DEFAULT 0
lastquotesvisit => INT(10) UNSIGNED NOT NULL DEFAULT 0
quotecount => INT(10) UNSIGNED NOT NULL DEFAULT 0
usergroup
Code:
quoteitpermissions => INT(10) UNSIGNED NOT NULL DEFAULT 2567