Jump to content


Photo
- - - - -

[SOLVED] Error when viewing news


5 replies to this topic

#1 Ben Morton

Ben Morton

    Member

  • Members
  • PipPip
  • 10 posts

Posted 09 November 2013 - 08:37 AM

Hi all,

When I post a news topic (after I've turned off the OpenCart 1.5.6 Fixes), if I go to the page and click the news item, I get the following errors:

Notice: Undefined index: keyword in catalog/controller/information/news.php on line 53 Google it
Notice: Undefined index: viewed in catalog/controller/information/news.php on line 62 Google it
Notice: Error: Unknown column 'viewed' in 'field list'
Error No: 1054
UPDATE news SET viewed = (viewed + 1) WHERE news_id = '2' in system/database/mysql.php on line 50 Google it

 

I've replaced the old news module with the newer one by villagedefrance.

 

I'm running OpenCart 1.5.6 with the latest version of OpenShop (1.6. B)


Edited by Ben Morton, 10 November 2013 - 04:04 AM.

  • 0

#2 Ivan Pramono Susanto

Ivan Pramono Susanto

    Advanced Member

  • Members
  • PipPipPip
  • 141 posts

Posted 09 November 2013 - 09:57 AM

there's a change in sql database if you update to newest version

have you edit it's sql database?


  • 0

#3 Ben Morton

Ben Morton

    Member

  • Members
  • PipPip
  • 10 posts

Posted 09 November 2013 - 11:22 AM

I haven't changed anything in the database...


  • 0

#4 Ivan Pramono Susanto

Ivan Pramono Susanto

    Advanced Member

  • Members
  • PipPipPip
  • 141 posts

Posted 09 November 2013 - 11:26 AM

for fresh install before using news mod it's ok

but after installing news that would be a problem

see my other post about news and how to upgrade it's database

hope it will help

http://devs.mx/topic...ce-news-module/


  • 1

#5 Ben Morton

Ben Morton

    Member

  • Members
  • PipPip
  • 10 posts

Posted 10 November 2013 - 04:03 AM

All fixed; thank you!


  • 0

#6 Ivan Pramono Susanto

Ivan Pramono Susanto

    Advanced Member

  • Members
  • PipPipPip
  • 141 posts

Posted 10 November 2013 - 11:31 AM

your welcome =^0^=


  • 0



Reply to this topic



  



 

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

Community Skin by Fredson Nunes Junior