lammy
Posts: 49
|
| Posted: 12/17/2004, 1:28 PM |
|
I have just created the taskmanager in ccs, using PHP all is well in my localhost. but when i upload to server I get the following error
Database error: Invalid SQL: SELECT COUNT(*) FROM ((((tasks LEFT JOIN statuses ON tasks.status_id = statuses.status_id) LEFT JOIN projects ON tasks.project_id = projects.project_id) LEFT JOIN priorities ON tasks.priority_id = priorities.priority_id) LEFT JOIN employees ON tasks.user_id_assign_to = employees.emp_id) INNER JOIN `types` ON tasks.type_id = `types`.type_id
MySQL Error: 1054 (Unknown column 'tasks.user_id_assign_to' in 'on clause')
Session halted.
could somebody tell me why it occurs all my tables are the same on both localhost and the server, the server is running phpmyadmin 2.6.0-pl3
Cheers
lammy
|
 |
 |
peterr
Posts: 5971
|
| Posted: 12/17/2004, 4:05 PM |
|
I suspect that possibly your databases aren't the same... Or possibly you're connecting to a wrong database. (?)
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
|
|
