SQL syntax error after JomSocial Core 4.7.8 upgrading on frontpage

rgfuchs

Hi,

After upgrading to JomSocial 4.7.8 I receive the following red Error message for
index.php?option=com_community&view=frontpage

Error
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 '-277' at line 1

I cannot find anything how to solve this error. Any ideas ?

Thanks,
Robert

Ninja

rgfuchs
Hi
I need to debug your site. Kindly Edit fields in first post and submit a temp super user login details of the site.
Also let me know which was the last JomSocial version installed on your site before updates.

rgfuchs

Hi Pankaj

I have setup a test site to debug (I will later need to fix it on the live site too)

https://testespen.org/join-espen-as-a-member/member-account

Error
SQLSTATE[42000]: Syntax error or access violation: 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 '-277' at line 1

Previous installed version was JomSocial 4.7.6

Thank you,
Robert

Ninja

rgfuchs
Hi
Please check you have recently updated your Joomla and there is error in your DB : http://prntscr.com/whymw8
You may fix the Joomla error first by remove duplicate users https://docs.joomla.org/J3.x😃uplicate_usernames_cause_update_issue
Till you fix it, you can set the error report to NONE from global configuration so the error not show to live site users.

rgfuchs

Thank you for this, I will check it out ... in the meantime I put error reporting to None, but the message still shows .. any idea how else to stop showing this error message temporarily ?

You can see in Joomla admin of testespen.org, how error reporting is put to None , but still showing.

Ninja

rgfuchs
Hi
I changed the DB to MySQLi from Global configurations as PDO is not compatible with JS.
Kindly fix the users issue as many duplicate entries http://prntscr.com/wi2mci
It appears you manually imported the DB user as they have duplicate.

rgfuchs

Hi,
Thanks Pankaj !
... I fixed the users in the table, there were quite a few duplicates indeed. I removed all of them and did run the query again to be sure none is left, then I fixed the database schema, which went ok too BUT the red error alert still shows under https://testespen.org/join-espen-as-a-member/member-account

Any idea while this red error alert is still showing after all these fixes ?

Thank you,
Robert

Ninja

rgfuchs
Hi
Still your DB has error, as your most of the userbase is not real and all settings from custom import or from 3rd party extension, it need dev assistance. I shared it with dev team member and once it check and i will update you here.

rgfuchs

Hi,
Any news ? Would you be able to tell me how to turn off this error message, it does not work by simply turning off error reporting in Joomla! Is there a manual way to turn this or change this error message ? perhaps tell me where I can change the text, that would be a great temporary option too while waiting for dev team response ....

Thank you very much !
Robert

Ninja

rgfuchs
Hi
These are system errors from Joomla and all words can be changed.
Add this code at the end of template.css file in template folder to hide the system messages.

.view-frontpage .alert-error {display:none;}

I will update you once its fixed.

manhta

rgfuchs

Hi,
You can open file /components/com_community/models/activities.php line 288

Change this code if ($numItemLeft) {

to this if ($numItemLeft > 0) {

Please check.

rgfuchs

Great ! Thank you, works like a charm.