Captcha

Hello,

if the captcha doesn’t work i assume your page caching gets in the way of it.
try and exclude the page from being cached and the captcha should work just fine :-).

Regards,
Marco

I don’t have any caching plugins enabled currently.

That sounds odd, as the captcha runs just fine code wise.

do you have other plugins loaded with custom captcha’s? (something that overwrites or breaks function).

you can optionally enable WP debug to see the errors behind it.

[ 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

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

what osticket version do you have?
and did you make sure you set the right version in the plugin configuration?

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

yeah their branch is a bit of a mess in github.

but our plugin isn’t compatible with 1.8
just 1.9.3 to 1.9.6
had to drop everything below as the queries got way too different.

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

it is the dev version, unfortunatly the branches they got are a big mess.
so to find the actual 1.9.6 or up is difficult

also keep in mind osticket changes their database queries on nearly every update, so if you want to stay compatible always check if the version is supported by our plugin (which currently is between 1.9.3 and 1.9.6)

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

yeah, there’s no db changes between 1.9.5.1 and 1.9.6 (was surprised about that my self too haha :-))

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

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?

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