Joomla Templates Club 406,261 posts

[ntonline Friend ntonlineJoin date: January 2009Posts: 164Downloads:31Uploads:42 Thanks: 24 Thanked: 12 times in 1 posts]

#661677

Hello,

After installing JA Social II I encountered a MySQL error while adding contacts and categories in the contact manager. I thought it was an issue caused by a bad installation so I downloaded a new quickstart file and installed it a second time. Again I ran into the same issue while adding contacts and categories in the contact manager. Here is the error I keep encountering:

<blockquote>Error
Save failed with the following 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 ‘AND `sha1_hash` = ’57f52337cea5b047925b7a25e118261fd963efea’ LIMIT 0, 1′ at line 3 SQL=SELECT * FROM `dxz5f_ucm_history` WHERE `ucm_item_id` = 2 AND `ucm_type_id` = AND `sha1_hash` = ’57f52337cea5b047925b7a25e118261fd963efea’ LIMIT 0, 1</blockquote>

I’m not very good with MySQL and would appreciate some help resolving this issue.

Thanks,

ntonline

[Pankaj Sharma Moderator Pankaj SharmaJoin date: February 2015Posts: 24589Downloads:144Uploads:202 Thanks: 127 Thanked: 4196 times in 4019 posts]

#661720

Please
Provide your PHP version, your SQL version and database collation so I can check it .

[ntonline Friend ntonlineJoin date: January 2009Posts: 164Downloads:31Uploads:42 Thanks: 24 Thanked: 12 times in 1 posts]

#661853

<em>@pankajsharma 487467 wrote:</em><blockquote>Please
Provide your PHP version, your SQL version and database collation so I can check it .</blockquote>

System Information
Setting Value

PHP Built On Linux serv01.siteground282.com 2.6.32.59-sg3 #9 SMP Wed Sep 26 03:29:25 CDT 2012 x86_64
Database Version 5.5.44-37.3-log
Database Collation utf8_general_ci
PHP Version 5.3.29
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.4.3 Stable [ Ember ] 2-July-2015 16:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.155 Safari/537.36

[ntonline Friend ntonlineJoin date: January 2009Posts: 164Downloads:31Uploads:42 Thanks: 24 Thanked: 12 times in 1 posts]

#745521

<em>@pankajsharma 487467 wrote:</em><blockquote>Please
Provide your PHP version, your SQL version and database collation so I can check it .</blockquote>

System Information
Setting Value

PHP Built On Linux serv01.siteground282.com 2.6.32.59-sg3 #9 SMP Wed Sep 26 03:29:25 CDT 2012 x86_64
Database Version 5.5.44-37.3-log
Database Collation utf8_general_ci
PHP Version 5.3.29
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.4.3 Stable [ Ember ] 2-July-2015 16:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.155 Safari/537.36

[ntonline Friend ntonlineJoin date: January 2009Posts: 164Downloads:31Uploads:42 Thanks: 24 Thanked: 12 times in 1 posts]

#662231

@pankajsharma
<blockquote>Please
Provide your PHP version, your SQL version and database collation so I can check it .</blockquote>

System Information
Setting Value

PHP Built On Linux serv01.siteground282.com 2.6.32.59-sg3 #9 SMP Wed Sep 26 03:29:25 CDT 2012 x86_64
Database Version 5.5.44-37.3-log
Database Collation utf8_general_ci
PHP Version 5.3.29
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.4.3 Stable [ Ember ] 2-July-2015 16:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.155 Safari/537.36

Thanks for the help.

[ntonline Friend ntonlineJoin date: January 2009Posts: 164Downloads:31Uploads:42 Thanks: 24 Thanked: 12 times in 1 posts]

#745574

@pankajsharma
<blockquote>Please
Provide your PHP version, your SQL version and database collation so I can check it .</blockquote>

System Information
Setting Value

PHP Built On Linux serv01.siteground282.com 2.6.32.59-sg3 #9 SMP Wed Sep 26 03:29:25 CDT 2012 x86_64
Database Version 5.5.44-37.3-log
Database Collation utf8_general_ci
PHP Version 5.3.29
Web Server Apache
WebServer to PHP Interface cgi-fcgi
Joomla! Version Joomla! 3.4.3 Stable [ Ember ] 2-July-2015 16:00 GMT
Joomla! Platform Version Joomla Platform 13.1.0 Stable [ Curiosity ] 24-Apr-2013 00:00 GMT
User Agent Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/44.0.2403.155 Safari/537.36

Thanks for the help.

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#662249

Hi there
This issue already addressed in many tickets. It’s all about MySQL collation .
Please set it to UTF-8.

If you can work on it. I can help you by install quickstart in my localhost and provide your dumped sql & zipped source.

But it’s bad practice way.

And one more thing. You should upgrade your PHP to 5.5 or higher. 5.3 already EOL.

Thank you,
Viet Vu

[jooservices Friend jooservicesJoin date: October 2014Posts: 8556Downloads:0Uploads:130 Thanked: 1245 times in 1121 posts]

#745592

Hi there
This issue already addressed in many tickets. It’s all about MySQL collation .
Please set it to UTF-8.

If you can work on it. I can help you by install quickstart in my localhost and provide your dumped sql & zipped source.

But it’s bad practice way.

And one more thing. You should upgrade your PHP to 5.5 or higher. 5.3 already EOL.

Thank you,
Viet Vu

[Author]

Posts