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

    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.

      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

        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.

          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.

            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

              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.

                4 days later

                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

                  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.

                    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.

                      Great ! Thank you, works like a charm.

                      Ninja locked the discussion.
                      Write a Reply...
                      You need to Login to view replies.