Welcome, Guest
Username: Password: Remember me

TOPIC: [SOLVED] 500 - An error has occured (Sandbox)

[SOLVED] 500 - An error has occured (Sandbox) 05 Jun 2013 15:26 #7354

  • Pantelis
  • Pantelis's Avatar
  • Offline
  • Senior Member
  • Posts: 47
  • Thank you received: 2
  • Karma: 1
500 - An error has occurred.

Unknown column 'a.publish' in 'field list' SQL=SELECT a.id,a.access,a.publish,a.published,a.customer_code,a.ordering,a.setup_date,a.store_name,a.subscription_audio,a.subscription_end_date,a.subscription_signed,a.subscription_start_date,a.subscription_support,a.subscription_video,_subscription_audio_.audio_subscription_name AS `_subscription_audio_audio_subscription_name`,_subscription_video_.video_subscription_name AS `_subscription_video_video_subscription_name`,_subscription_support_.support_name AS `_subscription_support_support_name`,_access_.title AS `_access_title` FROM jos_demo2580_customers AS a LEFT JOIN `jos_demo2580_audiosubscriptions` AS _subscription_audio_ ON _subscription_audio_.id = a.subscription_audio LEFT JOIN `jos_demo2580_videosubscriptions` AS _subscription_video_ ON _subscription_video_.id = a.subscription_video LEFT JOIN `jos_demo2580_supportsubscriptions` AS _subscription_support_ ON _subscription_support_.id = a.subscription_support LEFT JOIN `jos_viewlevels` AS _access_ ON _access_.id = a.access WHERE (a.published = 1 OR a.published IS NULL OR a.published = 0) ORDER BY a.store_name asc LIMIT 0, 20

Return to Control Panel

Admin Please Help with this... We need to finished our component ASAP.
The administrator has disabled public write access.

Re: 500 - An error has occured (Sandbox) 05 Jun 2013 16:23 #7357

  • admin
  • admin's Avatar
  • Offline
  • Administrator
  • Chef
  • Posts: 3711
  • Thank you received: 984
  • Karma: 140
Edit your publish field.

Edit and save, will rename the field for 'published'. It must be linked to the publish wizard

That's it.
Coding is now a piece of cake
The administrator has disabled public write access.
The following user(s) said Thank You: Pantelis
Time to create page: 0.093 seconds

Get Started