ntozier I figured out why I couldn't log into PHPMyAdmin, it was a user error on my part... 🙂
However, I do not see an ost_ticket__cdata table.
EDIT: I'm blind and dumb today apparently...
`-- phpMyAdmin SQL Dump
-- version 4.9.2
-- Host: localhost
-- Generation Time: May 14, 2020 at 12:47 PM
-- Server version: 10.3.21-MariaDB
-- PHP Version: 5.6.40
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT /;
/!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS /;
/!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION /;
/!40101 SET NAMES utf8mb4 */;
--
-- Database: trentontech_ost
--
-- Table structure for table ost_ticket__cdata
CREATE TABLE ost_ticket__cdata (
ticket_id int(11) UNSIGNED NOT NULL,
subject mediumtext DEFAULT NULL,
priority mediumtext DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
--
-- Dumping data for table ost_ticket__cdata
INSERT INTO ost_ticket__cdata (ticket_id, subject, priority) VALUES
(1, 'osTicket Installed!', '2'),
(2, 'Problems', '3'),
(3, 'slow computer', '2'),
(4, 'Lost Data', '3'),
(5, 'cmos', '2'),
(6, 'Work station locked up', '2'),
(7, 'Extremely Slow Machine', '2'),
(8, 'Computer ', '3'),
(9, 'Certain disks won\'t open on my computer.', '2'),
(10, 'Machine so slow, pratically non-functional', '2'),
(11, 'Computer is running very slow', '2'),
(12, 'Program keeps shutting down', '2'),
(13, 'Office issue', '3'),
(15, 'Computer is not responsive, extremely slow. ', '2'),
(16, 'Testing Something', '1'),
(17, 'Cannot Print Order Sheet', '2'),
(18, 'Cannot print box label', '2'),
(19, 'Cannot print to color printer', '2'),
(20, 'Boxing and Linking', '2'),
(21, 'Zebra ZD410 Printers on Windows 10', '2'),
(22, 'Cannot scan bar code to get a duplicate label', '2'),
(25, ' Printer hooked up', '2'),
(26, 'Printer Sharing', '2'),
(27, 'Order Picking', '2'),
(28, 'Need Programs installed on 2 stations', '2'),
(29, 'Station Re-setting', '2'),
(30, 'Need programs installed', '2'),
(31, 'User email', '2'),
(32, 'Word/Excel', '2'),
(33, 'Scanning Gun', '2'),
(34, 'New hire Jessica Magnino Ursys only', '2'),
(35, 'Test Ticket', '3'),
(36, 'Test Ticket', '2'),
(37, 'Brent\'s Software', '2'),
(38, 'test', '2'),
(39, 'UrSys', '2'),
(40, 'Last Ticket Maybe', '2'),
(41, 'Guess who', '2'),
(42, 'Knock knock', '2'),
(43, 'Brent', '2'),
(44, 'Brent', '2'),
(45, 'Boxing and Linking', '2'),
(46, 'Can\'t add file to Help Desk', '2'),
(47, 'Test', '2'),
(48, 'issues with cookies ', '1'),
(49, 'New Account Set-up', '1'),
(50, 'Email folder with EOL and Mfg PCN\'s is missing', '3'),
(51, 'EMPLOYEE ENTRANCE PHONE', '1'),
(52, 'Passwords', '3'),
(53, 'Phyllis Computer', '3'),
(54, 'Label printer', '2'),
(55, 'Do not have Microsoft Office', '1'),
(56, 'test', '1'),
(57, 'C&R Program Add', '2'),
(58, 'computer will not sign on', '2'),
(59, 'board view install', '2'),
(61, 'TTData labels bar code', '2'),
(62, 'Computer Running Slow on Windows 10', '1'),
(63, 'Email Not Sending', '3'),
(64, 'email keeps asking for login details ', '3'),
(65, 'Board View', '2'),
(66, 'Cannot open PDF in URSYS', '2'),
(67, 'Borrowed laptop number 12 on 2/19/2020', '1'),
(68, 'PDF Failing to Print', '2'),
(69, 'NEXIM update', '2'),
(70, 'Computer shuts down at midnight', '1'),
(71, 'Account Locked', '3'),
(72, 'Attempting Repairs Windows 10', '2'),
(73, 'label maker', '2'),
(74, 'Cody can\'t access any programs', '3'),
(75, 'Employee entrance phone not working-', '1'),
(76, 'Program unavailable ', '3'),
(77, 'FYI', '1'),
(78, 'Labler Not Resetting', '2'),
(79, 'shipping computer', '3'),
(80, 'Phone System', '1'),
(83, 'Cancel button', '1'),
(84, 'Second monitor', '2'),
(85, 'Test station 8 ', '2'),
(86, 'Phone Issue', '2'),
(87, 'DEAD PHONE', '2'),
(88, 'computer', '2'),
(89, 'box label', '2'),
(90, 'Cody\'s Computer', '3'),
(91, 'Computer doesn\'t turn on.', '2'),
(92, 'Newer computer for the smaller conf room', '2'),
(93, 'iTHX-SD Temp. + Hum. sensor', '2'),
(94, 'New Data Collection User', '2'),
(95, 'printer next to ADC cubicles not printing.', '2'),
(96, 'Font issue', '2'),
(97, 'Lap Le has returned', '2'),
(98, 'Shipping Station 5 Labeler Failure', '2'),
(99, 'Shipping Station 2 Display Failure', '2'),
(100, 'Computer hard failure', '3'),
(101, 'Error Messages', '2'),
(102, 'Trish Computer Update Failure', '2'),
(103, 'Add office to the Laptop Rachael is using-', '2'),
(104, 'Printer collection unit replacement', '2'),
(105, 'Lap Le e-mail', '2'),
(107, 'Inventory boxing labels', '2'),
(108, 'Move Printer', '3'),
(109, 'Liam -PC', '2'),
(110, 'login', '3'),
(111, 'Huckleberry Reports Section Unavailable', '2'),
(112, 'Trenton Phone added thing@domain.com', '1'),
(113, 'Cut printer', '3'),
(114, 'Login in issue', '2'),
(115, 'Computer screen shut down', '2'),
(116, 'Frozen Comp', '3'),
(117, 'Email', '2'),
(118, 'Remote desktop and computer set up-', '1'),
(119, 'tt date drawings', '2'),
(120, 'TTdata drawings', '2'),
(121, 'Printer Access', '2'),
(122, 'Remote Check Deposit', '2'),
(123, 'Software Install and Printer Install', '2'),
(124, 'Small conference room computer-', '3'),
(125, 'Email not working. ', '2'),
(126, 'Phyllis Lust\'s Computer', '2'),
(127, 'printer', '2'),
(128, 'Undeliverable', '1'),
(129, 'PointCentral Printer', '2'),
(130, 'email', '2'),
(131, 'TTdata apd and drawing issues', '2'),
(132, 'Bent Plug', '2'),
(133, 'Critical Machine Won\'t Allow Printing', '2'),
(134, 'PC/B36 Shipping label printer', '1'),
(135, 'Cannot open Excel attachments', '2'),
(136, 'Password/Ursys', '3'),
(137, 'Phyllis Lust\'s Computer Giving Errors', '2'),
(138, 'Remote Desktop', '3'),
(139, 'ursys not on file', '2'),
(140, 'Laptop', '3'),
(141, 'Phones are down', '1'),
(142, 'Box label', '3'),
(143, 'Email Log in', '2'),
(144, 'Josh M Printer', '2'),
(145, 'Email Access Problem', '2'),
(146, 'DataCollection for New Users on Existing Machines', '2'),
(147, 'Sharon Payne', '3'),
(148, 'Data Collection', '3'),
(149, 'Raymond Automated Shipping', '2'),
(150, 'LV comps and network drops', '2'),
(151, 'Unable to Close Purchase Orders', '2'),
(152, 'Box label', '3'),
(153, 'shipping issue', '3'),
(154, 'E-mail-', '2'),
(155, 'Would Like Boxing/Linking', '2'),
(156, 'Reinstall QI Macros ', '2'),
(157, 'Login Needed ', '3'),
(158, 'locked up', '2'),
(159, 'bar code TT data', '2'),
(160, 'Glenbrook X-Ray Computer', '2'),
(161, 'Ginger Hume Login Issues', '2'),
(162, 'New Raymond Test Area Requirements', '1'),
(163, 'New Raymond AutoShipping Program', '1'),
(164, 'Wifi network slow-', '1'),
(165, 'Dell micro desktop/ Remote acccess Michelle Foster', '3'),
(166, 'Windows Will not Boot at Chip Station', '2'),
(167, 'Low Memory Message', '2'),
(168, 'Boxing/Scanning Issue', '2'),
(169, 'Phuc Famolaro', '3'),
(170, 'login', '3'),
(171, 'Locked account', '3'),
(172, 'Line 1 PC', '2'),
(173, 'CMOS Battery Out on Windows 98 Station', '2'),
(174, 'Microdesktop for Joe Hill', '2'),
(175, 'Broken Monitor', '2'),
(176, 'Logmein for Me-', '2'),
(177, 'Phyllis Lust Repeated Error Codes', '2'),
(178, 'Austin Jones computer ', '2'),
(179, 'Frances Forgot Her Password', '2'),
(180, 'Another back up microdesktop-', '2'),
(181, 'Raymond WIN98 test stations', '2'),
(182, 'Ursys', '3'),
(183, 'Database error', '3'),
(184, 'Database is offline for all apps', '3'),
(185, 'Ursys is down', '3'),
(186, 'UrSys & TTDataCollection', '1'),
(187, 'Shipping Computer Will Not Wake Up', '2'),
(188, 'Test Update on Win98 LAN Needs to be Released', '2'),
(189, 'Monitor not working', '2'),
(190, 'TTBoxing&Linking ', '2'),
(191, 'Raymond Shipping Scale Not Connecting', '2'),
(192, 'Setting up Mele area for RMA\'s', '2'),
(193, 'Dave Peterson computer-', '2'),
(194, 'drawing search', '2'),
(195, 'E-mail Setup', '2'),
(197, 'Joe Mazloom-', '3'),
(198, 'Monitor Settings Change Independantly', '2'),
(199, 'PointCentral Box Printer', '2'),
(200, 'TT Boxing & Linking', '2'),
(201, 'RMA Nucleus Cable', '2'),
(202, 'Zebra Printer Error', '2'),
(203, 'Issues Calibrating label printer.', '1'),
(204, 'Update Jordan PC', '2'),
(205, 'UPS upgrade', '2'),
(206, 'Confirmation e-mail setup', '1'),
(207, 'Email Issue', '2'),
(208, '91 boards scanned as 95 boards', '2'),
(209, 'Tom Muraca PW Reset Req', '3'),
(210, 'Login', '3'),
(211, 'Home Seer Boxing and Linking', '1'),
(212, 'Printer', '2'),
(213, 'label', '1'),
(214, 'Windows 98 Test Station Issue', '2'),
(215, 'HP ColorJet 4650 in Raymond Repair Dept Offline', '2'),
(217, 'Label maker', '2'),
(218, 'Lost Information In Computer Transfer', '2'),
(219, 'Com Port', '2'),
(220, 'PC is slow and keeps disconnecting printer', '2'),
(221, 'Ticket Email Replies', '3'),
(222, 'Not responding', '2'),
(223, 'Label maker', '2'),
(224, 'Test', '2'),
(225, 'RMA Box Labeling', '1'),
(226, 'Line 3 Middle Station - SMTUser login', '2'),
(227, 'Hard ware and Soft ware', '2'),
(228, 'TT Data', '2'),
(229, 'osTicket Upgraded!', '2'),
(230, 'Scanner Requests', '2'),
(231, 'DataCollection', '2'),
(232, 'Label printer install at for Leslie and Nina', '2'),
(233, 'New person starting Monday 5/18', '1'),
(234, 'E-mail-', '2');
--
-- Indexes for dumped tables
--
-- Indexes for table ost_ticket__cdata
ALTER TABLE ost_ticket__cdata
ADD PRIMARY KEY (ticket_id);
COMMIT;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
`
KevinTheJedi
I'll look into this, thank you!
