news

[hireapro]

with php directory script when i create a news article I get(An error occurred while executing. Please try again later!).... any suggestions.
Bill

[administrator]

Open News class and define debug = true;
Then see error description.

[ravindararya]

In which line sir?

[ne_moj]

Hello ravindararya

After determining the class (almost at the top).

Look for lines

Code: Select all

class News extends MicroGrid {
   
   protected $debug = false;
....

Regards

[ne_moj]

ApPHP Business DIrectory and uBusinessDIrectory are two different products. This option is suitable for ApPHP Business Directory.

[ravindararya]

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
(
)

[ne_moj]

Hello ravindararya

I do not know what version of ApPHP Business Directory you have, but in any case in the database the "news" table does not have the field "is_active" because of this there is an error.

Regards