Details
-
Type:
Bug
-
Status: Done/Fixed
-
Priority:
Trivial
-
Resolution: Cannot Reproduce
-
Affects Version/s: 3.4.6
-
Fix Version/s: None
-
Component/s: None
-
Labels:None
Description
I am attempting to run the script /sites/all/modules/civicrm/bin/UpdateMembershipRecord.php from a cron job. When I run it, I receive the error pasted below. The error references the table hexagonc_drp1.users, however, all of my drupal tables are prefaced with drp_, which means the proper table name is hexagonc_drp1.drp_users. It appears that the script is not pulling the correct table names.
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" lang="en" xml:lang="en">
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<base href="/sites/all/modules/civicrm/" />
<style type="text/css" media="screen">@import url(/sites/all/modules/civicrm/css/civicrm.css);</style>
<style type="text/css" media="screen">@import url(/sites/all/modules/civicrm/css/extras.css);</style>
<script type="text/javascript" src="/sites/all/modules/civicrm/js/jquery/jquery.crmaccordions.js"></script>
</head>
<body>
<div id="crm-container" lang="en" xml:lang="en">
<div class="messages status"> <div class="icon red-icon alert-icon"></div>
<span class="status-fatal">Sorry. A non-recoverable error has occurred.</span>
<div class="crm-section crm-error-message"></div>
<hr style="solid 1px" />
<div class="crm-section crm-error-message">DB Error: no such table</div>
<div class="crm-accordion-wrapper crm-accordion_title-accordion crm-accordion-closed crm-fatal-error-details-block">
<div class="crm-accordion-header">
<div class="icon crm-accordion-pointer"></div>
Error Details </div><!-- /.crm-accordion-header -->
<div class="crm-accordion-body">
<div class="crm-section">Database Error Code: Table 'hexagonc_drp1.users' doesn't exist, 1146</div>
<div class="crm-section">Additional Details: <p><pre>Array
(
[callback] => Array
(
[0] => CRM_Core_Error
[1] => handle
)
[code] => -18
[message] => DB Error: no such table
[mode] => 16
[debug_info] => SELECT u.* FROM users u WHERE LOWER(u.name) = '***' AND u.pass = '***' AND u.status = 1 [nativecode=1146 ** Table 'hexagonc_drp1.users' doesn't exist]
[type] => DB_Error
[user_info] => SELECT u.* FROM users u WHERE LOWER(u.name) = '***' AND u.pass = '***' AND u.status = 1 [nativecode=1146 ** Table 'hexagonc_drp1.users' doesn't exist]
[to_string] => [db_error: message="DB Error: no such table" code=-18 mode=callback callback=CRM_Core_Error::handle prefix="" info="SELECT u.* FROM users u WHERE LOWER(u.name) = '***' AND u.pass = '***' AND u.status = 1 [nativecode=1146 ** Table 'hexagonc_drp1.users' doesn't exist]"]
)
</pre></p><p></p></div>
</div><!-- /.crm-accordion-body -->
</div><!-- /.crm-accordion-wrapper -->
<p><a href="https://www.hexagoncrm.org/" title="Main Menu">Return to home page.</a></p>
</div>
</div>
<script type="text/javascript">
cj(function() {
cj().crmaccordions();
});
</script>
</body>
</html>