1.4.1 RC1 - Error: Table 'faqdataold' already exists

fwhamm · Post by **fwhamm** » Thu Aug 05, 2004 8:25 am

Hallo Thorsten,

habe eine Installation von 1.3.9 auf 1.4.1 RC 1 aktualisiert - problemlos.
Bei der zweiten Installation brach das Update Script ab:

Code: Select all

Query:
ALTER TABLE compliance_faqdata RENAME faqdataold

Beide Installationen verweisen auf dieselbe Datenbank - jede mit einem anderen Tabellenprefix.
Meine Vermutung:

Bei dem Update wird eine Sicherungstabelle faqdataold angelebt
Die hat jedoch keinen Tabellenprefix
Bei dem zweiten Update in derselben DB knallts

KÃ¶nntest Du das bitte mal Ã¼berprÃ¼fen?

Bitte auch noch in die documentation.en.html aufnehmen, dass die Sicherungstabellen angelegt werden. Oder werden die nur temporÃ¤r gebraucht und wurden vergessen zu droppen?

Werde jetzt die DB-Sicherung der 2. DB zurÃ¼ckspielen, die Tabellen faqdataold und faqfragenold droppen und dann das Updatescript nochmal losjagen.

EDIT fwhamm: Jetzt brach das Updatescript ab, weil die Tabelle tempfaqdata bereits vorhanden war...

Post by **Thorsten** » Thu Aug 05, 2004 9:26 am

Hi,

stimmt, die temporÃ¤ren Tabellen werden nicht gelÃ¶scht und dann knallts.

Ich werde das fixen.

bye
Thorsten

AndrewB · Post by **AndrewB** » Wed Oct 06, 2004 4:11 pm

Hi Thorsten,

I have also just had this problem

I have 2 production 1.3.13 systems and one test 1.4.2 RC system

I was planning on upgrading one of my production systems to 1.4.2 once the final was released. So I built a test 1.3.13 system (table prefix 1313) and made it a duplicate of my production system. All looked good.

I downloaded the 1.4.2 RC3 and tried to upgrade the 1313 system. In Step 5 of the update.php I got an error about
Error: Table 'faqdataold' already exists

after deleting faqdataold and running step 5 again then I got messages about
table 1313faqrights does not exist

I should have stopped here I know!, but I continued on to try to make step 5 continue.
I had to delete fqdataold, faqfragenold and tempfaqdata tables
and add dummy tables for 1313faqrights, 1313faqstatistik and 1313faqdataold

but once step 5 was complete my tables were updated but 1313faqdata was empty

So, my questions are:

What tables should be removed prior to performing an upgrade?

Why doesn't the upgrade script delete temporary tables?

thanks for any help.

I am now rebuilding my test system and making it a copy of my production system again for a future test..

AndrewB · Post by **AndrewB** » Wed Oct 06, 2004 6:42 pm

Update:

I just tried again and it failed again

The first error I get is this:

Error: Unknown table '1313faqdataold'

Looking in phpMyAdmin I see that table 1313faqdata exists and has 120 rows.

However there is also a new table faqdataold and that has 120 rows.

It looks like the update script created faqdataold and used that but then tries to delete 1313faqdataold

You should add the database prefix to all places faqdataold is used!! Also check the faqfragen also as I had problems with that earlier.

Post by **Thorsten** » Wed Oct 06, 2004 7:05 pm

Hi Andrew,

you're right, there's a bug inside the update part from 1.3 to 1.4. I'll fix it as soon as possible.

bye
Thorsten

Post by **Thorsten** » Wed Oct 06, 2004 7:11 pm

Hi Andrew,

I fixed your bug and added the table prefix to all temporary tables we need during the update.

bye
Thorsten

AndrewB · Post by **AndrewB** » Wed Oct 06, 2004 7:20 pm

great!

for now. I manually edited and run the SQL statements that didn't run in the update.php file. My upgraded test system looks good now. Now I just have to rearrange all the categories and upload my templates