Well here is the line in the sql download on your website. Note that in Firefox, a warning did not come up about the new forum... It contains a drop
users table and insert
. Not good.
-
-- Table structure for table `xxx_users`
--
DROP TABLE IF EXISTS `p42v_users`;
CREATE TABLE IF NOT EXISTS `p42v_users` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(400) NOT NULL DEFAULT '',
`username` varchar(150) NOT NULL DEFAULT '',
`email` varchar(100) NOT NULL DEFAULT '',
`password` varchar(100) NOT NULL DEFAULT '',
`block` tinyint(4) NOT NULL DEFAULT '0',
`sendEmail` tinyint(4) DEFAULT '0',
`registerDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`lastvisitDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`activation` varchar(100) NOT NULL DEFAULT '',
`params` mediumtext NOT NULL,
`lastResetTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00' COMMENT 'Date of last password reset',
`resetCount` int(11) NOT NULL DEFAULT '0' COMMENT 'Count of password resets since lastResetTime',
`otpKey` varchar(1000) NOT NULL DEFAULT '' COMMENT 'Two factor authentication encrypted keys',
`otep` varchar(1000) NOT NULL DEFAULT '' COMMENT 'One time emergency passwords',
`requireReset` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'Require user to reset password on next login',
PRIMARY KEY (`id`),
KEY `idx_block` (`block`),
KEY `username` (`username`),
KEY `email` (`email`),
KEY `idx_name` (`name`(100))
) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=43 ;
--
-- Dumping data for table `p42v_users`
--
INSERT INTO `xxx_users` (`id`, `name`, `username`, `email`, `password`, `block`, `sendEmail`, `registerDate`, `lastvisitDate`, `activation`, `params`, `lastResetTime`, `resetCount`, `otpKey`, `otep`, `requireReset`) VALUES
(42, 'Super User', 'admin', 'test@joomlart.com', '$2y$10$YkXAm5EYId2eRWWfRUDu5unwuwLuMVl7m./rUs1xmaaOZjFvfZ89O', 0, 1, '2017-04-17 03:49:31', '2017-04-17 03:50:32', '0', '', '0000-00-00 00:00:00', 0, '', '', 0);
Your suggestion to get a back up is fine and well... A link to updated sql would be helpful too.