× 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 năm 9 tháng trước #1472 bởi 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;

Tin nhắn này có một tệp tin gắn kèm.
Vui lòng đăng nhập hoặc đăng kí để xem nó.

Vui lòng Đăng nhập hoặc Tạo tài khoản để tham gia cuộc hội thoại.

Thời gian tải trang: 0.051 giây
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