Error updating community edition from 5.3.3 to 7.0.1

Ask your questions regarding TimeTrex installation here.
Locked
HenrikH
Posts: 51
Joined: Wed Dec 09, 2009 2:07 am

Error updating community edition from 5.3.3 to 7.0.1

Post by HenrikH »

Hi,

When updating a get this error.

Please see attached file.

Br,

Henrik
Attachments
error.jpg
HenrikH
Posts: 51
Joined: Wed Dec 09, 2009 2:07 am

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by HenrikH »

And if you try to update to 7.0.0 first you get this error.

Pls. see attached file

Br,

Henrik
Attachments
error2.jpg
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by shaunw »

If you try to run the exact command specified in the first screenshot manually at a command prompt, do you get any error message?
HenrikH
Posts: 51
Joined: Wed Dec 09, 2009 2:07 am

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by HenrikH »

If I first upgrade to 7.0.0 and the installer stops at the httpd.exe error. Running the command manually I get and error regarding MSVCR100.dll
Attachments
error3.jpg
error3.jpg (10.68 KiB) Viewed 12073 times
HenrikH
Posts: 51
Joined: Wed Dec 09, 2009 2:07 am

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by HenrikH »

When you try to upgrade from 5.3.3 to 7.0.1 and the installer stops at the postgresql error. Running the command manually you get prompted for password.
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by shaunw »

What is the exact error that you receive trying to upgrade from v5.3.3 to v7.0.1?
HenrikH
Posts: 51
Joined: Wed Dec 09, 2009 2:07 am

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by HenrikH »

The installer fails when trying to run pg_dumpall.exe
Looking at the event viewer it look like a password error for the user postgres.

Event Type: Error
Event Source: PostgreSQL
Event Category: None
Event ID: 0
Date: 20-06-2013
Time: 09:30:30
User: N/A
Computer: XXXX
Description:
The description for Event ID ( 0 ) in Source ( PostgreSQL ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: FATAL: password authentication failed for user "postgres"
.
Attachments
error4.jpg
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by shaunw »

Is your TimeTrex installation currently in working order?

Can you attach your c:\timetrex\install.log file here as well?
HenrikH
Posts: 51
Joined: Wed Dec 09, 2009 2:07 am

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by HenrikH »

Yes, it is in working order.

Here's the install log from may 2'nd 2013
Attachments
install.log
(323.69 KiB) Downloaded 272 times
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by shaunw »

Can you also attach your timetrex.ini.php file and c:\timetrex\backup_database.bat ? I'm guessing that the database passwords in each may be different for some reason...
HenrikH
Posts: 51
Joined: Wed Dec 09, 2009 2:07 am

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by HenrikH »

Passwords seems to be identical.
Attachments
timetrex.ini.txt
Renamed since extension php is not allowed
(1.39 KiB) Downloaded 271 times
backup_database.txt
Renamed since extension php is not allowed
(504 Bytes) Downloaded 268 times
install.log
(323.69 KiB) Downloaded 263 times
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by shaunw »

The error is definitely a password error according to your event log, which the only way I can see as being possible is if in fact the passwords are different than what are specified in your timetrex.ini.php and backup_database.bat file. The installer basically runs the exact command in the backup_database.bat file, so if that file is working and is creating a backup of your database, there should be no reason why the installer fails.

Do you have recently dated .SQL files in your c:\timetrex\ directory? Would it be possible to attach a screenshot showing all the files in c:\timetrex\. If you edit your backup_database.bat file and remove the first @ECHO OFF line, then run that file from the command prompt, what output do you see?
HenrikH
Posts: 51
Joined: Wed Dec 09, 2009 2:07 am

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by HenrikH »

It's an password error. If I create a new superuser in Postgres, change backup_database.bat to use the new user an run it. Then it runs correctly. But I can see that the .sql file get's named wrong. Instead of adding _yyyy mm dd to the filename it adds _on.

I don't have any .sql file in the c:\timetrex directory.

If I run backup_database.bat without changes I get the password error as seen in the attached file error_echo_off.jpg

If I change the backup_database.bat to fit the new user an runs it. Then it works, but I get an .sql file with the wrong name as seen in error_reg_on.jpg

Br,

Henrik
Attachments
error_reg_on.jpg
error_echo_off.jpg
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by shaunw »

Okay, so because its a password issue, there isn't much our installer can do as it has no knowledge of the Postgres user's password to properly migrate the database. Having said that though the installer for TimeTrex v7.0.2 (due out in the next day or two) will try to work around this case (without knowing the password) and still allow the upgrade to occur.

I would see if that version allows the upgrade to happen.
HenrikH
Posts: 51
Joined: Wed Dec 09, 2009 2:07 am

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by HenrikH »

Ok, thanks.

I have tried to solve the problem by changing the password for the user postgres in postgreSQL to the same password as in backup_database.bat. By doing so the update from 5.3.3 to 7.0.1 seems to work now :D

Br,

Henrik
HenrikH
Posts: 51
Joined: Wed Dec 09, 2009 2:07 am

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by HenrikH »

And it works. Thanks for pointing to a solution. I know some people that will be mighty happy when then come to work.

Br,

Henrik
HenrikH
Posts: 51
Joined: Wed Dec 09, 2009 2:07 am

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by HenrikH »

Small issue apparently still exists after upgrade. The maintenance job will not run. If I try to run the command C:\TimeTrex\php\php-win.exe "C:\TimeTrex\timetrex\maint\cron.php" manually. I get this error (pls. see error_app.jpg)
Attachments
error_app.jpg
error_app.jpg (10.41 KiB) Viewed 11964 times
HenrikH
Posts: 51
Joined: Wed Dec 09, 2009 2:07 am

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by HenrikH »

And the error too (Pls. see error_app_2.jpg)
Attachments
error_app_2.jpg
error_app_2.jpg (10.08 KiB) Viewed 11963 times
HenrikH
Posts: 51
Joined: Wed Dec 09, 2009 2:07 am

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by HenrikH »

HenrikH wrote:And the error too (Pls. see error_app_2.jpg)
I tried to solve by upgrading to 7.0.2. But the problem still remains. Attached is install and error log.
Attachments
install.log
(3.02 MiB) Downloaded 267 times
upgrade_sql_error.log
(455 Bytes) Downloaded 269 times
shaunw
Posts: 7839
Joined: Tue Sep 19, 2006 2:22 pm

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by shaunw »

The libintl.dll can be copied from c:\timetrex\postgresql\bin\ to c:\timetrex\php to fix that error message. This issue was fixed in v7.0.1 but if you already upgraded to v7.0.0 it has to be fixed manually.

As for the kernel32.dll error, that appears to be caused by the PHP-APC extension, but just to confirm what operating system are you running?
HenrikH
Posts: 51
Joined: Wed Dec 09, 2009 2:07 am

Re: Error updating community edition from 5.3.3 to 7.0.1

Post by HenrikH »

I'm running Windows 2003 r2 64.

Thanks for the info. All systems are now green :-) After a restart of the server and a update to 7.0.2.

Br,

Henrik
Locked