FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.

Home » FUDforum » FUDforum Installation Issues » Upgrade Problems
Show: Today's Messages :: Polls :: Message Navigator
Return to the default flat view Create a new topic Submit Reply
forum files unlocked but database problem [message #20004 is a reply to message #19997] Tue, 21 September 2004 08:11 Go to previous messageGo to previous message
Lynky is currently offline  Lynky   Germany
Messages: 38
Registered: May 2003
Location: Germany
Karma:
Member
Hallo,

I've uploaded the 2.5.2 forum files again, created the symlinks to the GLOBALS.php, chmod all the directories with 777 and the files with 666 (including all subdirectories).
So I think the forum files would be ready for another try to upgrade.

Then I deleted the broken forum tables and tried to copy the old tables to the operating database. Everything worked fine but in table fud21_search (prefix because of an earlier FUD-version) mysql throws an exception:

#1062 - Duplicate entry 'das' for key 2

... the only thing is - that is not true! The first 218 Datasets import well, but on this _first_ occurence of the value "das" it throws it.
I can just copy the table with phpMyAdmin oder export and import the SQL into the new database - Although it hangs at this Dataset (when I delete it, it hangs 5 datasets past).

The SQL seems to be OK:

CREATE TABLE `fud21_search` (
  `id` int(10) unsigned NOT NULL auto_increment,
  `word` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `word` (`word`)
) TYPE=MyISAM AUTO_INCREMENT=41460 ;
...
INSERT INTO `fud21_search` VALUES (218, 'schade,');
INSERT INTO `fud21_search` VALUES (219, 'das');
INSERT INTO `fud21_search` VALUES (220, 'solchen');


The Table-Structure is identically with the old structure.

MySQL-server-version: 4.0.20

Any idea to avoid this error?
Thank you in advance,

Lynky (now even more confused)

[Updated on: Tue, 21 September 2004 08:12]

Report message to a moderator

[Message index]
 
Read Message icon4.gif
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: why not a tree-tarball?
Next Topic: can't get into groupmanager
Goto Forum:
  

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

Current Time: Sun Nov 24 00:54:43 GMT 2024

Total time taken to generate the page: 0.09676 seconds