SocialEngine 4: Mysqli Session Error

After installing SocialEngine 4 (4.8.6) on a Mac mini running Mavericks Server 3 and PHP 5.4.27, SocialEngine pukes with an error:

1 exception 'Zend_Db_Statement_Mysqli_Exception' with message 'Mysqli statement execute error : Duplicate entry

Read on for a solution!

The cause is two-fold:

1) SocialEngine expects a 32-character hash such as supplied by MD5;

2) PHP in Mavericks Server 3 uses SHA-512 as the default, generating 128 characters.

I’ve encouraged SocialEngine to support the vastly more secure SHA-512 hashing.

Until then, here’s the fix:

in /Library/Server/Web/Config/php/php.ini, comment out this line with a semi-colon:

1 session.hash_function = sha512

When testing this solution, make sure you delete the session ID in engine4_core_session in your database, AND delete the cookies for the domain from your browser.

Looking for quality SocialEngine Hosting? Look no further than Arvixe Web Hosting!

Tags: , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , | Posted under SocialEngine | RSS 2.0

Author Spotlight

Andrew Cross

Andrew Cross

Hi, I'm Andrew. A am a 26, ICT Administrator which offers support to company's around the South Wales Area. I have created a few social sites for myself and other company's. So far 2 out of 3 have been successful using the powerful SocialEngine Script. I continue to try and help the community of SocialEngine by giving Support and Technical Help where possible.

Leave a Reply

Your email address will not be published. Required fields are marked *

6 × = 36

You may use these HTML tags and attributes: <a href="" title="" rel=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>