Upgrade from 1.6 to 2.0.1 failed

calande · Post by **calande** » Mon Jun 25, 2007 2:54 am

I tried to upgrade from 1.6 to 2.0 a month ago, and it failed, so I decided to revert to 1.6. Now I tried to upgrade from 1.6 to 2.0.1 and it failed again. The installer stoped on step 5 where I only see the gree banner with phpMyFAQ 2.0.1 Update written. There's no content below. When accessing the home page of the FAQ of my web site, it's now a white page. I'm using PHP 5 and MySQL 5. Any idea?

Thanks in advance

Post by **Thorsten** » Mon Jun 25, 2007 6:24 am

Hi,

we found some issues in the MySQL 5 update queries. This is fixed in CVS for version 2.0.2.

bye
Thorsten

calande · Post by **calande** » Mon Jun 25, 2007 10:27 am

Thanks Thorsten!

calande · Post by **calande** » Sat Aug 25, 2007 4:56 pm

I just upgraded a 1.6 version to 2.0.3 but now nothing shows up: http://faqs.pcbsd.org/index.php

Do you know how we could find what went wrong? How could we solve this problem?

Is it possible to export entries from 1.6 and to import them to a 2.0.3 fresh installation?

Thanks

Post by **Thorsten** » Sat Aug 25, 2007 6:02 pm

Hi,

please enable the debug mode for error messages. Thanks.

bye
Thorsten

calande · Post by **calande** » Sat Aug 25, 2007 6:28 pm

Thanks Thorsten. I did and now I have this error message:

Code: Select all

Fatal error: Call to a member function fetch_object() on a non-object in /usr/home/pcbsd/www/faqs.pcbsd.org/inc/PMF_DB/Mysqli.php on line 124

TIA.

Post by **Thorsten** » Sat Aug 25, 2007 6:41 pm

Hi,

please open inc/PMF_DB/Mysqli.php and change at about line 123 the function fetch_object() to the following:

Code: Select all

public function fetch_object($result)
    {
        print_debug_backtrace();
        return $result->fetch_object();
    }

Please try it again and tell me the debug output. Thanks!

bye
Thorsten

calande · Post by **calande** » Sat Aug 25, 2007 6:45 pm

Sure, here it is:

Code: Select all

Fatal error: Call to undefined function print_debug_backtrace() in /usr/home/pcbsd/www/faqs.pcbsd.org/inc/PMF_DB/Mysqli.php on line 124

Post by **Thorsten** » Sat Aug 25, 2007 6:47 pm

Hi,

sorry, the function is debug_print_backtrace(), see http://de3.php.net/manual/en/function.d ... ktrace.php

bye
Thorsten

calande · Post by **calande** » Sat Aug 25, 2007 6:51 pm

Ok, here's the output:

Code: Select all

#0 db_mysqli->fetch_object() called at [/usr/home/pcbsd/www/faqs.pcbsd.org/inc/Configuration.php:74] #1 PMF_Configuration->getAll() called at [/usr/home/pcbsd/www/faqs.pcbsd.org/inc/Init.php:87] #2 require_once(/usr/home/pcbsd/www/faqs.pcbsd.org/inc/Init.php) called at [/usr/home/pcbsd/www/faqs.pcbsd.org/index.php:37] 
Fatal error: Call to a member function fetch_object() on a non-object in /usr/home/pcbsd/www/faqs.pcbsd.org/inc/PMF_DB/Mysqli.php on line 125

Post by **Thorsten** » Sat Aug 25, 2007 6:56 pm

Hi,

do you have values in the MySQL table faqconfig?

bye
Thorsten

calande · Post by **calande** » Sat Aug 25, 2007 6:59 pm

I don't have any table with this name. Here's my list of tables:

faqsfaqadminlog
faqsfaqadminsessions
faqsfaqcaptcha
faqsfaqcategories
faqsfaqcategoryrelations
faqsfaqchanges
faqsfaqcomments
faqsfaqdata
faqsfaqdata_revisions
faqsfaqfragen
faqsfaqnews
faqsfaqsessions
faqsfaquser
faqsfaqvisits
faqsfaqvoting

Post by **Thorsten** » Sat Aug 25, 2007 7:00 pm

Hi,

it seems, you didn't perform an update with update.php? You need 30 tables in 2.0

bye
Thorsten

calande · Post by **calande** » Sat Aug 25, 2007 7:03 pm

Actually yes I used update.php to update phpMyFAQ, but the last stet 5/5 shew a white page, I'm not sure it went through. Maybe the installation aborted. Can I run the script again? Or do you suggest something else?

Post by **Thorsten** » Sun Aug 26, 2007 8:27 am

Hi,

please run the update once again.

bye
Thorsten