FUDforum: Bug Reports » SQL Error: Unique key violated for forum_read and forum

Home » FUDforum Development » Bug Reports » SQL Error: Unique key violated for forum_read and forum_notify

Show: Today's Messages :: Polls :: Message Navigator

Re: SQL Error: Unique key violated for forum_read and forum_notify [message #27867 is a reply to message #27842]

Wed, 28 September 2005 23:13

awadallah

Messages: 11
Registered: September 2005
Location: Palo Alto, CA

Karma:

Junior Member

interesting, I double checked in the Admin Control Panel, and it says:

Use MySQL 4.1 Performance Options: YES
If enabled the forum will use various query optimization tricks available through MySQL 4.1.2+ functionality.

Is that the setting you referring too ?

Also this is a paste of the GLOBALS.php file in case that helps:

<?php
/**
* copyright : (C) 2001-2004 Advanced Internet Designs Inc.
* email : forum(at)prohost(dot)org
* $Id: GLOBALS.php,v 1.44 2004/11/24 19:53:33 hackie Exp $
*
* This program is free software; you can redistribute it and/or modify it
* under the terms of the GNU General Public License as published by the
* Free Software Foundation; either version 2 of the License, or
* (at your option) any later version.
**/

$INCLUDE = "//FUDforum/include/";
$WWW_ROOT = "http://egypt-chat.asfory.com/";
$WWW_ROOT_DISK = "//egypt_chat/";
$DATA_DIR = "//FUDforum/";
$ERROR_PATH = "//FUDforum/errors/";
$MSG_STORE_DIR = "//FUDforum/messages/";
$TMP = "//FUDforum/tmp/";
$FILE_STORE = "//FUDforum/files/";
$FORUM_SETTINGS_PATH = "//FUDforum/cache/";

$FUD_OPT_1 = 1731638323;
$FUD_OPT_2 = 692990317;
$FUD_OPT_3 = 5216;

$CUSTOM_AVATAR_MAX_SIZE = 10000; /* bytes */
$CUSTOM_AVATAR_MAX_DIM = "64x64"; /* width x height (pixels) */

$COOKIE_PATH = "/egypt_chat/";
$COOKIE_DOMAIN = ".asfory.com";
$COOKIE_NAME = "fud_session_1111565409";
$COOKIE_TIMEOUT = 604800; /* seconds */
$SESSION_TIMEOUT = 1800; /* seconds */

$DBHOST = "mysql";
$DBHOST_USER = "HIDDEN";
$DBHOST_PASSWORD = "HIDDEN";
$DBHOST_DBNAME = "fudforum";
$DBHOST_TBL_PREFIX = "fud26_"; /* do not modify this */

$FUD_SMTP_SERVER = "";
$FUD_SMTP_TIMEOUT = 10; /* seconds */
$FUD_SMTP_LOGIN = "";
$FUD_SMTP_PASS = "";

$ADMIN_EMAIL = "egyptchat(at)asfory(dot)com";

$PRIVATE_ATTACHMENTS = 0; /* int */
$PRIVATE_ATTACH_SIZE = 1000000; /* bytes */
$MAX_PMSG_FLDR_SIZE = 100000; /* bytes */

$FORUM_IMG_CNT_SIG = 2; /* int */
$FORUM_SIG_ML = 256; /* int */

$UNCONF_USER_EXPIRY = 30; /* days */
$MOVED_THR_PTR_EXPIRY = 5; /* days */

$MAX_SMILIES_SHOWN = 15; /* int */
$DISABLED_REASON = "Temporarily offline; please come back soon!";
$POSTS_PER_PAGE = 40;
$THREADS_PER_PAGE = 40;
$WORD_WRAP = 0;
$NOTIFY_FROM = "egyptchat(at)asfory(dot)com"; /* email */
$ANON_NICK = "Anonymous User";
$FLOOD_CHECK_TIME = 60; /* seconds */
$SERVER_TZ = "America/Los_Angeles"; /* timezone code from tz.inc */
$SEARCH_CACHE_EXPIRY = 172800; /* seconds */
$MEMBERS_PER_PAGE = 40;
$POLLS_PER_PAGE = 40;
$THREAD_MSG_PAGER = 5;
$GENERAL_PAGER_COUNT = 15;
$EDIT_TIME_LIMIT = 60;
$LOGEDIN_TIMEOUT = 15; /* minutes */
$MAX_IMAGE_COUNT = 10;
$STATS_CACHE_AGE = 600; /* seconds */
$FORUM_TITLE = "Egypt Chat by Asfory";
$MAX_LOGIN_SHOW = 25;
$MAX_LOCATION_SHOW = 40;
$SHOW_N_MODS = 2;

$TREE_THREADS_MAX_DEPTH = 15;
$TREE_THREADS_MAX_SUBJ_LEN = 75;

$REG_TIME_LIMIT = 60; /* seconds */
$POST_ICONS_PER_ROW = 9; /* int */
$MAX_LOGGEDIN_USERS = 50; /* int */
$PHP_COMPRESSION_LEVEL = 9; /* int 1-9 */
$MNAV_MAX_DATE = 90; /* days */
$MNAV_MAX_LEN = 256; /* characters */

$RDF_MAX_N_RESULTS = 100; /* int */
$RDF_AUTH_ID = 0; /* 0 - treat as anon user, >0 treat like specific forum user */

$PDF_PAGE = "letter"; /* string */
$PDF_WMARGIN = 15; /* int */
$PDF_HMARGIN = 15; /* int */
$PDF_MAX_CPU = 60; /* seconds */

/* DO NOT EDIT FILE BEYOND THIS POINT UNLESS YOU KNOW WHAT YOU ARE DOING */

require($INCLUDE.'core.inc');
?>

Report message to a moderator

[Message index]

		SQL Error: Unique key violated for forum_read and forum_notify By: awadallah on Wed, 28 September 2005 10:53
		Re: SQL Error: Unique key violated for forum_read and forum_notify By: Ilia on Wed, 28 September 2005 13:57
		Re: SQL Error: Unique key violated for forum_read and forum_notify By: awadallah on Wed, 28 September 2005 20:39
		Re: SQL Error: Unique key violated for forum_read and forum_notify By: Ilia on Wed, 28 September 2005 22:45
		Re: SQL Error: Unique key violated for forum_read and forum_notify By: awadallah on Wed, 28 September 2005 23:13
		Re: SQL Error: Unique key violated for forum_read and forum_notify By: Ilia on Wed, 28 September 2005 23:40
		Re: SQL Error: Unique key violated for forum_read and forum_notify By: awadallah on Thu, 29 September 2005 00:15
		Re: SQL Error: Unique key violated for forum_read and forum_notify By: Ilia on Thu, 29 September 2005 00:22
		Re: SQL Error: Unique key violated for forum_read and forum_notify By: awadallah on Thu, 29 September 2005 00:27
		Re: SQL Error: Unique key violated for forum_read and forum_notify By: Ilia on Thu, 29 September 2005 00:48
		Re: SQL Error: Unique key violated for forum_read and forum_notify By: awadallah on Thu, 29 September 2005 00:48

Previous Topic:	V2.7.0RC1 - thread not displayed in forum list or navigator
Next Topic:	locking/unlocking files crashed the server...

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Nov 25 18:12:18 GMT 2024

Total time taken to generate the page: 0.04856 seconds