PNC error Posted:
Sun Aug 05, 2007 3:45 pm |
|
|
|
|
|
Yes and No, SOlved that one and got basic installation done, but ran into another
vWar Isn't working.
Used the Special MYsql install for mysql 5
no idea what to fix.
-> Database Error: Invalid SQL: CREATE TABLE vwar_member (
memberid int(11) NOT NULL auto_increment,
accessgroupid smallint(5) unsigned NOT NULL default '0',
name varchar(100) NOT NULL default '',
realname varchar(255) NOT NULL default '',
birthday date NOT NULL default '0000-00-00',
location varchar(100) NOT NULL default '',
country char(3) NOT NULL default '',
sex char(3) NOT NULL NULL default '',
email varchar(255) NOT NULL default '',
homepage VARCHAR(150) NOT NULL default '',
icq varchar(30) NOT NULL default '',
aim varchar(30) NOT NULL default '',
yim varchar(30) NOT NULL default '',
msn varchar(30) NOT NULL default '',
xfire varchar( 100 ) NOT NULL default '',
password varchar(32) NOT NULL default '',
forgotpw int(11) NOT NULL,
customstatus varchar(150) NOT NULL default '',
status smallint(2) NOT NULL default '0',
language varchar(25) NOT NULL default '',
picture VARCHAR(255) NOT NULL default '',
ismember SMALLINT(1) NOT NULL default '1',
hidemember SMALLINT(1) NOT NULL default '0',
signature text NOT NULL default '',
lastactivity INT(10) NOT NULL default '0',
profilehits INT(11) NOT NULL DEFAULT '0',
joindate DATE NOT NULL default '0000-00-00',
userid TEXT NOT NULL default '',
wartag varchar(50) NOT NULL default '',
PRIMARY KEY (memberid)
) TYPE=MyISAM;
-> MySQL Error: BLOB/TEXT column 'signature' can't have a default value
-> MySQL Error Number: 1101
-> Date: 05.08.2007 @ 10:39
-> Script: /install_vwar.php?step=4
-> Referer: http://dtgaming.com/install_vwar.php?step=4
Edit: New error as well
I can't seem to add/ register users
I get "ERROR: There was a problem updating the database"
|
|
|
|
38.107.179.220
