Author Topic: Unable to import CiviCRM 4.3.5 database(on to shared server) (Read 2304 times)

rohanchavan · August 11, 2013, 11:56:24 pm

I have a CiviCRM 4.3.5 database which need to import it on server,but it is giving me DELIMITER error while importing.
Here is the error

DELIMITER ;; /*!50003 CREATE*//*!50017 DEFINER=`xxxx`@`localhost`*//*!50003 TRIGGER civicrm_address_after_insert after insert ON civicrm_address FOR EACH ROW BEGIN UPDATE civicrm_contact SET modified_date = CURRENT_TIMESTAMP WHERE id = NEW.contact_id; END */ ;;

#1227 - Access denied; you need the SUPER privilege for this operation

This works fine for CiviCRM 4.2 database. As shared server do not give super privilege to shared user.
Is there any specific change done in CiviCRM 4.3 ?

Hershel · August 12, 2013, 02:37:18 am

Remove all instances of

/*!50017 DEFINER=`xxxx`@`localhost`*/

and try again.

rohanchavan · August 12, 2013, 05:55:04 am

Thanks Hershel, it worked.

adizo · February 09, 2014, 04:06:24 am

How do i remove the instances: I have the same problem: here is my own error message:
--
-- Database: `bsociety3_portal`
--
DELIMITER $$--
-- Functions
--
CREATE DEFINER = `root`@`localhost` FUNCTION `civicrm_strip_non_numeric` (

input VARCHAR( 255 ) CHARACTER SET utf8
) RETURNS VARCHAR( 255 ) CHARSET utf8NO SQL DETERMINISTIC BEGIN DECLARE output VARCHAR( 255 ) CHARACTER SET utf8 DEFAULT '';

DECLARE iterator INT DEFAULT 1;

WHILE iterator < ( LENGTH( input ) +1 ) DO IF SUBSTRING( input, iterator, 1 ) IN (
'0', '1', '2', '3', '4', '5', '6', '7', '8', '9'
) THEN SET output = CONCAT( output, SUBSTRING( input, iterator, 1 ) ) ;

END IF ;

SET iterator = iterator +1;

END WHILE;

RETURN output;

END$$

Hershel · February 09, 2014, 04:18:42 am

Remove all instances of

Code: [Select]

DEFINER = `root`@`localhost`
and try again.

adizo · February 09, 2014, 04:32:35 am

Thanks. what about the 'Create' text. do l leave that.
Also, do edit the mysql file to remove the instances.

Hershel · February 09, 2014, 04:57:38 am

You must use a text editor (Google to find one--you can use a free open source one) and remove only exactly the text that I quoted above and nothing more. Thus the word "CREATE" should remain.

adizo · February 09, 2014, 05:17:57 am

Thanks a lot. resolved.

CiviCRM Community Forums (archive)

News:

Author Topic: Unable to import CiviCRM 4.3.5 database(on to shared server) (Read 2304 times)

rohanchavan

Unable to import CiviCRM 4.3.5 database(on to shared server)

Hershel

Re: Unable to import CiviCRM 4.3.5 database(on to shared server)

rohanchavan

Re: Unable to import CiviCRM 4.3.5 database(on to shared server)

adizo

Re: Unable to import CiviCRM 4.3.5 database(on to shared server)

Hershel

Re: Unable to import CiviCRM 4.3.5 database(on to shared server)

adizo

Re: Unable to import CiviCRM 4.3.5 database(on to shared server)

Hershel

Re: Unable to import CiviCRM 4.3.5 database(on to shared server)

adizo

Re: Unable to import CiviCRM 4.3.5 database(on to shared server)