It looks like you're new here. If you want to get involved, click one of these buttons!
[DELETE FROM ost_session WHERE session_id='lmm737725nheracle5v4960rj5']
Table 'helpdesk.ost_session' doesn't exist
After clicking upgrade, I receive the below DB errors, and the web page stops on a "Page could not be loaded" screen.
[SELECT team_id FROM ost_team_member WHERE staff_id=2]
Table 'helpdesk.ost_team_member' doesn't exist
[SELECT dept_id FROM ost_group_dept_access WHERE group_id=1]
Table 'helpdesk.ost_group_dept_access' doesn't exist
I attempted to add the tables manually using the scripts from the install-mysql.php file and suggestions from the forum. When the tables are manually entered, the upgrade appears to proceed; however, it eventually fails with the following message:
* Move dept_access from group table to group_dept_access table.
* @version 1.7-rc1 Dept_Access
CREATE TABLE `ost_group_dept_access` (
`group_id` int(10) unsigned NOT NULL default '0',
`dept_id` int(10) unsigned NOT NULL default '0',
UNIQUE KEY `group_dept` (`group_id`,`dept_id`),
KEY `dept_id` (`dept_id`)
) DEFAULT CHARSET=utf8] Table 'ost_group_dept_access' already exists
I have also attempted adding the ost_group_dept_access table to begin the upgrade, than removing it after it starts. I then receive the same error above stating that the table is missing. All other tables are successfully added by the upgrade process after I manually add the three tables mentioned above, so I don't believe it is a permissions issue.
I have attempted the upgrade with both utf8_general_ci and utf8_unicode_ci encoding. They both produce the same results described above. I am at a loss as to what to do. PHP logs only show time out errors, and the upgrader errors are as described above. Any suggestions are greatly appreciated.
Current OST Version: 1.6ST (Attempting upgrade to 1.7.7)
PHP Version: 5.3.28
DB Version: MariaDB 5.5.36
IIS 7 on Windows 7 Professional 32bit (test environment)