Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Community Information Center
News and Community Announcements
Read this thread - Forum database issues
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="vansmith" data-source="post: 1572446" data-attributes="member: 71075"><p>Now for the technical (as best I can): each post is stored in a row in a database (think of a row in an Excel or Numbers document). Each row has multiple columns that need to be filled in with values. In the post by bobtomay, this includes a post id, a user agent string, an ip, and a date (this goes for all people but I'll use his post with the error as an example). One of these columns has to have a value that no other row has which, according to the error, is the post id column. This makes sense - people can have the same IP, user agent and can post at exactly the same time but each post is unique so each row will have a unique post id. This is why the post id is a 'primary key.'</p><p></p><p>The error is quite simple: it's effectively saying that the post id for bobtomay's post is the same as another in the database. In other words, his post id is the same as someone else's. This throws an error since his post id has to be unique (otherwise, his post would overwrite someone else's).</p><p></p><p>Think of it this way - people in a country can share a birthday, a name, an address, etc. but no two people can share something like a passport number. In this error, bobtomay's post is sent to the database with the same "passport number" as someone else which throws an error.</p><p></p><p>In case anyone wanted to know.</p></blockquote><p></p>
[QUOTE="vansmith, post: 1572446, member: 71075"] Now for the technical (as best I can): each post is stored in a row in a database (think of a row in an Excel or Numbers document). Each row has multiple columns that need to be filled in with values. In the post by bobtomay, this includes a post id, a user agent string, an ip, and a date (this goes for all people but I'll use his post with the error as an example). One of these columns has to have a value that no other row has which, according to the error, is the post id column. This makes sense - people can have the same IP, user agent and can post at exactly the same time but each post is unique so each row will have a unique post id. This is why the post id is a 'primary key.' The error is quite simple: it's effectively saying that the post id for bobtomay's post is the same as another in the database. In other words, his post id is the same as someone else's. This throws an error since his post id has to be unique (otherwise, his post would overwrite someone else's). Think of it this way - people in a country can share a birthday, a name, an address, etc. but no two people can share something like a passport number. In this error, bobtomay's post is sent to the database with the same "passport number" as someone else which throws an error. In case anyone wanted to know. [/QUOTE]
Verification
Post reply
Forums
Community Information Center
News and Community Announcements
Read this thread - Forum database issues
Top