asadjaved63 / easy-appointments

Automatically exported from code.google.com/p/easy-appointments
0 stars 0 forks source link

Database error on install easy-appointments #31

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago
What steps will reproduce the problem?
1. I'm trying to install easy-appointments
2. On open the page on setup, and fill all fields I give the error below.

A Database Error Occurred

Error Number: 1005

Can't create table 'easy_appointments.#sql-2be0_4fbb' (errno: 121)

---- Περιορισμοί για 
άχρηστους πίνακες------ 
Περιορισμοί για 
πίνακα `ea_appointments`--ALTER TABLE `ea_appointments` ADD 
CONSTRAINT `ea_appointments_ibfk_2` FOREIGN KEY (`id_users_customer`) 
REFERENCES `ea_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD 
CONSTRAINT `ea_appointments_ibfk_3` FOREIGN KEY (`id_services`) REFERENCES 
`ea_services` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, ADD CONSTRAINT 
`ea_appointments_ibfk_4` FOREIGN KEY (`id_users_provider`) REFERENCES 
`ea_users` (`id`) ON DELETE CASCADE ON UPDATE CASCADE

Filename: /var/www/easyappointments/controllers/appointments.php

Line Number: 627

Original issue reported on code.google.com by max.mora...@gmail.com on 4 Apr 2014 at 1:06

GoogleCodeExporter commented 9 years ago
Hello and sorry for not replying earlier. I wasn't able to check your problem 
these days. 

MySQL error 1005 (errno 121) means that you're trying to add a constraint with 
a name that's already used somewhere else. So before installing 
Easy!Appointments check that you are using a clean database. 

It seems to me that you had a previous version installed and that's why E!A is 
crushing, am I right?

Original comment by alextselegidis@gmail.com on 30 Apr 2014 at 7:05

GoogleCodeExporter commented 9 years ago

Original comment by alextselegidis@gmail.com on 5 May 2014 at 8:48

GoogleCodeExporter commented 9 years ago

Original comment by alextselegidis@gmail.com on 5 May 2014 at 8:48