Advertisement:

Author Topic: database columns  (Read 170 times)

Offline Dave J

  • Full Member
  • ***
  • Posts: 450
    • The Hobby Workshop
database columns
« on: February 17, 2021, 07:04:30 AM »
Hi all

I'm using SMF 2.0.18
PHP 7.0

I was looking at the smf_members table today and did a compare with a previous version and I noticed that there was a difference in the columns. The code below shows the columns that I mean.

Code: [Select]
`facebook` varchar(45) NOT NULL DEFAULT '',
  `twitter` varchar(45) NOT NULL DEFAULT '',
  `googleplus` varchar(45) NOT NULL DEFAULT '',
  `linkedin` varchar(45) NOT NULL DEFAULT '',
  `youtube` varchar(45) NOT NULL DEFAULT '',
  `myspace` varchar(45) NOT NULL DEFAULT '',
  `github` varchar(45) NOT NULL DEFAULT '',
  `vk` varchar(45) NOT NULL DEFAULT '',
  `spring` varchar(45) NOT NULL DEFAULT '',
  `fquick` varchar(45) NOT NULL DEFAULT '',


I have now found where they came from. At some stage I installed 'Add Social Media Icons to Profiles v1.2.0'

I don't have that mod installed now so can I remove the columns from the table without causing any serious issues?

Thanks for any replies
« Last Edit: February 17, 2021, 07:18:55 AM by Dave J »
All the Quiz info is here

Offline vbgamer45

  • Customizer
  • SMF Super Hero
  • *
  • Posts: 23,474
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: database columns
« Reply #1 on: February 17, 2021, 07:48:03 AM »
Yes you can. they are not standard columns as long as you removed the mod should be ok.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline Dave J

  • Full Member
  • ***
  • Posts: 450
    • The Hobby Workshop
Re: database columns
« Reply #2 on: February 17, 2021, 07:54:10 AM »
Yes you can. they are not standard columns as long as you removed the mod should be ok.

Thanks VB much appreciated
All the Quiz info is here