Page 1 of 1

getting an error on /usr/share/astguiclient/AST_DB_optimize

PostPosted: Wed Dec 12, 2007 11:10 am
by CALLINGUSA
As soon as i run, /usr/share/astguiclient/AST_DB_optimize.pl on my CLI, it starts executing fine, with error in the last:
The output is as follows:



|asterisk.call_log|optimize|status|OK|
|asterisk.park_log|optimize|status|Table is already up to date|
|asterisk.vicidial_log|optimize|status|Table is already up to date|
|asterisk.vicidial_closer_log|optimize|status|Table is already up to date|
|asterisk.vicidial_xfer_log|optimize|status|Table is already up to date|
|asterisk.vicidial_list|optimize|status|OK|
|asterisk.vicidial_manager|optimize|status|OK|
|asterisk.vicidial_auto_calls|optimize|status|OK|
|asterisk.vicidial_live_agents|optimize|status|OK|
|asterisk.vicidial_campaign_stats|optimize|status|OK|
|asterisk.vicidial_campaign_server_stats|optimize|status|OK|
|asterisk.vicidial_dnc|optimize|status|Table is already up to date|
|asterisk.vicidial_callbacks|optimize|status|Table is already up to date|
|asterisk.vicidial_agent_log|optimize|status|Table is already up to date|
|asterisk.vicidial_conferences|optimize|status|Table is already up to date|
|asterisk.vicidial_hopper|optimize|status|OK|
DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/share/astguiclient/AST_DB_optimize.pl line 258.
|||||
DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/share/astguiclient/AST_DB_optimize.pl line 269.
|||||
DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/share/astguiclient/AST_DB_optimize.pl line 280.
|||||
DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/share/astguiclient/AST_DB_optimize.pl line 291.
|||||
DBD::mysql::st fetchrow_array failed: fetch() without execute() at /usr/share/astguiclient/AST_DB_optimize.pl line 302.
|||||



Can anyone guide me as to what could be wrong here......

PostPosted: Wed Dec 12, 2007 2:37 pm
by nobesnickr
I have the same issue :/

any ideas?

PostPosted: Wed Dec 12, 2007 2:40 pm
by nobesnickr
I wonder if you have to have the server not active in order to do this, I'm sure this is a good idea but maybe that is my problem... Ill work with it and post later if i find out anything

PostPosted: Wed Dec 12, 2007 3:08 pm
by mflorell
astguiclient version?

PostPosted: Wed Dec 12, 2007 3:26 pm
by nobesnickr
2.04 :D

PostPosted: Wed Dec 12, 2007 3:48 pm
by CALLINGUSA
i'm also using the same 2.0.4, with asterisk 1.2.24

hello

PostPosted: Thu Dec 13, 2007 1:14 am
by eliasferreyra
me to :D im having the same problem

PostPosted: Thu Dec 13, 2007 11:42 am
by nobesnickr
looks like we might have a bug

PostPosted: Thu Dec 13, 2007 12:01 pm
by CALLINGUSA
Anyone Else having the same issue????

hello

PostPosted: Fri Dec 14, 2007 2:34 pm
by eliasferreyra
im have the same problem

on astguiclient 2.0.3 and 2.0.4

PostPosted: Sat Dec 15, 2007 4:19 am
by mflorell
Thanks for finding this one, it has been fixed in SVN and will be in the bugfix 2.0.4 release that should be out before the end of the month.

ok

PostPosted: Sat Dec 15, 2007 10:40 pm
by eliasferreyra
ok matt thanks