| View previous topic :: View next topic |
| Author |
Message |
Blue
Joined: 04 May 2005
Posts: 13801
Location: Feel my Kappa
|
 Posted: Sun Nov 08, 2009 9:38 am Post subject: Trouble accessing the forums |
 |
|
Moontoon just told me that she's had problems coming to the forums, since this happens when she tries. And if tries to see her own posts, this happens.
So what's going on?
_________________
[My youtube videos] |
|
| Back to top |
|
 |
Moontoon
Joined: 17 Aug 2006
Posts: 9439
Location: Sweden
|
|
| Back to top |
|
|
Blue
Joined: 04 May 2005
Posts: 13801
Location: Feel my Kappa
|
| Posted: Sun Nov 08, 2009 9:43 am Post subject: |
|
|
Might as well use the topic to ask what was that error about
_________________
[My youtube videos] |
|
| Back to top |
|
|
Lunar Eclipse
Administrator
Joined: 21 May 2004
Posts: 21368
Location: U.S.A.
|
| Posted: Sun Nov 08, 2009 10:28 am Post subject: |
|
|
I think I saw the same thing once a looooong time ago, but I assume it's just some random fluke thing that no one can really put a stop to.
_________________
 |
|
| Back to top |
|
|
Moontoon
Joined: 17 Aug 2006
Posts: 9439
Location: Sweden
|
|
| Back to top |
|
|
Shadowfox
Moderator
Joined: 29 Jul 2004
Posts: 21725
Location: Make mine Mayday! 'nuff said...
|
|
| Back to top |
|
|
Laogeodritt
Joined: 13 Aug 2004
Posts: 15102
Location: Let me play not Man's music, but the music of Nature herself!
|
| Posted: Mon Nov 09, 2009 7:11 pm Post subject: |
|
|
Technical explanation:
Since conducting fulltext searches is relatively resource-intensive, PHPBB caches the results of searches in case someone makes the same search again. This is what that MySQL statement does - it tells the MySQL database server to store data corresponding to a search.
The error is that there is a duplicate ID. In SQL databases, you can define a "primary key" as being a certain column in a database table; in that case, each row has to have a UNIQUE value in the primary-key column. This is often used to assign unique IDs to rows for retrieval.
Here, for some reason, PHPBB specified, in that primary-key column, a key that was already used in that search-caching table. An INSERT statement was used (meaning "insert a new row into the table"), not an UPDATE statement (which modifies existing rows); since a primary key has to be unique, it gave out an error since it can't create a new row with a duplicatevalue for the primary key.
Why this happened, I couldn't tell you. Odd bug that nobody ever bothers trying to trace, or even is capable of tracing.
_________________
Cogito ergo sum. | Writers' Guild |
|
| Back to top |
|
|
|
