FreePBX 2.8.0 installation error

The following errors is created when installing FreePBX 2.8.0 with asterisk 1.4.35:

Installing new FreePBX files…OK (668 files copied, 0 skipped)
Configuring install for your environment…amportal…fpbx…freepbx_engine…done
apply username/password changes to conf files…done
creating missing #include files…OK
Setting permissions on files…OK
Checking for upgrades…48 found
Upgrading to 1.10.007beta1…
-> Running SQL script /usr/src/asterisksrc/freepbx-2.8.0/upgrades/1.10.007beta1/tables.sql
[FATAL] ALTER TABLE sip CHANGE id id BIGINT( 11 ) DEFAULT “-1” NOT NULL [nativecode=1146 ** Table ‘asterisk.sip’ doesn’t exist]" while running tables.sql

Any ideas?

Have you set up the database in MySQL as per the INSTALL dokumentation?

I am facing the the same problem …MYSQL setup is perfect as per doc…

Answer to both of you:
How did you install this?
Is this a plain install or a distro?

It’s a plain install as per doc:

  • SQL database has been successfully created without errors.
  • Then ./install_amp --username=asteriskuser --password=somepassword.
  • Proceed with default settings … ,then the error message was generated.

Next, downgraded to freepbx 2.7.0, got a bunch of PHP error message.
But still got the web interface. From here then we can upgrade to version 2.8.0 by upgrading the modules one by one. However, 2 modules still cannot be installed/enabled when downloaded, i.e: MOH and Blacklist.

Why can’t we install freepbx 2.8.0 directly with asterisk 1.4.35?