Details
-
Type: Bug
-
Status: Done/Fixed
-
Priority: Major
-
Resolution: Fixed/Completed
-
Affects Version/s: 1.0
-
Fix Version/s: 1.1
-
Component/s: Technical infrastructure
-
Labels:None
Description
I may possibly have a configuration issue, but I installed the 1.0 beta of CivicRM at http://www.erielead.org. I had to manually create the database erielead_civicrm because I had some problems running the setup.php4.sh script. I was able to paste in the SQL for Contacts.SQL and GeneratedData.SQL and the tables are indeed created and populated. If I use phpMYsqlAdmin, I can browse the tables, and they are indeed populated with data.
The Administer CivicRM seems to display okay (That is, I see lines with data) for each of the tabs apart from CivicRM profile. When I click on the CivicRM profile, I get a message about
user warning: Smarty error: unable to read resource: "CRM/Uf/Page/Group.tpl" in /home/erielead/public_html/modules/civicrm/packages/Smarty/Smarty.class.php on line 1088.
I checked, and the folder is named UF, not Uf, I copied over a version giving it a name of Uf. However, I looked in the Page folder and there is a Group.php, but no files named .tpl.
I seem to be having a problem with contacts, however, if I do a search, it displayes effectively lines with blank fields for all of the contacts, but no data. (I.e. I put myself in as new contact, and now have 103 contacts. if I look for my last name, I see 1 blank line, if I search for all contacts, I see 103)
The link to edit each line is http://www.erielead.org/civicrm/contact/edit?reset=1&cid= (i.e. no contactid)
If I click on a link to Edit the contact, I get:
Sorry. A non-recoverable error has occurred.
Could not get a contact_id and/or contact_type
Return to CiviCRM menu.
If I click on a link to view the contact, I get:
user error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ( ( 1 ) OR ( 1 ) )' at line 10
query: SELECT * FROM blocks WHERE status = 1 AND region IN ('0') ORDER BY weight, module in /home/erielead/public_html/includes/database.mysql.inc on line 66.
Fatal error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ( ( 1 ) OR ( 1 ) )' at line 10 query: INSERT INTO watchdog (uid, type, message, severity, link, location, hostname, timestamp) VALUES (1, 'php', 'You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near \'AND ( ( 1 ) OR ( 1 ) )\' at line 10 query: SELECT * FROM blocks WHERE status = 1 AND region IN (\'0\') ORDER BY weight, module in /home/erielead/public_html/includes/database.mysql.inc on line 66.', 2, '', '/civicrm/contact/view?reset=1&cid=', '71.116.23.89', 1120706777) in /home/erielead/public_html/includes/database.mysql.inc on line 66
Fatal error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND ( ( 1 ) OR ( 1 ) )' at line 10 query: UPDATE sessions SET uid = 1, hostname = '71.116.23.89', session = 'messages|a:0:{}watchdog_overview_filter|s:3:\"all\";contact_count|i:25;CiviCRM|a:14:{s:4:\"ufID\";s:1:\"1\";s:6:\"userID\";i:101;s:8:\"domainID\";i:1;s:7:\"ufEmail\";s:20:\"mmahler@erielead.org\";s:11:\"userContext\";a:4:
{i:0;s:57:\"/home/erielead/public_html/civicrm/contact/search?force=1\";i:1;s:31:\"/civicrm/contact/search?force=1\";i:2;s:40:\"/civicrm/contact/search/advanced?force=1\";i:3;s:31:\"/civicrm/contact/search?force=1\";}s:31:\"CRM_Admin_Page_RelationshipType\";a:1:
{s:6:\"action\";i:16;}s:27:\"CRM_Admin_Page_LocationType\";a:1:
{s:6:\"action\";i:16;}s:17:\"CRM_Uf_Page_Group\";a:1:{s:6:\ in /home/erielead/public_html/includes/database.mysql.inc on line 66
Warning: Unknown(): A session is active. You cannot change the session module's ini settings at this time. in Unknown on line 0