[marrr]

getting errors trying to update

Incorrect datetime value: '1219602102' for column 'lastvisit' at row 1

SQL Query type: EXECUTE
Script: '/sourcebans/updater/index.php'
SQL Query: UPDATE `sb_admins` SET `lastvisit` = UNIX_TIMESTAMP() WHERE `aid` = '1'
SQL Params:


$('msg-red-debug').setStyle('display', 'block');$('eed5af6').getChildren().injectIns ide('debug-text');$('eed5af6').getChildren().remove();Data truncated for column 'lastvisit' at row 1

SQL Query type: EXECUTE
Script: '/sourcebans/updater/index.php'
SQL Query: ALTER TABLE `sb_admins` CHANGE `lastvisit` `lastvisit` INT( 11 ) NULL DEFAULT NULL
SQL Params:

Setup...

• Checking current database version... 0
  Updating database to version: 112

Updating...

• Running update: v1... Done.
  
  Running update: v112... Error executing: /updater/data/112.php. Stopping Update!
  Update Failed.

[FredJed223]

Hi,

The updater is failing for me. Updating from 1.2.0

At the top I get:
Duplicate column name 'enabled'

SQL Query type: EXECUTE
Script: '/tf/sb_new/updater/index.php'
SQL Query: ALTER TABLE `sb_mods` ADD `enabled` TINYINT NOT NULL DEFAULT '1'


And then:

Setup...

• Checking current database version... 0
  Updating database to version: 112

Updating...

• Running update: v1... Error executing: /updater/data/1.php. Stopping Update!
  Update Failed.

[FeuerSturm]

Originally Posted by FredJed223 Hi, The updater is failing for me. Updating from 1.2.0 At the top I get: Duplicate column name 'enabled' SQL Query type: EXECUTE Script: '/tf/sb_new/updater/index.php' SQL Query: ALTER TABLE `sb_mods` ADD `enabled` TINYINT NOT NULL DEFAULT '1' And then: Setup... Checking current database version... 0 Updating database to version: 112 Updating... Running update: v1... Error executing: /updater/data/1.php. Stopping Update! Update Failed.

Hallo!

Exactly the same here!

[DJ Tsunami]

Then you're updating from a version after 1.2.0. As Olly said, you'll have to manually update.

[FredJed223]

Originally Posted by DJ Tsunami Then you're updating from a version after 1.2.0. As Olly said, you'll have to manually update.

Nope I used the official version. Never used the SVN...

[Olly]

Originally Posted by WebNoob Awesome! For us newbies....is there a list of changed files somewhere that we need to upload? I'd hate to overwrite any files we don't need to, as we've done quite a bit of customization to the look and feel.

There are too many files to list that changed. You should make a seperate theme, rather than editing the default one.

Originally Posted by FredJed223 Hi, The updater is failing for me. Updating from 1.2.0 At the top I get: Duplicate column name 'enabled' SQL Query type: EXECUTE Script: '/tf/sb_new/updater/index.php' SQL Query: ALTER TABLE `sb_mods` ADD `enabled` TINYINT NOT NULL DEFAULT '1' And then: Setup... Checking current database version... 0 Updating database to version: 112 Updating... Running update: v1... Error executing: /updater/data/1.php. Stopping Update! Update Failed.

Originally Posted by FeuerSturm Hallo! Exactly the same here!

You both must be using the SVN version, because the 'enabled' field wasnt there in the last release. Read the GIANT part in my post that says SVN USERS README

Originally Posted by marrr getting errors trying to update Incorrect datetime value: '1219602102' for column 'lastvisit' at row 1 SQL Query type: EXECUTE Script: '/sourcebans/updater/index.php' SQL Query: UPDATE `sb_admins` SET `lastvisit` = UNIX_TIMESTAMP() WHERE `aid` = '1' SQL Params: $('msg-red-debug').setStyle('display', 'block');$('eed5af6').getChildren().injectIns ide('debug-text');$('eed5af6').getChildren().remove();Data truncated for column 'lastvisit' at row 1 SQL Query type: EXECUTE Script: '/sourcebans/updater/index.php' SQL Query: ALTER TABLE `sb_admins` CHANGE `lastvisit` `lastvisit` INT( 11 ) NULL DEFAULT NULL SQL Params: Setup... Checking current database version... 0 Updating database to version: 112 Updating... Running update: v1... Done. Running update: v112... Error executing: /updater/data/112.php. Stopping Update! Update Failed.

I think I know whats going on here, ill take a look

[marrr]

cool,
im just gonna transfer back my old files till this is figured out. thanks

[FeuerSturm]

I'm using the "normal" 1.2.0 Release (SourceBans-1.2.0.zip 10.39 MB 5 weeks 19 hours),

I'm 100%ly sure about that as I just installed it a week ago
and still have the package on my HDD.

[Olly]

Originally Posted by FeuerSturm I'm using the "normal" 1.2.0 Release (SourceBans-1.2.0.zip 10.39 MB 5 weeks 19 hours), I'm 100%ly sure about that as I just installed it a week ago and still have the package on my HDD.

I re-checked the package JUST to make sure, and there is no trace of 'enabled' for the mods table.

1. Are you sure no-one else would have updated it using SVN?
2. Can you confirm that the 'enabled' field is in the mods table using phpMyAdmin or such tool

Cheers

[FredJed223]

Originally Posted by FeuerSturm I'm using the "normal" 1.2.0 Release (SourceBans-1.2.0.zip 10.39 MB 5 weeks 19 hours), I'm 100%ly sure about that as I just installed it a week ago and still have the package on my HDD.

same here