unsuccessful upgrade 2.02 > 2.03

[jazcyk]

I tried an upgrade from PMF 2.02 to 2.03. Everything went normally untill the display 'go to step 5 of 5' . After clicking this one nothing happend! First rather long time passes (abuot 20 secs) and the page displaying after that is totall blank except for the header 'phpMyFAQ 2.0.3 Update'

After this unsuccesfull upgrade the FAQ itself won't open!

The 2.02 version is still functional and can be seen at www.webyog.com/faq

The unsuccessfull 2.03 is at www.webyog.com/faq_new (or should have been - files are there!)

(I always make a copy of the PMF folder and perform the upgrade here, so that is why I can give links to both versions). The two versions share the same databae, but I also think there is no database change between the two!

[Thorsten]

Hi,

step 5 is just an optimize of the tables and and update on the version number in the table faqconfig. The update worked well on various test systems here.

bye
Thorsten

[jazcyk]

.. that it worked for you!

But what will I do from here?



you can see for yourself that the version no. has not changed from 2.0.2.

[Thorsten]

Hi,

please try it once again and use 2.0.2 as starting point at the beginning of the update routine. It has to work!

bye
Thorsten

[jazcyk]

I had renamed the data.php shipped with 2.03 to data_bak.php.
Now I find several data_bak(2) and ... (3) in that folder. Should I avoid using that data_bak.php file name?

[Thorsten]

Hi,

there is no data.php shipped with the package. Is the content of data.php correct? The update script creates an backup of data.php but it doesn't use it.

bye
Thorsten

[jazcyk]

yes .. I realize that your are right here. I must have messed up a few files! The data.php itself is OK. Now let me try once again.

I am pretty sure that that the files are all Ok now.

It could be a trivial connectivity issue occuring at a crtical point of the upgrade process.

[jazcyk]

Exactly the same result.

The script does not execute anything after this (in 5th step)!

// UPDATES FROM 2.0.2
//
if (version_compare($version, '2.0.2', '<')) {
etc.

Is '<' correct? to me '<=' would be core logical!


MySQL 4.1.20, PHP 4.4.7, php_mysql extension.



Now i have spent almost 5 hours with this.
But what will I do?

[jazcyk]

any idea what could make the script stop exactly this place?

[tnd]

I think there will have no any change of database between version 2.0.2 and 2.0.3 so only update php source it would make 2.0.3 work on your current database.

However, please make sure that you don't make any change on 2.0.2 source (example: add your own function or disable some part of code) or make any change on template.

I already work for upgrade from 2.0.2 to 2.0.3 last weekend it work properly untill I check all files that I make some change and apply the change into 2.0.3 then everything work fine.

I try to check on your 2.0.3 but I can not see anything on the page may be there have some error, and you can check error_log for more detail.

[Thorsten]

Hi,

the new index was introduced with phpMyFAQ 2.0.2, so if you're using 2.0.2 you don't need this index.

There are no database changes between 2.0.2 and 2.0.3 and the only queries we're doing are optimize statements and one update on the table faqconfig for setting the new version number.

You can run the statements bye hand or by SQLyog.

I don't have any idea what's happening on your system without an error log.

bye
Thorsten

[jazcyk]

From where will I get this error log?


I do exactly the same as I did with every update since we started using PMF early in 1.5.x.

*Download the archive,
*Add folders from existing installation (attachments, pdf and xml).
*Add .htacces and data.php (and config.php before PMF 2) from existing installation
*Replace a few files (only trivial ones like favicons etc.), replace colors.css.
*Edit the index.tpl (disable a few menu items and links in the top meny and add a JS statistics counter)
*Rename a few files like 'sendmail.php' >> 'sendmail_dead.php' (we don't want mails from the FAQ system). Similar with ask_questions (we have a Forum for that!)
*Backup the database
*Upload to a new folder ('faq_new') and execute update.php here
*Verify that it works
*Rename the new folder to the original folder name ('faq_new' >> 'faq'

.. and I never encountered anything like it before. The only change I can think of is that PHP was upgraded from 4.3.something to 4.4.7 recently. But this is my first 2x >> 2.x upgrade, so i wonder if I have overlooked something!

I think I will have to try again from the very beginning. But still please tell from where to get the error log!

[Thorsten]

Hi,

your way to the update was correct.

Do you see the MySQL error log?

bye
Thorsten

[jazcyk]

Nothing was recorded in the MySQL error log since July 7th (where we fooled a little while setting up replication!). Nothing recorded from the two attempts i did with this.

I think it is a webserver/PHP issue rather than a MySQL issue.

[Thorsten]

Hi,

any webserver error logs?

bye
Thorsten