clreed87

Hi Andrew–

Thanks so much for the reply. I enabled wp_debug and was able to recreate the issue–but there are no PHP errors being reported. Thanks again for the help!

This happens to me as well on all 3 sites I run this plugin on. The only way I can access the settings page is by going to the extensions page and then clicking on the general tab.

Thanks for the reply! The problem ended up being that the “from” email address was different than my WordPress admin email and that caused an error. Maybe the from address should be editable if PHP Mail has been selected.

Thanks!

Realized my “from” address was different from my WordPress admin email due to a typo.

Awesome thanks! I’ll upgrade and check it out and let you know what it looks like!

Would installing from the website vs the git repository make a difference? It shouldnt matter as long as I checkout the correct version.

Hmm. I switched to 1.9.6 and did a new install with a new database to make sure I had the correct DB config and I’m still getting the error notices from the plugin. Could there be something else I’m doing wrong?

Ok I’m going to checkout 1.9.6 and see how that works

Ok awesome. Thanks for the help. So I can use 1.9.6 even though the plugin dropdown only shows 1.9.5.1?

Ok I’ll try to switch. I was trying to use the latest version which I assumed would be the develop branch.

I’m using the develop branch from github. In the osTicket settings its listed as 1.8-git (?).

Sorry about not wrapping the PHP notices in code formatting. Anyway above are the errors I get when I set WP_DEBUG=TRUE.

[ Moderator note: Code fixed, please wrap code in backticks or use the code button. ]

Notice: Undefined variable: ost_ticket_status in /home/ezwriter/public_html/ezwriteraddin.com/wp-content/plugins/key4ce-osticket-bridge/includes/database.php on line 28

Notice: Undefined variable: ost_ticket_status in /home/ezwriter/public_html/ezwriteraddin.com/wp-content/plugins/key4ce-osticket-bridge/includes/database.php on line 28

Notice: Undefined variable: ost_ticket_status in /home/ezwriter/public_html/ezwriteraddin.com/wp-content/plugins/key4ce-osticket-bridge/includes/database.php on line 28
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON .id=ost_ticket.status_id WHERE user_id='' and .state='open'' at line 1]
SELECT COUNT(*) FROM ost_ticket INNER JOIN ON .id=ost_ticket.status_id WHERE user_id='' and .state='open'

Notice: Undefined variable: ost_ticket_status in /home/ezwriter/public_html/ezwriteraddin.com/wp-content/plugins/key4ce-osticket-bridge/includes/database.php on line 30

Notice: Undefined variable: ost_ticket_status in /home/ezwriter/public_html/ezwriteraddin.com/wp-content/plugins/key4ce-osticket-bridge/includes/database.php on line 30

Notice: Undefined variable: ost_ticket_status in /home/ezwriter/public_html/ezwriteraddin.com/wp-content/plugins/key4ce-osticket-bridge/includes/database.php on line 30
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON .id=ost_ticket.status_id WHERE user_id='' and .state='open'' at line 1]
SELECT COUNT(*) FROM ost_ticket INNER JOIN ON .id=ost_ticket.status_id WHERE user_id='' and .state='open'

Notice: Undefined variable: ost_ticket_status in /home/ezwriter/public_html/ezwriteraddin.com/wp-content/plugins/key4ce-osticket-bridge/includes/database.php on line 31

Notice: Undefined variable: ost_ticket_status in /home/ezwriter/public_html/ezwriteraddin.com/wp-content/plugins/key4ce-osticket-bridge/includes/database.php on line 31

Notice: Undefined variable: ost_ticket_status in /home/ezwriter/public_html/ezwriteraddin.com/wp-content/plugins/key4ce-osticket-bridge/includes/database.php on line 31
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'ON .id=ost_ticket.status_id WHERE user_id='' and .state='closed'' at line 1]
SELECT COUNT(*) FROM ost_ticket INNER JOIN ON .id=ost_ticket.status_id WHERE user_id='' and .state='closed'

Notice: Undefined variable: ost_ticket_status in /home/ezwriter/public_html/ezwriteraddin.com/wp-content/plugins/key4ce-osticket-bridge/includes/database.php on line 43

Notice: Undefined variable: ost_ticket_status in /home/ezwriter/public_html/ezwriteraddin.com/wp-content/plugins/key4ce-osticket-bridge/includes/database.php on line 43

Notice: Undefined variable: ost_ticket_status in /home/ezwriter/public_html/ezwriteraddin.com/wp-content/plugins/key4ce-osticket-bridge/includes/database.php on line 43

Notice: Undefined variable: ticket in /home/ezwriter/public_html/ezwriteraddin.com/wp-content/plugins/key4ce-osticket-bridge/includes/database.php on line 43
WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'as status,ost_ticket.number,ost_ticket.created,ost_ticket.ticket_id,ost_ticket.i' at line 1]
SELECT ost_ticket.user_id,.state as status,ost_ticket.number,ost_ticket.created,ost_ticket.ticket_id,ost_ticket.isanswered,ost_user.name,ost_department.dept_name,ost_ticket__cdata.priority,ost_ticket__cdata.subject,ost_user_email.address FROM ost_ticket INNER JOIN ost_department ON ost_department.dept_id=ost_ticket.dept_id INNER JOIN ost_user ON ost_user.id=ost_ticket.user_id INNER JOIN ON .id=ost_ticket.status_id INNER JOIN ost_user_email ON ost_user_email.user_id=ost_ticket.user_id LEFT JOIN ost_ticket__cdata on ost_ticket__cdata.ticket_id = ost_ticket.ticket_id WHERE 'number' =''

Notice: Undefined variable: ticket in /home/ezwriter/public_html/ezwriteraddin.com/wp-content/plugins/key4ce-osticket-bridge/includes/database.php on line 57

I don’t have any caching plugins enabled currently.

Thanks! Emailed yesterday and the team got it taken care of very quickly. Keep up the good work!