GoDaddy.com Installation

[peten]

Hosted on a shared server at GoDaddy.com

Installed without errors - clean as a whistle.

Configuration - smooth as silk.

But - seems there is an error when we try to open "Projects"...

ERROR: /home/content/w/e/x/whatever/html/whatever/classes/query.class.php(590): query failed(CREATE TEMPORARY TABLE tasks_sum SELECT task_project, COUNT(distinct task_id) AS total_tasks,
SUM(task_duration * task_percent_complete * IF(task_duration_type = 24, 8.0, task_duration_type))/
SUM(task_duration * IF(task_duration_type = 24, 8.0, task_duration_type)) AS project_percent_complete FROM `tasks` GROUP BY task_project) - error was: Access denied for user: 'whatever@64.202.163.%' to database 'whatever'
Backtrace:
0 /home/content/w/e/x/whatever/html/whatever/classes/query.class.php:590 dprint(

Warning: Invalid argument supplied for foreach() in /home/content/w/e/x/whatever/html/whatever/includes/main_functions.php on line 538

Any thoughts are GREATLY Appreciated

[pedroa]

You must have MySQL permissions to create temporary tables.
Talk to your host about this.

Pedro A.

[caseydk]

Go here: http://www.dotproject.net/vbulletin/...ead.php?t=2753

[peten]

Originally Posted by pedroa

You must have MySQL permissions to create temporary tables.
Talk to your host about this.

Pedro A.

Well, you know these people at GD usually just send is BS replies: attempting to delay the fact that they either a) need to get off their arse and do something or, b) haven't a clue as to what the issue is about. Generally we have bitch and scream until we either get this issue upgraded or supply them with firm evidence that the issue is with their hosting solution. This has been know to take as long as 6 months. You could help us substantially, if you could supply us with a direct quote that does indeed verify the issue is with their locking us out of writing temp tables to the database... then we might get them to actually do something. Please

Thanks

PS We did apply the patch mentioned in the previous post and it made no difference at all. This leads us to believe that your assessment of the situation is indeed correct.

[peten]

Originally Posted by caseydk

Go here: http://www.dotproject.net/vbulletin/...ead.php?t=2753

We applied this patch and it is still generating the exact same error.

Doesn't this look more like a permissions issue to write temp tables?

Thanks

[pedroa]

Hi peten,

Evidence?
Try doing a CREATE TEMPORARY TABLE on any database of yours (exclude dP one please) and see what you get.

I haven't tryed the hack of that post but seems to my eyes capable of working, so please tell here what you have done you might get some guidance.

By the way, you can exchange TRUNCATE TABLE .... for DELETE FROM ... should be the same (or maybe not).

The idea is:

1) Create the temporary tables as permanent tables (just not sure of the fields definitions, the DDL), and these CREATE TABLE statments should be executed from phpmyadmin or the like.
2) Instead of deleting the tables afterwards (thats what is being tryed to be commented), you are simply cleaning the records (TRUNCATE or DELETE).

Should work...if it is right.

Pedro A.

[ssutter]

I too am attempting dotProject on GoDaddy… their technical support says they do not allow Temporary Tables to be enabled. – I haven’t found anyone on this forum who has been successful in getting around this? Am I wrong?

[pedroa]

http://www.dotproject.net/vbulletin/...ead.php?t=4261

[Darksunz]

Hey guys... I did get dotProject installed on GD servers, though the error with the Reports are not going be be fixable with their service as you CAN NOT change the PHP.INI files on Shared hosting... So to awnser your question, dotProject will work, but you'll have to put up with the errors you see when submitting a Task.