News:

Wondering if this will always be free?  See why free is better.

Main Menu

Order Custom Profile Fields

Started by Nathaniel, August 14, 2008, 03:56:15 AM

Previous topic - Next topic

Mihkel

To which table the mod saves input string ?

NHWD

I'm guessing this won't wokr on RC5

poetra

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

Nathaniel

Quote from: Mihkel on August 03, 2010, 04:27:24 PM
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.

Quote from: NHWD on April 17, 2011, 10:43:01 PM
I'm guessing this won't wokr on RC5

Quote from: poetra on April 18, 2011, 04:58:35 AM
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.

fals

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

T3CHN0

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

King Death II

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?

Eclipse16V

I worked with:
SMF 2 in German

Shop:
SID Giessen

steiger

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?

HappyBits

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?

steiger

#50
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.

HappyBits

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?

Jessica.

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

Arantor

I can't see SMF adding 30KB+ of code for a single page.

HappyBits

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.

Arantor

QuoteShould 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.

HappyBits

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.

steiger

Quote from: HappyBits 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?

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.

amir.decom

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

amir.decom

Quote from: amir.decom on April 09, 2014, 03:14:12 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.

Advertisement: