Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N
mysql -h localhost -u root asterisk -f < /usr/src/astguiclient/trunk/extras/upgrade_2.14.sql
carpenox wrote:Vicibox 9 doesn't work anymore, use v10 or do a scratch
martinch wrote:Hey,
What's your DB schema version? Those tables were introduced in DB schema version 1679.
You could try running the mySQL upgrade command manually;
- Code: Select all
mysql -h localhost -u root asterisk -f < /usr/src/astguiclient/trunk/extras/upgrade_2.14.sql
Hope this helps,
Martin.
syedfahim786 wrote:martinch wrote:Hey,
What's your DB schema version? Those tables were introduced in DB schema version 1679.
You could try running the mySQL upgrade command manually;
- Code: Select all
mysql -h localhost -u root asterisk -f < /usr/src/astguiclient/trunk/extras/upgrade_2.14.sql
Hope this helps,
Martin.
Hello Martin,
I tried your suggestion but the issue still exists. It's a scratch install on Centos 7. DB schema version is: 1682
tail /usr/src/astguiclient/trunk/extras/upgrade_2.14.sql
martinch wrote:syedfahim786 wrote:martinch wrote:Hey,
What's your DB schema version? Those tables were introduced in DB schema version 1679.
You could try running the mySQL upgrade command manually;
- Code: Select all
mysql -h localhost -u root asterisk -f < /usr/src/astguiclient/trunk/extras/upgrade_2.14.sql
Hope this helps,
Martin.
Hello Martin,
I tried your suggestion but the issue still exists. It's a scratch install on Centos 7. DB schema version is: 1682
Hello there syed,
You're running DB schema 1682 but those tables were introduced in 1679. That means the schema hasn't been applied properly or the astguiclient isn't pointing to the right database server / IP / or bad username or password.
Can you give me the output of this command please;
- Code: Select all
tail /usr/src/astguiclient/trunk/extras/upgrade_2.14.sql
Thank you syed. Feel free to jump into ##vicidial chat on IRC if you'd like realtime support with this.
queue_date DATETIME DEFAULT current_timestamp()
ERROR 1067 (42000) at line 2177: Invalid default value for 'entry_date'
Users browsing this forum: No registered users and 13 guests