Page 2 of 5
Re: Updated Modules
Posted: Tue Aug 11, 2009 7:30 pm
by Rich
Well that did it

Thank you for the replay and support.
Re: Updated Modules
Posted: Sun Aug 23, 2009 10:12 pm
by czLEONcz
Hello all,
I implemented the module news 1.3.0.
The administration / news pages I error:
Code: Select all
Error: Table 'oc130.news' doesn't exist
Error No: 1146
SELECT COUNT(*) AS total FROM news
homepage shop I error:
Code: Select all
Error: Table 'oc130.news' doesn't exist
Error No: 1146
SELECT * FROM news n LEFT JOIN news_description nd ON (n.news_id = nd.news_id) WHERE nd.language_id = '1' AND n.status = '1' ORDER BY n.date_added DESC
Please help...
I do not know where I am doing a mistake.
Thank you very much
Re: Updated Modules
Posted: Wed Aug 26, 2009 11:01 am
by fido-x
The sql file that is included in the package to load the tables into the database needs to be edited before you run it. This file refers to the tables as "DB_PREFIXnews" and DB_PREFIXnews_description". You must replace "DB_PREFIX" with your own database prefix. For example, if you are using "oc_" as your database prefix, then replace "DB_PREFIX" with "oc_" before adding the tables to your database.
Hope this helps.
Re: Updated Modules
Posted: Wed Aug 26, 2009 7:10 pm
by czLEONcz
fido-x thank you very much.
Everything is OK.
Re: Updated Modules
Posted: Wed Aug 26, 2009 7:28 pm
by czLEONcz
Hi all,
How do I change the date format:
Date Added: 26-Aug-2009
On this date format
Date Added: 26-08-2009
Thank you.
Re: Updated Modules
Posted: Fri Aug 28, 2009 9:02 am
by fido-x
To change the date format, edit "catalog/controller/information/news.php".
Change line 71 from
Code: Select all
'date_added' => date('j-M-Y', strtotime($result['date_added']))
to
Code: Select all
'date_added' => date('j-m-Y', strtotime($result['date_added']))
You'll find more information about what the letters in the date() function mean from
http://www.w3schools.com/php/func_date_date.asp
Re: Updated Modules
Posted: Fri Aug 28, 2009 4:46 pm
by czLEONcz
fido-x thank you very much.
Sponsor_130
Posted: Tue Sep 01, 2009 12:51 pm
by madany
when i choose insert and save it, nothing happens. i still have "No results!" in catalog/sponsors window. i have followed your instructions to install it and no errors. and more question, why i cant upload image?? image doesnt show up after i pick it from directory. whats the difference between "HelperImage::resize" and "image_resize"?
i always had error with "HelperImage::resize".

Re: Updated Modules
Posted: Tue Sep 01, 2009 7:48 pm
by Qphoria
fido-x wrote:To change the date format, edit "catalog/controller/information/news.php".
Change line 71 from
Code: Select all
'date_added' => date('j-M-Y', strtotime($result['date_added']))
to
Code: Select all
'date_added' => date('j-m-Y', strtotime($result['date_added']))
You'll find more information about what the letters in the date() function mean from
http://www.w3schools.com/php/func_date_date.asp
Should date maybe be pulled from the main language file to keep it all in one place?
// Locale
$_['code'] = 'en';
$_['direction'] = 'ltr';
$_['date_format_short'] = 'd/m/Y';
$_['date_format_long'] = 'l dS F Y';
$_['time_format'] = 'h:i:s A';
Re: Updated Modules
Posted: Wed Sep 02, 2009 9:36 pm
by czLEONcz
Thank you for the explanation Qphoria.
Re: Updated Modules
Posted: Sat Sep 05, 2009 3:24 pm
by fido-x
Qphoria wrote:Should date maybe be pulled from the main language file to keep it all in one place?
// Locale
$_['code'] = 'en';
$_['direction'] = 'ltr';
$_['date_format_short'] = 'd/m/Y';
$_['date_format_long'] = 'l dS F Y';
$_['time_format'] = 'h:i:s A';
Now, why didn't I think of that?

I'll take that into account for the next update.
Re: Updated Modules
Posted: Sat Sep 12, 2009 2:15 pm
by fido-x
OK. You've been waiting for them -- here they are.
Homepage Package This package has been enhanced by the inclusion of a "Special Offers" module and a "Featured Products" module. Full installation instructions included.
http://www.fido-x.net/index.php?route=p ... duct_id=45
Events Calendar http://www.fido-x.net/index.php?route=p ... duct_id=43
FAQs http://www.fido-x.net/index.php?route=p ... duct_id=44
News Pages and Module http://www.fido-x.net/image/cache/news_1x-120x90.jpg
Sponsors Module This update opens the sponsor link in a new window.
http://www.fido-x.net/index.php?route=p ... duct_id=46
Enjoy.
Re: Updated Modules
Posted: Sun Sep 13, 2009 8:16 am
by nzjolly
Step 4: Catalog Components
Edit your store‘s "catalog/controller/module/information.php" file by adding the following lines:–
$this->data['text_faq'] = $this->language->get('text_faq');
$this->data['faq'] = $this->url->http('information/faq');
cannot seem to find this, in this location?
Re: Updated Modules
Posted: Sun Sep 13, 2009 10:38 am
by nzjolly
also getting a few errors?
/admin/view/template/catalog/faq_form.tpl on line 15
/admin/view/template/catalog/faq_form.tpl on line 29
not sure if this is a problem or not?
Re: Updated Modules
Posted: Sun Sep 13, 2009 5:56 pm
by myopen
hello fido_x,
I wanted to thank you for the outstanding contributions that allows you to use. You are really great .... thanks.
I want to point out some things not going well in module "news" 1.3.2.
1) If I insert the words links into a news that I create from admin -> catalog -> news pages, in homepage module "news" can be seen, but if I click on "read more" in a news to me open pages with strange links :
http://www ...% 20% 20% 3Ca% 20href% 3D/...but if I delete all the links works included in my news it works .. I do not understand why?
2) In Internet Explorer 7 is a bad view of the page on all the news (information / news). If I click on the module "Information" link "news" in IE7 makes me look all the news at the bottom with a big empty space in the center. In Chrome and Firefox, however, we see perfectly ... everything works. Only in IE7 not working.
3) Another problem related to the page "information / news", if I click or from the homepage link "news" from the information form, or click "headlines" from the page on the entire description of the news, I get the following error at the top:
Notice: Undefined offset: 1 in C:\Programs\EasyPHP3.1\www\mysite\catalog\controller\information\news.php on line 71
-------------------
The module is great news .. compliments .. but when not working well for OpenCart 1.3.2. I hope you can solve problems that I've listed above. I'm enclosing the images to better understand .. excuse my bad English.
Re: Updated Modules
Posted: Sun Sep 13, 2009 10:19 pm
by myopen
hello .. I understand where is the problem. If I create my pages without inserting links in news .. everything worked. ... is a problem of links that join the words. If I associate a word a link to me from all the mistakes that I have outlined above.
Then .. Fullsize not work in the catalog / news pages / images
How come when I put links inside the pages news gives me all those mistakes I mentioned above and the module is not working well?
Re: Updated Modules
Posted: Tue Sep 15, 2009 1:05 am
by myopen
Hello great fido-x,
I found some strangeness in the module FAQs 1.3.2 after I've installed with your information presente into a folder installation:
1) Do not you see the button at the bottom to return to the list of general FAQs.
2) The height of the box that contains the FAQs is out of proportion ... If I put a short answer is the box is very high.
I'm enclosing a picture, hoping that would resolve the problems.
Your modules are great
Re: Updated Modules
Posted: Wed Sep 16, 2009 12:44 pm
by fido-x
nzjolly wrote:also getting a few errors?
/admin/view/template/catalog/faq_form.tpl on line 15
/admin/view/template/catalog/faq_form.tpl on line 29
not sure if this is a problem or not?
Sorry about that!
Change line 15 to:
Code: Select all
<td><input name="faq_description[<?php echo $language['language_id']; ?>][title]" value="<?php echo isset($faq_description[$language['language_id']]) ? $faq_description[$language['language_id']]['title'] : ''; ?>" />
and change line 29 to:
Code: Select all
<td><textarea name="faq_description[<?php echo $language['language_id']; ?>][description]" id="description<?php echo $language['language_id']; ?>"><?php echo isset($faq_description[$language['language_id']]) ? $faq_description[$language['language_id']]['description'] : ''; ?></textarea>
I'll fix this up and release an update.
myopen wrote:Hello great fido-x,
I found some strangeness in the module FAQs 1.3.2 after I've installed with your information presente into a folder installation:
1) Do not you see the button at the bottom to return to the list of general FAQs.
2) The height of the box that contains the FAQs is out of proportion ... If I put a short answer is the box is very high.
I'm enclosing a picture, hoping that would resolve the problems.
Your modules are great
The "middle" class in the default stylesheet has a minimum height. It's the same class that used for the "middle" section of every page in the OpenCart system.
With regard to a button to return to the list of general FAQs, I'll include that in the next update.
myopen wrote:hello .. I understand where is the problem. If I create my pages without inserting links in news .. everything worked. ... is a problem of links that join the words. If I associate a word a link to me from all the mistakes that I have outlined above.
Then .. Fullsize not work in the catalog / news pages / images
How come when I put links inside the pages news gives me all those mistakes I mentioned above and the module is not working well?
The column module displays the first sentence with a "read more" link, the headlines page displays the first 2 sentences with a "read more" link. How this is done, is by breaking up your news story into an array, using the "full stop" as a delimiter. Your problem occurs because the "full stop" at the end of a sentence is the same character as the "dot" in a web address.
As for the "undefined offset" error, I think this is related to the "error page" not displaying when there are no news stories. I'll look into it.
Re: Updated Modules
Posted: Wed Sep 16, 2009 4:49 pm
by myopen
thanks fido-x
By this I mean that:
For module NEWS:
a) I can not insert links within individual news? ... if I can post links as I do that?
2) I hope will solve the problem of fullsize images in ..admin / catalog / news pages / images
----------------------------------------------
For module FAQs:
1) I hope that in the next release of the module insert a button (similar to the news module) to return to index of all FAQs.
----------------------------------------------
when do you think of the new update of module FAQ and NEWS?
PS= Many thanks fido-x ... I see that in this forum there are 4 special people and you're one of these people (including imaginetech, Daniel, q-Phoria)... Thank you OpenCart become the Number 1 in e-commerce!
Re: Updated Modules
Posted: Wed Sep 16, 2009 8:39 pm
by kornovec
Hey ho!
really great module News 132!!!
But Im having trouble when i click on NEWS PAGES. I get error msg:
Notice: Undefined offset: 1 in D:\xampp\htdocs\oc\catalog\controller\information\news.php on line 71
What is that mean?
Thanks!
K.