× 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 years 9 months ago #1472 by David Thornton
built one but now i get the following error when attempting to install was created by 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.

Please Log in or Create an account to join the conversation.

Time to create page: 0.048 seconds
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.

Learn More