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

All installation and configuration problems and questions

Moderators: gerski, enjay, williamconley, Op3r, Staydog, gardo, mflorell, MJCoate, mcargile, Kumba, Michael_N

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

Postby CALLINGUSA » Wed Dec 12, 2007 11:10 am

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......
CALLINGUSA
 
Posts: 27
Joined: Fri Nov 30, 2007 2:02 pm

Postby nobesnickr » Wed Dec 12, 2007 2:37 pm

I have the same issue :/

any ideas?
nobesnickr
 
Posts: 56
Joined: Thu Nov 01, 2007 6:44 pm

Postby nobesnickr » Wed Dec 12, 2007 2:40 pm

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
nobesnickr
 
Posts: 56
Joined: Thu Nov 01, 2007 6:44 pm

Postby mflorell » Wed Dec 12, 2007 3:08 pm

astguiclient version?
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby nobesnickr » Wed Dec 12, 2007 3:26 pm

2.04 :D
nobesnickr
 
Posts: 56
Joined: Thu Nov 01, 2007 6:44 pm

Postby CALLINGUSA » Wed Dec 12, 2007 3:48 pm

i'm also using the same 2.0.4, with asterisk 1.2.24
CALLINGUSA
 
Posts: 27
Joined: Fri Nov 30, 2007 2:02 pm

hello

Postby eliasferreyra » Thu Dec 13, 2007 1:14 am

me to :D im having the same problem
eliasferreyra
 
Posts: 367
Joined: Wed Jul 18, 2007 3:27 pm

Postby nobesnickr » Thu Dec 13, 2007 11:42 am

looks like we might have a bug
nobesnickr
 
Posts: 56
Joined: Thu Nov 01, 2007 6:44 pm

Postby CALLINGUSA » Thu Dec 13, 2007 12:01 pm

Anyone Else having the same issue????
CALLINGUSA
 
Posts: 27
Joined: Fri Nov 30, 2007 2:02 pm

hello

Postby eliasferreyra » Fri Dec 14, 2007 2:34 pm

im have the same problem

on astguiclient 2.0.3 and 2.0.4
eliasferreyra
 
Posts: 367
Joined: Wed Jul 18, 2007 3:27 pm

Postby mflorell » Sat Dec 15, 2007 4:19 am

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.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

ok

Postby eliasferreyra » Sat Dec 15, 2007 10:40 pm

ok matt thanks
eliasferreyra
 
Posts: 367
Joined: Wed Jul 18, 2007 3:27 pm


Return to Support

Who is online

Users browsing this forum: Bing [Bot] and 173 guests