How did your config ended up???? May I see the params?

Hi, have tried any of the solutions by searching at he forum?? it is very common, but most of the times depends on a variety of situations. I strongly recommend you jump in the forum, check if any of the symptoms are the same as yours or you can follow your topic by proving more details, like version of your web server, php, Joomla, Vtiger, SO and if you are using the lastest mod and com of openwebapps.

Last but not least, check carefully videotutorial, maybe you just missed something, it happens even if you are keen at vTiger or Joomla, you can take things for granted.

Let me know if I can help you.

Hi,

First of all I would like to thank you for all of your time and effort in bringing this extension to fruition.
I notice after signing up to your site and going through the activation process, once I register I am welcomed by my surname.
Would that also be the case for people who register on my site once vtiger is installed?
Is it easy for me to edit the compulsary fields to work round this?

Regards

Mutley

Hi and welcome, This seems like a customization on Joomla template, I recommend you (considering you are keen at PHP) check the folder template/nameofyourdefaulttemplate/com_login (in case is not there, you can find it at components/com_login). It only requires to get used to some Joomla lang (especially JFactory) and you can present any info you like in order to welcome your registered user (you can even show the password, but it is encrypted)

Well, I hope you enjoy using Joomla/vTiger Lead Capturing, believe me, it rocks.

I am getting:
Error
Vtiger database connection error

Having read the prior posts, I think I have the username, password, and URL correct. However, I don't think I have 'YourVtigerDatabaseName' correct. I have tried the mySQL DB name in my system, with and without 'vtiger' as a prefix.

FYI, my URL is of the form '23.23.244.244', I have also tried the IP the :1234 suffix. I have also tried it as 'http://23.23.244.244'

My host is hostgator.com. I have experienced hostgator requiring whitelisting. Please advise, thanks

I wonder if you add port number. I suggest you to take a look at mysqli_connect documentation Remember that port number is int, hence, you don´t need to add any kind of quotes.

Hope this solves the issue.

that goes for me, I won't happen again, promise.

Well, v_connect show us that in order to establish a connection between client side (Joomla) and vTiger's database "mysqli_connect" function is used. Far as I can remember you have to configure v_connect as follows:

// In the following line Replace vtiger_database_user_name with UserNameToAccessYourMysqlVitigerDatabase
$vtigerdb['username']="user";
// In the following line Replace vtiger_database_user_password with PasswordToAccessYourMysqlVitigerDatabase
$vtigerdb['password']="pass";
// In the following line Replace ip_address_or_url_of_mysql_vtiger_database_server with YourVtigerMysqlServerWebAddress
$vtigerdb['host']="ip";
// In the following line Replace vtiger_database_name with YourVtigerDatabaseName
$vtigerdb['database']="dbname";
//
// Do not modify the fallowing lines
//
@$vtdb = mysqli_connect($vtigerdb['host'], $vtigerdb['username'], $vtigerdb['password'], $vtigerdb['database'],yourport);

As you can see, despite the warning "Do not modify the 'fallowing' lines", you actually have to add your port number. I suggest you to add it as an integer (without quotation marks) because a number is requiered by the function. Hope it helps you.

First of all, thank for the info, those are great news!!!!!

Then, I'm not well versed at English and I didn´t understand the following:

Thank you for participating in the forum.
The businesses who are using the component log into vtiger database periodically and check out the leads. There one can assign the leads to whomever one wants.

Could you please elaborate??

Thanks in advance

Hi friends:

I wonder if you having the same issue,because the potencial of this com and mod is amazing, it would be a shame if for this little issue everything gets stuck.

Thanks

Ok, Thanks
Now it works fine

I have one more doubt, how can i add description field, also checkboxes and radio buttons are not working

Hi, make sure you are mapping values with your customs fields. Possible it may be the case.

Hi there.

Finally is working!!! I have written the instructions at:

http://www.openwebapplications.com/forums/go-to-forums-/topic/24-installjoomlavtigerregistrationonwindows

My guess is that the MySql port I was using ( 3308 ) was the whole problem, maybe it caused the hanging, I don't know. I switched to the default MySql port, 3306, and it is working now.

However, I found that sometimes it saves twice a new lead created on Joomla (it's kind of weird because sometimes does it, most of the times does not) and I can't understand how the Lead is saved at vTiger. Nonetheless. superb work.

Cheers!!!! and double Cheers!
The frustration is gone!

Hi everyone:

After several errors, blood, sweat and tears it works. Call me naive but I'm feeling excellent after having Joomla/Vtiger Registration working. This are the directions I used:

1.Install last version of WAMP server and add PHP add http://www.wampserver.com/en/addons_php.php (this is because neither Joomla or vTiger works on PHP 5.3.0, both of them need deprecated functions not availble at last version of PHP)

2. Change version of PHP at WAMP by clicking on tray icon PHP -> version -> 5.2.9 and restart services.

3.Download vtigercrm-5.1.0.tar and extract the entire folder at ..wamp/www

4. Single click on tray icon and choose localhost, on your proyects choose vTiger (vtigercrm if you left default folder name)

5.Try to install. vTiger would show you some warning stating that php.ini is not using recommended values. Edit them (post any doubt you may have)

6. Finish the installation (I strongly recommend you to use root mysql user, this way you won't have any restriction. Remember it has empy password)

7.Download two previous release of Joomla (I'm using 1.5.13) I guess this is the trick. Extract it at ..wamp/vtigercrm/Joomla so you can have both at the same "site"

8. Install Joomla it by browing to that new folder. Use the same database and mysql user.

9. Download com and mod from this site and install them. Please refer to online tutorial/training if you have any doubt (It's quite handy!)

10. Enable module and edit component (again refer to online tutorial/training)

11. Test,test and after test, test. (It may sound stupid but believe me it's for the better)

So that's it, I just need to adjust some actions and I'll have it my way!!

Cheers.

Thanks for the info.

Hi everybody:

First of all, I would like to point out that I'm amazed with the way openwebapps is integrating Joomla and Vtiger, that's why I tried to installed on my Windows 7 desktop.
After some tests, I get trapped when windows hang in a "mysqli_connect" statement, in v_connect.php, without any error or time out. As a result a blank page was what I got after clicking the "Register" button. For more details please check http://www.openwebapplications.com/forums/go-to-forums-/topic/20-iamredirectedtoablankpageaftersavingalead

That's why I'm asking those how have installed succesfully on Windows the component and module to give some directions that can be followed by people like me.

Thanks in advance.

We have discovered that in Windows the mysql connection hangs and does not give response.

Thank you Octavian for your effords, all of them are appreaciated, I hope that someone has found the solution and is willing to share it.

Thanks.

Hello Herrera,
I might need to take a look. Do you have a skype id?
Cheers

Hi if you have time my id is dheimoz, hope you can help me. Thanks in advance

Octavian, if you are available, I'm ready. Thank you very much

Same issue dude, perhaps it just a Windows thing as expected. If you wish I'll give it a try at Linux. I'll request a Virtual Machine with Linux Installed and test if that'a the thing. Thanks

Hello Herrera,
I might need to take a look. Do you have a skype id?
Cheers

Hi if you have time my id is dheimoz, hope you can help me. Thanks in advance

Octavian, if you are available, I'm ready. Thank you very much

Hello Herrera,
I might need to take a look. Do you have a skype id?
Cheers

Hi if you have time my id is dheimoz, hope you can help me. Thanks in advance

Hello Herrera,
Frustration is not a good feeling, cheer up :-) .
There is nothing wrong with Windows XP. Thousand of businesses around the world use our extension on XP without any problems.

HI, thanks for your kind words.

How did you install the extension? Did you use joomla install, with the zipped package? Did you install it manually by copying the files? There could be file permission issues.

Cheers

I usedthe zipped package.

Can't find a way to make it work. Sorry man, I'm stressed.

Ok, you may right, mysqli_connect requires another param in order to specify the port number Mysql uses. However; is not working. Mmm, I'm frustrated!

Hello Herrera,
Blank pages usually happen if files were corrupted / modified and syntax errors were introduced. Did you modify any other file besides v_connect?

Now, regarding the Mysql port number; are you sure yours is 3308? Usually it is 3306 (the default Mysql port number) . However an incorrect port number will not cause a blank page. If you need a port number that is different from default then in mysqli_connet add one more parameter, "3308", after the last one. Of course then replace "http://localhost:3308" with "localhost" . Again this has nothing to do with the blank page.
Cheers

Hi,

First of all, thanks for your concern.
No I haven't edited any file, in fact all is a new installation.
Yes I have configured port 3308 as mysql port. I have to say that vtiger and Joomla work perfect by themselves, the issue happens when I try to integrate using Joomla-Vtiger Customizable Registration Form. I can't see what I'm doing wrong, maybe versions of Joomla or Vtiger are creating this thing, I don't know.
By the way, I'm at Windows XP, I first installed Vtiger 5.1 using the Windows installation (vtigercrm-5.1.0.exe), it creates it's own apache,php, mysql "schema" (that´s why I'm using different ports than defaults)
Inside vtiger's apache htdocs I installed joomla, and again separately work fine, the thing comes when I try to achive lead-joomla registration.

I hope you can give me some light. Thanks

Any thoughts about why it's redirecting me to a blank page?? I have continued the topic, or do you suggest me to create a new topic?
Thanks.

Hello Herrera,
Using Joomla wrapper is a good approach. It will give your Joomla and Vtiger a common look and feel. Make sure that you give the wrapper enough height to see as much as possible from Vtiger's screen. It is also a good idea to suspend the viewing of all left or right positioned modules or both to increase the width available for Vtiger. You can achieve this by using the wrapper module and making it visible under certain menus, the left and right positioned modules should be made invisible under those menus.
Cheers and Good Luck

Thank you man, definitely you give the best help at this forum.

Sorry, as you see I'm just a newbie. Can't say I'm good at Joomla or Vtiger but I'm improving. Far as I can understand, the only thing you need to do at joomla is creating a wrapper with the url of Vtiger client. Well, forgive me If I look like naive but I can say that vtiger and joomla are interacting, at least at basic level. Cheers, and thanks for your help.

HI:

i'm having the same issue, I hope you can help me. I installed a fresh vtiger 5.1.0 at my computer (there is no place like 127.0.0.1 right?), ports 82 Apache, 3008 MySQL. Then at root level (vtigercrm-5.1.0/apache/htdocs/vtigercrm) I installed a new joomla 1.5.15. Joomla's database name is vitiger510, Vtiger's is vtigercrm510 (default name). Vtiger and Joomla are loaded with "example data". The params at v_connect are the following:

// In the following line Replace vtiger_database_user_name with UserNameToAccessYourMysqlVitigerDatabase
$vtigerdb['username']="root";
// In the following line Replace vtiger_database_user_password with PasswordToAccessYourMysqlVitigerDatabase
$vtigerdb['password']="root";
// In the following line Replace ip_address_or_url_of_mysql_vtiger_database_server with YourVtigerMysqlServerWebAddress
$vtigerdb['host']="http://localhost:3308";
// In the following line Replace vtiger_database_name with YourVtigerDatabaseName
$vtigerdb['database']="vtigercrm510";

As you see i'm using the root user for both mysql connections, Joomla and Vtiger. After registering a new user it redirects me to a blank page. I only have mapped 4 checkboxes with 4 products from vtiger:
Vtiger Single User Pack
Vtiger 5 Users Pack
Vtiger 10 Users Pack
Vtiger 25 Users Pack

What's the problem?? I can't see it. Thanks in advance.

Hello Herrera,
Thank you (Gracias :-) ) for using this extension.
If you like it please go to http://extensions.joomla.org/extensions/clients/crm/7307 and give us a good review.

As you notice we are fully integrated with Vtiger on our website, www.openwebapplications.com, when you login in Joomla you also login into Vtiger admin, when you logout from Joomla you also logout from Vtiger. If you are interested please email us at sales@openwebapplications.com and we will be glad to do a project for you.
Cheers

Thanks for the info, it is very kind. I guess the fully integration is not for free. Nonetheless, thanks for your work.

Hi I must say that it's amazing what you have done, congratulations!

I've got a few questions:

It's superb how you embebed vitger into Joomla, how can I achive that?

Is it possible to access via Joomla the vtiger admin session in order to make quotes for example?

Thank you very much for your effords. Gracias!