Can't execute SQL: CREATE TABLE `hesk_attachments

Helpdesk for my helpdesk software

Moderator: mkoch227

Post Reply
supermac1
Posts: 2
Joined: Mon Feb 23, 2009 12:24 am

Can't execute SQL: CREATE TABLE `hesk_attachments

Post by supermac1 »

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
Klemen
Site Admin
Posts: 10142
Joined: Fri Feb 11, 2005 4:04 pm

Post by Klemen »

See if this helps:
viewtopic.php?t=2296
Klemen, creator of HESK and PHPJunkyardWas this helpful? You can buy me a drink here Image

Image You should follow me on Twitter here

Help desk software | Cloud help desk | Guestbook | Link manager | Click counter | more PHP Scripts ...

Also browse for php hosting companies, read php books, find php resources and use webmaster tools
supermac1
Posts: 2
Joined: Mon Feb 23, 2009 12:24 am

Post by supermac1 »

Thanks! I will try this over the weekend and see if it works.
Post Reply