Tycoon Talk
Become a Big fish!
The number 1 forum for online business!
Post topics, ask questions, share your knowledge.
Tycoon Talk is part of Freelancer.com - find skilled workers online at a fraction of the cost.

The Database Forum


You are currently viewing our The Database Forum as a guest. Please register to participate.
Login



Reply
Old 09-19-2006, 03:15 AM SQL Error
taelmx's Avatar
Novice Talker

Posts: 10
Trades: 0
Ok, I have restored the database, but when I try to make a post or change something on my vbulletin, I get this errror:

Code:
Database error in vBulletin 3.5.4:

Invalid SQL:
INSERT INTO rsforumpost
    (showsignature, allowsmilie, username, userid, title, pagetext, iconid, visible, parentid, threadid, dateline, ipaddress, attach)
VALUES
    (1, 1, 'taelmx', 1, '', 'What.....this isn\'t the right thread....I swear this is a database problem.', 0, 1, 1485, 128, 1158646509, '75.5.41.167', 0);

MySQL Error  : Duplicate entry '0' for key 1
Error Number : 1062
Date         : Monday, September 18th 2006 @ 11:15:09 PM
Script       : http://www.rs-anime.com/forum/newreply.php
Referrer     : http://www.rs-anime.com/forum/showthread.php?t=128
IP Address   : 75.5.41.167
Username     : taelmx
Classname    : vb_database

Code:
Database error in Subdreamer

Invalid SQL: INSERT INTO rs_main_p7_chatterbox (categoryid, username, comment)
                VALUES (1, 'taelmx', 'Well, its not very reliable.') 
Error: Duplicate entry '0' for key 1 
Error number: 1062 
Date: Tuesday 19th of September 2006 06:06:39 AM
File: http://www.rs-anime.com/index.php
taelmx is offline
Reply With Quote
View Public Profile
 
 
Register now for full access!
Old 09-19-2006, 02:01 PM Re: SQL Error
Extreme Talker

Posts: 246
Trades: 3
Perhaps the index (or key) has been changed from the original or intended one. What fields are in "key 1"? If there is a unique index (or key) with one field like userid, or another combination of fields that is not guaranteed to be unique, that might cause you to see what you are seeing.
__________________

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
CouponGuy is offline
Reply With Quote
View Public Profile
 
Old 09-19-2006, 03:13 PM Re: SQL Error
taelmx's Avatar
Novice Talker

Posts: 10
Trades: 0
Well, I think what you are saying is right, but do you know how the change it to the right one?
taelmx is offline
Reply With Quote
View Public Profile
 
Old 09-19-2006, 03:22 PM Re: SQL Error
Extreme Talker

Posts: 246
Trades: 3
phpmyadmin?
__________________

Please login or register to view this content. Registration is FREE
|
Please login or register to view this content. Registration is FREE
CouponGuy is offline
Reply With Quote
View Public Profile
 
Old 09-19-2006, 06:12 PM Re: SQL Error
taelmx's Avatar
Novice Talker

Posts: 10
Trades: 0
Ok, I figured out what the problem was. When I exported it in phpmyadmin from the old server, godaddy said that "AUTO_INCREMENT" couldn't be included in the export. However, doing so made my forums and everything else spit out an error.


Is there a way to export it and import it with AUTO_INCREMENT from MySQL 4.1 to MySQL 4.0? I think Godaddy might have just been saying "no".
taelmx is offline
Reply With Quote
View Public Profile
 
Reply     « Reply to SQL Error
 

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are Off
Pingbacks are Off
Refbacks are Off





   
RSS Feed  Feeds: RSS   JS   XML
RSS Feed  Feeds for this forum: RSS   JS   XML



Page generated in 0.24728 seconds with 12 queries