Author Topic: Unknown column 'f1' in 'field list'  (Read 105 times)

wre2wre

  • Confirmed Member
  • **
  • Posts: 5
  • Karma: +0/-0
Unknown column 'f1' in 'field list'
« on: September 09, 2017, 12:24:18 AM »
I deleted from admin panel from Profile Fields
(f1) I am a
(f2) Seeking

and get the error

Unknown column 'f1' in 'field list'
Last query run: SELECT a.`fk_user_id`,a.`_user`,a.`_photo`,a.`status`,a.`del`,`f1`,`f2`,DATE_FORMAT(`f3`,'%Y-%m-%d') as `f3`,`f4_country`,`f4_state`,`f4_city`,`f4_zip`,`f5`,`f6`,`f7`,`f23`,`f8`,`f9`,`f10`,`f11`,`f12`,`f13`,`f14`,`f15`,`f18`,`f19`,`f20`,`f21`,`f22` FROM `dsb_user_profiles` a WHERE a.`fk_user_id` IN ('5','4','1','2') ORDER BY a.`fk_user_id` DESC LIMIT 0,10
Array
(
   
  • => Array

        (
            [function] => general_error
            [args] => Array
                (
                   
  • => 256
  • [1] => Unknown column 'f1' in 'field list'
                        [2] => /home/username/public_html/admin/member_results.php
                        [3] => 162
                        [4] => Array
                            (
                                [_GET] => Array
                                    (
                                       
[user] =>
                                    [email] =>
                                    [astat] => 0
                                    [pstat] => 0
                                    [membership] => 0
                                    [f3_min] => 18
                                    [f3_max] => 80
                                    [f4_country] => 0
                                    [f4_state] => 0
                                    [f4_city] => 0
                                    [f4_zip] =>
                                    [photo] => 0
                                )

maverick

  • Administrator
  • Veteran Member
  • *****
  • Posts: 3005
  • Karma: +210/-7
    • Maverick Webworks
Re: Unknown column 'f1' in 'field list'
« Reply #1 on: September 09, 2017, 03:53:49 AM »

Refer to the online documentation:
http://www.datemill.com/etano/wiki/doku.php?id=admin:setup#profile_fields

And look for the following:

Caution - the first 4 profile fields should not be deleted as they are key profile elements that are integrated through-out the script. You can edit them but just be careful not to delete them.

You shouldn't have deleted these profile fields but instead edited or disabled them. By deleting them you've really messed the script up and there's really no advice or instructions I can provide to fix or restore it, other than reinstalling the script.

Fusion Responsive Template & Free Mods
http://www.maverickwebworks.com
DO NOT PM me asking for personal help. Post your problem or request in the forums so the entire community can contribute and benefit.

wre2wre

  • Confirmed Member
  • **
  • Posts: 5
  • Karma: +0/-0
Re: Unknown column 'f1' in 'field list'
« Reply #2 on: September 09, 2017, 04:28:56 AM »
i make new fields at the database `dsb_profile_fields2` and renamed them as f1 and f2 the same valuew as previews