Upgrade from 1.6 to 2.0.1 failed

In this board you can talk about general questions about phpMyFAQ

Moderator: Thorsten

calande
Posts: 70
Joined: Sat Sep 02, 2006 7:01 am

Upgrade from 1.6 to 2.0.1 failed

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? :roll:

Thanks in advance :wink:

Thorsten
Posts: 15024
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

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
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

calande
Posts: 70
Joined: Sat Sep 02, 2006 7:01 am

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

Thanks Thorsten!

calande
Posts: 70
Joined: Sat Sep 02, 2006 7:01 am

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 :roll:

Thorsten
Posts: 15024
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

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

Hi,

please enable the debug mode for error messages. Thanks.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

calande
Posts: 70
Joined: Sat Sep 02, 2006 7:01 am

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.

Thorsten
Posts: 15024
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

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
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

calande
Posts: 70
Joined: Sat Sep 02, 2006 7:01 am

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

Thorsten
Posts: 15024
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

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
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

calande
Posts: 70
Joined: Sat Sep 02, 2006 7:01 am

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

Thorsten
Posts: 15024
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

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

Hi,

do you have values in the MySQL table faqconfig?

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

calande
Posts: 70
Joined: Sat Sep 02, 2006 7:01 am

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

Thorsten
Posts: 15024
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

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
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

calande
Posts: 70
Joined: Sat Sep 02, 2006 7:01 am

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?

Thorsten
Posts: 15024
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

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

Hi,

please run the update once again.

bye
Thorsten
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

Post Reply