Page 1 of 1

vtiger_search.php

PostPosted: Wed Mar 10, 2010 4:29 pm
by theman2000k
Hey guys,

I have done several installs of this wonderful program over the last few months and they have been perfect.

I have always used the default ip address but I have an install that has a different IP address. I downloaded the latest and greatest 1.3 and the install is perfect except the vtiger_search.php is having issues.

In the webform field I put "http://192.168.47.107/vicidial/vtiger_search.php" and when the form is clicked from the agent screen I get..."http://192.168.47.107/agc2/vicidial/vtiger_search.php" with all the code behind it.

If I back out the agc2 from the url and hit enter I get..."http://192.168.47.107/vicidial/192.168.47.107/vtigercrm/index.php"

I have run the server IP update and have also looked in the vtiger_search.php but am not sure where to make the changes in the file. Am I supposed to change something in the area below?

###############################################################
##### START SYSTEM_SETTINGS VTIGER CONNECTION INFO LOOKUP #####
$stmt = "SELECT enable_vtiger_integration,vtiger_server_ip,vtiger_dbname,vtiger_login,vtiger_pass,vtiger_url FROM system_settings;";
$rslt=mysql_query($stmt, $link);
if ($DB) {echo "$stmt\n";}
$ss_conf_ct = mysql_num_rows($rslt);
if ($ss_conf_ct > 0)
{
$row=mysql_fetch_row($rslt);
$enable_vtiger_integration = $row[0];
$vtiger_server_ip = $row[1];
$vtiger_dbname = $row[2];
$vtiger_login = $row[3];
$vtiger_pass = $row[4];
$vtiger_url = $row[5];
}
##### END SYSTEM_SETTINGS VTIGER CONNECTION INFO LOOKUP #####
#############################################################

Sorry for all the info. I am just at a loss on this one.

PostPosted: Thu Mar 11, 2010 6:25 am
by mflorell
vicidial.php version and build?

vtiger version?

PostPosted: Thu Mar 11, 2010 12:52 pm
by theman2000k
mflorell wrote:vicidial.php version and build?

vtiger version?


Sorry about that I should know better. :-(

VERSION: 2.0.5-174
BUILD: 90522-0506
Vtiger5.0.4

I just did a reinstall from scratch this morning and this is all I get when I do a "sale made" and then "webform submit". I changed my IP from the above install.

http://192.168.47.188/vicidial/192.168. ... ttab=Sales

I am not sure where that double IP address is comming from?


Thanks

PostPosted: Thu Mar 11, 2010 6:48 pm
by mflorell
not sure about that one either, what do you have in the web form value for that campaign/in-group?

You should consider upgrading to 2.2.0.

PostPosted: Tue Mar 16, 2010 9:25 am
by theman2000k
mflorell wrote:not sure about that one either, what do you have in the web form value for that campaign/in-group?


There is nothing in that field.

I made some changes to the router and went ahead and installed the system and left the IP address alone. Things seem to be working great except for that webform.

I am still trying to hunt down where the URL is created for the webform submit.

EDIT FYI the records are getting added to vtiger when the submit webform is clicked.

Here is what I am getting now in the address bar when I click sale made and webform submit...

http://192.168.1.2/vicidial/192.168.1.2 ... ttab=Sales

This is what the browser returns...

Not Found

The requested URL /vicidial/192.168.1.2/vtigercrm/index.php was not found on this server.
Apache/2.2.3 (CentOS) Server at 192.168.1.2 Port 80



I hope someone can point me in the right direction of where this extra url info comes from.

Thanks[/img]

PostPosted: Tue Mar 16, 2010 12:10 pm
by mflorell
So you are saying that the webform address field for your campaign is blank?

PostPosted: Tue Mar 16, 2010 1:02 pm
by theman2000k
mflorell wrote:So you are saying that the webform address field for your campaign is blank?


No, in the campaign webform field I have "http://192.168.1.2/vicidial/vtiger_search.php"


The webform target is "vcdwebform"


I have nothing in the webform field for the in-group

PostPosted: Tue Mar 16, 2010 3:45 pm
by mflorell
I cannot duplicate this issue in 2.2.0 with those settings. I do not have 2.0.5 set up anywhere so I cannot confirm that.

PostPosted: Wed Mar 17, 2010 10:15 am
by theman2000k
mflorell wrote:I cannot duplicate this issue in 2.2.0 with those settings. I do not have 2.0.5 set up anywhere so I cannot confirm that.


You recommended upgrading to 2.2.0. The install that I downloaded last week came with 2.0.5. Is there a new version of the automatic Vicidialnow install that comes with 2.2.0?

If not, what is the best way to upgrade?

Sorry about being a PITA. I'm still new to the product and am still figuring out all of the in's and out's.

PostPosted: Wed Mar 17, 2010 10:56 am
by mflorell
I don't think there is a new vicidialnow download with that on it, but vicibox redux does have 2.2.0 on it and it is available now.

Of course you could always just follow the UPGRADE doc procedures and upgrade your existing install.

PostPosted: Wed Mar 17, 2010 11:19 am
by theman2000k
mflorell wrote:I don't think there is a new vicidialnow download with that on it, but vicibox redux does have 2.2.0 on it and it is available now.

Of course you could always just follow the UPGRADE doc procedures and upgrade your existing install.


I will do the upgrade. Where might that Doc be located?

Thanks

PostPosted: Wed Mar 17, 2010 12:14 pm
by mflorell
Well, download 2.2.0(or check it out from SVN), open it up, and it's the file named "UPGRADE" that is in the main folder.

PostPosted: Wed Mar 17, 2010 3:10 pm
by theman2000k
I figured it out.

I went ahead and upgraded to the new version ans still had the same problem.

What fixed the issue was adding http:// to the begenning of the "vtiger url" in the system settings section. I just had 192.168.1.2/vtigercrm

I must have looked at that 100 times and did not think twice about it.

Thanks for all the help.

PostPosted: Wed Mar 17, 2010 3:26 pm
by mflorell
Thanks for posting your solution, glad everything is working well now.

PostPosted: Thu Mar 18, 2010 12:22 am
by josh1856
VERSION: 2.2.0-234
BUILD: 100116-0718
vtiger: 5.0.4

Current settings
db name: vtiger504
vtiger
vtuser
localhost

I upgraded from 2.0.5 to 2.2.0 and managed to create the same error.

Connected successfully
Could not execute: No database selected

what am I missing? I tried your fix and it did not work?

PostPosted: Thu Mar 18, 2010 6:56 am
by mflorell
what fix did you try?

are you sure that database exists? That error message usually means that is doesn't.