Field 'lastView' doesn't have a default value

Started by JimM, October 21, 2016, 10:48:14 PM

Previous topic - Next topic

JimM

Finally upgraded my 1.1.xx forum to 2.1.12.  The upgrade went well without any errors but now this is what I get attempting to read an individual message.  It's been so long since I have done anything with this that I thought I would ask the experts before I go digging around myself.

Field 'lastView' doesn't have a default value
File: /home/ghostjim/public_html/smf/Sources/Display.php
Line: 849
Jim "JimM" Moore
Former Support Specialist

vbgamer45

lastView doesn't seem to be part of the default SMF probably a mod
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

JimM

I did have the Topic View Mod in the old version.
Jim "JimM" Moore
Former Support Specialist

vbgamer45

That would probably be it.
The database column for lastview needs to be altered and have a default value set for it.
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

JimM

Thanks vbgamer45.  That was it.  It was actually the old Topic Log mod.  I dropped those columns as the mod is no longer needed and the error is gone.
Jim "JimM" Moore
Former Support Specialist

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

Kindred

actually, as it turns out, that error is a bug in the mySQL version...   having your host upgrade mySQL will also solve the issue.

(do a google search on the "doesn't have last value" error)
Сл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."

Advertisement: