You are not logged in. [Log In] UBB.threads PHP Forum Software Community » Forums » UBB.threads 7 Discussion » Bug Reports
      » Non Bugs » [7.0.2] Unable to post to board...
Register User    Portal Page     Forum List        Calendar     Active Topics     Search     FAQ
Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
1 registered (JPFolks), 38 Guests and 16 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 05/10/05
Posts: 1
Top Posters (30 Days)
Ruben 49
DennyP 24
Gizmo 23
Dunny 17
SteveS 14
AllenAyres 12
dbremer 10
drkknght00 9
SD 9
driv 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#172688 - 01/08/07 03:09 AM [7.0.2] Unable to post to board...
Noxegon Offline
newbie 		Registered: 10/17/06
Posts: 37
 Quote:
Script: /home/vs020b2/public_html/forums/scripts/addpost.inc.php
Line#: 473
SQL Error: Duplicate entry '25749' for key 1
SQL Error #: 1062
Query: INSERT INTO ubbt_POSTS (POST_PARENT_ID,TOPIC_ID,POST_IS_TOPIC,POST_POSTED_TIME,POST_POSTER_IP,POST_SUBJECT,POST_BODY,POST_DEFAULT_BODY,POST_IS_APPROVED,POST_ICON,POST_HAS_POLL,POST_HAS_FILE,POST_MARKUP_TYPE,USER_ID,POST_PARENT_USER_ID,POST_ADD_SIGNATURE,POST_LAST_EDITED_TIME) VALUES ( 25730 , 2901 , 0 , 1168272336 , '89.100.182.164' , 'Re: installing zinc osx 10.3' , 'Test post' , 'Test post' , 1 , 'book.gif' , 0 , 0 , 'markup' , 11 , 68 , 1 , 0 )

Please use your back button to return to the previous page.


The board recently had to be lifted from one server to another. It certainly appeared to be working okay, but it's broken as of this morning - maybe a few days after the move. Suggestions?

http://www.bannister.org/forums/
Top
Express Hosting
Express Hosting "We are the official hosting company of UBB.threads. Ask us about our free migration services to migrate your UBB.threads installation."
#172689 - 01/08/07 03:15 AM Re: [7.0.2] Unable to post to board... [Re: Noxegon]
ntdoc Offline
Registered: 11/09/06
Posts: 3384
Can you post an all new post, or was this an all new post?

Basically MySQL says that exact post already exists so it can't create it. You could edit it, but not create it.

.
Top
#172691 - 01/08/07 03:28 AM Re: [7.0.2] Unable to post to board... [Re: ntdoc]
Noxegon Offline
newbie 		Registered: 10/17/06
Posts: 37
No, you can't reply to a post or start a new topic. I figured it was something like that post already existing. I can't seem to locate the offending post, however. Suggestions?
Top
#172692 - 01/08/07 04:07 AM Re: [7.0.2] Unable to post to board... [Re: Noxegon]
ntdoc Offline
Registered: 11/09/06
Posts: 3384
This may require deletion of your session for PHP.

It also might require some manual SQL changes so I'll leave that to someone with more experience to assist you so that I don't lead you down the wrong path.

I'm sure someone can assist you within the next few hours.

.
Top
#172693 - 01/08/07 05:13 AM Re: [7.0.2] Unable to post to board... [Re: ntdoc]
Gizmo Offline

Registered: 06/05/06
Posts: 14994
Loc: Portland, OR; USA
It's an SQL error, deleting his session won't matter; I've seen this before but forget the fix, so he'll need to wait for Rick to take a gander.
_________________________
Forums: UGN Security & VNC Web Design & Development
UBB.Threads: UBB.Wiki, My UBBSkins, UBB.Sitemaps
Longtime UBB Supporter, UBB Beta Tester & Resident Post-A-Holic.
UBB Modifications, Styling, Coding Services, Disaster Recovery, and more!
Top
#172699 - 01/08/07 11:09 AM Re: [7.0.2] Unable to post to board... [Re: Gizmo]
Rick Offline
Post-a-holic 		Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
That's a bit strange. Basically '25749' is a number that is automatically generated by MySQL as the post id for the post that is being inserted. The auto_increment property is supposed to take care of that. But, that error is saying that post id already exists. I don't think I've ever seen MySQL do that before.

First thing to do would be to find out the actual max post id in the posts table. So try this SQL command:

select max(POST_ID) from ubbt_POSTS
Top
#172700 - 01/08/07 11:22 AM Re: [7.0.2] Unable to post to board... [Re: Rick]
Noxegon Offline
newbie 		Registered: 10/17/06
Posts: 37
25748
Top
#172701 - 01/08/07 11:39 AM Re: [7.0.2] Unable to post to board... [Re: Noxegon]
Rick Offline
Post-a-holic 		Registered: 06/04/06
Posts: 10164
Loc: Aberdeen, WA
Ok, that's very strange. Definitely sounds like MySQL is a bit of sync since when you try to insert a new post, it thinks 25749 is already in there. Perhaps try repairing the table:

repair table ubbt_POSTS
Top
#172702 - 01/08/07 12:14 PM Re: [7.0.2] Unable to post to board... [Re: Rick]
Noxegon Offline
newbie 		Registered: 10/17/06
Posts: 37
That appears to have done the trick.

Number of rows changed from 25729 to 25730...

Richard
Top



Moderator:  AllenAyres, Harold, Ian, Ron M 
Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Custom forum permissions
by ntdoc
05/18/12 02:07 PM
Forum Stats
10489 Members
36 Forums
33841 Topics
181697 Posts

Max Online: 978 @ 06/24/07 11:19 PM
Random Image
Board Rules · Mark all read
Contact Us · UBBCentral · Top