Problems with fresh install

Hello,

Think you already got this msg from the other forum topic but figured best to write it here too:
version 1.2.5 has been released with osticket 1.9.4 support.
just make sure you select version 1.9.4 from the config page and it should be good to go ??

Regards,
Marco

Hi Marco,

I have downloaded and installed the plugin again, but during the installation and the plugin, as well that when puting the database information, I got many errors. I also see the interfice quite strange.

Errors:

Warning: extract() expects parameter 1 to be array, boolean given in /wp-content/plugins/key4ce-osticket-bridge/ost-bridge.php on line 98

Warning: extract() expects parameter 1 to be array, boolean given in /wp-content/plugins/key4ce-osticket-bridge/ost-bridge.php on line 109

Warning: extract() expects parameter 1 to be array, boolean given in /wp-content/plugins/key4ce-osticket-bridge/admin/ost-config.php on line 96

WordPress database error: [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ”ost_ticket__cdata'( ticket_id int(11) unsigned NOT NULL DEFAULT ‘0’, subj’ at line 1]
CREATE TABLE IF NOT EXISTS ‘ost_ticket__cdata'( ticket_id int(11) unsigned NOT NULL DEFAULT ‘0’, subject mediumtext, priority mediumtext, priority_id bigint(20) DEFAULT NULL, PRIMARY KEY (ticket_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;

WordPress database error: [Unknown column ‘priority_id’ in ‘field list’]
INSERT INTO ost_ticket__cdata (ticket_id,subject,priority,priority_id) VALUES (‘1’, ‘osTicket Installed!’, ‘Normal’, ‘2’)

I have checked the option of 1.9.4 or above, which is my OST installation.

The first two errors appeared during the installation, before I was able to put any information.

Thanks for your help!

Hello,

First 2 can be ignored, (will make a small patch for that shortly) basically happens as the plugin becomes active without mysql database settings being present in the settings.

the query error i have to investigate, it seems like osticket dropped some entire tables causing this (we tested with an upgraded osticket instead).

Regards,
Marco

Quick question: what mysql version do you have?

as “You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near…” seems bit out of place.

Regards,
Marco

Hi Marco,

MySQL Version:5.5.35-0ubuntu0.12.04.2

No other issues detected before. It′s a zpanel installation I gave u access once time ago.

Regards,
Ruben

Sorry for the delay on answering.
We have indeed found that it was an issue with a fresh osticket installation.
fixes to address those issues have been made in todays release of 1.2.6.

Regards,
Marco

Marco,

Great, as always! This version works fine !!!!

THANK YOU !!! BEDANKT !!! XIEXIE!!!

first install of this product
using ampps then auto install 1.9.4
is that all ok or is there an issue with that version?

I am at the setting up email stage so dont want to spend a day setting up the email only to find the version is wrong ??

Hello,

since the 1.2.6 update a fresh 1.9.4 is now supported.
so it will work.

Regards,
Marco