Installation issue on 1.8

Hi there,

I went trough the installation guide for 1.8 series for the first time and that when well until i came to the loginscreen.
It says "Unexpected Error, please contact support."

And in the SQL log table there are following error records:

SQLSTATE[23000]: Integrity constraint violation: 1048 Column ‘userId’ cannot be null Exception Type: PDOException
Seems that something maybe failed in the DB deployment?

Any ideas?

I’m sure I’ve seen this before and indeed fixed it, but I cannot for the life of me remember exactly what the problem is/was. I think I will have to ask you to try and get some more logging out (which might be challenging given you cannot login).

Do you have access to the database? If so could you run the following SQL?

UPDATE `setting` SET `value` = 'test' WHERE setting = 'SERVER_MODE';

And then recreate the issue, and then run

SELECT * FROM `log` ORDER BY 1 DESC LIMIT 50;

and paste the results here between ``` ?

Hey,

OK I applied the SQL, and I still get the same errormessage.

SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'userId' cannot be null Exception Type: PDOException

I was rather hoping there would be another set of messages in there - debug messages rather than errors.

Can you try this SQL please?

UPDATE `setting` SET `value` = '1' WHERE setting = 'DEFAULTS_IMPORTED';