Recent posts in this topic
this is the error i get afer moving from one host to another.
and after finally getting permission set right ( i think) it looks like its all working
i can brows my data... but as soon as i tried to add a test task list...
"Query failed with message 'Duplicate entry '0' for key 1'"
is it the sql dump was done wrong?
has his happened to anyone else before?
and after finally getting permission set right ( i think) it looks like its all working
i can brows my data... but as soon as i tried to add a test task list...
"Query failed with message 'Duplicate entry '0' for key 1'"
is it the sql dump was done wrong?
has his happened to anyone else before?
also... ive tested all types of input and only adding messages works
also found if i choose to email members when posting a message i get the
"Query failed with message 'Duplicate entry '0' for key 1'"
error...
no wait i take off the checkmarks and it still wont post. so im at a loss
"Query failed with message 'Duplicate entry '0' for key 1'"
error...
no wait i take off the checkmarks and it still wont post. so im at a loss
Staff
Ilija Studen
on Nov 5. 2006. 11:18 am
Make sure that ID fields in tables are properly marked as auto_increment. I had a problem where export and import with a certain version of phpMyAdmin didn't transfer value of auto_increment field and that resulted in pretty weird behavior on every second insert.
To see what fields need to be made auto_increment use old installation or fresh one on the localhost.
To see what fields need to be made auto_increment use old installation or fresh one on the localhost.
activeCollab team member | LinkedIn
ok the list ive compiled that have tables with aut increment flagged on are as follows:
ac_administration_tools
ac_application_logs
ac_comments
ac_companies
ac_config_categories
ac_config_options
ac_file_typesa
ac_im_types
ac_project_file_revisions
ac_project_files
ac_project_folders
ac_project_forms
ac_project_messages
ac_project_milestones
ac_project_task_lists
ac_project_tasks
ac_projects
ac_tags
ac_users
Ill post to tell you if it works if not i'll gladly pay for your time to fix it. :)
ac_administration_tools
ac_application_logs
ac_comments
ac_companies
ac_config_categories
ac_config_options
ac_file_typesa
ac_im_types
ac_project_file_revisions
ac_project_files
ac_project_folders
ac_project_forms
ac_project_messages
ac_project_milestones
ac_project_task_lists
ac_project_tasks
ac_projects
ac_tags
ac_users
Ill post to tell you if it works if not i'll gladly pay for your time to fix it. :)
Got it to work!!!!
ok, heres what i did....
after getting import error after error i was able to import with autoingremment off from the dump since it was causing errors...
but the problem i was having was listed above....
after going table by table and reimporting one by one i decided to dump it all and reimport with a slight modification...
i selected all tables in the database and dropped them. then i copy and pasted the entire sql dump minus the tope few lines which read....
"-- phpMyAdmin SQL Dump
-- version 2.6.2
-- http://www.phpmyadmin.net
--
-- Host: db.modwest.com
-- Generation Time: Nov 05, 2006 at 03:06 AM
-- Server version: 4.1.11
-- PHP Version: 4.3.10
--
-- Database: `activecollab`
--
DROP DATABASE `activecollab`;
CREATE DATABASE `activecollab` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE activecollab;"
BAM!
it all works now
ok, heres what i did....
after getting import error after error i was able to import with autoingremment off from the dump since it was causing errors...
but the problem i was having was listed above....
after going table by table and reimporting one by one i decided to dump it all and reimport with a slight modification...
i selected all tables in the database and dropped them. then i copy and pasted the entire sql dump minus the tope few lines which read....
"-- phpMyAdmin SQL Dump
-- version 2.6.2
-- http://www.phpmyadmin.net
--
-- Host: db.modwest.com
-- Generation Time: Nov 05, 2006 at 03:06 AM
-- Server version: 4.1.11
-- PHP Version: 4.3.10
--
-- Database: `activecollab`
--
DROP DATABASE `activecollab`;
CREATE DATABASE `activecollab` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE activecollab;"
BAM!
it all works now
shoot! new quirk....
added a company fine
then went to add a user and got something about UserController.class.php on line 100
but i seems like the user was added.... any ideas?
added a company fine
then went to add a user and got something about UserController.class.php on line 100
but i seems like the user was added.... any ideas?
that works...
norw i logged in as a client today after thinking all was fine and was showing them how to see their tasks.
and got the following! ( i will be looking into it when i get home. man this moving it between servers really bunked things up!)
-------------------------------------------------------------------------------
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 '? ORDER BY `due_date`' at line 1'
Error params:
File: /home/sastian/public_html/work/environment/library/database/adapters/AbstractDBAdapter.class.php
Line: 371
Sql: SELECT * FROM `ac_project_milestones` WHERE `project_id` = '15' AND ((`assigned_to_user_id` = '26' AND `assigned_to_company_id` = '11') OR (`assigned_to_user_id` = '0' AND `assigned_to_company_id` = '11') OR (`assigned_to_user_id` = '0' AND `assigned_to_company_id` = '0')) AND `completed_on` = '0000-00-00 00:00:00' AND `is_private` = ? ORDER BY `due_date`
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 '? ORDER BY `due_date`' at line 1
Backtrace:
#0 /home/sastian/public_html/work/environment/library/database/adapters/AbstractDBAdapter.class.php(289): AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
#1 /home/sastian/public_html/work/environment/library/database/DB.class.php(171): AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
#2 /home/sastian/public_html/work/environment/classes/dataaccess/DataManager.class.php(182): DB::executeAll('SELECT * FROM `...')
#3 /home/sastian/public_html/work/application/models/project_milestones/base/BaseProjectMilestones.class.php(101): DataManager->find(Array)
#4 /home/sastian/public_html/work/environment/classes/dataaccess/DataManager.class.php(210): BaseProjectMilestones->find(Array)
#5 /home/sastian/public_html/work/application/models/project_milestones/base/BaseProjectMilestones.class.php(118): DataManager->findAll(Array)
#6 /home/sastian/public_html/work/application/models/project_milestones/base/BaseProjectMilestones.class.php(120): BaseProjectMilestones->findAll(Array)
#7 /home/sastian/public_html/work/application/models/projects/Project.class.php(846): BaseProjectMilestones->findAll(Array)
#8 /home/sastian/public_html/work/application/views/dashboard/my_tasks.php(19): Project->getUsersMilestones(Object(User))
#9 /home/sastian/public_html/work/environment/classes/template/Template.class.php(74): include('/home/sastian/p...')
#10 /home/sastian/public_html/work/environment/classes/template/Template.class.php(46): Template->includeTemplate('/home/sastian/p...')
#11 /home/sastian/public_html/work/environment/classes/template/template.php(35): Template->fetch('/home/sastian/p...')
#12 /home/sastian/public_html/work/environment/classes/controller/PageController.class.php(92): tpl_fetch()
#13 /home/sastian/public_html/work/environment/classes/controller/PageController.class.php(63): PageController->render('/home/sastian/p...')
#14 /home/sastian/public_html/work/environment/classes/Env.class.php(109): PageController->execute()
#15 /home/sastian/public_html/work/init.php(134): Env::executeAction('my_tasks')
#16 /home/sastian/public_html/work/index.php(9): require('/home/sastian/p...')
#17 {main}
Autoglobal varibles:
$_GET: Array (
['c'] => (string) 'dashboard'
['a'] => (string) 'my_tasks'
['active_project'] => (string) '15'
)
$_POST:
$_COOKIE: Array (
['PHPSESSID'] => (string) 'da48a58615f99a26ffb80e51d04fa354'
['id'] => (string) '26'
['token'] => (string) 'd6f3e813c37057f4d86920b7d287d825dcdf9a8c'
)
$_SESSION:
Execution time:
Total execution time: 0.403185 seconds
norw i logged in as a client today after thinking all was fine and was showing them how to see their tasks.
and got the following! ( i will be looking into it when i get home. man this moving it between servers really bunked things up!)
-------------------------------------------------------------------------------
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 '? ORDER BY `due_date`' at line 1'
Error params:
File: /home/sastian/public_html/work/environment/library/database/adapters/AbstractDBAdapter.class.php
Line: 371
Sql: SELECT * FROM `ac_project_milestones` WHERE `project_id` = '15' AND ((`assigned_to_user_id` = '26' AND `assigned_to_company_id` = '11') OR (`assigned_to_user_id` = '0' AND `assigned_to_company_id` = '11') OR (`assigned_to_user_id` = '0' AND `assigned_to_company_id` = '0')) AND `completed_on` = '0000-00-00 00:00:00' AND `is_private` = ? ORDER BY `due_date`
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 '? ORDER BY `due_date`' at line 1
Backtrace:
#0 /home/sastian/public_html/work/environment/library/database/adapters/AbstractDBAdapter.class.php(289): AbstractDBAdapter->prepareAndExecute('SELECT * FROM `...', NULL)
#1 /home/sastian/public_html/work/environment/library/database/DB.class.php(171): AbstractDBAdapter->executeAll('SELECT * FROM `...', NULL)
#2 /home/sastian/public_html/work/environment/classes/dataaccess/DataManager.class.php(182): DB::executeAll('SELECT * FROM `...')
#3 /home/sastian/public_html/work/application/models/project_milestones/base/BaseProjectMilestones.class.php(101): DataManager->find(Array)
#4 /home/sastian/public_html/work/environment/classes/dataaccess/DataManager.class.php(210): BaseProjectMilestones->find(Array)
#5 /home/sastian/public_html/work/application/models/project_milestones/base/BaseProjectMilestones.class.php(118): DataManager->findAll(Array)
#6 /home/sastian/public_html/work/application/models/project_milestones/base/BaseProjectMilestones.class.php(120): BaseProjectMilestones->findAll(Array)
#7 /home/sastian/public_html/work/application/models/projects/Project.class.php(846): BaseProjectMilestones->findAll(Array)
#8 /home/sastian/public_html/work/application/views/dashboard/my_tasks.php(19): Project->getUsersMilestones(Object(User))
#9 /home/sastian/public_html/work/environment/classes/template/Template.class.php(74): include('/home/sastian/p...')
#10 /home/sastian/public_html/work/environment/classes/template/Template.class.php(46): Template->includeTemplate('/home/sastian/p...')
#11 /home/sastian/public_html/work/environment/classes/template/template.php(35): Template->fetch('/home/sastian/p...')
#12 /home/sastian/public_html/work/environment/classes/controller/PageController.class.php(92): tpl_fetch()
#13 /home/sastian/public_html/work/environment/classes/controller/PageController.class.php(63): PageController->render('/home/sastian/p...')
#14 /home/sastian/public_html/work/environment/classes/Env.class.php(109): PageController->execute()
#15 /home/sastian/public_html/work/init.php(134): Env::executeAction('my_tasks')
#16 /home/sastian/public_html/work/index.php(9): require('/home/sastian/p...')
#17 {main}
Autoglobal varibles:
$_GET: Array (
['c'] => (string) 'dashboard'
['a'] => (string) 'my_tasks'
['active_project'] => (string) '15'
)
$_POST:
$_COOKIE: Array (
['PHPSESSID'] => (string) 'da48a58615f99a26ffb80e51d04fa354'
['id'] => (string) '26'
['token'] => (string) 'd6f3e813c37057f4d86920b7d287d825dcdf9a8c'
)
$_SESSION:
Execution time:
Total execution time: 0.403185 seconds
Topic is locked. If you have something important to say about issues discussed on this page please write at hi@a51dev.com.
