Welcome, Guest. Please Login or Register.
July 11, 2025, 06:52:05 AM
Home Help Search Log in Register
News: If you are still using YaBB SE, please consider upgrading to SMF as soon as possible.

YaBB SE Community  |  English User Help  |  English Help  |  Install screws up on step 3 « previous next »
Pages: [1] Reply Ignore Print
Author Topic: Install screws up on step 3  (Read 369 times)
gatrhaze
Noobie
*
Posts: 2


I R N00b

Install screws up on step 3
« on: May 07, 2003, 12:34:44 AM »
Reply with quote

Here is part of what it says as the problem...

Executing package #5... unsuccessful!
Error: Column 'year' is used with UNIQUE or INDEX but is not defined as NOT NULL
In CREATE TABLE yabbse_calendar_holiday ( id int(10) unsigned NOT NULL auto_increment, title char(30) NOT NULL default '', month tinyint(4) NOT NULL default '0', day tinyint(4) NOT NULL default '0', year smallint(6) default NULL, PRIMARY KEY (id), KEY idx_month (month), KEY idx_year (year)) TYPE=MyISAM;

Anyone have a solution?
Logged
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:Install screws up on step 3
« Reply #1 on: May 07, 2003, 12:51:35 AM »
Reply with quote

What version of MySQL are you running?

yse151.sql, find:
 KEY idx_month (month),
 KEY idx_year (year))


Replace:
 KEY idx_month (month))

But... wierd.  Are you using MySQL 3.22?

-[Unknown]
Logged
gatrhaze
Noobie
*
Posts: 2


I R N00b

Re:Install screws up on step 3
« Reply #2 on: May 07, 2003, 01:02:59 AM »
Reply with quote

I'm using
mysql  Ver 9.38 Distrib 3.22.32, for pc-linux-gnu (i686)

and that worked for that step, but then brought upon more problems

http://www.geocities.com/gatrhaze/yabberrors.txt

(no im not trying to install yabbse on geocities)
Logged
[Unknown]
Global Moderator
YaBB God
*****
Posts: 7830


ICQ - 179721867unknownbrackets@hotmail.com WWW
Re:Install screws up on step 3
« Reply #3 on: May 07, 2003, 03:02:33 AM »
Reply with quote

Ask your host to upgrade.  The install doesn't seem to run for 3.22....

-[Unknown]
Logged
Pages: [1] Reply Ignore Print 
YaBB SE Community  |  English User Help  |  English Help  |  Install screws up on step 3 « previous - next »
 


Powered by MySQL Powered by PHP YaBB SE Community | Powered by YaBB SE
© 2001-2003, YaBB SE Dev Team. All Rights Reserved.
SMF 2.1.4 © 2023, Simple Machines
Valid XHTML 1.0! Valid CSS

Page created in 0.145 seconds with 20 queries.