Advertisement:

Author Topic: Custom fields and filters of post  (Read 84064 times)

Offline mtechama

  • Full Member
  • ***
  • Posts: 612
  • Gender: Male
    • mtechama on Facebook
    • @mtechama on Twitter
    • Morris Technologies
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #20 on: April 20, 2014, 04:39:25 PM »
Will this mod do the following:
Topic will be my (Item)
A field for (Price)
A field for (Discription)
A Drop down menu for (City & State)

What I am doing is almost like a online Classified.

Thanks

Offline davidhs

  • Sr. Member
  • ****
  • Posts: 936
  • Gender: Male
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #21 on: April 22, 2014, 05:47:44 PM »
Will this mod do the following:
Topic will be my (Item)
A field for (Price)
A field for (Discription)
A Drop down menu for (City & State)

What I am doing is almost like a online Classified.

Thanks
Yes, of course :)

You can to do this:

1. Create a group of fields
Quote
Name: Item
Type: Record
Boards: Select board where you will create items
Show in sticky topics: No (I suppouse)
Show in locked topics: No (I suppouse)
Show on the first post of topic: Yes
Show on the replies of topic: No
Search page: Search items
Permissions: For example...
- Administrator, Global moderador, Local moderador and Owner of post: check all
- User: View, Search
- Guest: View

2. Create fields of group "Item"
Quote
Name: Price
Order: 1
Show enclosed within text: Write your currency symbol, for example: ${INPUT} (in next update I will add more settings for this)
Show on message index: Yes
Filter the message index: No
Show on records list: Yes, in a column with only this field
Type: Text
Maximum lenght of data: 0
Input mask: [0-9]+(\.[0-9][0-9]?)?   (You will can write 9999, 9999.9, 9999.99; I am not test this regular expression)
Permissions: For example... check all, except Search
Quote
Name: Description
Order: 2
Show on message index: Yes
Filter the message index: Yes
Show on records list: Yes, in a column with only this field
Type: Large text
Maximum lenght of data: 0
Permissions: For example... check all
Quote
Name: State
Order: 3
Show on message index: Yes
Filter the message index: Yes
Show on records list: Yes, in a column with only this field
Type: You have two options:

1. If states are countries of world
Type: Combo box
Options: You can add some states, but is not necessary

2. If states are states of USA
Type: Select box
Options: Add 50 states of USA

Maximum lenght of data: 0
Permissions: For example... check all
Quote
Name: City
Order: 4
Show on message index: Yes
Filter the message index: Yes
Show on records list: Yes, in a column with only this field
Type: Combo box
Maximum lenght of data: 0
Options: You can add some cities, but is not necessary
Permissions: For example... check all
Note: City and State buttons are not related.

3. Modify group Item and select column and order in "Sort search results by"

These are the basic settings. You can create templates for group on post and group on message index.

Offline mtechama

  • Full Member
  • ***
  • Posts: 612
  • Gender: Male
    • mtechama on Facebook
    • @mtechama on Twitter
    • Morris Technologies
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #22 on: April 22, 2014, 08:30:07 PM »
Will this mod do the following:
Topic will be my (Item)
A field for (Price)
A field for (Discription)
A Drop down menu for (City & State)

What I am doing is almost like a online Classified.

Thanks
Yes, of course :)

You can to do this:

1. Create a group of fields
Quote
Name: Item
Type: Record
Boards: Select board where you will create items
Show in sticky topics: No (I suppouse)
Show in locked topics: No (I suppouse)
Show on the first post of topic: Yes
Show on the replies of topic: No
Search page: Search items
Permissions: For example...
- Administrator, Global moderador, Local moderador and Owner of post: check all
- User: View, Search
- Guest: View

2. Create fields of group "Item"
Quote
Name: Price
Order: 1
Show enclosed within text: Write your currency symbol, for example: ${INPUT} (in next update I will add more settings for this)
Show on message index: Yes
Filter the message index: No
Show on records list: Yes, in a column with only this field
Type: Text
Maximum lenght of data: 0
Input mask: [0-9]+(\.[0-9][0-9]?)?   (You will can write 9999, 9999.9, 9999.99; I am not test this regular expression)
Permissions: For example... check all, except Search
Quote
Name: Description
Order: 2
Show on message index: Yes
Filter the message index: Yes
Show on records list: Yes, in a column with only this field
Type: Large text
Maximum lenght of data: 0
Permissions: For example... check all
Quote
Name: State
Order: 3
Show on message index: Yes
Filter the message index: Yes
Show on records list: Yes, in a column with only this field
Type: You have two options:

1. If states are countries of world
Type: Combo box
Options: You can add some states, but is not necessary

2. If states are states of USA
Type: Select box
Options: Add 50 states of USA

Maximum lenght of data: 0
Permissions: For example... check all
Quote
Name: City
Order: 4
Show on message index: Yes
Filter the message index: Yes
Show on records list: Yes, in a column with only this field
Type: Combo box
Maximum lenght of data: 0
Options: You can add some cities, but is not necessary
Permissions: For example... check all
Note: City and State buttons are not related.

3. Modify group Item and select column and order in "Sort search results by"

These are the basic settings. You can create templates for group on post and group on message index.

I am also will be needing a custom field for at least 3 references. How can able add that in too?

Offline davidhs

  • Sr. Member
  • ****
  • Posts: 936
  • Gender: Male
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #23 on: April 23, 2014, 06:53:19 AM »
I am also will be needing a custom field for at least 3 references. How can able add that in too?
Are there 3 text fields?

You can add 3 text fields like Price (without "Show enclosed within text" and with other "Input mask").

Offline mtechama

  • Full Member
  • ***
  • Posts: 612
  • Gender: Male
    • mtechama on Facebook
    • @mtechama on Twitter
    • Morris Technologies
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #24 on: April 23, 2014, 09:27:51 AM »
I am also will be needing a custom field for at least 3 references. How can able add that in too?
Are there 3 text fields?

You can add 3 text fields like Price (without "Show enclosed within text" and with other "Input mask").

They will be 3 text field for references.

Offline mtechama

  • Full Member
  • ***
  • Posts: 612
  • Gender: Male
    • mtechama on Facebook
    • @mtechama on Twitter
    • Morris Technologies
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #25 on: April 29, 2014, 09:43:08 PM »
I am also will be needing a custom field for at least 3 references. How can able add that in too?
Are there 3 text fields?

You can add 3 text fields like Price (without "Show enclosed within text" and with other "Input mask").

They will be 3 text field for references.

Plus I also need a field where they can upload a image of the item (Optional) into the post.

Offline davidhs

  • Sr. Member
  • ****
  • Posts: 936
  • Gender: Male
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #26 on: April 30, 2014, 05:05:40 AM »
I also need a field where they can upload a image of the item (Optional) into the post.
This not exists. If you want:

- Upload images to server, you can attach images like in other message.

- Show external images, you can create a text field for input image url and write this in Show enclosed with text:
Code: [Select]
<img src="{INPUT}">

Offline ralph622

  • Newbie
  • *
  • Posts: 5
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #27 on: May 03, 2014, 04:11:32 AM »
Hi. This modification sounds awesome, but i ve got a problem after manual installation (AUTO doesnt work).
SMF 2.0.7. All files are uploaded and changed, i cant execute code-2.0.php and database-2.0.php. i uploaded these files in my root directory where is SMF and execute from browser.
errors in db
code-2.0.php :
Code: [Select]
Table 'smf_forum.smf_cffp_settings_groups' doesn't exist
File: /home/blabla/domains/[u]blabla[/u]/public_html/smf2/Sources/Themes-CustomFieldFilterPost.php
Linia: 25

database-2.0.php tells me the same problem...

Now i cant view my smf, error is :
Code: [Select]
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 'FROM smf_cffp_settings_groups
WHERE active = 1
ORDER BY group_order ASC' at line 2
Plik: /home/blablabla/domains/blablabla/public_html/smf2/Sources/Themes-CustomFieldFilterPost.php
Linia: 41

Anyone can help me? ;)

Offline davidhs

  • Sr. Member
  • ****
  • Posts: 936
  • Gender: Male
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #28 on: May 03, 2014, 06:21:49 AM »
i ve got a problem after manual installation (AUTO doesnt work).
SMF 2.0.7. All files are uploaded and changed, i cant execute code-2.0.php and database-2.0.php. i uploaded these files in my root directory where is SMF and execute from browser.

Try to do these steps:

1. Extract code-2.0.php and database-2.0.php files from MOD package.

2. Open code-2.0.php in a text editor and add this in line 12
Code: [Select]
include_once("Settings.php");
3. Upload these files to your forum directory.

4. Visit these pages in your browser
Quote
www.your-forum/code-2.0.php
www.your-forum/database-2.0.php

Perhaps you see warning like this, you do not worry!
Quote
Strict Standards: strftime() [function.strftime]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Paris' for '2.0/DST' instead in ...\Subs.php on line 810

Strict Standards: strftime() [function.strftime]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Paris' for '2.0/DST' instead in ...\Sources\Subs.php on line 813

Strict Standards: strftime() [function.strftime]: It is not safe to rely on the system's timezone settings. Please use the date.timezone setting, the TZ environment variable or the date_default_timezone_set() function. In case you used any of those methods and you are still getting this warning, you most likely misspelled the timezone identifier. We selected 'Europe/Paris' for '2.0/DST' instead in ...\Sources\Subs.php on line 821
Else, you see an empty page.

5. Settings are installed and database is update. :)

Offline ralph622

  • Newbie
  • *
  • Posts: 5
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #29 on: May 03, 2014, 06:41:23 AM »
Code: [Select]
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 'FROM smf_cffp_settings_groups
WHERE active = 1
ORDER BY group_order ASC' at line 2
Plik: /home/blabla/domains/blabla/public_html/smf2/Sources/Themes-CustomFieldFilterPost.php
Linia: 41
hmmm... added all to 12 line. db error after executing. forum is still off. it turns on when i delete themes-customfieldpost.php from sources dir.

Offline davidhs

  • Sr. Member
  • ****
  • Posts: 936
  • Gender: Male
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #30 on: May 03, 2014, 07:11:17 AM »
1. About settings, execute this on your database (use phpMyAdmin, i.e)
Code: [Select]
SELECT *
FROM `smf_settings`
WHERE `variable` LIKE 'integrate_%'
and write here the output

2. About tables, have these tables in your database?
Quote
smf_cffp_fields
smf_cffp_settings_fields
smf_cffp_settings_groups

Offline ralph622

  • Newbie
  • *
  • Posts: 5
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #31 on: May 03, 2014, 07:25:54 AM »
Code: [Select]
<?php
/**
 * Export to PHP Array plugin for PHPMyAdmin
 * @version 0.2b
 */

//
// Database `rafaell_clubstage`
//

// `rafaell_clubstage`.`smf_settings`
$smf_settings = array(
  array(
'variable' => 'integrate_actions','value' => 'cffp_actions,simtopics_actions'),
  array(
'variable' => 'integrate_admin_areas','value' => 'cffp_admin_areas,simtopics_admin_areas'),
  array(
'variable' => 'integrate_admin_include','value' => '$sourcedir/Admin-CustomFieldFilterPost.php,$sourcedir/Admin-SimTopics.php'),
  array(
'variable' => 'integrate_load_permissions','value' => 'simtopics_permissions'),
  array(
'variable' => 'integrate_load_theme','value' => 'cffp_load_theme,simtopics_load_theme'),
  array(
'variable' => 'integrate_menu_buttons','value' => 'cffp_menu_buttons,simtopics_menu_buttons'),
  array(
'variable' => 'integrate_modify_modifications','value' => 'cffp_modify_modifications,simtopics_modifications'),
  array(
'variable' => 'integrate_pre_include','value' => '$sourcedir/Subs-CustomFieldFilterPost.php,$sourcedir/Subs-SimTopics.php'),
  array(
'variable' => 'integrate_theme_include','value' => '$sourcedir/Themes-CustomFieldFilterPost.php')
);

There is one table smf_cffp_fields

maybe i should check this mod on a clean SMF copy?

Offline davidhs

  • Sr. Member
  • ****
  • Posts: 936
  • Gender: Male
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #32 on: May 03, 2014, 07:51:04 AM »
Code: [Select]
<?php
/**
 * Export to PHP Array plugin for PHPMyAdmin
 * @version 0.2b
 */

//
// Database `rafaell_clubstage`
//

// `rafaell_clubstage`.`smf_settings`
$smf_settings = array(
  array(
'variable' => 'integrate_actions','value' => 'cffp_actions,simtopics_actions'),
  array(
'variable' => 'integrate_admin_areas','value' => 'cffp_admin_areas,simtopics_admin_areas'),
  array(
'variable' => 'integrate_admin_include','value' => '$sourcedir/Admin-CustomFieldFilterPost.php,$sourcedir/Admin-SimTopics.php'),
  array(
'variable' => 'integrate_load_permissions','value' => 'simtopics_permissions'),
  array(
'variable' => 'integrate_load_theme','value' => 'cffp_load_theme,simtopics_load_theme'),
  array(
'variable' => 'integrate_menu_buttons','value' => 'cffp_menu_buttons,simtopics_menu_buttons'),
  array(
'variable' => 'integrate_modify_modifications','value' => 'cffp_modify_modifications,simtopics_modifications'),
  array(
'variable' => 'integrate_pre_include','value' => '$sourcedir/Subs-CustomFieldFilterPost.php,$sourcedir/Subs-SimTopics.php'),
  array(
'variable' => 'integrate_theme_include','value' => '$sourcedir/Themes-CustomFieldFilterPost.php')
);
Settings was correct instaled from code-2.0.php. :)

There is one table smf_cffp_fields
When you executed database-2.0.php should have created three tables, not just one. :(
You delete table smf_cffp_fields and create three. Excecute this SQL
Code: [Select]
CREATE TABLE smf_cffp_fields (
  id_cffp int(10) NOT NULL auto_increment,
  id_msg int(10) NOT NULL default '0',
  id_group int(10) NOT NULL default '0',
  id_member int(10) NOT NULL default '0',
  poster_name varchar(255) NOT NULL default '',
  poster_email varchar(255) NOT NULL default '',
  poster_ip varchar(255) NOT NULL default '',
  poster_time int(10) NOT NULL default '0',
  modified_name varchar(255) NOT NULL default '',
  modified_time int(10) NOT NULL default '0',
  PRIMARY KEY  (id_cffp)
);

CREATE TABLE smf_cffp_settings_fields (
  id_field int(10) NOT NULL auto_increment,
  id_group int(10) NOT NULL default '0',
  id_column int(10) NOT NULL default '0',
  name varchar(40) NOT NULL default '',
  field_desc varchar(255) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  field_order tinyint(3) NOT NULL default '0',
  `type` varchar(8) NOT NULL default 'text',
  type_filter varchar(15) NOT NULL default 'text',
  length smallint(5) NOT NULL default '255',
  options text NOT NULL,
  options_text text NOT NULL,
  mask varchar(255) NOT NULL default '',
  bbc tinyint(3) NOT NULL default '0',
  default_value text NOT NULL,
  enclose_type varchar(4) NOT NULL default 'html',
  enclose_text text NOT NULL,
  show_message_index tinyint(3) NOT NULL default '0',
  filter_message_index tinyint(3) NOT NULL default '0',
  show_record_list_type varchar(5) NOT NULL default 'no',
  show_record_list_width varchar(7) NOT NULL default '',
  show_record_list_name varchar(40) NOT NULL default '',
  not_empty_value tinyint(3) NOT NULL default '0',
  unique_value tinyint(3) NOT NULL default '0',
  subset varchar(40) NOT NULL default '',
  permissions text NOT NULL,
  active tinyint(3) NOT NULL default '1',
  PRIMARY KEY  (id_field)
);
CREATE TABLE smf_cffp_settings_groups (
  id_group int(10) NOT NULL auto_increment,
  name varchar(40) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  group_order tinyint(3) NOT NULL default '0',
  text_input text NOT NULL,
  text_output text NOT NULL,
  boards text NOT NULL,
  child_boards tinyint(3) default '0',
  `type` varchar(10) NOT NULL default 'fields',
  show_group_name_message_index tinyint(3) NOT NULL default '0',
  show_group_name_filter tinyint(3) NOT NULL default '0',
  show_group_name_search tinyint(3) NOT NULL default '0',
  show_fields_name tinyint(3) NOT NULL default '1',
  show_fields_set tinyint(3) NOT NULL default '0',
  show_empty_fields_post tinyint(3) NOT NULL default '0',
  show_empty_fields_message_index tinyint(3) NOT NULL default '0',
  show_actions_as varchar(10) NOT NULL default 'icon_text',
  show_member_expanded tinyint(3) NOT NULL default '0',
  show_member_expanded_data tinyint(3) NOT NULL default '0',
  show_member_expanded_new tinyint(3) NOT NULL default '0',
  show_sticky tinyint(3) default NULL,
  show_locked tinyint(3) default NULL,
  show_first_post_topic tinyint(3) NOT NULL default '0',
  show_replies_topic tinyint(3) NOT NULL default '0',
  no_show_with_subject_prefix text NOT NULL,
  show_in_topic varchar(11) NOT NULL default 'no',
  show_filters text NOT NULL,
  search_page_name text NOT NULL,
  search_page_order_by text NOT NULL,
  permissions text NOT NULL,
  active tinyint(3) NOT NULL default '1',
  template_type varchar(4) NOT NULL default 'html',
  template_text text NOT NULL,
  template_message_index_type varchar(4) NOT NULL default 'html',
  template_message_index_text text NOT NULL,
  PRIMARY KEY  (id_group)
);


I expect your forum works!

maybe i should check this mod on a clean SMF copy?
If you can to do this, yes.

Offline ralph622

  • Newbie
  • *
  • Posts: 5
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #33 on: May 03, 2014, 07:58:53 AM »
Quote
I expect your forum works!
table deleted, sql executed and it works !
Everything is okay now. I see options, forum works, thanks david :) I am grateful to you for help :)

Edit :
my happiness didnt last too long... after a making new group i see this error :
Code: [Select]
Field 'template_text' doesn't have a default value
Plik: /home/blabla/domains/blabla/public_html/smf2/Sources/Admin-CustomFieldFilterPost.php
Linia: 1687
« Last Edit: May 03, 2014, 08:17:21 AM by ralph622 »

Offline davidhs

  • Sr. Member
  • ****
  • Posts: 936
  • Gender: Male
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #34 on: May 03, 2014, 08:32:18 AM »
after a making new group i see this error :
Code: [Select]
Field 'template_text' doesn't have a default value
Plik: /home/blabla/domains/blabla/public_html/smf2/Sources/Admin-CustomFieldFilterPost.php
Linia: 1687
Delete these tables

smf_cffp_settings_fields
smf_cffp_settings_groups

and excecute these SQL
Code: [Select]
CREATE TABLE smf_cffp_settings_fields (
  id_field int(10) NOT NULL auto_increment,
  id_group int(10) NOT NULL default '0',
  id_column int(10) NOT NULL default '0',
  name varchar(40) NOT NULL default '',
  field_desc varchar(255) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  field_order tinyint(3) NOT NULL default '0',
  `type` varchar(8) NOT NULL default 'text',
  type_filter varchar(15) NOT NULL default 'text',
  length smallint(5) NOT NULL default '255',
  options text NOT NULL default '',
  options_text text NOT NULL default '',
  mask varchar(255) NOT NULL default '',
  bbc tinyint(3) NOT NULL default '0',
  default_value text NOT NULL default '',
  enclose_type varchar(4) NOT NULL default 'html',
  enclose_text text NOT NULL default '',
  show_message_index tinyint(3) NOT NULL default '0',
  filter_message_index tinyint(3) NOT NULL default '0',
  show_record_list_type varchar(5) NOT NULL default 'no',
  show_record_list_width varchar(7) NOT NULL default '',
  show_record_list_name varchar(40) NOT NULL default '',
  not_empty_value tinyint(3) NOT NULL default '0',
  unique_value tinyint(3) NOT NULL default '0',
  subset varchar(40) NOT NULL default '',
  permissions text NOT NULL default '',
  active tinyint(3) NOT NULL default '1',
  PRIMARY KEY  (id_field)
);
CREATE TABLE smf_cffp_settings_groups (
  id_group int(10) NOT NULL auto_increment,
  name varchar(40) NOT NULL default '',
  description varchar(255) NOT NULL default '',
  group_order tinyint(3) NOT NULL default '0',
  text_input text NOT NULL default '',
  text_output text NOT NULL default '',
  boards text NOT NULL default '',
  child_boards tinyint(3) default '0',
  `type` varchar(10) NOT NULL default 'fields',
  show_group_name_message_index tinyint(3) NOT NULL default '0',
  show_group_name_filter tinyint(3) NOT NULL default '0',
  show_group_name_search tinyint(3) NOT NULL default '0',
  show_fields_name tinyint(3) NOT NULL default '1',
  show_fields_set tinyint(3) NOT NULL default '0',
  show_empty_fields_post tinyint(3) NOT NULL default '0',
  show_empty_fields_message_index tinyint(3) NOT NULL default '0',
  show_actions_as varchar(10) NOT NULL default 'icon_text',
  show_member_expanded tinyint(3) NOT NULL default '0',
  show_member_expanded_data tinyint(3) NOT NULL default '0',
  show_member_expanded_new tinyint(3) NOT NULL default '0',
  show_sticky tinyint(3) default NULL,
  show_locked tinyint(3) default NULL,
  show_first_post_topic tinyint(3) NOT NULL default '0',
  show_replies_topic tinyint(3) NOT NULL default '0',
  no_show_with_subject_prefix text NOT NULL default '',
  show_in_topic varchar(11) NOT NULL default 'no',
  show_filters text NOT NULL default '',
  search_page_name text NOT NULL,
  search_page_order_by text NOT NULL,
  permissions text NOT NULL default '',
  active tinyint(3) NOT NULL default '1',
  template_type varchar(4) NOT NULL default 'html',
  template_text text NOT NULL default '',
  template_message_index_type varchar(4) NOT NULL default 'html',
  template_message_index_text text NOT NULL default '',
  PRIMARY KEY  (id_group)
);

Offline ralph622

  • Newbie
  • *
  • Posts: 5
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #35 on: May 03, 2014, 09:21:15 AM »
Code: [Select]
CREATE TABLE smf_cffp_settings_fields ( id_field int(10) NOT NULL auto_increment, id_group int(10) NOT NULL default '0', id_column int(10) NOT NULL default '0', name varchar(40) NOT NULL default '', field_desc varchar(255) NOT NULL default '', description varchar(255) NOT NULL default '', field_order tinyint(3) NOT NULL default '0', `type` varchar(8) NOT NULL default 'text', type_filter varchar(15) NOT NULL default 'text', length smallint(5) NOT NULL default '255', options text NOT NULL default '', options_text text NOT NULL default '', mask varchar(255) NOT NULL default '', bbc tinyint(3) NOT NULL default '0', default_value text NOT NULL default '', enclose_type varchar(4) NOT NULL default 'html', enclose_text text NOT NULL default '', show_message_index tinyint(3) NOT NULL default '0', filter_message_index tinyint(3) NOT NULL default '0', show_record_list_type varchar(5) NOT NULL default 'no', show_record_list_width varch[...]

MySQL zwrócił komunikat: Dokumentacja
#1101 - BLOB/TEXT column 'options' can't have a default value

After that i deleted all tables from cffp and execute sql from your previuos post and again from last post. Value is the same... I totally dont know whats wrong...

Offline davidhs

  • Sr. Member
  • ****
  • Posts: 936
  • Gender: Male
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #36 on: May 03, 2014, 11:17:04 AM »
Code: [Select]
CREATE TABLE smf_cffp_settings_fields ( id_field int(10) NOT NULL auto_increment, id_group int(10) NOT NULL default '0', id_column int(10) NOT NULL default '0', name varchar(40) NOT NULL default '', field_desc varchar(255) NOT NULL default '', description varchar(255) NOT NULL default '', field_order tinyint(3) NOT NULL default '0', `type` varchar(8) NOT NULL default 'text', type_filter varchar(15) NOT NULL default 'text', length smallint(5) NOT NULL default '255', options text NOT NULL default '', options_text text NOT NULL default '', mask varchar(255) NOT NULL default '', bbc tinyint(3) NOT NULL default '0', default_value text NOT NULL default '', enclose_type varchar(4) NOT NULL default 'html', enclose_text text NOT NULL default '', show_message_index tinyint(3) NOT NULL default '0', filter_message_index tinyint(3) NOT NULL default '0', show_record_list_type varchar(5) NOT NULL default 'no', show_record_list_width varch[...]

MySQL zwrócił komunikat: Dokumentacja
#1101 - BLOB/TEXT column 'options' can't have a default value

After that i deleted all tables from cffp and execute sql from your previuos post and again from last post. Value is the same... I totally dont know whats wrong...
I think this is a bug of your version of SQL http://bugs.mysql.com/bug.php?id=47901
Solution, I do not know... perhaps modify sql_mode value.

Offline mtechama

  • Full Member
  • ***
  • Posts: 612
  • Gender: Male
    • mtechama on Facebook
    • @mtechama on Twitter
    • Morris Technologies
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #37 on: May 05, 2014, 01:13:57 PM »
David,

I have found this mod for posting:

(Simple Image Upload)
http://custom.simplemachines.org/mods/index.php?mod=1669

I want to know if this mod will interfere with this Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7) mod?

Thanks

Offline davidhs

  • Sr. Member
  • ****
  • Posts: 936
  • Gender: Male
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #38 on: May 05, 2014, 04:08:13 PM »
David,

I have found this mod for posting:

(Simple Image Upload)
http://custom.simplemachines.org/mods/index.php?mod=1669

I want to know if this mod will interfere with this Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7) mod?

Thanks
No but... yes:
- No: Simple Image Upload works when my mod is install. :)
- Yes: Simple Image Upload add a link for upload images before all textarea fields of my mod. :( (And works in all these).

Offline mtechama

  • Full Member
  • ***
  • Posts: 612
  • Gender: Male
    • mtechama on Facebook
    • @mtechama on Twitter
    • Morris Technologies
Re: Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7)
« Reply #39 on: May 05, 2014, 04:19:54 PM »
David,

I have found this mod for posting:

(Simple Image Upload)
http://custom.simplemachines.org/mods/index.php?mod=1669

I want to know if this mod will interfere with this Custom fields and filters of post, 1.0 (SMF 2.0-2.0.7) mod?

Thanks
No but... yes:
- No: Simple Image Upload works when my mod is install. :)
- Yes: Simple Image Upload add a link for upload images before all textarea fields of my mod. :( (And works in all these).

Cool,,, I will have to mess with it and see if it will work the way I need it.