This forum has moved to a new location and is in read-only mode. Please visit talk.octobercms.com to access the new location.

tja51110977
tja51110977

Hi guys, I'm new to OctoberCMS (and laravel in general). I've got my theme generally up and running and I'm accessing the backend fine. However, whenever I try to use an account related function (e.g. 'My Account' on the dashboard). I get an error like this:

SQLSTATE[42000]: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near the keyword 'from'. (SQL: select * from [system_files] where ([system_files].[attachment_id] = 1 and [system_files].[attachment_id] is not null and [system_files].[attachment_type] = Backend\Models\User and [field] = avatar or exists (from [deferred_bindings] where slave_id = system_files.id and [master_field] = avatar and [master_type] = Backend\Models\User and [session_key] = cWp44X2eZboGrXRM51YDoZS6MchcNHtCmcpq4uV6 and [is_bind] = 1)) and not exists (from [deferred_bindings] where slave_id = system_files.id and [master_field] = avatar and [master_type] = Backend\Models\User and [session_key] = cWp44X2eZboGrXRM51YDoZS6MchcNHtCmcpq4uV6 and [is_bind] = 0 and id > ifnull((select max(id) from deferred_bindings where slave_id = system_files.id and master_field = avatar and master_type = Backend\Models\User and session_key = cWp44X2eZboGrXRM51YDoZS6MchcNHtCmcpq4uV6 and is_bind = 1 ), 0)) order by [sort_order] asc)

from vendor\laravel\framework\src\Illuminate\Database\Connection.php line 624

My SQL connection seems to be fine, does anyone have an ideas?

1-1 of 1

You cannot edit posts or make replies: the forum has moved to talk.octobercms.com.