PHPJunkyard support forum

Script URL: http://www.sacomaine.org/helpdesk
Version of script: 2.4.1
Hosting company: One World Hosting
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution:

Write your message below: I'm upgrading 2.4.1 to 2.5.1

I figure I'd duplicate my current database and work off a copy to be safe. So:
1) I exported my current database using phpMyAdmin to a .sql file
2) I created a new blank database on my server
3) I attempted to use phpMyAdmin to import the exported file

I get this error and I'm not sure what it means. Any suggestions?

Error

SQL query:

-- -- Dumping data for table `hesk_categories` -- INSERT INTO `hesk_categories` (`id`, `name`, `cat_order`, `autoassign`, `type`) VALUES (1, 'Parks', 20, '1', '0'), (25, 'Hunting, fishing, recreational vehicles', 90, '1', '0'), (24, 'Property tax collections', 80, '1', '0'), (23, 'Motor vehicle registrations', 70, '1', '0'), (22, 'Code violations', 60, '1', '0'), (21, 'Sewer collections', 50, '1', '0'), (20, 'Roads and sidewalks', 40, '1', '0'), (19, 'Solid Waste and Recycling', 30, '1', '0'), (18, 'Trees on city streets', 10, '1', '0'), (41, 'Recreation programs', 240, '1', '0'), (26, 'Elections', 100, '1', '0'), (27, 'Vital records', 110, '1', '0'), (28, 'Business licensing', 120, '1', '0'), (40, 'Emergency management, disaster issues', 200, '1', '0'), (30, 'Fire services', 140, '1', '0'), (31, 'Emergency medical services', 150, '1', '0'), (32, 'Police enforcement', 160, '1', '0'), (33, 'Crime prevention', 170, '1', '0'), (34, 'Historic preservation', 180, '1', '0'), (35, 'Map and[...]

MySQL said: Documentation
#1062 - Duplicate entry '1' for key 1

The problem is your database already has category with ID 1 inside (make sense, because the default category is created automatically when you install HESK) and you are trying to insert another one with the same ID (from your copied DB).

What you should do is EMPTY all tables in the new database before importing data from your old database.

Ah -- thank you.

John