CMS MADE SIMPLE FORGE

CGClientTickets

 
Back Back to List

[#10371] Tables not installed

avatar
Created By: Mathieu Muths (airelibre) (airelibre)
Date Submitted: Mon Jan 19 02:59:23 -0500 2015

Assigned To: Robert Campbell (calguy1000)
Version: 1.0.1
CMSMS Version: 2.0-beta3
Severity: Critical
Resolution: Fixed
State: Open
Summary:
Tables not installed
Detailed Description:
Hi Robert,

When installing, the DB tables are not set (nothing in the db) - tried to
uninstall / reinstall but doesn't work

Hope this will help


History

Comments
avatar 
Date: 2015-03-10 12:33
Posted By: Mathias (math)

Same issue for me too
avatar 
Date: 2015-05-05 21:36
Posted By: Robert Campbell (calguy1000)

fixed and released
avatar 
Date: 2015-06-02 03:43
Posted By: Mathias (math)

Hello

I upgraded to version 1.1.4 but it didn't fixe the issue. 

Module admin page:

Tickets
Settings
My Tickets List Templates
Manage Tickets List Templates
New Ticket Form Templates
View Ticket Report Templates
Prototype Templates
SELECT SQL_CALC_FOUND_ROWS T.id, T.owner, T.alert_group, T.e_key1, T.e_key2,
T.e_key3, T.status, T.priority, T.created, COUNT(M.id) AS nmsgs, M.subject,
MAX(M.modified) AS modified_date, S.n_unread FROM cms_mod_cgct_tickets T LEFT
JOIN cms_mod_cgct_msgs M ON T.id = M.ticket_id LEFT JOIN (SELECT
ticket_id,COUNT(id) AS n_unread FROM cms_mod_cgct_msgs WHERE dest < 0 AND
viewed_by IS NULL GROUP BY ticket_id) S ON T.id = S.ticket_id GROUP BY T.id
ORDER BY modified_date DESC LIMIT 0, 100 Table 'CMSMS_2015.cms_mod_cgct_tickets'
doesn't exist

King regards
avatar 
Date: 2015-06-03 13:36
Posted By: Robert Campbell (calguy1000)

Just did a test install on a brand new CMSMS install.  tables installed fine.  
They use InnoDB  and foreign key relations.  maybe there is a problem there.

I am using a stock ubuntu 14.04 install virtual machine.   No modifications
(other than some more php plugins installed like xdebug).
avatar 
Date: 2016-05-25 11:14
Posted By: Mathias (math)

I tried again but always the same issue.
avatar 
Date: 2016-06-08 07:27
Posted By: Jurrie Overgoor (jurrie)

There are a couple of bugs in method.install.php.
avatar 
Date: 2016-06-08 07:29
Posted By: Jurrie Overgoor (jurrie)

(Continued from last post)

You'll need to change line 45 to
$taboptarray = array('mysql' => 'ENGINE=InnoDB');

and you'll need to change line 116 to
    audit('',$this->GetName(),'Install: '.$e->getMessage());

Below is the complete patch (generated by Netbeans):

--- a/<html>method.install.php (<b>Today 11:50:47 AM</b>)</html>
+++ b/<html><b>Current File</b></html>
@@ -42,7 +42,7 @@
 
 $db = cge_utils::get_db();
 $dict = NewDataDictionary($db);
-$taboptarray = array('mysql' => 'TYPE=InnoDB');
+$taboptarray = array('mysql' => 'ENGINE=InnoDB');
 
 try {
     $flds = "
@@ -113,7 +113,7 @@
     $this->CreateEvent(CGClientTickets::EVENT_DELETETICKET);
 }
 catch( \Exception $e ) {
-    audit('',$this->GetName(),'Install: '.$e->GetMessage);
\ No newline at end of file
+    audit('',$this->GetName(),'Install: '.$e->getMessage());
\ No newline at end of file
     return FALSE;
 }
Updates

Updated: 2015-05-05 21:36
resolution_id: => 7