Upgrading phpMyFAQ 1.6.12 -> 2.0.0

Dawn · Post by **Dawn** » Wed May 23, 2007 9:49 am

Hi,

First of all, thanks a lot for releasing your 2.0.0 version. I tried to update as usually:

1. Dowload the archive to my server via wget
2. Extracted it via tar xvfz [archivename]
3. Changed the owner to www-data:www-data of all dirs and subdirs
4. Overwrite the existing data (I've a daily backup of the whole server)
5. Entered the .../install/update.php and chossed upgrade from 1.6.x
6. Every step till step 5 works great, but then I've got the following error-message:

DB error: Table '[dbname].phpmyfaq_faqfragen' doesn't exist
Query: ALTER TABLE phpmyfaq_faqfragen RENAME TO phpmyfaq_faqquestions

Then I've entered phpMyAdmin an searched for [dbname].phpmyfaq_faqfragen but I only can find [dbname].phpmyfaq_faqquestions. I tought: Ok I think it will work, but when I now enter my faq site everything is messed up. No data is found and a different theme is selected.

Can anybody please tell me what's my fault or what I can do?

Greets and best regards,
Dawn

Post by **Thorsten** » Wed May 23, 2007 9:50 am

Hi,

which tables do you have in your database?

bye
Thorsten

Dawn · Post by **Dawn** » Wed May 23, 2007 9:58 am

Hi Thorsten,

Wow, a very fast reply

I've got the following tables in my db (I've got other tables too, but they aren't from phpmyfaq and aren't relevant for this case I think):

Code: Select all

 phpmyfaq_faqadminlog 
 phpmyfaq_faqadminsessions 
 phpmyfaq_faqcaptcha 
 phpmyfaq_faqcategories 
 phpmyfaq_faqcategoryrelations 
 phpmyfaq_faqcategory_group 
 phpmyfaq_faqcategory_user 
 phpmyfaq_faqchanges 
 phpmyfaq_faqcomments 
 phpmyfaq_faqconfig 
 phpmyfaq_faqdata 
 phpmyfaq_faqdata_group 
 phpmyfaq_faqdata_revisions 
 phpmyfaq_faqdata_tags 
 phpmyfaq_faqdata_user 
 phpmyfaq_faqglossary 
 phpmyfaq_faqgroup 
 phpmyfaq_faqgroup_right 
 phpmyfaq_faqlinkverifyrules 
 phpmyfaq_faqnews 
 phpmyfaq_faqquestions 
 phpmyfaq_faqright 
 phpmyfaq_faqsessions 
 phpmyfaq_faqtags 
 phpmyfaq_faquser 
 phpmyfaq_faquserdata 
 phpmyfaq_faquserlogin 
 phpmyfaq_faquser_group 
 phpmyfaq_faquser_right 
 phpmyfaq_faqvisits 
 phpmyfaq_faqvoting

Greets,
Dawn

Post by **Thorsten** » Wed May 23, 2007 10:07 am

Hi,

the tables are looking good, but I think it's still broken because all queries after the wrong query weren't executed...

bye
Thorsten

Dawn · Post by **Dawn** » Wed May 23, 2007 10:12 am

And what should I do now? Do you have any idea?

Greets,
Dawn

wolf · Post by **wolf** » Wed May 23, 2007 12:39 pm

Dawn,

Dawn wrote:Do you have any idea?

Have a look here.

Dawn · Post by **Dawn** » Wed May 23, 2007 1:10 pm

Hi Wolf,

I tried your solution:

Code: Select all

@ob_flush(); 
flush();

was allready there but I've added "$query = array();" now I've got an additional error:

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/[domain]/httpdocs/faq/inc/PMF_DB/Mysql.php on line 119

Warning: mysql_fetch_object(): supplied argument is not a valid MySQL result resource in /var/www/vhosts/[domain]/httpdocs/faq/inc/PMF_DB/Mysql.php on line 119

When I look into your thread I see there are a lot of people who have this problem. Looks like upgrading from 1.6.12 doesn't work at the moment. Then I'll switch back to to 1.6.12. Getting the files isn't a problem for me but, do I have to load the db backup back too?

Greets and THX for helping,
Dawn

wolf · Post by **wolf** » Wed May 23, 2007 1:15 pm

Dawn wrote:Looks like upgrading from 1.6.12 doesn't work at the moment. Then I'll switch back to to 1.6.12. Getting the files isn't a problem for me but, do I have to load the db backup back too?

I can't imagine the code for 1.6.12 will work with a database that has been (partially) upgraded to 2.0.0. You'll have to revert both the code and the database to get back to 1.6.12.

If you've already attempted some of the upgrade and didn't revert to the 1.6.12 database before running my code fix, then I imagine this is why you're getting new warnings about invalid resources.

Dawn · Post by **Dawn** » Wed May 23, 2007 1:26 pm

Thanks for your explanation.

Do you think there is any other way except loading db- and file-backup and try your solution?

Greets and best regards,
Dawn

wolf · Post by **wolf** » Wed May 23, 2007 1:31 pm

Dawn wrote:Do you think there is any other way except loading db- and file-backup and try your solution?

If you want to roll back to 1.6.12, then you'll have to restore both the files and the database.

Otherwise, if you want to just try upgrading again with my solution, let the code stay in place and just restore the database.

remuze · Post by **remuze** » Wed May 23, 2007 2:39 pm

the tables are looking good, but I think it's still broken because all queries after the wrong query weren't executed...

Is it not possible to make a php-file that runs the query's that weren't executed ?

Post by **Thorsten** » Wed May 23, 2007 2:41 pm

Hi,

we'll release a special update the next days!

bye
Thorsten