Advertisement:

Author Topic: profile image does not load  (Read 515 times)

Offline Replikacep

  • Jr. Member
  • **
  • Posts: 381
  • Gender: Male
    • Orjinal Cin Kore Telefon lari Rom ve Destek
profile image does not load
« on: April 17, 2019, 04:22:53 PM »
smf 2.1 rc 2

profile image does not load what is your reason

Database Error

Field 'expire_date' doesn't have a default value
Dosya: /home/kuluckad/public_html/Sources/Profile-Modify.php
Satır: 3567

Offline Kindred

  • The Mean One
  • Support Specialist
  • SMF Legend
  • *
  • Posts: 58,063
  • Gender: Male
    • Kindred-999 on GitHub
Re: profile image does not load
« Reply #1 on: April 17, 2019, 05:05:05 PM »
sounds like a mod problem to me.... 

give the column a default value (NULL) in mySQL.
Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

Offline Replikacep

  • Jr. Member
  • **
  • Posts: 381
  • Gender: Male
    • Orjinal Cin Kore Telefon lari Rom ve Destek
Re: profile image does not load
« Reply #2 on: April 18, 2019, 02:50:48 AM »
sounds like a mod problem to me.... 

give the column a default value (NULL) in mySQL.
The site was changed from beta 3 to rc2 the problem started

which table is missing ?

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 70,952
    • StoryBB/StoryBB on GitHub
Re: profile image does not load
« Reply #3 on: April 18, 2019, 03:09:01 AM »
Nothing's missing, this is a mod you had that didn't do things properly in the first place. But we don't know what mods you have...
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline Replikacep

  • Jr. Member
  • **
  • Posts: 381
  • Gender: Male
    • Orjinal Cin Kore Telefon lari Rom ve Destek
Re: profile image does not load
« Reply #4 on: April 18, 2019, 03:44:54 AM »
Nothing's missing, this is a mod you had that didn't do things properly in the first place. But we don't know what mods you have...

re-reset the site unfortunately did not improve.

please help us solve this problem

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 70,952
    • StoryBB/StoryBB on GitHub
Re: profile image does not load
« Reply #5 on: April 18, 2019, 04:07:04 AM »
Please add your Profile-Modify.php file here for me.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 70,952
    • StoryBB/StoryBB on GitHub
Re: profile image does not load
« Reply #6 on: April 18, 2019, 07:35:24 AM »
You need to change the attachments table, go to phpMyAdmin, find smf_attachments, change the expire_date column -> tick the box called 'nullable' and save.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 70,952
    • StoryBB/StoryBB on GitHub
Re: profile image does not load
« Reply #7 on: April 18, 2019, 07:38:13 AM »
I don’t need the SQL, I need you to go change your database.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline Replikacep

  • Jr. Member
  • **
  • Posts: 381
  • Gender: Male
    • Orjinal Cin Kore Telefon lari Rom ve Destek
Re: profile image does not load
« Reply #8 on: April 18, 2019, 07:42:21 AM »
thank you solved problem

Offline Replikacep

  • Jr. Member
  • **
  • Posts: 381
  • Gender: Male
    • Orjinal Cin Kore Telefon lari Rom ve Destek
Re: profile image does not load
« Reply #9 on: April 18, 2019, 07:56:22 AM »
I don’t need the SQL, I need you to go change your database.

Thank you for your help  :)

When I compare the table I looked at another site's database
expire_date not available in another table I guess it would be unnecessary to delete it?


Offline Arantor

  • Resident Overthinker
  • SMF Friend
  • SMF Legend
  • *
  • Posts: 70,952
    • StoryBB/StoryBB on GitHub
Re: profile image does not load
« Reply #10 on: April 18, 2019, 07:56:59 AM »
You have a mod that put it in - unless you know the mod is gone, leave the column there.
Don’t try to tell me that some power can corrupt a person. You haven’t had enough to know what it’s like.

No good deed goes unpunished / No act of charity goes unresented.

Offline Replikacep

  • Jr. Member
  • **
  • Posts: 381
  • Gender: Male
    • Orjinal Cin Kore Telefon lari Rom ve Destek
Re: profile image does not load
« Reply #11 on: April 18, 2019, 08:02:55 AM »
You have a mod that put it in - unless you know the mod is gone, leave the column there.

Modes used in sdanrdat are the same as the modes installed on my site because the system does not have the same mods board.

possibly residues from the SMF 2.0 series