hoadv / employee-mgmt-laravel5.4-adminlte Goto Github PK

vender file missing

On initial migrate I get an error complaining about "can't add foreign key"

  SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint (SQL  
  : alter table `employees` add constraint `employees_city_id_foreign` foreig  
  n key (`city_id`) references `city` (`id`))                                  
                                                                               

                                                                          
  [PDOException]                                                          
  SQLSTATE[HY000]: General error: 1215 Cannot add foreign key constraint 

I get this error on migrate, I use xampp version 7.2.2 with specs:

• PHP to 7.2.1
• MariaDB to 10.1.30
• phpMyAdmin 4.7.7

[Illuminate\Database\QueryException]
SQLSTATE[HY000]: General error: 1005 Can't create table isave_db.#sql-2fbe_b (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter table employee_salary add constraint employee_salary_employee_id_foreign foreign key (employee_id) references employee (id))

na

When i run the migrate command I got the error below. Any idea on how to fix it?

[Illuminate\Database\QueryException]
SQLSTATE[HY000]: General error: 1005 Can't create table employee_db.#sql-123c_53 (errno: 150 "Foreign key constraint is incorrectly formed") (SQL: alter table employees add cons
traint employees_city_id_foreign foreign key (city_id) references city (id))

firstname and lastname not added in register blade
so it gives error while creating a new user

at HandleExceptions->handleError(2, 'count(): Parameter must be an array or an object that implements Countable', 'J:\xampp\htdocs\employee-mgmt-laravel5.4\app\Http\Controllers\CountryController.php', 81, array('id' => '1', 'country' => object(Country)))

in app/Http/Controllers/DepartmentController.php
is: use App\department;
should be: use App\Department;

Why is the employee City a drop down select list? Just curious

company_id has been used as a foreign key but there is no table called company
so it gives error while creating a new employee.

I solved this issue by removing company_id column from employees and also from store() function (in EmployeeManagementController)

(2/2) QueryException
SQLSTATE[23000]: Integrity constraint violation: 1452 Cannot add or update a child row: a foreign key constraint fails (callcentre.employees, CONSTRAINT employees_company_id_foreign FOREIGN KEY (company_id) REFERENCES company (id)) (SQL: insert into employees (lastname, firstname, middlename, address, city_id, state_id, country_id, zip, age, birthdate, date_hired, department_id, division_id, picture, company_id, updated_at, created_at) values (Aiman, Ahmed, Aiman, Izzudheen Magu, 20329, M. Rankoralige, 1, 1, 1, 20329, 29, 1990/03/01, 2017/07/24, 1, 1, avatars/JdzVGpL3M6G2bJFq9GY35xsyOsmYmjlf0OhilvQY.jpeg, 0, 2017-07-01 16:00:37, 2017-07-01 16:00:37))

country, state,city,department and devision migration files should have lesser time stamps than employees migration file.

at present employee table is being created first before creating child tables like country,state, city, devision and department so it is giving error saying foreign key constraint wrongly framed.

so we need to create the child tables first so that employee table can have foreign keys for these child tables.

currently migration error is there, i resolved it by changing file name of the child tables,
I gave lesser date and executed following command,

"php artisan migrate"

migration was succesfully completed..

Descibe as head... searching nothing work.. if i have search with paging here..

when i try to execute the code php artisan db:seed it gives me these errors:
[Illuminate\Database\QueryException]
SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.
(SQL: insert into users (username, email, password, lastname, firstname, remember_token, updated_at , created_at) values (admin, [email protected], $2y$10$XuU3jo.4m5ZePqM9S6d8u.CfSmyXLwNLrNoFcLzHtnS./Ksf78rB2, Mr,
admin, qZsLqjAmnt, 2017-08-18 14:51:52, 2017-08-18 14:51:52))

[PDOException]
SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.

We are running BigBlueButton Ver. 2.6.15 on a Ubuntu 20.04 server. We need to change the color of the Navbar and the ActionsBar located above and below the central Presentation container on the classroom screen. The current color is dark blue (#06172A). Having searched through all configurations files I still cannot find where in BBB the colors of the Navbar and ActionsBar are defined.

If anyone can give me the name and location of the file(s) that define those colors, I will be most grateful !

Foreign key constraint 1005 on employees table

New User Registration is giving error

In the RegisterController in create() function
'name' => $data['name'],
should be replaced by
'username' => $data['username'],
because in database column name is 'username'

when i try to execute php artisan migrate it gives me these errors below:
[Illuminate\Database\QueryException]
SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.
(SQL: select * from information_schema.tables where table_schema = employees_db and table_name = migrations)

[PDOException]
SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it.

pls help

The vendor is missing in this repository leading to error:

_

PHP Fatal error: Uncaught Error: Class 'Illuminate\Foundation\Application' not found in /home/vyruss/click/employee-mgmt-laravel5.4-adminlte/bootstrap/app.php:14
Stack trace:
#0 /home/vyruss/click/employee-mgmt-laravel5.4-adminlte/artisan(18): require_once()
#1 {main}
thrown in /home/vyruss/click/employee-mgmt-laravel5.4-adminlte/bootstrap/app.php on line 14

_

I pasted a vendor folder into the offline repo. Still, Another error was prompted;

**_

In excel.php line 182:

Class 'PHPExcel_Shared_Font' not found

_**