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

news

Postby hireapro on 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
hireapro
Newbie
Newbie
 
Posts: 2
Joined: Jun 9th, '16, 18:42

Re: news

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

Open News class and define debug = true;
Then see error description.
User avatar
administrator
Site Admin
Site Admin
 
Posts: 5914
Joined: Jan 7th, '09, 23:18

Re: news

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

In which line sir?
ravindararya
Newbie
Newbie
 
Posts: 8
Joined: Sep 1st, '17, 09:21

Re: news

Postby ne_moj on 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
User avatar
ne_moj
Master
Master
 
Posts: 240
Joined: Jan 1st, '16, 14:11

Re: news

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

ApPHP Business DIrectory and uBusinessDIrectory are two different products. This option is suitable for ApPHP Business Directory.
User avatar
ne_moj
Master
Master
 
Posts: 240
Joined: Jan 1st, '16, 14:11

Re: news

Postby ravindararya on 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
(
)
ravindararya
Newbie
Newbie
 
Posts: 8
Joined: Sep 1st, '17, 09:21

Re: news

Postby ne_moj on 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
User avatar
ne_moj
Master
Master
 
Posts: 240
Joined: Jan 1st, '16, 14:11


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

Who is online

Users browsing this forum: No registered users and 1 guest