FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum Development » Bug Reports » duplicate key
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
icon8.gif  duplicate key [message #28393] Fri, 21 October 2005 11:32 Go to next message
enunes is currently offline  enunes   Brazil
Messages: 2
Registered: October 2005
Location: BRASIL
Karma: 0
Junior Member
Hi, i cant solve this problem bellow. I have tried everything. Please, help me. I'm using postgresql with egroupware 1.0.0.9 1.0.0.0.9.

Thanks

/var/www/html/egroupware/fudforum/2460875652/index.php:248
/var/www/html/egroupware/fudforum/2460875652/index.php:385
/var/www/html/egroupware/fudforum/2460875652/theme/default/m sg.php:1007
/var/www/html/egroupware/fudforum/2460875652/index.php:436
) : ERROR: duplicate key viola a restrição de unicidade "phpgw_fud_read_thread_id_key"
Query: INSERT INTO phpgw_fud_read (last_view, msg_id, thread_id, user_id) VALUES(1129837959, 9, 4, 2)
Server Version:

[Updated on: Fri, 21 October 2005 12:00]

Report message to a moderator

Re: duplicate key [message #28635 is a reply to message #28393] Wed, 02 November 2005 23:00 Go to previous messageGo to next message
ruzam is currently offline  ruzam   Canada
Messages: 44
Registered: July 2005
Karma: 0
Member
Same problem, adding avatar image to more than one gallery.

For that matter, what is the purpose of fud26_avatar_i_i index on fud26_avatar table? A far as I can tell, the avatar img field is never used as a key.

Making DB maintain an index is wasting cycles (and causing a bug).

Report message to a moderator

Re: duplicate key [message #28650 is a reply to message #28635] Thu, 03 November 2005 15:38 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
It is not causing a bug, those are 2 completely different tables. This index exists for the purpose of preventing duplicate avatars.

FUDforum Core Developer

Report message to a moderator

Re: duplicate key [message #28652 is a reply to message #28650] Thu, 03 November 2005 15:48 Go to previous messageGo to next message
ruzam is currently offline  ruzam   Canada
Messages: 44
Registered: July 2005
Karma: 0
Member
So what if you want to include the same Avatar in two diferent galleries?

Report message to a moderator

Re: duplicate key [message #28653 is a reply to message #28652] Thu, 03 November 2005 15:54 Go to previous messageGo to next message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
The gallery name would modify the file name and there would not be a conflict.

FUDforum Core Developer

Report message to a moderator

Re: duplicate key [message #28654 is a reply to message #28653] Thu, 03 November 2005 16:25 Go to previous messageGo to next message
ruzam is currently offline  ruzam   Canada
Messages: 44
Registered: July 2005
Karma: 0
Member
Well, first I don't think FUD modifies the file name (properly anyway). Attempting to select an existing avatar into a new gallery just seems to muck things up.

Second what you're describing may apply to custom avatars which are automatically named by FUD to match the database id. Exactly how are you planning to modify the name of built Avatars?

Third, your suggesting to duplicate the avatar data at the cost of increased storage, when in fact zero extra storage is required to simply allow the same image in multiple galleries.

Report message to a moderator

Re: duplicate key [message #28677 is a reply to message #28654] Fri, 04 November 2005 22:27 Go to previous message
Ilia is currently offline  Ilia   Canada
Messages: 13241
Registered: January 2002
Karma: 0
Senior Member
Administrator
Core Developer
You're right, I've reviewed the code and there is little point in forcing unique filenames. Index was removed in CVS.

FUDforum Core Developer

Report message to a moderator

  Switch to threaded view of this topic Create a new topic Submit Reply
Previous Topic: Initiating mysql_connect (v.2.7.3)
Next Topic: 2.7.3 - editing a group in the admin groups manager
Goto Forum:
  

-=] Back to Top [=-
[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Nov 21 19:41:43 GMT 2024

Total time taken to generate the page: 0.02705 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software