Build Database and DB Schema issue

Starting Update…
Migration table created successfully.
Migrating: 2018_07_03_091314_create_access_points_table
SQLSTATE[42S01]: Base table or view already exists: 1050 Table ‘access_points’ already exists (SQL: create table access_points (accesspoint_id int unsigned not null auto_increment primary key, device_id int unsigned not null, name varchar(255) not null, radio_number tinyint null, type varchar(16) not null, mac_addr varchar(24) not null, deleted tinyint(1) not null default ‘0’, channel tinyint unsigned not null default ‘0’, txpow tinyint not null default ‘0’, radioutil tinyint not null default ‘0’, numasoclients smallint not null default ‘0’, nummonclients smallint not null default ‘0’, numactbssid tinyint not null default ‘0’, nummonbssid tinyint not null default ‘0’, interference tinyint unsigned not null) default character set utf8 collate ‘utf8_unicode_ci’)

Error!

once i ./validate.php
[FAIL] Your database is out of date!
[FIX]:
./lnms migrate
librenms@netplus-NMS:~$ ./lnms migrate


  • Application In Production!     *
    

Do you really wish to run this command? (yes/no) [no]:

yes

Migration table created successfully.
Loading stored database schema: /opt/librenms/database/schema/mysql-schema.dump

In Process.php line 267:

anyone help me please

error gone i just Drop the librenms database and re-create in mysql

This topic was automatically closed 186 days after the last reply. New replies are no longer allowed.