Upon trying to generate a report i receive this error.

Unknown column 'myevents.state' in 'field list' 
---- Backtrace ---- 
#0 D:\xampp\htdocs\osticket\include\mysqli.php(199): osTicket->logDBError('DB Error #1054', '[SELECT \n\t\t m...') 
#1 D:\xampp\htdocs\osticket\include\plugins\REPORTS\class.report.php(710): db_query('SELECT \n\t\t my...') 
#2 D:\xampp\htdocs\osticket\include\plugins\REPORTS\class.report.php(1085): Report->get_report() 
#3 D:\xampp\htdocs\osticket\scp\reports.php(67): Report->create_report('csv') 
#4 {main}

This is the full email i receive on error..

[SELECT
myevents.id as event_id,
users.id as user_id,
users.name,
address,
staff.firstname,
staff.lastname,
staff.staff_id,
tickets.ticket_id,
teams.team_id,
teams.name as team,
depts.name as dept_name,
depts.id as dept_id,
tickets.topic_id,
help_topics.topic,
myevents.timestamp,
MONTH(myevents.timestamp) as month,
DAY(myevents.timestamp) as day,
YEAR(myevents.timestamp) as year,
concat(MONTH(myevents.timestamp), '-', YEAR(myevents.timestamp)) as monthYear,
concat(DAY(myevents.timestamp), '-', MONTH(myevents.timestamp), '-', YEAR(myevents.timestamp)) as dayMonthYear,
UNIX_TIMESTAMP(myevents.timestamp) as epoch,
orgs.name as orgname,
orgs.id as org_id,
myevents.state,
myevents.data,
tickets.created,
tickets.closed
FROM ost_thread_event myevents
LEFT JOIN ost_thread threads
ON myevents.thread_id=threads.id
LEFT JOIN ost_ticket tickets
ON threads.object_id=tickets.ticket_id
LEFT JOIN ost_user users
ON users.id=tickets.user_id
LEFT JOIN ost_user_email uemails
ON users.id=uemails.user_id
LEFT JOIN ost_help_topic help_topics
ON tickets.topic_id=help_topics.topic_id
LEFT JOIN ost_team teams
ON tickets.team_id=teams.team_id
LEFT JOIN ost_department depts
ON tickets.dept_id=depts.id
LEFT JOIN ost_organization orgs
ON users.org_id=orgs.id
LEFT JOIN ost_staff staff
ON myevents.staff_id=staff.staff_id WHERE timestamp >=
DATE_ADD(CURDATE(), INTERVAL -30 DAY) AND threads.object_type="T" AND state IN ("created","assigned","closed","overdue","reopened") ORDER BY tickets.topic_id]

I tried to attach a notepad file but forum wont let me of System information.. listed below

Server Information
osTicket Version v1.12 (a076918) — Up to date
Web Server Software Apache/2.4.33 (Win32) OpenSSL/1.1.0h PHP/7.2.5
MySQL Version 10.1.32
PHP Version 7.2.5
PHP Extensions
gdlib Used for image manipulation and PDF printing
imap Used for email fetching
xml XML API
xml-dom Used for HTML email processing
json Improves performance creating and processing JSON
mbstring Highly recommended for non western european language content
phar Highly recommended for plugins and language packs
intl Highly recommended for non western european language content
fileinfo Used to detect file types for uploads
APCu Improves overall performance
Zend Opcache Improves overall performance
PHP Settings
cgi.fix_pathinfo "1" is recommended if AJAX is not working
date.timezone Europe/Berlin
Database Information and Usage
Schema osticket (localhost)
Schema Signature 00c949a623b82848baaf3480b51307e3
Space Used 3.39 MiB
Space for Attachments 0.27 MiB
Timezone Eastern Daylight Time (Interpreted as America/New_York)

Installed Language Packs
English - US (English)
en_US — include/i18n/en_US