-
Notifications
You must be signed in to change notification settings - Fork 2
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Issue Installing #2
Comments
Looks like you have not gone to the plug-in section of osTicket and installed it. Kind Regards Robin Toy Sent from my Windows Phone From: derekjohnsonzethconmailto:notifications@github.com When installing it creates a whole bunch of text above my pages. See attached. — Robin Toy Making IT Possible for: Business, Health & Life! [Follow Us via LinkedIn Logo]http://www.linkedin.com/company/strobe-it/ [Follows Us via Twitter Logo] https://twitter.com/StrobeIT/ [Follow Us via Google+ Logo] https://plus.google.com/b/100491222414369340300/100491222414369340300/ [Follow Us via Spiceworks Logo] http://community.spiceworks.com/service-providers/25927-strobe-technologies-ltd Please consider the environment before printing this E-mail Strobe IT is the trading name of Strobe Technologies Ltd. Company registration No. 8031223. Registered in England. 1 Emperor Way, Exeter Business Park, Exeter, Devon EX1 3QS Disclaimer Confidentiality Notice |
ronintoy, This is what happens when I install it. Just FYI I am running osTicket version 1.9.11 |
Mmmm ok, Been awhile since I have done an install as all worked lol. Will have to look at getting test system up Kind Regards Robin Toy Sent from my Windows Phone From: derekjohnsonzethconmailto:notifications@github.com ronintoy, This is what happens when I install it. — Robin Toy Making IT Possible for: Business, Health & Life! [Follow Us via LinkedIn Logo]http://www.linkedin.com/company/strobe-it/ [Follows Us via Twitter Logo] https://twitter.com/StrobeIT/ [Follow Us via Google+ Logo] https://plus.google.com/b/100491222414369340300/100491222414369340300/ [Follow Us via Spiceworks Logo] http://community.spiceworks.com/service-providers/25927-strobe-technologies-ltd Please consider the environment before printing this E-mail Strobe IT is the trading name of Strobe Technologies Ltd. Company registration No. 8031223. Registered in England. 1 Emperor Way, Exeter Business Park, Exeter, Devon EX1 3QS Disclaimer Confidentiality Notice |
Robin, If you like i can get you access to my system. We can use teamviewer if you can |
Hi Derek, That would be great but not sure I can do that today as have friends come round soon to which I better do something for. The screenshot you have sent looks like the main screen after installation indeed, but is displaying code not the page which is odd. So the osTicket plugin installer didn't display any errors and shows as version 0.1.6 or greater? Kind Regards Robin Toy Sent from my Windows Phone From: derekjohnsonzethconmailto:notifications@github.com Robin, If you like i can get you access to my system. We can use teamviewer if you Derek Johnson Director of Technical Infrastructure Google Voice: (331) 551-9098 Primary Email: derek.johnson@zethcon.com Secondary Email: djohnson@tekguys.net Website: http://www.Zethcon.com/ http://www.zethcon.com/ Find me on: LinkedIn https://www.linkedin.com/in/dajmlp812 On Sat, Aug 15, 2015 at 8:36 AM, Robin Toy notifications@github.com wrote:
— Robin Toy Making IT Possible for: Business, Health & Life! [Follow Us via LinkedIn Logo]http://www.linkedin.com/company/strobe-it/ [Follows Us via Twitter Logo] https://twitter.com/StrobeIT/ [Follow Us via Google+ Logo] https://plus.google.com/b/100491222414369340300/100491222414369340300/ [Follow Us via Spiceworks Logo] http://community.spiceworks.com/service-providers/25927-strobe-technologies-ltd Please consider the environment before printing this E-mail Strobe IT is the trading name of Strobe Technologies Ltd. Company registration No. 8031223. Registered in England. 1 Emperor Way, Exeter Business Park, Exeter, Devon EX1 3QS Disclaimer Confidentiality Notice |
i am having the same problem with the install . Also running the latest version 1.9.11 |
Hi Guys, found an issue with the installation SQL which I have now updated and will be on here shortly. |
This update solves a simple typo in the SQL installation command that stops the data base being created causing many more errors.
still ran into the error |
tried running the code directly in the database and produced errors. |
This is written in SQL with a few changes to the code to be osTicket compliant. Change the $ symbol at end of lines to a ; for MySQL Kind Regards Robin Toy Sent from my Windows Phone From: yisrael1981mailto:notifications@github.com tried running the code directly in the database and produced errors. — Robin Toy Making IT Possible for: Business, Health & Life! [Follow Us via LinkedIn Logo]http://www.linkedin.com/company/strobe-it/ [Follows Us via Twitter Logo] https://twitter.com/StrobeIT/ [Follow Us via Google+ Logo] https://plus.google.com/b/100491222414369340300/100491222414369340300/ [Follow Us via Spiceworks Logo] http://community.spiceworks.com/service-providers/25927-strobe-technologies-ltd Please consider the environment before printing this E-mail Strobe IT is the trading name of Strobe Technologies Ltd. Company registration No. 8031223. Registered in England. 1 Emperor Way, Exeter Business Park, Exeter, Devon EX1 3QS Disclaimer Confidentiality Notice |
Hi @derekjohnsonzethcon & @yisrael1981 |
I'll test it in a bit. |
I did get a chance to try to install it earlier and came across the same issue that I was getting with the code on the page. Below is additional information that I recieved [DELETE FROM ost_ticket_lock WHERE expire<NOW()] You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column |
Hi @derekjohnsonzethcon So odd why you getting those errors, none of the plugin uses that code as it all part of osTicket classes built in to the system. I have just added a commit to the develop branch which disables all the SQL install and uninstall from within osTicket, along with cleaning up some other lines of the plugin setup. It's working like a dream here which is so odd. Can I ask you create the DB tables manually using the following code and try it again? CREATE TABLE IF NOT EXISTS `ost_checklist` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`orde` int(11) NOT NULL,
`menu_id` int(11) NOT NULL default '0',
`indent` int(11) NOT NULL default '0',
`header` int(11) NOT NULL default '0',
`period` int(11) NOT NULL default '0',
`tekst` varchar(250) default NULL,
`disabled` int(11) NOT NULL default '0',
`start` date NOT NULL,
`help` text NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
KEY `orde` (`orde`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
CREATE TABLE IF NOT EXISTS `ost_checklist_entries` (
`id` bigint(20) unsigned NOT NULL auto_increment,
`datum` datetime default NULL,
`door` varchar(30) default NULL,
`ref` int(11) default NULL,
`tekst` text,
`status` int(11) NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
KEY `datum` (`datum`),
KEY `ref` (`ref`),
FULLTEXT KEY `tekst` (`tekst`),
FULLTEXT KEY `volletekst` (`tekst`,`door`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; |
@robintoy |
Hi @Dorian-Grim |
1.9.14 |
very odd indeed.... Is this mod something that would be of interest or help to you? |
Yes, it would... |
When installing it creates a whole bunch of text above my pages. See attached.
The text was updated successfully, but these errors were encountered: