Previous Thread
Next Thread
Print Thread
Rate Thread
Joined: Feb 2003
Posts: 174
Member
Member
Joined: Feb 2003
Posts: 174
Hi,
As the title says, Ive moved my forum but upon adding the database again I seem to have done something wrong and i think i have duplicate entries now.

When trying to make a post I get the following error:

Script: /var/www/website.co.uk/forum/addpost.php
Line#: 873
SQL Error: Duplicate entry '0' for key 1
SQL Error #: 1062
Query: INSERT INTO w3t_Posts (B_Board,B_Parent,B_Main,B_Posted,B_Last_Post,B_IP,B_Subject,B_Body,B_Kept,B_Status,B_Approved,B_Icon,B_Reged,B_Poll,B_Replies,B_Topic,B_Convert,B_PosterId,B_AnonName,B_Sticky,B_ParentUser,B_CalDay,B_CalMonth,B_CalYear,B_AddSig) VALUES ('2','0','0','1145769428','1145769428','192.168.0.6','test','testing',' ','O','yes','book.gif','y','','0',1,'markup','2','','0','','','','','1')

Also when trying to send a PM, I get this error message:

Script: /var/www/website.co.uk/forum/sendmessage.php
Line#: 224
SQL Error: Duplicate entry '0' for key 1
SQL Error #: 1062
Query: INSERT INTO w3t_Messages (M_Uid,M_Status,M_Subject,M_Sender,M_Message,M_Sent) VALUES ('10062', 'N', 'test', '2', 'testing', 1145769821)

Any guru's out there know whats wrong or how I can fix this please?

Sponsored Links
Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
hmmm, you might try:

REPAIR TABLE `w3t_Posts`

and

REPAIR TABLE `w3t_Messages`


- Allen wavey
- What Drives You?
Joined: Feb 2003
Posts: 174
Member
Member
Joined: Feb 2003
Posts: 174
Hey,
Thanks for the reply... the SQL command executed fine but still get the same error.

Any other idea's please?

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
hmmm... what version forum are you running? I didn't notice the copyright.


- Allen wavey
- What Drives You?
Joined: Feb 2003
Posts: 174
Member
Member
Joined: Feb 2003
Posts: 174
good point, i dont know because it was setup for me... My membership has now expired but it is a recent version.

Sponsored Links
Joined: Feb 2003
Posts: 174
Member
Member
Joined: Feb 2003
Posts: 174
I have found another site which explains how to fix it but I dont understand mysql and dont know how to fix this. Can someone take a look please and tell me what to do?

http://www.mambers.com/showthread.php?p=164114

Joined: Mar 2000
Posts: 21,079
Likes: 3
I type Like navaho
I type Like navaho
Joined: Mar 2000
Posts: 21,079
Likes: 3
hmmm... it would help to know what version you are running - if you haven't updated since installing it could be version 6.4.1 (or older) - lots of bugs fixed since then.


- Allen wavey
- What Drives You?
Joined: Feb 2003
Posts: 174
Member
Member
Joined: Feb 2003
Posts: 174
6.4.1 sounds familiar but i dont have access to the members section anymore to download the latest version because my membership has expired and i cant afford to renew it. So I'll have to make to with what ive got already.

Do you have any idea's how to fix this? it's been like this for ages now and im totally stumped without you guys.

Joined: Feb 2003
Posts: 174
Member
Member
Joined: Feb 2003
Posts: 174
just found out it's version 6.5.2. It shows that version in the control panel.

Joined: Feb 2003
Posts: 174
Member
Member
Joined: Feb 2003
Posts: 174
surely someone must know how to fix this?

Sponsored Links
Joined: May 1999
Posts: 3,039
Guru
Guru
Offline
Joined: May 1999
Posts: 3,039
What version of mysql is running on the new server? This looks like a bit more than database corruption. Key 1 in both of those tables is the autoincrement field, and it's trying to put 0 in that field instead of the actual next number.


UBB.threads Developer
Joined: Feb 2003
Posts: 174
Member
Member
Joined: Feb 2003
Posts: 174
Hi,
Sorry ive been away on holiday and have just got back.

The version is MySQL version 4.0.24


Link Copied to Clipboard
Donate Today!
Donate via PayPal

Donate to UBBDev today to help aid in Operational, Server and Script Maintenance, and Development costs.

Please also see our parent organization VNC Web Services if you're in the need of a new UBB.threads Install or Upgrade, Site/Server Migrations, or Security and Coding Services.
Recommended Hosts
We have personally worked with and recommend the following Web Hosts:
Stable Host
bluehost
InterServer
Visit us on Facebook
Member Spotlight
isaac
isaac
California
Posts: 1,157
Joined: July 2001
Forum Statistics
Forums63
Topics37,573
Posts293,925
Members13,849
Most Online5,166
Sep 15th, 2019
Today's Statistics
Currently Online
Topics Created
Posts Made
Users Online
Birthdays
Top Posters
AllenAyres 21,079
JoshPet 10,369
LK 7,394
Lord Dexter 6,708
Gizmo 5,833
Greg Hard 4,625
Top Posters(30 Days)
Top Likes Received
isaac 82
Gizmo 20
Brett 7
WebGuy 2
Morgan 2
Top Likes Received (30 Days)
None yet
The UBB.Developers Network (UBB.Dev/Threads.Dev) is ©2000-2024 VNC Web Services

 
Powered by UBB.threads™ PHP Forum Software 8.0.0
(Preview build 20240430)