× 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 Anni 9 Mesi fa #1472 da David Thornton
built one but now i get the following error when attempting to install è stato creato da 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;

Questo messaggio ha un file allegato.
Accedi o registrati per visualizzarlo.

Si prega Accedi o Crea un account a partecipare alla conversazione.

Tempo creazione pagina: 0.051 secondi
Powered by Forum Kunena

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