I found out that it has to do with the 'foreign key' in the data. one table is

CREATE TABLE `authors` (
    `id` INT(50) NOT NULL AUTO_INCREMENT,
    `authorName` TINYTEXT NOT NULL,
    `aboutAuthor` TINYTEXT NOT NULL,
    PRIMARY KEY (`id`)
)
COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
;
[download]

and other table is

CREATE TABLE `295c` (
    `id` INT(50) NOT NULL AUTO_INCREMENT,
    `fileName` VARCHAR(40) NULL DEFAULT NULL,
    `file_link` VARCHAR(40) NULL DEFAULT NULL,
    `file_toolTips` VARCHAR(40) NULL DEFAULT NULL,
    `image` VARCHAR(100) NOT NULL DEFAULT '/img/IconFlag.png',
    `content` TEXT NOT NULL,
    `author` INT(50) NOT NULL,
    `keywords` VARCHAR(80) NULL DEFAULT NULL,
    `timemade` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    INDEX `FK__authors` (`author`),
    CONSTRAINT `FK__authors` FOREIGN KEY (`author`) REFERENCES `author
+s` (`id`)
)COLLATE='latin1_swedish_ci'
ENGINE=InnoDB
;
[download]

these simple tables are giving me the error, Any solution, Many thanks,