Can't execute SQL: CREATE TABLE `hesk_attachments
Posted: Mon Feb 23, 2009 12:32 am
Script URL: Posted on our Intranet, not accessible from outside.
Version of script: 2.0
Hosting company: Internal
URL of phpinfo.php: Posted on an Intranet, so not accessible
URL of session_test.php: Posted on an Intranet, so not accessible
What terms did you try when SEARCHING for a solution: Can't execute SQL
PHP version: 4.4.2
MySQL version: 5.0.18
Write your message below:
I am currently trying to upgrade to version 2.0 of the hesk helpdesk software from versioin 0.94.1 and everything goes well up until I click on "Continue to step 4" and I then receive the following message. I have tried all the steps I can find listed in here to fix the problem, but have not been successful to this point. Here is the message I receive. If anyone can offer assistance, I would be most grateful. Thanks in advance!
Can't execute SQL: CREATE TABLE `hesk_attachments` ( `att_id` mediumint(8) unsigned NOT NULL auto_increment, `ticket_id` varchar(10) NOT NULL default '', `saved_name` varchar(255) NOT NULL default '', `real_name` varchar(255) NOT NULL default '', `size` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`att_id`), KEY `ticket_id` (`ticket_id`) ) ENGINE=MyISAM
MySQL said:
Table 'hesk_attachments' already exists
Version of script: 2.0
Hosting company: Internal
URL of phpinfo.php: Posted on an Intranet, so not accessible
URL of session_test.php: Posted on an Intranet, so not accessible
What terms did you try when SEARCHING for a solution: Can't execute SQL
PHP version: 4.4.2
MySQL version: 5.0.18
Write your message below:
I am currently trying to upgrade to version 2.0 of the hesk helpdesk software from versioin 0.94.1 and everything goes well up until I click on "Continue to step 4" and I then receive the following message. I have tried all the steps I can find listed in here to fix the problem, but have not been successful to this point. Here is the message I receive. If anyone can offer assistance, I would be most grateful. Thanks in advance!
Can't execute SQL: CREATE TABLE `hesk_attachments` ( `att_id` mediumint(8) unsigned NOT NULL auto_increment, `ticket_id` varchar(10) NOT NULL default '', `saved_name` varchar(255) NOT NULL default '', `real_name` varchar(255) NOT NULL default '', `size` int(10) unsigned NOT NULL default '0', PRIMARY KEY (`att_id`), KEY `ticket_id` (`ticket_id`) ) ENGINE=MyISAM
MySQL said:
Table 'hesk_attachments' already exists