Hi All,

I'm tearing my hair out whilst trying to update Jomsocial from 3.0.x to 3.1.0.1 and whilst I have tried manual upgrade and also iJoominstall etc, I'm having no joy and need some guidance if possible please?

I have uninstalled my Jomsocial 3.0.x and have the Jomsocial 3.1.0.1 installer uploaded to my space fine, however when I run it and go through the on screen prompts, it goes like the following screenshots;

This was the initial results and as you can see there was a couple in orange.



As you can see here I've managed to correct the first two orange warning settings, however I'm not sure where or what to amend to sort the "connect_timeout" setting or even if I need to?

Hi,

Can you contact your hosting provide to increase the connect_timeout setting please?

Hi Dimas,

Thanks for the reply. however as I have a VPS server which is in effect un-managed by the host but they're very helpful to point me in any new direction required, they said that what I had already done by adding the following in to my sites php.ini;

[MySQL]
mysql.connect_timeout = 120

Is correct but I'm trying to find confirmation from the internet that this is the case.

Can you please advise why the above is happening, as far as I can tell I am doing everything correct.

Dimas Tekad Santosa wrote: Hi,

Can you contact your hosting provide to increase the connect_timeout setting please?

I've also checked within my joomla backend global config>system information>php information tab and it's saying that the mysql connect_timeout is set at 60, which isn't the 120 I'm asking the system for but is certainly above the 10 that the Jomsocial installer is currently showing?

Regards,
Rob

I have been notified by my hosting company that offer me the VPS the following;

Thanks for your reply.

I've contacted my seniors about this. It appears that we may be barking up the wrong tree.

The PHP info page shows the timeout settings, this suggests that the jomsocial installation script is using a different value to determine this.

My senior has done some looking into this and there are a fair few hits on the jomsocial site where people have the same problem. Only registered users are allowed to see the answer though, so I'd recommend you possibly use your account with them.

www.jomsocial.com/forum/installation/365...2-8-3-unpack-problem

In light of that I would suggest that you contact their support and ask for advice on exactly which variable to use.

Installation done, this issue caused by duplicate entry JomsocilToolbar in your database, I already delete it and re-install again and done.

Thanks Dimas, just what the doctor ordered, much appreciated.

Regards,
Rob

You're welcome :)

Sorry to bring this thread up again but rather than start a new one when I'm 99% sure it's the exact same problem and I want to fix it myself this time for future reference.

I've just used iJoomlainstaller to upgrade my now previous Jomsocial version 3.1.1 I think it was to the latest 3.2.1 and it's installed to the point I have the browser led installer ready.

I've done this and it's done the exact same as the messages above on a previous update I tried to do and you fixed.

As per your message below, can you tell me exactly what extensionID I'm looking for in phpmyadmin so I can delete the offending record from my database and try the browser jomsocial installer again?

I look forward to hearing from you.

Regards,
Rob

Dimas Tekad Santosa wrote: Installation done, this issue caused by duplicate entry JomsocilToolbar in your database, I already delete it and re-install again and done.

Hi Robert,

Simply, just search the com_community menu in #__menu and delete it, this is the query :

DELETE FROM #__menu WHERE link like '%com_community%'

Dimas,

Thank you for the reply, however when I run that query in the "SQL" tab within PHPMyAdmin I get the following;

SQL query:


DELETE FROM #__menu WHERE link like '%com_community%'
MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 

Dimas Tekad Santosa wrote: Hi Robert,

Simply, just search the com_community menu in #__menu and delete it, this is the query :

DELETE FROM #__menu WHERE link like '%com_community%'

i hope it will help.

thank you

Hi Rob,

I thought you know how to change this prefix #__

ok this, this is the correct one :

DELETE FROM rj0vn_menu WHERE link like '%com_community%'