[Devel] [ openser-Bugs-1462013 ] openser_mysql.sh reinstall fails

[SourceForge.net]

Bugs item #1462013, was opened at 2006-03-31 13:20
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1462013&group_id=139143

Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: tools
Group: None
Status: Open
Resolution: None
Priority: 7
Submitted By: Klaus Darilion (klaus_darilion)
Assigned to: Nobody/Anonymous (nobody)
Summary: openser_mysql.sh reinstall fails

Initial Comment:
Hi!

i tried to update today from 1.0 to cvs and it failed:

server1:~# openser_mysql.sh reinstall
MySql password for root:
creating backup database
dumping table content (openser)
dropping table (openser)
creating new structures
creating database openser ...
restoring table content
ERROR 1062 (23000) at line 216: Duplicate entry '' for
key 2
reinstall: restoring table failed

The strange thing is, that it copied one subscriber
from the backup subscriber table to the new subscriber
table, but:
1. when copying the second subscriber it failed
2. The username of the subscribers (which was copied)
was changed (from user101 to username101). Very strange.

I have no time to debug it now, but I thougt it would
be good to leave a note on the bugtracker.


----------------------------------------------------------------------

You can respond by visiting: 
https://sourceforge.net/tracker/?func=detail&atid=743020&aid=1462013&group_id=139143