with php directory script when i create a news article I get(An error occurred while executing. Please try again later!).... any suggestions.
Bill
news
Moderator: alexandrleonenko
-
- Site Admin
- Posts: 6176
- Joined: Jan 7th, '09, 23:18
- Contact:
Re: news
Open News class and define debug = true;
Then see error description.
Then see error description.
Re: news
Hello ravindararya
After determining the class (almost at the top).
Look for lines
Regards
After determining the class (almost at the top).
Look for lines
Code: Select all
class News extends MicroGrid {
protected $debug = false;
....
Regards
-
- Junior
- Posts: 11
- Joined: Sep 1st, '17, 09:21
Re: news
After change in debug = true; showing this error at admin pannel
Total running time: 0.00241 sec.
Errors(1):
------
* SELECT COUNT(*) as mg_total_records, id, type, header_text, body_text, DATE_FORMAT(news.date_created, '%d %b, %Y %H:%i') as mod_date_created, CASE WHEN type = "events" THEN CONCAT("events", " (", (SELECT COUNT(*) as cnt FROM events_registered er WHERE er.event_id = news.id), ")") ELSE type END as type_link, is_active FROM news WHERE language_id = 'en' LIMIT 0, 1
Unknown column 'is_active' in 'field list'
Warnings(1):
------
* SELECT COUNT(*) as mg_total_records, id, type, header_text, body_text, DATE_FORMAT(news.date_created, '%d %b, %Y %H:%i') as mod_date_created, CASE WHEN type = "events" THEN CONCAT("events", " (", (SELECT COUNT(*) as cnt FROM events_registered er WHERE er.event_id = news.id), ")") ELSE type END as type_link, is_active FROM news WHERE language_id = 'en' LIMIT 0, 1
SQL:
------
Retrieve Records | T: 0.0002 sec.
SELECT id, type, header_text, body_text, DATE_FORMAT(news.date_created, '%d %b, %Y %H:%i') as mod_date_created, CASE WHEN type = "events" THEN CONCAT("events", " (", (SELECT COUNT(*) as cnt FROM events_registered er WHERE er.event_id = news.id), ")") ELSE type END as type_link, is_active FROM news WHERE language_id = 'en' ORDER BY date_created DESC LIMIT 0, 20
POST:
------
Array
(
)
Total running time: 0.00241 sec.
Errors(1):
------
* SELECT COUNT(*) as mg_total_records, id, type, header_text, body_text, DATE_FORMAT(news.date_created, '%d %b, %Y %H:%i') as mod_date_created, CASE WHEN type = "events" THEN CONCAT("events", " (", (SELECT COUNT(*) as cnt FROM events_registered er WHERE er.event_id = news.id), ")") ELSE type END as type_link, is_active FROM news WHERE language_id = 'en' LIMIT 0, 1
Unknown column 'is_active' in 'field list'
Warnings(1):
------
* SELECT COUNT(*) as mg_total_records, id, type, header_text, body_text, DATE_FORMAT(news.date_created, '%d %b, %Y %H:%i') as mod_date_created, CASE WHEN type = "events" THEN CONCAT("events", " (", (SELECT COUNT(*) as cnt FROM events_registered er WHERE er.event_id = news.id), ")") ELSE type END as type_link, is_active FROM news WHERE language_id = 'en' LIMIT 0, 1
SQL:
------
Retrieve Records | T: 0.0002 sec.
SELECT id, type, header_text, body_text, DATE_FORMAT(news.date_created, '%d %b, %Y %H:%i') as mod_date_created, CASE WHEN type = "events" THEN CONCAT("events", " (", (SELECT COUNT(*) as cnt FROM events_registered er WHERE er.event_id = news.id), ")") ELSE type END as type_link, is_active FROM news WHERE language_id = 'en' ORDER BY date_created DESC LIMIT 0, 20
POST:
------
Array
(
)