Install errors

[Nobody/Anonymous]

Just ran the install script and received this output.

Install in progress....

Starting to create tables...
Creating namemap table...done!
Creating torrent summary table...FAILED
Creating timestamps table...done!
Creating logins table...done!
Creating IP ban table...FAILED
Creating external torrents table...done!
Creating retired torrents table...done!
Creating user permissions table...done!
Creating torrents table...done!
Creating subgrouping table...done!

8 tables were created.

This script did NOT attempt to write a configuration file to the server. You will need to rename config_sample.php to config.php manually.

Installation appears to have had errors. Please check and try again, if needed.
_________

Why can it not create the "torrent summary table" & "IP ban table" ?

thanks

[Dan]

That's a good question, I thought the script was supposed to tell you why it failed.

I may have to write a slightly different script for you to try.

What version of PHP & MySQL?

[Nobody/Anonymous]

PHP v5.1.6
SQL v5.0.24a

[Dan]

I've created a new bug for this: http://sourceforge.net/tracker/index.php?func=detail&aid=1571884&group_id=120663&atid=687790

I've also created a new install.php that should show more detailed errors. Try downloading it and see what it says.

Please note I haven't had time to test it (other than for syntax errors.) I will also be unavailable for comment until Tuesday October 10th, in case you are wondering why I'm not responding.

[Nobody/Anonymous]

The Error Are:

SQL 1:

CREATE TABLE `summary` (`info_hash` CHAR (40) NOT NULL, `dlbytes` BIGINT (20) UNSIGNED DEFAULT '0' NOT NULL, `seeds` INT (10) UNSIGNED DEFAULT '0' NOT NULL, `leechers` INT (10) UNSIGNED DEFAULT '0' NOT NULL, `finished` INT (10) UNSIGNED DEFAULT '0' NOT NULL, `lastcycle` INT (10) UNSIGNED DEFAULT '0' NOT NULL, `lastSpeedCycle` INT (10) UNSIGNED DEFAULT '0' NOT NULL, `lastAvgCycle` INT (10) UNSIGNED DEFAULT '0' NOT NULL, `speed` BIGINT (20) UNSIGNED DEFAULT '-1' NOT NULL, `hide_torrent` ENUM ('N','Y') DEFAULT 'N', `avgdone` FLOAT DEFAULT '0' NOT NULL, `external_torrent` ENUM ('N','Y') DEFAULT 'N', `ext_no_scrape_update` ENUM ('N','Y') DEFAULT 'N', PRIMARY KEY(`info_hash`), INDEX(`hide_torrent`,`external_torrent`,`ext_no_scrape_update`))

ERROR 1:

`speed` BIGINT (20) UNSIGNED DEFAULT '-1' <-- Can't be unsigned with default -1. I used 0 I hope it works...

SQL 2:

CREATE TABLE `ipbans` (`ban_id` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `ip` VARCHAR (16) NOT NULL, `iplong` INT(10)  DEFAULT '0' NOT NULL, `bandate` DATE DEFAULT '0000-00-00' NOT NULL, `reason` VARCHAR (50) NOT NULL, `autoban` ENUM ('Y','N') DEFAULT 'N' NOT NULL, `banlength` TINYINT (3) UNSIGNED DEFAULT '0' NOT NULL, `banexpiry` DOUBLE DEFAULT '0000-00-00' NOT NULL, `banautoexpires` ENUM ('Y','N') DEFAULT 'N' NOT NULL, PRIMARY KEY(`ban_id`), INDEX(`bandate`,`autoban`,`banexpiry`,`banautoexpires`, `iplong`))

ERROR 2:

`banexpiry` DOUBLE DEFAULT '0000-00-00' NOT NULL <-- Double is not a date. I changed the default to 0. I hope it works...

[Dan]

Those values should be fine.

I've looked over the install script and made sure the other queries are ok. The fixes will be included in v2.2 which will hopefully be released over the next few weeks, albiet with new mysql requirements.