Advertisement:

Author Topic: Order Custom Profile Fields  (Read 24632 times)

Offline Mihkel

  • Semi-Newbie
  • *
  • Posts: 30
  • Gender: Male
  • Estonian translator
Re: Order Custom Profile Fields
« Reply #40 on: August 03, 2010, 04:27:24 PM »
To which table the mod saves input string ?

Offline NHWD

  • Jr. Member
  • **
  • Posts: 300
Re: Order Custom Profile Fields
« Reply #41 on: April 17, 2011, 10:43:01 PM »
I'm guessing this won't wokr on RC5

Offline poetra

  • Semi-Newbie
  • *
  • Posts: 19
Re: Order Custom Profile Fields
« Reply #42 on: April 18, 2011, 04:58:35 AM »
Have some one try to use it on RC5 ver??

Offline Nathaniel

  • SMF Friend
  • SMF Hero
  • *
  • Posts: 3,117
  • Gender: Male
    • Verbtest.com
Re: Order Custom Profile Fields
« Reply #43 on: June 21, 2011, 07:31:46 AM »
To which table the mod saves input string ?

This mod doesn't save an input string. The relevant ordering is saved to the usual smf_custom_fields table in the database.

I'm guessing this won't wokr on RC5

Have some one try to use it on RC5 ver??

The latest version should work on RC5, it definitely works on SMF 2.0 final.
SMF Friend (Former Support Specialist) | SimplePortal Developer
My SMF Mods | SimplePortal

"Quis custodiet ipsos custodes?" - Who will Guard the Guards?

Please don't send me ANY support related PMs. I will just delete them.

Offline fals

  • Jr. Member
  • **
  • Posts: 287
  • Gender: Male
  • bouncing through codes...
    • Large Scale Forum Denmark
Re: Order Custom Profile Fields
« Reply #44 on: July 11, 2011, 08:27:19 AM »
Perfect - this MOD was just what i needed
500fan.dk - SMF 2.0 ~ custom theme
ls-forum.dk - SMF 2.0.2 ~ custom theme and custom iPhone theme

Offline T3CHN0

  • Full Member
  • ***
  • Posts: 618
  • Gender: Male
  • knowledge is power
    • Aussie Rampage
Re: Order Custom Profile Fields
« Reply #45 on: September 22, 2011, 11:44:53 AM »
Hi

great Mod idea...

I just installed this mod and it installed no errors but I can't find the settings

Configuration" -> "Features And Options" -> "Profile Fields" But nothing there.
I have about 20 custom fields there already from what a added with all the different time
zones so a member can select just [1] for his time zone to display in the list of profile info
and all members can then see each others each others time of when replying.

Does custom fields stop this mod from working?

Plus if your intersted in my idea for a mod!!! have a look at Time Zones I posted on the SMF board
there are other mod for times but nothing like this

Offline King Death II

  • Semi-Newbie
  • *
  • Posts: 26
Re: Order Custom Profile Fields
« Reply #46 on: March 15, 2012, 12:33:31 PM »
I see the mod has been updated for 2.0 but does that mean it works on 2.0.2 also? If not, can it be updated?

Offline Eclipse16V

  • Sophist Member
  • *****
  • Posts: 1,068
  • Gender: Male
  • Tornado Map
    • Eclipse16V on Facebook
    • @Eclipse16V on Twitter
    • Tornado Map
Re: Order Custom Profile Fields
« Reply #47 on: March 16, 2012, 04:57:35 AM »
Work on 2.0.2
I work with:
SMF 2 in German
Tornado Map

Offline steiger

  • Semi-Newbie
  • *
  • Posts: 90
Re: Order Custom Profile Fields
« Reply #48 on: January 11, 2013, 06:01:44 AM »
Just installed this mod and it would be really great except that it does not save the position.
Drag and Drop works but there is no change to the position column in the smf_custom_fields table.

I am running 2.0.3 and the installation of the mod worked without a problem.
If I manually change the position values in the database they are correctly used.

Any hints how I can debug this problem?

Offline HappyBits

  • Semi-Newbie
  • *
  • Posts: 16
Re: Order Custom Profile Fields
« Reply #49 on: February 13, 2013, 02:17:00 PM »
Steiger, I am seeing the same behavior that you are reporting - I can drag and drop the fields and put them into the correct order, but when I refresh the page they show up in a different order. This is very strange, given that the mod was working previously. According to my notes I added fields on January 31st, so it must have worked then. I added more fields today but I can't order them.

However, your problems predate all of my work.

I am running SMF 2.0.4 with Firefox 18 and these mods:

1.    Join Password                           1.0.4
2.    SMF 2.0.4 Update                   1.0
3.    Default_Membergroup           2.0
4.    Order Custom Profile Fields    1.1.1
5.    SMF 2.0.3 Update                   1.0

Hmmm, I added 'Join Password' and 'Default Member Group' after my last field additions on January 31st; perhaps one of them is interacting with 'Order Custom Profile Fields'? What mods do you have installed?

Offline steiger

  • Semi-Newbie
  • *
  • Posts: 90
Re: Order Custom Profile Fields
« Reply #50 on: March 08, 2013, 04:11:03 AM »
Sorry, for replying late but notifications do not work for me and I was on vacation until last weekend.

Here is my list of mods:
1.    SMF 2.0.4 Update    1.0
2.    Disable 'last edit by...' for Administrators    1.9
3.    Restrict Email Providers on Registration    1.2
4.    Simple Audio Video Embedder    2.0.6
5.    SimplePortal - German Informal    2.3.5
6.    SimplePortal    2.3.5
7.    Custom SQL Profile Field Mod    1.0
8.    Order Custom Profile Fields    1.1.1

But AFAIR I tried this with "Order Custom Profile Fields" as the only mod and it did not work as well.
« Last Edit: March 10, 2013, 08:00:27 AM by steiger »

Offline HappyBits

  • Semi-Newbie
  • *
  • Posts: 16
Re: Order Custom Profile Fields
« Reply #51 on: March 11, 2013, 02:14:10 PM »
Hmmm, I didn't get a notification for your post either.

So we are both running SMF 2.0.4, but we aren't running any of the same mods except for 'Order Custom Profile Fields'. It never worked for you. For me it worked at first but does not work now.

Steiger, would you mind sharing the SQL you used to manually change the position values?

Does anyone have any suggestions for debugging or troubleshooting?

Offline Jessica.

  • Full Member
  • ***
  • Posts: 468
  • Gender: Female
  • I use SMF 2.0.2, Default theme
    • Testing Zone
Re: Order Custom Profile Fields
« Reply #52 on: March 12, 2013, 04:19:01 PM »
Good mod. should be in SMF by default.
Testing Zone - SMF 2.0.7, default Curve
School & Chat - phpBB3, over 170 mods installed, official live forum

I use the latest version of Chrome

phpBB: Forum = a section; Board = whole site
SMF: Forum = whole site; Board = a section

Offline Arantor

  • SMF Friend
  • SMF Legend
  • *
  • Posts: 61,736
Re: Order Custom Profile Fields
« Reply #53 on: March 12, 2013, 04:24:29 PM »
I can't see SMF adding 30KB+ of code for a single page.
And his eyes have all the seeming of a demon's that is dreaming,
And the lamp-light o'er him streaming throws his shadow on the floor

Offline HappyBits

  • Semi-Newbie
  • *
  • Posts: 16
Re: Order Custom Profile Fields
« Reply #54 on: March 15, 2013, 11:14:04 AM »
Just to update everyone on my investigations:

 -  'SELECT position, id_field, field_name FROM smf_custom_fields ORDER BY position;' will show the names of the custom profile fields and the current order in which they will appear on the registration page.
 - When I did this, I found three fields with Position =16; that seems wrong. Should Position have a 'Unique' attribute? If so, this would be a change in SMF itself.
 -  'update smf_custom_fields set position =17 where id_field = 31;' will move the field with ID=31 to Position 17. Change the Position of the fields to fit your needs.

However, after eliminating the duplicates, 'Order Custom Profile Fields' still does not work. I can drag and drop fields, but as soon as I refresh the page they are back to their original positions.

@Jessica., how many custom fields do you have? It seems silly to think that something might have a limit of 16 custom fields, but 16 _is_ a magic number, and that is where my duplicates were.

Offline Arantor

  • SMF Friend
  • SMF Legend
  • *
  • Posts: 61,736
Re: Order Custom Profile Fields
« Reply #55 on: March 15, 2013, 11:24:00 AM »
Quote
Should Position have a 'Unique' attribute? If so, this would be a change in SMF itself.

That would be a change to this mod, because SMF doesn't have the position column itself.
And his eyes have all the seeming of a demon's that is dreaming,
And the lamp-light o'er him streaming throws his shadow on the floor

Offline HappyBits

  • Semi-Newbie
  • *
  • Posts: 16
Re: Order Custom Profile Fields
« Reply #56 on: March 22, 2013, 01:51:04 PM »
Good to know Arantor; thank you.

I think I can confidently say now that the cause of the problem is that the mod is generating duplicate position numbers. I had 23 custom profile fields (zero through 22) and added one; here is what smf_custom_fields looks like afterward:

mysql> SELECT position, id_field, field_name FROM smf_custom_fields ORDER BY position;
+----------+----------+------------------------------------------+
| position | id_field | field_name                                   |
+----------+----------+------------------------------------------+
|        0 |        1 | First Name                                         |
          .
          .
          .
|       20 |       36 | Work Phone Number                         |
|       21 |       34 | Cell Phone Number                           |
|       21 |       37 | Emergency Contact                          |
|       22 |       35 | Home Phone Number                        |
+----------+----------+------------------------------------------+
24 rows in set (0.00 sec)

In SMF, the new field (Emergency Contact) shows up before or after the Cell Phone Number. That is, on some screens it appears before, and on other screens it appears after, depending on the order in which the query decides to return them.

At the moment I don't have time to dig into the source code of the Mod to find the bug and fix it, but if anyone else has the time and the inclination, I think you now know exactly what to look for.

Offline steiger

  • Semi-Newbie
  • *
  • Posts: 90
Re: Order Custom Profile Fields
« Reply #57 on: March 25, 2013, 03:29:28 PM »
Hmmm, I didn't get a notification for your post either.

So we are both running SMF 2.0.4, but we aren't running any of the same mods except for 'Order Custom Profile Fields'. It never worked for you. For me it worked at first but does not work now.

Steiger, would you mind sharing the SQL you used to manually change the position values?

Sorry for responding so late but I still do not receive any notifications for any threads from this forum. And currently I have no time to look proactively for any replies.

I think you have already found some SQL code to change the order of profile fields.
I just changed the position field of each profile field manually.
As the set of fields is rather static in my installation I do not need to do this very often.

Offline amir.decom

  • Newbie
  • *
  • Posts: 2
Re: Order Custom Profile Fields
« Reply #58 on: April 09, 2014, 03:14:12 AM »
Hi everyone;

I tried to install this mod for SMF 2.0.7, and followed all the steps mention here:

http://custom.simplemachines.org/mods/index.php?action=parse

then when i went to "Profile Fields" section of my forum, i received the following error:

Unknown column 'position' in 'field list'
File: C:\xampp\htdocs\smf_2-0-7_install\Sources\ManageSettings.php
Line: 1528


attached is my ManageSettings.php file.

Cheers

Offline amir.decom

  • Newbie
  • *
  • Posts: 2
Re: Order Custom Profile Fields
« Reply #59 on: April 09, 2014, 04:30:43 AM »

then when i went to "Profile Fields" section of my forum, i received the following error:

Unknown column 'position' in 'field list'
File: C:\xampp\htdocs\smf_2-0-7_install\Sources\ManageSettings.php
Line: 1528



I just solved it by using the install package and quit manual installing.