From: George C. <ga...@sp...> - 2003-09-02 13:35:59
|
-----Original Message----- From: George Clark [mailto:ga...@sp...] Sent: Tuesday, September 2, 2003 01:26 PM To: sh...@lo... Cc: sla...@li...urceforge Subject: Re: [Slashcode-general] Problems with slash installation Hi Shane, > > I'm trying to migrate off of T-80 onto the latest R113 tag, and I'm > > running into two issues. I've believe that I've proven that this fir= st > > one is an error in my existing SQL tables somewhere, but I cannot fin= d > > it. As long as I don't "migrate" my existing data, then all is well.= > > define "migrate" > I'm using the procedure that you provided quite some time ago - running a= dump --add-drop-table on the database, installing the new site, restorin= g the database, running the upgrades on the tables, re-installing templat= es & plugins, etd. Works well except for this one issue. > > > > Any suggestions on what might be causing this? > > There was a problem with this, a while back. Look through the bug repor= ts. Will do... > I don't recall whether it was foreign key releated, or not. But I'd bet= you it > was. I'll check the keys more carefully. Other than a manual check, any othe= r suggestions? I did do a reasonably careful check of all the table definitions, suspect= ing that maybe a column was missed. Other than column ordering, it was t= he same. Except for the topics table that has name defined as "char" in = one place and "varchar" in another. I corrected that anonomly but no cha= nge. > define "restore". What exactly are you trying to do? Are you mysql dump= ing > in/out of the db's? Ran a new install, and then once I confirmed all was working correctly, I= did a mysql dump. Did the migration, checkboxes went away. Then I hav= e been manually restoring from the "new install" dump, to try to see if o= ne cluster of tables might restore the checkboxes. ie. Restored the Sec= tion/Topic related tables to see if the boxes would come back. ... no j= oy. I assume that the problem would be somewhere in section, topics and sect= ion_topics? And maybe the other section_* and topic_* tables? It would h= elp to narrow this down just a bit. > > What versions of perl, slash, mysql, etc, are you using? perl 5.8.0-17 mysql 4.0.13 slash R-tag 113 debian (Knoppix) packages are from the debian "testing" branch. > If you're using mysql4: > > Please put > > SET FOREIGN_KEY_CHECKS=3D0; Good hint! I didn't have that one. > > to the start of the dump file(s) before you import them into your DB. > > Shane Thanks Shane, I'll poke around more tonight to see if I can figure it out. George |