news

Discuss everything related to Business Directory. All versions. Any questions related to the Business Directory developing or using should be posted to this forum.

Moderators: ne_moj, zewa

hireapro
Newbie
Newbie
Posts: 2
Joined: Jun 9th, '16, 18:42

news

Postby hireapro » Jun 12th, '16, 23:08

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
Site Admin
Site Admin
Posts: 5937
Joined: Jan 7th, '09, 23:18
Contact:

Re: news

Postby administrator » Jun 13th, '16, 09:37

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

ravindararya
Junior
Junior
Posts: 11
Joined: Sep 1st, '17, 09:21

Re: news

Postby ravindararya » Sep 4th, '17, 04:25

In which line sir?

ne_moj
Master
Master
Posts: 243
Joined: Jan 1st, '16, 14:11

Re: news

Postby ne_moj » Sep 4th, '17, 07:45

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
Master
Master
Posts: 243
Joined: Jan 1st, '16, 14:11

Re: news

Postby ne_moj » Sep 4th, '17, 07:48

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

ravindararya
Junior
Junior
Posts: 11
Joined: Sep 1st, '17, 09:21

Re: news

Postby ravindararya » Sep 4th, '17, 12:40

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
Master
Master
Posts: 243
Joined: Jan 1st, '16, 14:11

Re: news

Postby ne_moj » Sep 5th, '17, 11:13

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


Return to “ApPHP Business Directory / uBusinessDirectory Talk {developers/users}”