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 »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Help! Unknown DB Error on transact Page
Pages: [1]

Author Topic: Help! Unknown DB Error on transact Page  (Read 4115 times)

Shawn_LaLucha

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: Drupal 7
  • MySQL version: 5.1.67
  • PHP version: 5.3.3
Help! Unknown DB Error on transact Page
June 10, 2013, 11:01:42 am
I'm a relatively new user with a very small non-profit and we're about to launch our first CiviCRM site.. I have implemented CiviCRM with Drupal 7 and everything seems to be working famously, except that when I go to make contributions I go through the entire process but when I click to confirm and pay for my contribution i get a db error.

We are using PayPal Payments Standard (business account) for our payment processing.  Previously during the build of the site I had done a test payment, but that was prior to changing over to our new domain.. When I migrated from local to production I did the test, but then after taking off civi and reinstalling it on the new domain (following some instructions I found online... thanks community!), re-importing db except a few cache and civicrm_domain tables ... but none the less it doesn't work.

Help as to where I should start in troubleshooting this issue would be much appreciated - my constituents wanted us to go live on Friday..

One last note: I do have IPN set in paypal with the correct domain, and I did clear caches and make sure the base url in civi setup - as far as i could find - matches ...

Thanks very much for any responses and assistance. I appreciate all the terrific work the CiviCRM community has done and look forward to joining in !



Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: Help! Unknown DB Error on transact Page
June 10, 2013, 11:10:40 am
Check /files/civicrm/configAndLog directory on your server for any relevant log messages and post them here.
If you don't find any, try turning on debugging and backtrace in system settings then submit the payment again. If you get a backtrace output on your screen, post it here.

Also, did you try something simple like deleting the payment processor, creating it again, and updating the contribution page with the "new" processor?
Try asking your question on the new CiviCRM help site.

Shawn_LaLucha

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: Drupal 7
  • MySQL version: 5.1.67
  • PHP version: 5.3.3
Re: Help! Unknown DB Error on transact Page
June 10, 2013, 02:53:04 pm
Doesn't seem to trigger a log, but it does give me more info with backtrace (thanks by the way, thought those would pop up if errors were on in Drupal.)..

Thanks so much for your help Coleman - it's much appreciated!

Here is what I get:

Coleman Watts

  • Administrator
  • I’m (like) Lobo ;)
  • *****
  • Posts: 2346
  • Karma: 183
  • CiviCRM version: The Bleeding Edge
  • CMS version: Various
Re: Help! Unknown DB Error on transact Page
June 10, 2013, 03:02:49 pm
The relevant message seems to be: "Cannot load from mysql.proc. The table is probably corrupted"
Since that is not specific to Civi but is a general mysql error you might want to google it. Just a guess but something might have gone wrong with your migration from one server to the other.
Try asking your question on the new CiviCRM help site.

Shawn_LaLucha

  • I’m new here
  • *
  • Posts: 8
  • Karma: 0
  • CiviCRM version: 4.3
  • CMS version: Drupal 7
  • MySQL version: 5.1.67
  • PHP version: 5.3.3
Re: Help! Unknown DB Error on transact Page
June 11, 2013, 08:20:56 am
Thanks Coleman it was as simple as running a mysql command and was fixed.

Thanks agian.

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using CiviContribute (Moderator: Donald Lobo) »
  • Help! Unknown DB Error on transact Page

This forum was archived on 2017-11-26.