Problems with upgrade to 2.2.14

[Batrams]

Hi - 2.2.13 was working fine on my Linux machine - I installed from the .zip file. Today I installed the new version the same way but could not get it to function properly. Specifically, when I tried to add a punch for an employee, the punch window just turned blank instead of closing, and the punch was not recorded.

I got the below email even after changing the permissions of all cache files and folders to 777:

DEBUG [43]: <b>DBError::__construct()</b>: mysqlt error: [-32000: Cache write error] in CacheExe
cute(/tmp/timetrex//ec/adodb_ece0be921a6650b75691c54b2fce6fb4.cache, select * from cron where id = -
1)
<br>

I went back to the previous version and all seems ok. Any thoughts on what's wrong?

[Batrams]

More info - I tried the new version again, this time with debugging on. In the punch window that turns blank with debugging turned off, I now get:

Code: Select all

Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysqlt error: [1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as z WHERE z.id in ( select a.id from user_date_total as a ' at line 1] in adodb_throw(DELETE FROM user_date_total as z WHERE z.id in ( select a.id from user_date_total as a LEFT JOIN punch_control as b ON a.punch_control_id = b.id where a.user_date_id = '298' AND ( ( a.override = 0 AND a.status_id in (10,30) ) OR ( b.id IS NOT NULL AND a.user_date_id != b.user_date_id ) ) AND ( a.deleted = 0 ) ), ) ' in /var/www/htdocs/TimeTrex/classes/adodb/adodb-exceptions.inc.php:78 Stack trace: #0 /var/www/htdocs/TimeTrex/classes/adodb/adodb.inc.php(221): adodb_throw('mysqlt', 'adodb_throw', 1064, 'You have an err...', 'DELETE FROM use...', false, Object(ADODB_mysqlt)) #1 /var/www/htdocs/TimeTr in /var/www/htdocs/TimeTrex/classes/adodb/adodb-exceptions.inc.php on line 78

and in the main window I see:

Code: Select all

Debug Buffer
============================================================================
Memory Usage: 8072104
----------------------------------------------------------------------------
DEBUG [111]: TTDate::setTimeZone(): Setting TimeZone: America/New_York
DEBUG [519]: Authentication::Check(): Session Name: SessionID
DEBUG [525]: Authentication::Check(): Session ID: b79846493d244d3a0aa951bdd8a87341
DEBUG [403]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:b79846493d244d3a0aa951bdd8a87341
DEBUG [82]: Authentication::getIdle(): Idle Seconds Allowed: 14400
DEBUG [403]: Validator::stripNonAlphaNumeric(): Alpha Numeric String:b79846493d244d3a0aa951bdd8a87341
DEBUG [70]: [Function](): User Authenticated: mandd Created Date: 1221744469
DEBUG [1987]: UserFactory::isInformationComplete(): User Information is Complete:
DEBUG [111]: TTDate::setTimeZone(): Setting TimeZone: US/Eastern
DEBUG [139]: TTDate::setDateFormat(): Setting Default Date Format: d-M-y
DEBUG [153]: TTDate::setTimeFormat(): Setting Default Time Format: g:i A
DEBUG [167]: TTDate::setTimeUnitFormat(): Setting Default Time Unit Format: 20
DEBUG [102]: [Function](): Locale Cookie: en_US
DEBUG [291]: TTi18n::getLanguageFromLocale(): Locale: en_US
DEBUG [110]: [Function](): User Preference Language matches cookie!
DEBUG [322]: TTi18n::setLocale(): Generated/Passed In Locale:
DEBUG [256]: TTi18n::generateLocale(): Array of Locales to try in order: en_US,en_US.UTF-8,en,en.UTF-8
DEBUG [215]: TTi18n::tryLocale(): Found valid locale: en_US
DEBUG [328]: TTi18n::setLocale(): Attempting to set Locale(s) to: en_US Category: 6 Current Locale:
DEBUG [331]: TTi18n::setLocale(): Setting currency/numeric Locale to: en_US
DEBUG [344]: TTi18n::setLocale(): Setting translator locale to: en_US
DEBUG [361]: TTi18n::setLocale(): Set Master Locale To: en_US
DEBUG [1987]: UserFactory::isInformationComplete(): User Information is Complete:
DEBUG [1145]: UserPreferenceFactory::isPreferencesComplete(): User Preferences IS Complete:
DEBUG [139]: [Function](): Station ID Cookie found! a1171d4a36f36b68483c0cd5988150b5
DEBUG [337]: [Function](): ID was NOT passed:
DEBUG [341]: [Function](): Punch Control ID was passed: 221

[shaunw]

It appears as though one of our mirrors had a corrupt .ZIP file, please download TimeTrex v2.2.14 again and install it over top of your current installation.

[Batrams]

Hi - I re-downloaded and re-installed but am seeing the same behavior. Is it normal to have to manually create the log, storage and cache directories using the .zip version? I don't remember doing that last time but maybe I did. Anyway, creating them manually cleared the errors on the install page and allowed it to proceed, but I still get the failed punches happening.

[shaunw]

Try using this URL to download it:
http://www.timetrex.com/download/TimeTr ... 2.2.14.zip

Here is the md5sum to confirm you get the proper uncorrupted file:
# md5sum TimeTrex_Standard_Edition_v2.2.14.zip
f33f813087a61296ff2795e8e650203f TimeTrex_Standard_Edition_v2.2.14.zip

[Batrams]

Hi - the first two downloads indeed failed the md5 test but the link you posted worked and now all's well. Thanks!