CiviCRM Community Forums (archive)

Thanks, that´s great.

At the moment, when using the Mac command line, I will get this error:

mich:~ mich___$ cat /Users/mich___/Documents/gemeingut_civicrm_change.sql | s|/\\*!50017 DEFINER=`[^`]*`@`[^`]*`\s*\\*/||g'  | sed '/\\*!50013 DEFINER=.*/ d' > /Users/mich___/Documents/gemeingut_civicrm_change2.sql
-bash: !50017: event not found
mich:~ mich___$


The file is not too long, before figuring out the correct commands, would it be possible to just manually find and replace the line DEFINER=`gemeingut`@`%?
In another thread they mentioned to replace it with "", but when I use "" it creates an import error. If "" means blank, to leave nothing
behind, the definers DEFINER=`gemeingut`@`% will be back after the database is imported. This is confusing.

   
         

Thanks for the response! So in my text editor, would I replace the entire 'DEFINER=root @ localhost' string with ""? Or replace 'root @ localhost'? –  FastTrack Feb 25 '12 at 23:02
1       
@FastTrack, please remove the entire string. –  Abhay Feb 26 '12 at 7:53

Best, Michael

Thanks!

I thought the quick mode exports tables plus data, everything.
Is there a way to safe those dump files when exported via quick option?
(I think it´s actually more data as it includes cache files etc.)

I now walk my way back - as there is one backup made last year via the control panel - which should exclude any
import/export issues, right? (as it´s done by the cp backup mode)

Then I will install the civicrm folder from that time (version 4.1.) and hope they both relate and it works.

Unfortunately:

4.1
With the control panel backup (from a previous administrator) and the old civicrm folder, I will
get following error message: DB Error: division by zero

NEW COMMENT: I managed to make a database from 2013 work, it was an automatically generated one, therefore no quick dump and I think
that´s a structure to look at. Civicrm automatically offered to upgrade the database and I can access data now.

(See further down the problems with the newest database which was dumped with quick mode)
Would this be a method? to compare both databases and erase from the newest one everything that´s not in the old one like
definer statements etc. I have to do this manually as I have no knowledge of the command lines)

Can you still have a look at the error log?
I still want to have the newest database work.
Or is there a way to merge the date of the newest database (which doesn't work) with the data from the working one?


4.5
I now focus on the newest backup again (post-upgrade),
I could upload the sql dump after adding a foreign key .... 0 to the file (and a 1 at the end of the file)

Now I geht this old error: DB Error: invalid view

These are the error logs.
(The same as at the beginning of this thread)

Can I step by step make this work? Can you guide me?

Php

[24-Feb-2015 17:11:16 Europe/Berlin] PHP Fatal error:  Call to undefined function is_admin() in /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/CRM/Utils/System/Base.php on line 83

I checked on line 83
      if (is_admin()) {
        require_once (ABSPATH . 'wp-admin/admin-header.php');
      }
      else {
        // FIX ME: we need to figure out to replace civicrm content on the frontend pages
      }
    }


Civicrm:

This is either from one hour before or time is set incorrectly: nonetheless it´s the last entry
(it could be that the swap between databases is still represented in this log, but the newest and
final one is gemeingut_civicrm)

Feb 24 16:09:51  [info] $backTrace = #0 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Error.php(239): CRM_Core_Error::backtrace("backTrace", TRUE)
#1 [internal function](): CRM_Core_Error::handle(Object(DB_Error))
#2 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(931): call_user_func((Array:2), Object(DB_Error))
#3 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/packages/DB.php(975): PEAR_Error->PEAR_Error("DB Error: no such field", -19, 16, (Array:2), "\nSELECT  v.label as label ,v.name as value, v.grouping as grouping\nFROM   c...")
#4 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/packages/PEAR.php(564): DB_Error->DB_Error(-19, 16, (Array:2), "\nSELECT  v.label as label ,v.name as value, v.grouping as grouping\nFROM   c...")
#5 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1905): PEAR->raiseError(NULL, -19, NULL, NULL, "\nSELECT  v.label as label ,v.name as value, v.grouping as grouping\nFROM   c...", "DB_Error", TRUE)
#6 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(899): DB_common->raiseError(-19, NULL, NULL, NULL, "1054 ** Unknown column 'v.label' in 'field list'")
#7 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/packages/DB/mysql.php(328): DB_mysql->mysqlRaiseError()
#8 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/packages/DB/common.php(1216): DB_mysql->simpleQuery("\nSELECT  v.label as label ,v.name as value, v.grouping as grouping\nFROM   c...")
#9 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(2442): DB_common->query("\nSELECT  v.label as label ,v.name as value, v.grouping as grouping\nFROM   c...")
#10 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/packages/DB/DataObject.php(1634): DB_DataObject->_query("\nSELECT  v.label as label ,v.name as value, v.grouping as grouping\nFROM   c...")
#11 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(325): DB_DataObject->query("\nSELECT  v.label as label ,v.name as value, v.grouping as grouping\nFROM   c...")
#12 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/DAO.php(1116): CRM_Core_DAO->query("\nSELECT  v.label as label ,v.name as value, v.grouping as grouping\nFROM   c...", TRUE)
#13 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/OptionGroup.php(152): CRM_Core_DAO::executeQuery("\nSELECT  v.label as label ,v.name as value, v.grouping as grouping\nFROM   c...", (Array:1))
#14 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/PseudoConstant.php(321): CRM_Core_OptionGroup::values("languages", FALSE, FALSE, FALSE, NULL, "label", TRUE, FALSE, "name")
#15 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/CRM/Contact/BAO/Contact.php(3255): CRM_Core_PseudoConstant::get("CRM_Contact_BAO_Contact", "preferred_language", (Array:0), NULL)
#16 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/I18n.php(129): CRM_Contact_BAO_Contact::buildOptions("preferred_language")
#17 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Smarty.php(165): CRM_Core_I18n::languages(TRUE)
#18 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Smarty.php(183): CRM_Core_Smarty->initialize()
#19 /home/gemeingut/www/www/wp-content/plugins/files/civicrm/custom_ext/sfe.donationreceipts/donationreceipts.civix.php(13): CRM_Core_Smarty::singleton()
#20 /home/gemeingut/www/www/wp-content/plugins/files/civicrm/custom_ext/sfe.donationreceipts/donationreceipts.php(29): _donationreceipts_civix_civicrm_config(Object(CRM_Core_Config))
#21 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/CRM/Utils/Hook.php(194): donationreceipts_civicrm_config(Object(CRM_Core_Config))
#22 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/CRM/Utils/Hook.php(133): CRM_Utils_Hook->runHooks((Array:2), "civicrm_config", 1, Object(CRM_Core_Config), NULL, NULL, NULL, NULL, NULL)
#23 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/CRM/Utils/Hook/WordPress.php(69): CRM_Utils_Hook->commonInvoke(1, Object(CRM_Core_Config), NULL, NULL, NULL, NULL, NULL, "civicrm_config", "wordpress")
#24 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/CRM/Utils/Hook.php(907): CRM_Utils_Hook_WordPress->invoke(1, Object(CRM_Core_Config), NULL, NULL, NULL, NULL, NULL, "civicrm_config")
#25 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/CRM/Core/Config.php(256): CRM_Utils_Hook::config(Object(CRM_Core_Config))
#26 /home/gemeingut/www/www/wp-content/plugins/civicrm/civicrm/extern/open.php(7): CRM_Core_Config::singleton()
#27 {main}

Glad you got it fixed. Thank you for reporting back.