vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vB4 Programming Discussions (https://vborg.vbsupport.ru/forumdisplay.php?f=252)
-   -   Vb 4.2.5 fresh install (https://vborg.vbsupport.ru/showthread.php?t=329453)

blind-eddie 12-30-2022 09:13 PM

Vb 4.2.5 fresh install
 
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?

Hostboard 01-09-2023 12:01 PM

What version of PHP/MySQL?


All times are GMT. The time now is 11:40 PM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.00911 seconds
  • Memory Usage 1,704KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (2)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete