Page 1 of 1

Cant add new campaigns

PostPosted: Thu Dec 06, 2007 1:57 am
by Michael_N
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];

PostPosted: Fri Dec 07, 2007 12:32 pm
by mflorell
Did you upgrade from 2.0.3?

Do you have xfer_groups in the vicidial_campaigns table?

PostPosted: Fri Dec 07, 2007 6:23 pm
by Michael_N
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?

PostPosted: Sat Dec 08, 2007 2:31 pm
by mflorell
I don't think there would be a problem with www-data as the user for Apache.