News:

Bored?  Looking to kill some time?  Want to chat with other SMF users?  Join us in IRC chat or Discord

Main Menu

Out of range value adjusted for column 'numTopics' at row 1

Started by CapriSkye, November 07, 2005, 03:33:54 AM

Previous topic - Next topic

CapriSkye

I think this has to do with MySQL 5...
I've seen this post, but there are too many files to edit so I gave up.
http://www.simplemachines.org/community/index.php?topic=50865.0

This following error is not the same error as above topic.
Whenever I try to remove a board, or a category, I get the following error:

Out of range value adjusted for column 'numTopics' at row 1
File: D:\website\capriskye\forums\Sources\RemoveTopic.php
Line: 293


I've tried with everything I know but still can't get rid of that.
I also found couple places if somebody wants to read up about it.
http://www.openwin.org/mike/index.php/archives/2005/02/using-strict-mode-to-make-not-null-safe/
http://sourceforge.net/mailarchive/forum.php?thread_id=8881499&forum_id=31882
http://db4free.blogspot.com/2005/10/web-apps-ready-for-mysql-5.html

Compuart

Try Admin -> 'Forum Maintenance' -> 'Recount all forum totals and statistics.'

I think that should solve the problem of not being able to delete boards and categories.
Hendrik Jan Visser
Former Lead Developer & Co-founder www.simplemachines.org
Personal Signature:
Realitynet.nl -> ExpeditieRobinson.net / PekingExpress.org / WieIsDeMol.Com

CapriSkye


NavyGuy

Open up your MySQL configuration file and comment out the sql-mode line, it will disable the strict settings, which should make things work again :)
E-2 Delayed Entry Personnel Specialist,
U.S. Navy

Advertisement: