While I waited I decided to restore a backup. As a precaution is exported the frontacc database first. Restoring the backup did not fix the issue. So now, with the most recent input from rafat, I plan to install a new version of xampp. However, I would like to restore the exported database file, since it contains the most up to date data. I'm not sure though that using that exported file will result in a clean restore. When I compare the backup file that I used to the exported database file I see some differences in code. The backup has the following code (similar code precedes each table listing):
DROP TABLE IF EXISTS `0_areas`;
CREATE TABLE `0_areas` (
`area_code` int(11) NOT NULL AUTO_INCREMENT,
`description` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`inactive` tinyint(1) NOT NULL DEFAULT 0,
PRIMARY KEY (`area_code`),
UNIQUE KEY `description` (`description`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ;
### Data of table `0_areas` ###
INSERT INTO `0_areas` VALUES
('1', 'Global', '0'),
('2', 'TSI', '0'),
('3', 'Mech.Eng.', '0');
Whereas the exported database file has this code:
CREATE TABLE `0_areas` (
`area_code` int(11) NOT NULL,
`description` varchar(60) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
`inactive` tinyint(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `0_areas`
--
INSERT INTO `0_areas` (`area_code`, `description`, `inactive`) VALUES
(1, 'Global', 0),
(2, 'TSI', 0),
(3, 'Mech.Eng.', 0);
I've been told that the code "DROP TABLE IF EXISTS" is very important to have included. I would appreciate folks weighing in on this.
Thx
