A PHP Error was encountered

Severity: 8192

Message: Function create_function() is deprecated

Filename: geshi/geshi.php

Line Number: 4698

Backtrace:

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 4698
Function: _error_handler

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 4621
Function: _optimize_regexp_list_tokens_to_string

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 1655
Function: optimize_regexp_list

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 2029
Function: optimize_keyword_group

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/geshi/geshi.php
Line: 2168
Function: build_parse_cache

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/libraries/Process.php
Line: 45
Function: parse_code

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/models/Pastes.php
Line: 517
Function: syntax

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/application/controllers/Main.php
Line: 693
Function: getPaste

File: /home/httpd/vhosts/scratchbook.ch/geopaste.scratchbook.ch/index.php
Line: 315
Function: require_once

sugarcrm fail - Stikked
Stikked

sugarcrm fail

From Buff Teal, 12 Years ago, written in SQL.
URL http://geopaste.scratchbook.ch/view/78e52cf9
Embed
Download Paste or View Raw
  1.  (SELECT
  2.  contacts.id  ,
  3.  contacts_cstm.projectilelink_c,
  4.  contacts_cstm.alarm_c,
  5.  contacts_cstm.vertragszusatz_c,
  6.  contacts_cstm.escalation_c,
  7.  LTRIM(RTRIM(CONCAT(IFNULL(contacts.first_name,''),
  8.  IFNULL(contacts.last_name,'')))) AS name,
  9.  p0005_organization_contacts_name ,
  10.  p0005_organization_contactsp0005_organization_ida ,
  11.  contacts.phone_work ,
  12.  account_name ,
  13.  account_id ,
  14.  contacts.first_name ,
  15.  contacts.last_name ,
  16.  contacts.salutation ,
  17.  opportunity_role_fields ,
  18.  opportunity_id ,
  19.  contacts.assigned_user_id  ,
  20.  'contacts' panel_name
  21.  
  22.  FROM contacts
  23.  
  24.  LEFT JOIN contacts_cstm ON contacts.id = contacts_cstm.id_c
  25.  INNER JOIN  opportunities_contacts ON contacts.id=opportunities_contacts.contact_id
  26.  AND opportunities_contacts.opportunity_id='9beb9644-6a49-2083-dd40-5028d7e575c9'
  27.  AND opportunities_contacts.deleted=0
  28.  
  29.  WHERE contacts.deleted=0)
  30.  ORDER BY opportunity_role DESC
  31.  LIMIT 0,30

Reply to "sugarcrm fail"