× Please submit new Bug Reports on GitHub: github.com/Jensen-Technologies/component-creator-issues/issues

built one but now i get the following error when attempting to install

7 år 10 månader sedan #1472 av David Thornton
Anyone have a clue what i am doing wrong here????

Warning

JInstaller: :Install: Error SQL You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(255) NOT NULL , `deceasedchildren` LONGTEXT(255) NOT NULL , `survivinggrand' at line 45 SQL=CREATE TABLE IF NOT EXISTS `#__obituarly_deathinfo` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `ordering` INT(11) NOT NULL , `state` TINYINT(1) NOT NULL , `checked_out` INT(11) NOT NULL , `checked_out_time` DATETIME NOT NULL , `created_by` INT(11) NOT NULL , `modified_by` INT(11) NOT NULL , `firstname` VARCHAR(255) NOT NULL , `middlename` VARCHAR(255) NOT NULL , `lastname` VARCHAR(255) NOT NULL , `nickname` VARCHAR(255) NOT NULL , `ageatdeath` VARCHAR(3) NOT NULL , `residenceatdeath` VARCHAR(255) NOT NULL , `dateofdeath` DATE NOT NULL , `placeofdeath` VARCHAR(255) NOT NULL , `causeofdeath` VARCHAR(255) NOT NULL , `dateofbirth` DATE NOT NULL , `placeofbirth` VARCHAR(255) NOT NULL , `mothersname` VARCHAR(255) NOT NULL , `momalive` VARCHAR(255) NOT NULL , `fathersname` VARCHAR(255) NOT NULL , `fatheralive` VARCHAR(255) NOT NULL , `grandmothername` VARCHAR(255) NOT NULL , `grandmotheralive` VARCHAR(255) NOT NULL , `grandfather` VARCHAR(255) NOT NULL , `grandfatheralive` VARCHAR(255) NOT NULL , `sibling1` VARCHAR(255) NOT NULL , `sibling1alive` VARCHAR(255) NOT NULL , `sibling2` VARCHAR(255) NOT NULL , `sibling2alive` VARCHAR(255) NOT NULL , `sibling3` VARCHAR(255) NOT NULL , `sibling3alive` VARCHAR(255) NOT NULL , `sibling4` VARCHAR(255) NOT NULL , `sibling4alive` VARCHAR(255) NOT NULL , `sibling5` VARCHAR(255) NOT NULL , `sibling5alive` VARCHAR(255) NOT NULL , `sibling6` VARCHAR(255) NOT NULL , `sibling6alive` VARCHAR(255) NOT NULL , `spouse` VARCHAR(255) NOT NULL , `spousealive` VARCHAR(255) NOT NULL , `dateofmarriage` DATE NOT NULL , `placeofmarriage` VARCHAR(255) NOT NULL , `survivingchildren` LONGTEXT(255) NOT NULL , `deceasedchildren` LONGTEXT(255) NOT NULL , `survivinggrandchildren` LONGTEXT(255) NOT NULL , `deceasedgrandchildren` LONGTEXT(255) NOT NULL , `survivinggreatgrandchildren` LONGTEXT(255) NOT NULL , `survivingotherfamily` LONGTEXT(255) NOT NULL , `deceasedotherfamily` LONGTEXT(255) NOT NULL , `survivingfriends` LONGTEXT(255) NOT NULL , `survivingpets` LONGTEXT(255) NOT NULL , `educationinfo` LONGTEXT(255) NOT NULL , `militaryservice` LONGTEXT(255) NOT NULL , `awards` LONGTEXT(255) NOT NULL , `employment` LONGTEXT(255) NOT NULL , `hobbies` LONGTEXT(255) NOT NULL , `chairatibleinfo` LONGTEXT(255) NOT NULL , `achievements` LONGTEXT(255) NOT NULL , `disappointments` LONGTEXT(255) NOT NULL , `unusual` LONGTEXT(255) NOT NULL , `placesofresidenct` LONGTEXT(255) NOT NULL , `dateofservice` DATE NOT NULL , `timeofservice` TIME NOT NULL , `placeofservice` VARCHAR(255) NOT NULL , `dateofvisitation` DATE NOT NULL , `timeofvisitation` TIME NOT NULL , `placeofvisitation` VARCHAR(255) NOT NULL , `dateofreception` DATE NOT NULL , `timeofreception` TIME NOT NULL , `placeofreception` VARCHAR(255) NOT NULL , `servicepallbearersother` LONGTEXT(255) NOT NULL , `othervigil` LONGTEXT(255) NOT NULL , `placeofinterment` LONGTEXT(255) NOT NULL , `funeralhome` VARCHAR(255) NOT NULL , `whotocall` VARCHAR(255) NOT NULL , `phoneforinfo` VARCHAR(255) NOT NULL , `donations` LONGTEXT(255) NOT NULL , `thankyou` LONGTEXT(255) NOT NULL , `poem` LONGTEXT(255) NOT NULL , `threewords` VARCHAR(255) NOT NULL , `firstnameplanner` VARCHAR(255) NOT NULL , `lastname_planner` VARCHAR(255) NOT NULL , `phoneforplanner` VARCHAR(255) NOT NULL , `emailofplanner` VARCHAR(255) NOT NULL , PRIMARY KEY (`id`) ) DEFAULT COLLATE=utf8mb4_unicode_ci;
Extension Install: SQL error processing query: DB function failed with error number 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(255) NOT NULL , `deceasedchildren` LONGTEXT(255) NOT NULL , `survivinggrand' at line 45 SQL=CREATE TABLE IF NOT EXISTS `#__obituarly_deathinfo` ( `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT, `ordering` INT(11) NOT NULL , `state` TINYINT(1) NOT NULL , `checked_out` INT(11) NOT NULL , `checked_out_time` DATETIME NOT NULL , `created_by` INT(11) NOT NULL , `modified_by` INT(11) NOT NULL , `firstname` VARCHAR(255) NOT NULL , `middlename` VARCHAR(255) NOT NULL , `lastname` VARCHAR(255) NOT NULL , `nickname` VARCHAR(255) NOT NULL , `ageatdeath` VARCHAR(3) NOT NULL , `residenceatdeath` VARCHAR(255) NOT NULL , `dateofdeath` DATE NOT NULL , `placeofdeath` VARCHAR(255) NOT NULL , `causeofdeath` VARCHAR(255) NOT NULL , `dateofbirth` DATE NOT NULL , `placeofbirth` VARCHAR(255) NOT NULL , `mothersname` VARCHAR(255) NOT NULL , `momalive` VARCHAR(255) NOT NULL , `fathersname` VARCHAR(255) NOT NULL , `fatheralive` VARCHAR(255) NOT NULL , `grandmothername` VARCHAR(255) NOT NULL , `grandmotheralive` VARCHAR(255) NOT NULL , `grandfather` VARCHAR(255) NOT NULL , `grandfatheralive` VARCHAR(255) NOT NULL , `sibling1` VARCHAR(255) NOT NULL , `sibling1alive` VARCHAR(255) NOT NULL , `sibling2` VARCHAR(255) NOT NULL , `sibling2alive` VARCHAR(255) NOT NULL , `sibling3` VARCHAR(255) NOT NULL , `sibling3alive` VARCHAR(255) NOT NULL , `sibling4` VARCHAR(255) NOT NULL , `sibling4alive` VARCHAR(255) NOT NULL , `sibling5` VARCHAR(255) NOT NULL , `sibling5alive` VARCHAR(255) NOT NULL , `sibling6` VARCHAR(255) NOT NULL , `sibling6alive` VARCHAR(255) NOT NULL , `spouse` VARCHAR(255) NOT NULL , `spousealive` VARCHAR(255) NOT NULL , `dateofmarriage` DATE NOT NULL , `placeofmarriage` VARCHAR(255) NOT NULL , `survivingchildren` LONGTEXT(255) NOT NULL , `deceasedchildren` LONGTEXT(255) NOT NULL , `survivinggrandchildren` LONGTEXT(255) NOT NULL , `deceasedgrandchildren` LONGTEXT(255) NOT NULL , `survivinggreatgrandchildren` LONGTEXT(255) NOT NULL , `survivingotherfamily` LONGTEXT(255) NOT NULL , `deceasedotherfamily` LONGTEXT(255) NOT NULL , `survivingfriends` LONGTEXT(255) NOT NULL , `survivingpets` LONGTEXT(255) NOT NULL , `educationinfo` LONGTEXT(255) NOT NULL , `militaryservice` LONGTEXT(255) NOT NULL , `awards` LONGTEXT(255) NOT NULL , `employment` LONGTEXT(255) NOT NULL , `hobbies` LONGTEXT(255) NOT NULL , `chairatibleinfo` LONGTEXT(255) NOT NULL , `achievements` LONGTEXT(255) NOT NULL , `disappointments` LONGTEXT(255) NOT NULL , `unusual` LONGTEXT(255) NOT NULL , `placesofresidenct` LONGTEXT(255) NOT NULL , `dateofservice` DATE NOT NULL , `timeofservice` TIME NOT NULL , `placeofservice` VARCHAR(255) NOT NULL , `dateofvisitation` DATE NOT NULL , `timeofvisitation` TIME NOT NULL , `placeofvisitation` VARCHAR(255) NOT NULL , `dateofreception` DATE NOT NULL , `timeofreception` TIME NOT NULL , `placeofreception` VARCHAR(255) NOT NULL , `servicepallbearersother` LONGTEXT(255) NOT NULL , `othervigil` LONGTEXT(255) NOT NULL , `placeofinterment` LONGTEXT(255) NOT NULL , `funeralhome` VARCHAR(255) NOT NULL , `whotocall` VARCHAR(255) NOT NULL , `phoneforinfo` VARCHAR(255) NOT NULL , `donations` LONGTEXT(255) NOT NULL , `thankyou` LONGTEXT(255) NOT NULL , `poem` LONGTEXT(255) NOT NULL , `threewords` VARCHAR(255) NOT NULL , `firstnameplanner` VARCHAR(255) NOT NULL , `lastname_planner` VARCHAR(255) NOT NULL , `phoneforplanner` VARCHAR(255) NOT NULL , `emailofplanner` VARCHAR(255) NOT NULL , PRIMARY KEY (`id`) ) DEFAULT COLLATE=utf8mb4_unicode_ci;
SQL =
CREATE TABLE IF NOT EXISTS `#__obituarly_deathinfo` (
`id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,

`ordering` INT(11) NOT NULL ,
`state` TINYINT(1) NOT NULL ,
`checked_out` INT(11) NOT NULL ,
`checked_out_time` DATETIME NOT NULL ,
`created_by` INT(11) NOT NULL ,
`modified_by` INT(11) NOT NULL ,
`firstname` VARCHAR(255) NOT NULL ,
`middlename` VARCHAR(255) NOT NULL ,
`lastname` VARCHAR(255) NOT NULL ,
`nickname` VARCHAR(255) NOT NULL ,
`ageatdeath` VARCHAR(3) NOT NULL ,
`residenceatdeath` VARCHAR(255) NOT NULL ,
`dateofdeath` DATE NOT NULL ,
`placeofdeath` VARCHAR(255) NOT NULL ,
`causeofdeath` VARCHAR(255) NOT NULL ,
`dateofbirth` DATE NOT NULL ,
`placeofbirth` VARCHAR(255) NOT NULL ,
`mothersname` VARCHAR(255) NOT NULL ,
`momalive` VARCHAR(255) NOT NULL ,
`fathersname` VARCHAR(255) NOT NULL ,
`fatheralive` VARCHAR(255) NOT NULL ,
`grandmothername` VARCHAR(255) NOT NULL ,
`grandmotheralive` VARCHAR(255) NOT NULL ,
`grandfather` VARCHAR(255) NOT NULL ,
`grandfatheralive` VARCHAR(255) NOT NULL ,
`sibling1` VARCHAR(255) NOT NULL ,
`sibling1alive` VARCHAR(255) NOT NULL ,
`sibling2` VARCHAR(255) NOT NULL ,
`sibling2alive` VARCHAR(255) NOT NULL ,
`sibling3` VARCHAR(255) NOT NULL ,
`sibling3alive` VARCHAR(255) NOT NULL ,
`sibling4` VARCHAR(255) NOT NULL ,
`sibling4alive` VARCHAR(255) NOT NULL ,
`sibling5` VARCHAR(255) NOT NULL ,
`sibling5alive` VARCHAR(255) NOT NULL ,
`sibling6` VARCHAR(255) NOT NULL ,
`sibling6alive` VARCHAR(255) NOT NULL ,
`spouse` VARCHAR(255) NOT NULL ,
`spousealive` VARCHAR(255) NOT NULL ,
`dateofmarriage` DATE NOT NULL ,
`placeofmarriage` VARCHAR(255) NOT NULL ,
`survivingchildren` LONGTEXT(255) NOT NULL ,
`deceasedchildren` LONGTEXT(255) NOT NULL ,
`survivinggrandchildren` LONGTEXT(255) NOT NULL ,
`deceasedgrandchildren` LONGTEXT(255) NOT NULL ,
`survivinggreatgrandchildren` LONGTEXT(255) NOT NULL ,
`survivingotherfamily` LONGTEXT(255) NOT NULL ,
`deceasedotherfamily` LONGTEXT(255) NOT NULL ,
`survivingfriends` LONGTEXT(255) NOT NULL ,
`survivingpets` LONGTEXT(255) NOT NULL ,
`educationinfo` LONGTEXT(255) NOT NULL ,
`militaryservice` LONGTEXT(255) NOT NULL ,
`awards` LONGTEXT(255) NOT NULL ,
`employment` LONGTEXT(255) NOT NULL ,
`hobbies` LONGTEXT(255) NOT NULL ,
`chairatibleinfo` LONGTEXT(255) NOT NULL ,
`achievements` LONGTEXT(255) NOT NULL ,
`disappointments` LONGTEXT(255) NOT NULL ,
`unusual` LONGTEXT(255) NOT NULL ,
`placesofresidenct` LONGTEXT(255) NOT NULL ,
`dateofservice` DATE NOT NULL ,
`timeofservice` TIME NOT NULL ,
`placeofservice` VARCHAR(255) NOT NULL ,
`dateofvisitation` DATE NOT NULL ,
`timeofvisitation` TIME NOT NULL ,
`placeofvisitation` VARCHAR(255) NOT NULL ,
`dateofreception` DATE NOT NULL ,
`timeofreception` TIME NOT NULL ,
`placeofreception` VARCHAR(255) NOT NULL ,
`servicepallbearersother` LONGTEXT(255) NOT NULL ,
`othervigil` LONGTEXT(255) NOT NULL ,
`placeofinterment` LONGTEXT(255) NOT NULL ,
`funeralhome` VARCHAR(255) NOT NULL ,
`whotocall` VARCHAR(255) NOT NULL ,
`phoneforinfo` VARCHAR(255) NOT NULL ,
`donations` LONGTEXT(255) NOT NULL ,
`thankyou` LONGTEXT(255) NOT NULL ,
`poem` LONGTEXT(255) NOT NULL ,
`threewords` VARCHAR(255) NOT NULL ,
`firstnameplanner` VARCHAR(255) NOT NULL ,
`lastname_planner` VARCHAR(255) NOT NULL ,
`phoneforplanner` VARCHAR(255) NOT NULL ,
`emailofplanner` VARCHAR(255) NOT NULL ,
PRIMARY KEY (`id`)
) DEFAULT COLLATE=utf8mb4_unicode_ci;

This message has an attachment file.
Please log in or register to see it.

Be Logga in eller Skapa ett konto ansluta till konversationen.

Sidan laddades på: 0.050 sekunder
Powered by Kunena Forum

We use cookies so that you can place orders and we can provide a better service. You can control the use of cookies at the individual browser level. If you reject cookies, you may still use our website, but your ability to use some features or areas of our website may be limited.