Update to 2.0.1 failed

Docstone · Post by **Docstone** » Mon Jun 04, 2007 8:37 am

Hi Team!

I just tried to update to 2.0.1 from 1.6.1 and got this error:

Notice: Undefined index: mod_rewrite in D:\Wissensdatenbank\Magna\install\update.php on line 1254

Notice: Undefined index: spamEnableCatpchaCode in D:\Wissensdatenbank\Magna\install\update.php on line 1269
| | | |

DB error: Field 'group_id' doesn't have a default value

Query:

INSERT INTO faq_faqcategory_group (category_id) SELECT DISTINCT id FROM faq_faqcategories

Previous version is:

Code: Select all

phpMyFAQ Version
    phpMyFAQ 1.6.1

what should i do now? i think i roll back to prev. version until you give me some hints for this!

tia,
JÃ¶rg

Post by **Thorsten** » Mon Jun 04, 2007 11:23 am

Hi,

which database do you use?

bye
Thorsten

Docstone · Post by **Docstone** » Mon Jun 04, 2007 11:50 am

hi thorsten!

i'm using:

IIS 5
MySQL - 5.0.22-community-nt
PHP 5.1.2

I'm Using multiple FAQs in this DB. with one of them, an empty one, the update worked without any problems.

i think, there is an error, refilling the old cats in a new table?!

Post by **Thorsten** » Mon Jun 04, 2007 2:26 pm

Hi,

I tested this on my machine here with PHP 5.1.6 and MySQL 5.0.41 and it worked... do you have a backup?

bye
Thorsten

Docstone · Post by **Docstone** » Mon Jun 04, 2007 8:25 pm

sure, i have a backup. i tried to restore an update again, again... but everytime the same error.

asmentioned above, with an empty faq, the update worked fine, but not with any of the filled ones. Maybe you want to have access to the faq an also to phpmyadm? just write a message to me, and i will set up an account for you.

tia,
JÃ¶rg

Post by **Thorsten** » Mon Jun 04, 2007 8:27 pm

Hi,

it's easier to sent me your dump because I can debug here on my system.

bye
Thorsten

Docstone · Post by **Docstone** » Mon Jun 04, 2007 8:56 pm

ok. i do so tomorrow, when i'm back in my office.

thx so long,
jÃ¶rg

Docstone · Post by **Docstone** » Tue Jun 05, 2007 12:22 pm

So, nun auch hier noch mal vielen Dank an Thorsten, der seine kostbare Zeit opferte, um mich mit meinem FAQ auf die Version 2.0.1 upzudaten!

Ich werd mir die Wishlist mal durchsehen

liebe GrÃ¼ÃŸe aus Ã–sterreich & herzlichen Dank,

JÃ¶rg

freeman · Post by **freeman** » Mon Jun 11, 2007 9:58 am

Hallo,

was ist den fÃ¼r dieses Problem die LÃ¶sung gewesen? Ich stoÃŸe bei zwei Updates auf den selben Fehler.

Eintrag im Bugtracker bzgl. dem "Fehler" habe ich ebnfalls erstellt.

PHP Version 5.2.3
MySQL-Version: 5.0.41-community-nt
Update von 1.6.12 auf 2.0.1

GruÃŸ Christian

Post by **Thorsten** » Mon Jun 11, 2007 12:49 pm

Hi,

dieser Bug ist in der 2.0.2 gefixt, lade dir mal den stabilen CVS Snapshot runter, dann geht es.

bye
Thorsten

freeman · Post by **freeman** » Mon Jun 11, 2007 1:49 pm

Hallo,

sieht gut aus, das Update lief nun ohne Probleme durch. Danke!

Update to 2.0.1 failed

Update to 2.0.1 failed

DANKE