Forum
You are not logged in. Please note that you need to log in before posting.
#1 2010-04-19 21:54:48
- JasonSGN
- Member
- Registered: 2009-08-06
- Posts: 52
4.0.15 Upgrade Issue
My site would not load after upgrading to 4.0.15 from 4.0.14, so I decided to create a new database an receive the following error on a clean install:
MySQL error - 1060: Duplicate column name 'need_provider'. The query was:
CREATE TABLE IF NOT EXISTS `ha_services` (
`id` int(11) NOT NULL auto_increment,
`title` VARCHAR(255),
`description` TEXT,
`total_seats` int(11) DEFAULT 1,
`min_seats` int(11) DEFAULT 1,
`max_seats` int(11) DEFAULT 1,
`min_from_now` int(11) DEFAULT 0,
`max_from_now` int(11) DEFAULT 1209600,
`min_cancel` int(11) DEFAULT 86400,
`allow_queue` TINYINT DEFAULT 0,
`need_provider` TINYINT DEFAULT 1,
`need_provider` TINYINT DEFAULT 0,
`show_order` int(11) DEFAULT 1,
PRIMARY KEY (`id`)
)
MySQL error!: MySQL error - 1060: Duplicate column name 'need_provider'
Offline
#2 2010-04-19 22:01:37
- JasonSGN
- Member
- Registered: 2009-08-06
- Posts: 52
Re: 4.0.15 Upgrade Issue
I removed the duplicate column name 'need_provider' in setup.php and then received this message:
MySQL error - 1054: Unknown column 'share_location' in 'field list'. The query was:
INSERT INTO ha_services
(title, description, total_seats, min_seats, max_seats, min_from_now, max_from_now, min_cancel, allow_queue, id, need_provider, share_location) VALUES ('My Service', 'Description of My Service', 1, 1, 1, 10800, 4838400, 86400, 0, 0, 1, 0)
Admin account has been successfully created, sample data populated
Now please delete the setup.php file. Then your hitAppoint will be ready.
Offline
