Mysql sql file import

[Darrenj]

Some parts of this message have been removed. Learn more about Nabble's security policy.

Hi,

 

can some one please tell me how I go about importing a backup file eGroupware.sql as I have tried to import the file, it drops the tables, creates the tables and inserts the data fine, but when a user tries to put an entry into the calendar is gives an error "duplicate entry for "0"" so at this point I'm at a loss on how to fix this, I'm running different tests on a test server I have here to find ways to fix this, any advise or help is most welcome.

 

 

 

 

Kind Regards,

---

Darren Jones
IT Administrator

Cashworks Corporate Services Ltd

Level 1, 28 Downer Street
Lower Hutt 5040, New Zealand
PO Box 31512, Lower Hutt 5040
Mobile: [phone]
DDI: [phone]
Fax: [phone]

Email: darrenj@...

Website: http://www.cashworksgroup.co.nz

---

Email Disclaimer - This email and any files transmitted with it are confidential and may contain privileged or copyright information. You must not present this message to another party without gaining permission from the sender. If you are not the intended recipient you must not copy, distribute or use this email or the information contained in it for any purpose other than to notify us. If you have received this message in error, please notify the sender immediately, and delete this email from your system. We do not guarantee that this material is free from viruses or any other defects although due care has been taken to minimize the risk. Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Cashworks Corporate Services Ltd, PO Box 31 512, Lower Hutt NZ 5040.

 

 

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
eGroupWare-users mailing list
eGroupWare-users@...
https://lists.sourceforge.net/lists/listinfo/egroupware-users

[Darrenj]

Darrenj wrote:

Hi,
 
can some one please tell me how I go about importing a backup file
eGroupware.sql as I have tried to import the file, it drops the tables,
creates the tables and inserts the data fine, but when a user tries to put
an entry into the calendar is gives an error "duplicate entry for "0"" so at
this point I'm at a loss on how to fix this, I'm running different tests on
a test server I have here to find ways to fix this, any advise or help is
most welcome.
 
ERROR MESSAGE:

Database error: Invalid SQL: INSERT INTO egw_api_content_history (sync_appname,sync_contentid,sync_added,sync_guid,sync_changedby) VALUES ('calendar','','2008-10-06 09:54:43','',102)
mysql Error: 1062 (Duplicate entry '0' for key 1)

File: /var/www/egroupware/phpgwapi/inc/class.contenthistory.inc.php
Line: 165
Function: egw_db::insert / contenthistory::updateTimeStamp / bocalupdate::save / bocalupdate::update / uiforms::process_edit / ExecMethod(calendar.uiforms.process_edit) / etemplate::process_exec / ExecMethod(etemplate.etemplate.process_exec)

Session halted.


 
Darren Jones
IT Administrator

Cashworks Corporate Services Ltd

 

 

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
eGroupWare-users mailing list
[e-mail]
https://lists.sourceforge.net/lists/listinfo/egroupware-users

[kitichai]

Hi Darrenj,

On exporting process you may need to apply for "Add AUTO_INCREMENT value" on phpMyAdmin.

The sql output file will contain the latest id (AUTO_INCREMENT=1227 ;)

CREATE TABLE `egw_cal` (
  `cal_id` int(11) NOT NULL auto_increment,
  `cal_uid` varchar(255) NOT NULL default '',
  `cal_owner` int(11) NOT NULL default '0',
  `cal_category` varchar(30) default NULL,
  `cal_modified` bigint(20) default NULL,
  `cal_priority` smallint(6) NOT NULL default '2',
  `cal_public` smallint(6) NOT NULL default '1',
  `cal_title` varchar(255) NOT NULL default '1',
  `cal_description` text,
  `cal_location` varchar(255) default NULL,
  `cal_reference` int(11) NOT NULL default '0',
  `cal_modifier` int(11) default NULL,
  `cal_non_blocking` smallint(6) default '0',
  `cal_special` smallint(6) default '0',
  `cal_etag` int(11) default '0',
  PRIMARY KEY  (`cal_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1227 DEFAULT CHARSET=latin1 AUTO_INCREMENT=1227 ;


Your could you verify your currently value from "Structure" tab at "Next Autoindex". Your value maybe currently point to duplicate value.

Regards,
Kitichai

Darrenj wrote:

Hi,
 
can some one please tell me how I go about importing a backup file
eGroupware.sql as I have tried to import the file, it drops the tables,
creates the tables and inserts the data fine, but when a user tries to put
an entry into the calendar is gives an error "duplicate entry for "0"" so at
this point I'm at a loss on how to fix this, I'm running different tests on
a test server I have here to find ways to fix this, any advise or help is
most welcome.
 

 

 

 

Kind Regards,

  _____  

Darren Jones
IT Administrator

Cashworks Corporate Services Ltd

Level 1, 28 Downer Street
Lower Hutt 5040, New Zealand
PO Box 31512, Lower Hutt 5040
Mobile: [phone]
DDI: [phone]
Fax: [phone]

Email: [e-mail]

Website: http://www.cashworksgroup.co.nz <http://www.cashworksgroup.co.nz/>

  _____  

Email Disclaimer - This email and any files transmitted with it are
confidential and may contain privileged or copyright information. You must
not present this message to another party without gaining permission from
the sender. If you are not the intended recipient you must not copy,
distribute or use this email or the information contained in it for any
purpose other than to notify us. If you have received this message in error,
please notify the sender immediately, and delete this email from your
system. We do not guarantee that this material is free from viruses or any
other defects although due care has been taken to minimize the risk. Any
views expressed in this message are those of the individual sender, except
where the sender specifically states them to be the views of Cashworks
Corporate Services Ltd, PO Box 31 512, Lower Hutt NZ 5040.

 

 

-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
eGroupWare-users mailing list
[e-mail]
https://lists.sourceforge.net/lists/listinfo/egroupware-users