Hello,
I've tried to install this add-on, v3.0.2, for the first time on my test site, hopefully according to the instructions (I did not have a tpl_index_default.php file yet, so all the files in the add-on could be copied as-is, I merely ensured they had correct ownership and permissions on my linux system).
The problem is that the DB initialization did not seem to work, so although the Admin menus for the add-on all appear fine, and I have the ability to create articles, which I did: a single Type 1 article in both English and Japanese (my two site languages). Unfortunately, when I activate the sidebox for New Type 1 in order to actually display on storefront, I get a "An error appeared, please refresh page" type of error in the location where the sidebox should appear.
Interestingly, no debug log is produced. However, when I set strict debugging, the on-page warning turns into the very clear indication that the DB tables were not created as expected:
Code:
1146 Table 'zencartshoptest.TABLE_BOX_NEWS_CONTENT' doesn't exist
in:
[SELECT nc.news_title, nc.news_content, n.* FROM TABLE_BOX_NEWS_CONTENT nc INNER JOIN TABLE_BOX_NEWS n ON n.box_news_id = nc.box_news_id AND nc.languages_id = 3 WHERE n.news_status = 1 AND now() >= n.news_start_date AND (n.news_end_date IS NULL OR now() <= n.news_end_date) ORDER BY n.news_start_date DESC, n.box_news_id DESC LIMIT 5]
Obviously, something went wrong, but I am unsure what best to do to fix the situation.
I also noticed that there was a file in the add-on not listed in the HTML instructions:
Code:
YOUR_ADMIN/includes/classes/observers/NewsBoxManagerAdminObserver.php
and that there was no observer in my ADMIN/classes directory yet, so that meant the new addition of a directory in my ADMIN folder.
Any other information required, please ask. I will wait before uninstalling and trying to re-install.
Bookmarks