can't end task and other errors- 1.4rc

[tamalita]

I just upgraded from 1.3.1 (I think) to 1.4RC. I can't end my task. I get the following:

Code: [Select]

Error (DBQueryError)
Query failed with message '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 '' at line 1'
Error params:
File: /home/XXX/public_html/goo/environment/library/database/adapters/AbstractDBAdapter.class.php
Line: 386
Sql: SELECT * FROM `og_workspace_billings` WHERE project_id = '144' AND billing_id =
Error number: 1064
Error message: 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 '' at line 1
Backtrace:
#0 /home/XXX/public_html/goo/environment/library/database/adapters/AbstractDBAdapter.class.php(304):

AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
#1 /home/XXX/public_html/goo/environment/library/database/DB.class.php(199):

AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
#2 /home/XXX/public_html/goo/environment/classes/dataaccess/DataManager.class.php(231):

DB::executeAll('SELECT * FROM `...')
#3

/home/XXX/public_html/goo/application/models/workspace_billing/base/BaseWorkspaceBillings.class.php(

112): DataManager->find(Array)
#4 /home/XXX/public_html/goo/environment/classes/dataaccess/DataManager.class.php(277):

BaseWorkspaceBillings->find(Array)
#5

/home/XXX/public_html/goo/application/models/workspace_billing/base/BaseWorkspaceBillings.class.php(

146): DataManager->findOne(Array)
#6

/home/XXX/public_html/goo/application/models/workspace_billing/base/BaseWorkspaceBillings.class.php(

148): BaseWorkspaceBillings->findOne(Array)
#7 /home/XXX/public_html/goo/application/models/projects/Copy of Project.class.php(455):

BaseWorkspaceBillings->findOne(Array)
#8 /home/XXX/public_html/goo/application/controllers/TimeslotController.class.php(164):

Project->getBillingAmount(0)
#9 /home/XXX/public_html/goo/environment/classes/controller/Controller.class.php(75):

TimeslotController->close()
#10 /home/XXX/public_html/goo/environment/classes/controller/PageController.class.php(62):

Controller->execute('close')
#11 /home/XXX/public_html/goo/environment/classes/Env.class.php(133):

PageController->execute('close')
#12 /home/XXX/public_html/goo/init.php(150): Env::executeAction('timeslot', 'close')
#13 /home/XXX/public_html/goo/index.php(9): require('/home/XXX/...')
#14 {main}
Autoglobal varibles:
$_GET: Array (
  ['active_project'] => (string) '0'
  ['ajax'] => (string) 'true'
  ['c'] => (string) 'timeslot'
  ['a'] => (string) 'close'
  ['id'] => (string) '317'
  ['current'] => (string) 'overview-panel'
)
$_POST: Array (
  ['timeslot'] => Array (
    ['description'] => (string) 'XXX'
  )
)
$_COOKIE: Array (
  ['exp_last_visit'] => (string) '1242701756'
  ['exp_last_activity'] => (string) '1242772504'
  ['exp_perpage'] => (string) '50'
  ['exp_mode'] => (string) 'normal'
  ['id'] => (string) '1'
  ['token'] => (string) 'a51b7a4143bb5a1c400dead9f4eaecd1bacebdc4'
  ['remember'] => (string) '1'
  ['PHPSESSID'] => (string) 'd9b245e9d8ae2a58be36d194f85f4817'
)
$_SESSION: Array (
  ['cal_version'] => true
  ['month'] => (string) '5'
  ['year'] => (string) '2009'
  ['day'] => (string) '19'
  ['cal_loginfailed'] => (int)0
  ['cal_user'] => (string) 'tamalita'
  ['cal_userid'] => (int)1
)
Execution time:
Total execution time: 0.156226 seconds
I was able to Complete the task and the time was ended, but I got an error:

Code: [Select]

Error:
App.modules.addTaskForm is undefined
When I try to navigate around the dashboard, the calendar also gives me an error:

Code: [Select]

Error
og.CalendarTopToolbar is not a constructor
If I look at the calendar and click on a task I get a duplicate error as above:

Code: [Select]

Error

App.modules.addTaskForm is undefined.
I have also tried to view the tasks and they are not showing up under Tasks on the dashboard. I get an error:

Code: [Select]

ogTasks is not defined
If I try to add a task I get

Code: [Select]

Og.CSVCombo is not a constructor
og.DateField is not a constructor
og.DateField is not a constructor
if I try to edit the milestone, I get:

Code: [Select]

Og.CSVCombo is not a constructor
og.DateField is not a constructor
If I try to save the changes I get

Code: [Select]

Fatal error: Call to a member function getMonth() on a non-object
in /home/XXX/public_html/goo/application/controllers/MilestoneController.class.php on line 297

[alvarotm01]

Hi,
We are working to reproduce and fix that error,
the errors that you got after the task completion should be solved refreshing the browser.

Did the upgrade ended correctly ?

[tamalita]

yes, the upgrade was successful. in general, I'm not having any other issues. even when i do get error messages, it seems that some things are still working ok.

thank you so much. i love opengoo.

[alvarotm01]

examining  the error trace i noticed that there is a file in your installation that should not be there, that file is

/home/XXX/public_html/goo/application/models/projects/Copy of Project.class.php

there should be a file named "Projects.class.php" in that folder, not "Copy of Projects.class.php".

Even i've made a fix in order to avoid this error to happen again.
soon we will publish a new release with some fixes, including this.

[tamalita]

interesting ... thanks for the info! And even more interesting. I was working with my opengoo installation this morning, timing tasks, adding tasks, etc and all was good. I just now deleted that "Copy of Projects.class.php" and immediately began getting a failure, and was not able to access anything.

Code: [Select]

Fatal error: Call to a member function getId() on a non-object in /home/XXX/public_html
/goo/application/controllers/ProjectController.class.php on line 1007
I tried it twice just to be sure. As soon as I added that file back, everything began working again.

[alvarotm01]

that is strange ...

because the only files that should be in folder 'application/models/projects/' are
 - Project.class.php
 - Projects.class.php
and the subfolder 'base' with the files
 - 'BaseProject.class.php'
 - 'BaseProjects.class.php'

only with this files it should work ok.

Although now it is working with the file 'Copy of Project.class.php', I don't think it is a good idea to mantain this file, to avoid possible errors in future updates.

Rename that file to 'Project.class.php', and then delete the file 'cache/autoloader.php', then test if everything keeps working ok in Opengoo.

Tell me if this does not work.

greetings