Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Who's Online
3 Registered (Anrui, driv, 1 invisible), 26 Guests and 28 Spiders online.
Key: Admin, Global Mod, Mod
Top Posters
Gizmo 11678
Rick 7551
Ian 4102
Mark S 3969
ntdoc 3102
Sirdude 2041
jgeoff 1876
David Dreezer 1750
driv 1557
AllenAyres 1523
Latest Photos
Carrie - So Very
Testing
Test Photo
4TH of July at the river!
Test shots from D300 part 3
Topic Options
Rate This Topic
#216212 - 08/04/08 08:13 AM [FIXED for 7.3.2] Error message while trying to delete a post
MacW Offline
newbie

Registered: 09/26/04
Posts: 32
Hi,

Using 7.3.1, licensed version.
I tried to delete a post I made a minute ago and received the message below. This problem is reproducible, but seems to happen only on this forum


We encountered a problem. The reason reported was

Script: C:\web\forum\libs\content_rebuild.inc.php
Line#: 349
SQL Error: Incorrect integer value: '' for column 'FORUM_LAST_POSTER_ID' at row 1
SQL Error #: 1366
Query: UPDATE ubbt_FORUMS SET FORUM_LAST_POSTER_ID = '' , FORUM_LAST_TOPIC_ID = '' , FORUM_LAST_POST_ID = '' , FORUM_LAST_POST_TIME = '' , FORUM_LAST_POSTER_NAME = '' , FORUM_LAST_POST_SUBJECT = '' , FORUM_LAST_POST_ICON = '' , FORUM_TOPICS = 2 , FORUM_POSTS = 0 WHERE FORUM_ID = 3


Any idea?


Top
#216234 - 08/05/08 06:23 AM [FIXED for 7.3.2] Re: Error message while trying to delete a post [Re: MacW]
Rick Administrator Offline

*****

Registered: 06/04/06
Posts: 7551
Loc: Aberdeen, WA
It looks like a problem with strict mode. What you can do for now is disable that within MySQL. I'll need to fix this so it doesn't give the error. Running this SQL command should fix it:

SET GLOBAL SQL_MODE=''
_________________________
UBB.threads™ Developer
My Personal Website · StogieSmokers.com

Top


Shout Box

Recent Topics
Anyone tested threads with IE8
by Ian
Today at 09:04 AM
Community Spotlight
by Thelockman
Yesterday at 08:04 AM
Protecting Board from hackers
by duquesne
Yesterday at 04:48 AM
Change New Topic text
by MLD
08/25/08 04:59 PM
Reason for deleting a thread
by MattUK
08/24/08 09:40 PM
Forum Stats
4017 Members
33 Forums
30845 Topics
156628 Posts

Max Online: 978 @ 06/24/07 08:19 PM