–– Support ––

Community Forum

This forum has now moved to https://suitecrm.com/forum

You can still use the forum below to look at historical SuiteCRM and SugarCRM issues and fixes.

Welcome, Guest
Username: Password:
Please post all questions or issues about AOP 1.x here

TOPIC: MySQL error 1054: Unknown column 'state' in 'field

MySQL error 1054: Unknown column 'state' in 'field 5 years 11 months ago #3852

  • staypo
  • staypo's Avatar
  • Offline
  • Fresh Boarder
  • Posts: 1
  • Karma: 0
I have some Problems with the AOP.

The first thing is that i can't upload files in a case in Joomla. I see the note in Sugar but there is no file.

The second thing is, that i cant update a case in SugarCRM because i get the Error Database failure, look in the sugarcrm.log


Sun Sep 29 10:46:59 2013 [17694][e0759786-6560-1994-a21c-5229aeb6687e][FATAL] Error updating table: cases: Query Failed: UPDATE cases
SET name='Iphone 5 Kontakte',date_modified='2013-09-29 08:46:59',modified_user_id='e0759786-6560-1994-a21c-5229aeb6687e',created_by='1',description='Die Kontakte sync. nicht mit dem Exchange Server',assigned_user_id='e0759786-6560-1994-a21c-5229aeb6687e',type='Administration',status='Open_Assigned',priority='P1',resolution=NULL,work_log=NULL,account_id='d6caa3d4-003f-d4d5-759b-5247e82f5ecc',state='Open'
WHERE cases.id = '190af27b-0892-4dae-ffd1-5247e384655d' AND deleted=0: MySQL error 1054: Unknown column 'state' in 'field list'

My next problem is

Sun Sep 29 11:04:25 2013 [18082][1][FATAL] Failed to load original or custom subpanel data for aop_case_updates in modules/AOP_Case_Updates/metadata/subpanels/default.php
Sun Sep 29 11:04:25 2013 [18082][1][FATAL] Failed to load original or custom subpanel data for aop_case_events in modules/AOP_Case_Events/metadata/subpanels/default.php
The administrator has disabled public write access.

MySQL error 1054: Unknown column 'state' in 'field 5 years 11 months ago #3868

  • Will
  • Will's Avatar
  • Offline
  • Administrator
  • Posts: 953
  • Thank you received: 79
  • Karma: 0
Hi staypo,

Please check your PHP settings and check that your Admin Panel contains the right data/URLs.

Thanks.
Software Support Engineer
SalesAgility - SugarCRM Consultants and Developers
The administrator has disabled public write access.
Time to create page: 0.091 seconds
Powered by Kunena Forum