Atlasx Posted July 18, 2017 Share Posted July 18, 2017 INSERT INTO `cms_custom_database_3` ( `record_publish_date`, `record_last_comment`, `member_id`, `record_last_comment_by`, `record_last_comment_name`, `record_last_review`, `category_id`, `record_approved`, `record_locked`, `record_views`, `record_pinned`, `record_featured`, `record_future_date`, `record_comments`, `record_reviews`, `record_comments_queued`, `record_comments_hidden`, `record_meta_keywords`, `record_meta_description`, `field_18`, `field_12`, `field_13`, `field_11`, `field_14`, `field_15`, `field_16`, `field_17`, `record_saved`, `record_updated`, `record_allow_comments`, `record_static_furl` ) VALUES ( 1500355528, 1500355528, 1, 1, 'Atlas', 1500355528, 4, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '<p> Testing </p>', '', '', '', '', '', '', '', 1500355528, 1500355528, true, NULL ) IPS\Db\Exception: Incorrect integer value: '' for column 'field_14' at row 1 (1366) #0 /var/www/html/community/system/Db/Db.php(808): IPS\_Db->preparedQuery('/*IPS\\collab_ho...', Array) #1 /var/www/html/community/system/Patterns/ActiveRecord.php(460): IPS\_Db->insert('cms_custom_data...', Array) #2 [internal function]: IPS\Patterns\_ActiveRecord->save() #3 /var/www/html/community/init.php(448) : eval()'d code(183): call_user_func_array('parent::save', Array) #4 /var/www/html/community/applications/cms/sources/Records/Records.php(1650): IPS\collab_hook_ipsContent->save() #5 /var/www/html/community/applications/cms/sources/Records/Records.php(1026): IPS\cms\_Records->save() #6 /var/www/html/community/system/Content/Item.php(332): IPS\cms\_Records->processForm(Array) #7 /var/www/html/community/applications/cms/sources/Records/Records.php(2018): IPS\Content\_Item::createFromForm(Array, Object(IPS\cms\Categories3), true) #8 /var/www/html/community/system/Content/Item.php(87): IPS\cms\_Records::createFromForm(Array, Object(IPS\cms\Categories3)) #9 /var/www/html/community/applications/cms/modules/front/database/category.php(545): IPS\Content\_Item::create(Object(IPS\cms\Categories3)) #10 /var/www/html/community/system/Dispatcher/Controller.php(86): IPS\cms\modules\front\database\_category->form() #11 /var/www/html/community/applications/cms/sources/Databases/Dispatcher.php(299): IPS\Dispatcher\_Controller->execute() #12 /var/www/html/community/applications/cms/modules/front/pages/page.php(164): IPS\cms\Databases\_Dispatcher->run() #13 /var/www/html/community/system/Dispatcher/Controller.php(86): IPS\cms\modules\front\pages\_page->__call('form', Array) #14 /var/www/html/community/applications/cms/modules/front/pages/page.php(34): IPS\Dispatcher\_Controller->execute() #15 /var/www/html/community/system/Dispatcher/Dispatcher.php(129): IPS\cms\modules\front\pages\_page->execute() #16 /var/www/html/community/index.php(13): IPS\_Dispatcher->run() #17 {main} Thoughts? No idea where to go from here lol, this is upon posting something. Quote Link to comment Share on other sites More sharing options...
Cookie Monster Posted July 18, 2017 Author Share Posted July 18, 2017 23 minutes ago, Atlasx said: INSERT INTO `cms_custom_database_3` ( `record_publish_date`, `record_last_comment`, `member_id`, `record_last_comment_by`, `record_last_comment_name`, `record_last_review`, `category_id`, `record_approved`, `record_locked`, `record_views`, `record_pinned`, `record_featured`, `record_future_date`, `record_comments`, `record_reviews`, `record_comments_queued`, `record_comments_hidden`, `record_meta_keywords`, `record_meta_description`, `field_18`, `field_12`, `field_13`, `field_11`, `field_14`, `field_15`, `field_16`, `field_17`, `record_saved`, `record_updated`, `record_allow_comments`, `record_static_furl` ) VALUES ( 1500355528, 1500355528, 1, 1, 'Atlas', 1500355528, 4, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', '', '<p> Testing </p>', '', '', '', '', '', '', '', 1500355528, 1500355528, true, NULL ) IPS\Db\Exception: Incorrect integer value: '' for column 'field_14' at row 1 (1366) #0 /var/www/html/community/system/Db/Db.php(808): IPS\_Db->preparedQuery('/*IPS\\collab_ho...', Array) #1 /var/www/html/community/system/Patterns/ActiveRecord.php(460): IPS\_Db->insert('cms_custom_data...', Array) #2 [internal function]: IPS\Patterns\_ActiveRecord->save() #3 /var/www/html/community/init.php(448) : eval()'d code(183): call_user_func_array('parent::save', Array) #4 /var/www/html/community/applications/cms/sources/Records/Records.php(1650): IPS\collab_hook_ipsContent->save() #5 /var/www/html/community/applications/cms/sources/Records/Records.php(1026): IPS\cms\_Records->save() #6 /var/www/html/community/system/Content/Item.php(332): IPS\cms\_Records->processForm(Array) #7 /var/www/html/community/applications/cms/sources/Records/Records.php(2018): IPS\Content\_Item::createFromForm(Array, Object(IPS\cms\Categories3), true) #8 /var/www/html/community/system/Content/Item.php(87): IPS\cms\_Records::createFromForm(Array, Object(IPS\cms\Categories3)) #9 /var/www/html/community/applications/cms/modules/front/database/category.php(545): IPS\Content\_Item::create(Object(IPS\cms\Categories3)) #10 /var/www/html/community/system/Dispatcher/Controller.php(86): IPS\cms\modules\front\database\_category->form() #11 /var/www/html/community/applications/cms/sources/Databases/Dispatcher.php(299): IPS\Dispatcher\_Controller->execute() #12 /var/www/html/community/applications/cms/modules/front/pages/page.php(164): IPS\cms\Databases\_Dispatcher->run() #13 /var/www/html/community/system/Dispatcher/Controller.php(86): IPS\cms\modules\front\pages\_page->__call('form', Array) #14 /var/www/html/community/applications/cms/modules/front/pages/page.php(34): IPS\Dispatcher\_Controller->execute() #15 /var/www/html/community/system/Dispatcher/Dispatcher.php(129): IPS\cms\modules\front\pages\_page->execute() #16 /var/www/html/community/index.php(13): IPS\_Dispatcher->run() #17 {main} Thoughts? No idea where to go from here lol, this is upon posting something. This is what is the problem. Incorrect integer value: '' for column 'field_14' at row 1 (1366) Missing a value Quote Liked what i posted remember to feed me a cookie ->Or you can add a cookie to my Link to comment Share on other sites More sharing options...
Atlasx Posted July 18, 2017 Share Posted July 18, 2017 This is the error I get when I upload the database, it still lets you use it but yeah. As you can see I'm running 4.1.19.4 Where to go from here? Quote Link to comment Share on other sites More sharing options...
Cookie Monster Posted July 19, 2017 Author Share Posted July 19, 2017 7 hours ago, Atlasx said: This is the error I get when I upload the database, it still lets you use it but yeah. As you can see I'm running 4.1.19.4 Where to go from here? Did you remove the old template tag's and did you remove the database after you get that error? I Just tried to install it and I don't get the error. Quote Liked what i posted remember to feed me a cookie ->Or you can add a cookie to my Link to comment Share on other sites More sharing options...
Atlasx Posted July 19, 2017 Share Posted July 19, 2017 41 minutes ago, Cookie Monster said: Did you remove the old template tag's and did you remove the database after you get that error? I Just tried to install it and I don't get the error. I got this on first install Quote Link to comment Share on other sites More sharing options...
xtrex1029 Posted July 19, 2017 Share Posted July 19, 2017 I followed this tut to the T, worked fine but the release notes were not parsing HTML. I figured turning on "Allow HTML" for the Title field would suffice considering only administrators can touch the records. Thank you Cookie Quote Link to comment Share on other sites More sharing options...
Cookie Monster Posted July 19, 2017 Author Share Posted July 19, 2017 5 hours ago, Atlasx said: I got this on first install I would give it another go. 4 hours ago, xtrex1029 said: I followed this tut to the T, worked fine but the release notes were not parsing HTML. I figured turning on "Allow HTML" for the Title field would suffice considering only administrators can touch the records. Thank you Cookie Glad i might have to change that and edit the post thanks for the update Quote Liked what i posted remember to feed me a cookie ->Or you can add a cookie to my Link to comment Share on other sites More sharing options...
S!r.ReaDy Posted September 20, 2017 Share Posted September 20, 2017 @Cookie Monster any help ? Quote Link to comment Share on other sites More sharing options...
Cookie Monster Posted September 20, 2017 Author Share Posted September 20, 2017 4 minutes ago, S!r.ReaDy said: @Cookie Monster any help ? swap around title and content (they are been mixed) also you can then change the fields from text to editor and vise versa. Quote Liked what i posted remember to feed me a cookie ->Or you can add a cookie to my Link to comment Share on other sites More sharing options...
S!r.ReaDy Posted September 21, 2017 Share Posted September 21, 2017 (edited) 18 hours ago, Cookie Monster said: swap around title and content (they are been mixed) also you can then change the fields from text to editor and vise versa. ok thx , i will try and let u know @Cookie Monster Tell me what to edit... idk :/ title is = titlefield_2 contnt = type adrees, and = field contentfield_2 whats wrong here the problem, how to fix ? Edited September 21, 2017 by S!r.ReaDy Quote Link to comment Share on other sites More sharing options...
Cookie Monster Posted September 21, 2017 Author Share Posted September 21, 2017 27 minutes ago, S!r.ReaDy said: ok thx , i will try and let u know @Cookie Monster Tell me what to edit... idk :/ title is = titlefield_2 contnt = type adrees, and = field contentfield_2 whats wrong here the problem, how to fix ? But read the GREEN LINES (content -> Title) (Title -> Content) Edit Title select Editor instead of Text(SAVE) Edit Content Select Text of EDITOR (SAVE) That's it. Quote Liked what i posted remember to feed me a cookie ->Or you can add a cookie to my Link to comment Share on other sites More sharing options...
S!r.ReaDy Posted September 21, 2017 Share Posted September 21, 2017 8 minutes ago, Cookie Monster said: But read the GREEN LINES (content -> Title) (Title -> Content) Edit Title select Editor instead of Text(SAVE) Edit Content Select Text of EDITOR (SAVE) That's it. That did the trick, but it doesnt show the 'tag", curent release or beta or whatever i choose @Cookie Monster Quote Link to comment Share on other sites More sharing options...
Cookie Monster Posted September 21, 2017 Author Share Posted September 21, 2017 40 minutes ago, S!r.ReaDy said: That did the trick, but it doesnt show the 'tag", curent release or beta or whatever i choose @Cookie Monster Then i suggest try read the guide again, or experiment with the settings of the things you are missing. Currently at work so i won't be able to assist much at the moment Quote Liked what i posted remember to feed me a cookie ->Or you can add a cookie to my Link to comment Share on other sites More sharing options...
PraxedesBR Posted September 29, 2017 Share Posted September 29, 2017 Hello, mine worked perfectly. However, I would like to know how I can change the title by placing only one version instead of the name. Same as webflake or Invision ... Well I put it and the same changes also is not marked from the rectangle ... Thanks Follow the image for comprehension of what I am saying. Quote Link to comment Share on other sites More sharing options...
Administrator Tony Posted September 30, 2017 Administrator Share Posted September 30, 2017 On 9/29/2017 at 11:40 AM, PraxedesBR said: Hello, mine worked perfectly. However, I would like to know how I can change the title by placing only one version instead of the name. Same as webflake or Invision ... Well I put it and the same changes also is not marked from the rectangle ... Thanks Follow the image for comprehension of what I am saying. 3 Follow Invision's tutorial then. This is just a very basic tutorial provided for those that we expect to have a rudimentary grasp of PHP, HTML, and basic JS. We're not going to hold your hand through emulating our customizations entirely. 1 1 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.