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
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?