News:

SMF 2.1.4 has been released! Take it for a spin! Read more.

Main Menu

Field 'img_name' doesn't have a default value

Started by Yikesfactor, September 22, 2018, 06:13:37 AM

Previous topic - Next topic

Yikesfactor

I mistakenly put a url into the Replacement Board Title image field, thinking it was for the top title. I took it out again.

Now trying to create a new board, I get this:


Field 'img_name' doesn't have a default value
File: /home/azrapeyq/public_html/writersanctum.com/Sources/Subs-Boards.php
Line: 794


Now what have I done wrong? How do I fix it.
Version 2.0.15

Used phpBB before, new to SMF.

I know enough to be dangerous.
Breaking things is my specialty.

Kindred

sounds like a problem with a mod, since I don't think that is part of the core.
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Yikesfactor

Quote from: Kindred on September 22, 2018, 09:04:11 AM
sounds like a problem with a mod, since I don't think that is part of the core.

Ok thanks. I'll remove the mod then.
Version 2.0.15

Used phpBB before, new to SMF.

I know enough to be dangerous.
Breaking things is my specialty.

Yikesfactor

Uninstalled the mod.

It didn't fix the problem. Still get the error message.

Modifying an existing board works fine. Just cant add a new one.
Version 2.0.15

Used phpBB before, new to SMF.

I know enough to be dangerous.
Breaking things is my specialty.

vbgamer45

Alter your smf_boards database struture in phpmyadmin change the default value of img_name column to have a default value of empty and allow null instead not null for the column
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

Yikesfactor

Quote from: vbgamer45 on September 22, 2018, 09:38:31 AM
Alter your smf_boards database struture in phpmyadmin change the default value of img_name column to have a default value of empty and allow null instead not null for the column

Found it.

Was set to none, changed to null. Is that correct?
Version 2.0.15

Used phpBB before, new to SMF.

I know enough to be dangerous.
Breaking things is my specialty.

vbgamer45

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

Yikesfactor

Quote from: vbgamer45 on September 22, 2018, 09:47:53 AM
Yes that should work.

Thanks. Done.

Ended up having to change all 3 img feilds, but that did the trick.

Thanks everyone. :)
Version 2.0.15

Used phpBB before, new to SMF.

I know enough to be dangerous.
Breaking things is my specialty.

Kindred

I was reading quickly from my mobile... so I missed the fact that it was the standard "no default value" error...

  incidentally - it's an issue with your host's configuration -- they have mySQL STRICT mode turned on...
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Yikesfactor

Quote from: Kindred on September 22, 2018, 10:32:50 AM
I was reading quickly from my mobile... so I missed the fact that it was the standard "no default value" error...

  incidentally - it's an issue with your host's configuration -- they have mySQL STRICT mode turned on...

Is that good or bad?

What is recommended? I can ask them to change it.

The host had a crash earlier in the week, and a lot of settings seem to have been lost, or returned to defaults.
Version 2.0.15

Used phpBB before, new to SMF.

I know enough to be dangerous.
Breaking things is my specialty.

Kindred

It'snot good or bad... it does mean that you may encounter the same issue with various mods
Слaва
Украинi

Please do not PM, IM or Email me with support questions.  You will get better and faster responses in the support boards.  Thank you.

"Loki is not evil, although he is certainly not a force for good. Loki is... complicated."

Yikesfactor

Quote from: Kindred on September 22, 2018, 09:34:09 PM
It'snot good or bad... it does mean that you may encounter the same issue with various mods

I mentioned it to the host, and they asked if there was still a problem, so they might have changed it now. No change though to other issues.
Version 2.0.15

Used phpBB before, new to SMF.

I know enough to be dangerous.
Breaking things is my specialty.

Advertisement: