Cant add new campaigns

All installation and configuration problems and questions

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

Cant add new campaigns

Postby Michael_N » Thu Dec 06, 2007 1:57 am

This happend when i try to ad a campaign it accept the add but it wont show in the list, and i get the message below in apache error_log
PHP Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/html/vicidial/admin.php on line 1616,

I am using mysql 5.0.22 php 5 vicidial 2.0.4

##### BEGIN get inbound groups listing for checkboxes #####
$xfer_groupsSQL='';
if ( (($ADD>20) and ($ADD<70)) and ($ADD!=41) )
{
$stmt="SELECT closer_campaigns,xfer_groups from vicidial_campaigns where campaign_id='$campaign_id';";
$rslt=mysql_query($stmt, $link);
$row=mysql_fetch_row($rslt); LINE 1616
$closer_campaigns = $row[0];
$closer_campaigns = preg_replace("/ -$/","",$closer_campaigns);
$groups = explode(" ", $closer_campaigns);
$xfer_groups = $row[1];
Michael_N
 
Posts: 687
Joined: Wed Jul 05, 2006 3:13 pm
Location: sweden

Postby mflorell » Fri Dec 07, 2007 12:32 pm

Did you upgrade from 2.0.3?

Do you have xfer_groups in the vicidial_campaigns table?
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida

Postby Michael_N » Fri Dec 07, 2007 6:23 pm

mflorell wrote:Did you upgrade from 2.0.3?

Do you have xfer_groups in the vicidial_campaigns table?


No clean install 2.0.4
And importing database created in 2.0.3

But i think the problem is solved,, i did an reinstall folowing scrath install debian

And i noticed that the apache server is runnig by user www-data, will that caurse any problems with vicidial?
Michael_N
 
Posts: 687
Joined: Wed Jul 05, 2006 3:13 pm
Location: sweden

Postby mflorell » Sat Dec 08, 2007 2:31 pm

I don't think there would be a problem with www-data as the user for Apache.
mflorell
Site Admin
 
Posts: 18387
Joined: Wed Jun 07, 2006 2:45 pm
Location: Florida


Return to Support

Who is online

Users browsing this forum: Google [Bot] and 102 guests