CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • DB Error: no such field -after migrating to new hosting
Pages: [1]

Author Topic: DB Error: no such field -after migrating to new hosting  (Read 1498 times)

NASC2009

  • I post occasionally
  • **
  • Posts: 32
  • Karma: 0
DB Error: no such field -after migrating to new hosting
August 11, 2012, 06:33:06 am
We have Wordpress 3.3.1 with CiviCRM 4.1, everything was fine until out hosting service upgrades our plan to a
new unlimited plan.

We have several profiles from 10 fields to 40 fieldseach . Each one gives the same error after the visitor views the results of their registration on the screen and selects continue.

The hosting service has looked at the document on moving the Civicrm database to a new server but they don't see anything wrong. They have worked on this daily for over a week and have dumped it in our laps to figure out.

We have created a new profile with just one field and we still get the same error. DB error - no such field

Any ideas?

Hershel

  • Forum Godess / God
  • I’m (like) Lobo ;)
  • *****
  • Posts: 4640
  • Karma: 176
    • CiviHosting
  • CiviCRM version: Latest
  • CMS version: Mostly WordPress and Drupal
Re: DB Error: no such field -after migrating to new hosting
August 11, 2012, 12:18:33 pm
Can you compare the DB structure on the old host to the new one? Can you post the exact error? Can you post the PHP and MySQL versions for both hosts?
CiviHosting and CiviOnline -- The CiviCRM hosting experts, since 2007

See here for the official: What to do if you think you've found a bug.

NASC2009

  • I post occasionally
  • **
  • Posts: 32
  • Karma: 0
Re: DB Error: no such field -after migrating to new hosting
August 11, 2012, 06:29:06 pm
Both the previous server and ourcurrent server use the same versions of MySQL and PHP:

MySQL: 5.5.23-55 Percona Server (GPL), Release rel25.3, Revision 2
PHP: PHP 5.2.17

We have checked the old server for nasconline.com, and the content/databases have been removed; we can not make a comparison with the previous installation. However, we do have a dump file from the previous server. The differences between the two database schemas are that several wp_m_* tables have been added into the current version of the database:

wp_m_communications
wp_m_levelmeta
wp_m_member_payments
wp_m_membership_levels
wp_m_membership_news
wp_m_membership_relationships
wp_m_membership_rules
wp_m_ping_history
wp_m_pings
wp_m_subscription_transaction
wp_m_subscriptionmeta
wp_m_subscriptions
wp_m_subscriptions_levels
wp_m_urlgroups

These appear to be from another Wordpress plugin, rather than related to the CiviCRM. The only other differences were in AUTO_INCREMENT start values (which indicates that some data has been inserted into the tables since initial import). All other parameters were identical.

The following are errors on the backend:
Warning: Smarty error: problem creating directory '/home/nasc/public_html/wp-content/plugins/files/civicrm/templates_c/en_US/%%AA' in /home/nasc/public_html/wp-content/plugins/civicrm/civicrm/packages/Smarty/Smarty.class.php on line 1093

Warning: include(/home/nasc/public_html/wp-content/plugins/files/civicrm/templates_c/en_US//%%AA/AA4/AA4260A9%%Delete.tpl.php) [function.include]: failed to open stream: No such file or directory in /home/nasc/public_html/wp-content/plugins/civicrm/civicrm/packages/Smarty/Smarty.class.php on line 1906

Warning: include() [function.include]: Failed opening '/home/nasc/public_html/wp-content/plugins/files/civicrm/templates_c/en_US//%%AA/AA4/AA4260A9%%Delete.tpl.php' for inclusion (include_path='.:/home/nasc/public_html/wp-content/plugins/civicrm/civicrm/:/home/nasc/public_html/wp-content/plugins/civicrm/civicrm//packages:.:/usr/lib/php:/usr/local/lib/php') in /home/nasc/public_html/wp-content/plugins/civicrm/civicrm/packages/Smarty/Smarty.class.php on line 1906

After getting the 'no such field error' we still get  an email stating that someone just completed the application and they are created as a user in Wordpress and in CiviCRM. If we click on the user name in the backend under memberships we immediatlely
get a 'no such field error' also.




Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Installing CiviCRM »
  • WordPress Installations (Moderators: Kurund Jalmi, Coleman Watts) »
  • DB Error: no such field -after migrating to new hosting

This forum was archived on 2017-11-26.