Stuck in Offline Mode

I am getting the same. Seems like it’s not posting the data to the form or pulling it. ??

https://pixori.al/MgWr

Hello,
In the osT-Config tab does it hold the setting for your version of osTicket 1.7+ or 1.8.1

Regards,
Michael B

Yes, my database settings stay there. I even tried to put in the wrong information and the plugin gave me an error. The problem is, at this point, is the settings tab. Everything gets wiped out and set back to offline mode.

I am having the same problem.

WordPress 3.8.1
OSTicket 1.8.1
osTicket-WPbridge 1.9.2

OST-settings tab reverts to blank form fields after the save is complete, and OSTicket remains in offline-mode. No other issues noted.

the OST-setting tab is correctly displaying: *System Settings For osTicket ? v1.8.1

I am also having the same issue running WordPress 3.8.1, OSTicket 1.8.1, and a fresh install of thins plugin. When putting in 1.7 for OSTicket version this warning appears in the Settings tab as it should. Warning: mysql_num_rows() expects parameter 1 to be resource, boolean given in /home/bouimette/public_html/wp-content/plugins/osticket-wp-bridge/admin/db-settings-17.php on line 140

When using 1.8.1 there are no warnings in the Settings tab. You can enter all the information you want into the fields but trying to change from offline to online and hitting save changes forces it back offline. I have verified to make sure all settings I have entered are correct to my installation.

Same here. Doesn’t save the settings, can’t get it out of offline.

Any update on this, Michael?

Hello Everyone!

I had the same symptoms today. (1st try with the plugin).
The answer seems simple. The plugin has a hard-coded DB prefix of ost_ (assuming the default installation of osticket. Most auto installers will create or offer a different prefix for the tables.

FIX:
1) look at your installation (either PhpMyAdmin or the config of osTicket) and find your table prefix.
2) open /wp-content/plugins/osticket-wp-bridge/admin/db-setting-18.php

3) EDIT the following block

~
$config = get_option(‘os_ticket_config’);
extract($config);
$ost_wpdb = new wpdb($username, $password, $database, $host);
global $ost;
$config_table= “CHANGE: ost_ _config”;
$dept_table= “CHANGE: ost_ _department”;
$topic_table= “CHANGE: ost_ _help_topic”;
$email_temp_table= “CHANGE: ost_ _email_template”;
$ticket_table= “CHANGE: ost_ _ticket”;
$ticket_event_table= “CHANGE: ost_ _ticket_event”;
$thread_table= “CHANGE: ost_ _ticket_thread”;
$priority_table= “CHANGE: ost_ _ticket_priority”;
$ticket_cdata= “CHANGE: ost_ _ticket__cdata”;
$staff_table= “CHANGE: ost_ _staff”;
$ost_user= “CHANGE: ost_ _user”;
$ost_useremail= “CHANGE: ost_ _user_email”;
$directory=$config[‘supportpage’];
$dirname = strtolower($directory);
$version=$config[‘version’];
$category=@$_GET[‘cat’];
$status_opt=@$_GET[‘status’];
$ticket=@$_GET[‘ticket’];
~

Off course a permanent fix would be to add a variable for the prefix … ??
I am still looking to solve the “offline” page problem.
Seems the developer is “off-line” (his Hostgator expired …)
Anyone else needs this fixed?

Greets!

I have added the prefix option to the files (files available if needed).

The result is data in the settings is saved successfully (including status) and corresponds with osTicket. WP backend replies are sent just fine.

However, the front-end page for supportpage always opens in offline-mode.
Anyone have other suggestions …?

Out of the off-line mode – running ok.
The modifications are needed in more than one location. So, message here if you need it …

Anyone interested to review/streamline this plugin?
Anyone still using it?
Happy to hear …

Hey Emstatay,
Been very busy so I haven’t had the chance to write back until now. I am still interested in using this plug-in, provided it isn’t broken and it works like it should. Is what you listed above the complete fix for getting rid of the offline page?

Emstatay,
I got the plugin to stay out of offline mode and I can see the tickets from the osTicket window in the admin panel.

What did you do to get the front-end to work?