-1

If anyone familiar with contao, I got a default contao error page when I try to create a news archive, I have check the log and nothing is wrong. Do I need add the news module first?

P.S I am newbie contao user, as a client only asked me to resolve this problem.

Last error log : 

[12-Jan-2017 12:46:29 GMT] PHP Fatal error: Uncaught exception 'Exception' with message 'Query error: Unknown column 'master' in 'where clause' (SELECT id, title 
                FROM tl_news_archive 
                WHERE jumpTo IN (315) AND master=0 
                ORDER BY title)' thrown in /homepages/19/d124359810/htdocs/2016/system/modules/core/library/Contao/Database/Statement.php on line 295

I use 2 languages for the website with language extension. I wonder if it has something to do with the language setting of main archive, because it somehow tells the error of unknown "master"

this is the screenshot of the interface when I tried to create a news archive. Image : create new news archive

Pragmaticoder
  • 81
  • 1
  • 11

1 Answers1

0

Your database is missing a column from the changelanguage extension. If you still have this extension installed, simply log into the Contao Install Tool and execute a database update.

fritzmg
  • 2,494
  • 3
  • 21
  • 51
  • Would it be possible to updating manually by adding the master table from phpmyadmin? or there's no way but update database using the install tool? – Pragmaticoder Jan 13 '17 at 08:56
  • You can update the database via the Install Tool or via the Extension Repository. From your initial post I guess you have access to both of those things, since the error only occurs when creating a news archive? – fritzmg Jan 13 '17 at 22:47
  • It happens not only for news archive but also for creating feeds and calendar unfortunately. – Pragmaticoder Jan 15 '17 at 21:46
  • Yes, then simply make a database update via the Contao backend or the Install Tool and you should be fine ;) – fritzmg Jan 16 '17 at 10:35
  • I use the install tool to update but unfortunately this is what I have, after running the update : Fatal error: Uncaught exception Exception with message Query error: Duplicate entry '5311731150a4248ce922b13ea84cd792-205' for key 'checksum_pid' (ALTER TABLE `tl_search` ADD UNIQUE KEY `checksum_pid` (`checksum`, `pid`);) thrown in system/modules/core/library/Contao/Database/Statement.php on line 295 #0 system/modules/core/library/Contao/Database.php(207): Contao\Database\Statement->query('ALTER TABLE `tl...') #1 system/modules/core/controllers/BackendInstall.php(616): .............. – Pragmaticoder Jan 16 '17 at 13:47
  • When I tried to run the database update via backend it is also the same, showing the error with the indication to check the system log – Pragmaticoder Jan 16 '17 at 13:55
  • I run the update with only selecting the creation of news and archive with master table and it works now. Thank you @fritzmg ! now on to another issues :D – Pragmaticoder Jan 16 '17 at 13:59
  • Regarding the `Duplicate entry` error: simply purge the search cache in the maintenance section of the backend. Then run the database update again. – fritzmg Jan 16 '17 at 15:44