blind-eddie
12-30-2022, 09:13 PM
When running the installer for vb 4.2.5, I get the following error on step two:
An error has occurred with your database. Please contact vBulletin Support for assistance.
Module: install, Step 2 Database Error:1064
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 'groups INT unsigned DEFAULT '0', PRIMARY KEY (socialgroupcategoryid), KEY dis' at line 10
Query:
CREATE TABLE socialgroupcategory (
socialgroupcategoryid INT unsigned NOT NULL auto_increment,
creatoruserid INT unsigned NOT NULL,
title VARCHAR(250) NOT NULL,
description TEXT NOT NULL,
displayorder INT unsigned NOT NULL,
lastupdate INT unsigned NOT NULL,
groups INT unsigned DEFAULT '0',
PRIMARY KEY (socialgroupcategoryid),
KEY displayorder (displayorder)
)
Does anyone know what I can do to fix this?
An error has occurred with your database. Please contact vBulletin Support for assistance.
Module: install, Step 2 Database Error:1064
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 'groups INT unsigned DEFAULT '0', PRIMARY KEY (socialgroupcategoryid), KEY dis' at line 10
Query:
CREATE TABLE socialgroupcategory (
socialgroupcategoryid INT unsigned NOT NULL auto_increment,
creatoruserid INT unsigned NOT NULL,
title VARCHAR(250) NOT NULL,
description TEXT NOT NULL,
displayorder INT unsigned NOT NULL,
lastupdate INT unsigned NOT NULL,
groups INT unsigned DEFAULT '0',
PRIMARY KEY (socialgroupcategoryid),
KEY displayorder (displayorder)
)
Does anyone know what I can do to fix this?