Since upgrading to Joomla 3.3 two days ago, when I click on 'profile' on my Jomsocial toolbar I get the following SQL error message:

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 'IN (221,406,682,990,1067,1123,1127,1255,1285,1306,1730,1799,2109) ) ) OR ( (a.`p' at line 1 SQL=select a.*, b.`title` AS

Hi, Andrew.

I mentioned about it in your previous post. This is not WHOLE error notice. After AS its cut... as what? We need to have whole notice in order to figure out what's happening here... you may add a printscreen as still I can't reach your site due to timeouts.

That's the whole error message. You can see for yourself when you log in with the 'support' admin credentials provided in the first post in this thread and click on 'profile' in the jomsocial status bar/menu.

Hi, Andrew.

Hmmm... so something is covering the notice... try to check in code (CTR+U) if you'll see whole notice.

The problem is I CAN'T REACH YOUR SITE DUE TO TIMEOUTS - I'm sorry.. that's why I can't check it myself... If I could I'll not bother you with my requests.

The time out issues have been resolved. In fact, all problems with the site caused by the upgrade to Joomla 3.3 have been resolved, except for one. The only problem left - as far as I'm aware - is the SQL error when opening the profile link on the Jomsocial toolbar menu.

awesomescreenshot.com/0803yv8ud8

Here's the link to the page on my site:

therebel.website/en/profile

Please note the domain name change from therebel.org to therebel.website.

P.S.: There is one more problem, the non-resizing of the jomsocial status update form, but on your recommendation I've passed this topic to Joomlart, the vendor of the template, which - according to your view - has a conflicting script preventing the dynamic resizing of the form.

Hi, Andrew.

I asked other support members to try to log in to your site... as only when try to log in I get still timeouts.

In addition:

Your currently supported domain is: therebel.org
You request support on therebel.website

This require supported domain change. Please, post a domain change request here: www.jomsocial.com/forum/billing-issues

Hi Andrew,

That query error message belongs to EasyBlog.

select a.*, b.`title` AS `category` 
  from `j25_easyblog_post` as a 
  LEFT JOIN `j25_easyblog_category` AS b 	
  ON a.`category_id` = b.`id` 
  where a.`created_by` = '2098' 
  and a.`published` = 1 
  AND ( (a.`private`= 0 ) OR ( (a.`private` = 20) 
  AND ('2098' > 0 ) ) OR ( (a.`private` = 30) 
  AND ( 1 = 2 ) ) OR ( (a.`private` = 40) 
  AND ( a.=2098) ) ) 
  order by a.`created` DESC 
  LIMIT 5

Explain
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 '=2098) ) ) order by a.`created` DESC LIMIT 5' at line 1 SQL=EXPLAIN select a.*, b.`title` AS `category` from `j25_easyblog_post` as a LEFT JOIN `j25_easyblog_category` AS b ON a.`category_id` = b.`id` where a.`created_by` = '2098' and a.`published` = 1 AND ( (a.`private`= 0 ) OR ( (a.`private` = 20) AND ('2098' > 0 ) ) OR ( (a.`private` = 30) AND ( 1 = 2 ) ) OR ( (a.`private` = 40) AND ( a.=2098) ) ) order by a.`created` DESC LIMIT 5

The Jomsocial Profile page still produces the same SQL error. It doesn't make any references to EasyBlog. There used to be an EasyBlog SQL error in their component, but it's got nothing to do with the Jomsocial Profile error message. The EasyBlog SQL error has been fixed in the meantime, but the Jomsocial Profile SQL error is still there.

I also get this SQL error when I click on the 'stream' link when being told that a user has replied to one of my status updates.

And the article preview no longer works when entering a link and hitting the enter key.

Hi Andrew,

please check your DB connection setting at joomla configuration.php file. because your site is not working, seem lost DB connection.
please let me know if your site up and running again.

Regards,
Albert

That was a temporary problem earlier this morning due to a crashed table. It's been fixed. The site is working fine right now except for the jomsocial problems with resizing of the status update and the SQL errors.

Hi Andrew,

I cant replicate this issue (the SQL errors) by using Support user. maybe cache issue, please try to clear all joomla cache first. from joomla backend.
let me know the result.

and about resizing of the status update has been fixed.

Regards,
Albert

I can confirm that the resizing problem with the status update has been fixed. Many thanks for that. Is this problem going to come back with the next jomsocial update? Or is it a permanent fix?

The SQL error problem in the jomsocial profile is still happening. I just got that screen when I tried, even after emptying the cashe and refreshing the page.

awesomescreenshot.com/08d3zbdve6

The SQL error is fixed. The problem was a bug in the Jomsocial plugin for EasyDiscuss. Thankyou for your help.