Post by Rich » Tue Aug 11, 2009 7:30 pm

Well that did it :D Thank you for the replay and support.

Rich
Bird is the word


New member

Posts

Joined
Tue Jul 28, 2009 2:56 am
Location - Bird Cage

Post by czLEONcz » Sun Aug 23, 2009 10:12 pm

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

czLEONcz


New member

Posts

Joined
Fri Mar 20, 2009 5:35 pm

Post by fido-x » Wed Aug 26, 2009 11:01 am

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.

Image
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool

If you're not living on the edge ... you're taking up too much space!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by czLEONcz » Wed Aug 26, 2009 7:10 pm

fido-x thank you very much.
Everything is OK.

czLEONcz


New member

Posts

Joined
Fri Mar 20, 2009 5:35 pm

Post by czLEONcz » Wed Aug 26, 2009 7:28 pm

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.

czLEONcz


New member

Posts

Joined
Fri Mar 20, 2009 5:35 pm

Post by fido-x » Fri Aug 28, 2009 9:02 am

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

Image
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool

If you're not living on the edge ... you're taking up too much space!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by czLEONcz » Fri Aug 28, 2009 4:46 pm

fido-x thank you very much.

czLEONcz


New member

Posts

Joined
Fri Mar 20, 2009 5:35 pm

Post by madany » Tue Sep 01, 2009 12:51 pm

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". ???

New member

Posts

Joined
Mon Aug 31, 2009 2:03 pm

Post by Qphoria » Tue Sep 01, 2009 7:48 pm

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';

Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by czLEONcz » Wed Sep 02, 2009 9:36 pm

Thank you for the explanation Qphoria.

czLEONcz


New member

Posts

Joined
Fri Mar 20, 2009 5:35 pm

Post by fido-x » Sat Sep 05, 2009 3:24 pm

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.

Image
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool

If you're not living on the edge ... you're taking up too much space!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by fido-x » Sat Sep 12, 2009 2:15 pm

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.

Image
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool

If you're not living on the edge ... you're taking up too much space!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by nzjolly » Sun Sep 13, 2009 8:16 am

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?

New member

Posts

Joined
Tue Sep 01, 2009 6:52 am

Post by nzjolly » Sun Sep 13, 2009 10:38 am

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?

New member

Posts

Joined
Tue Sep 01, 2009 6:52 am

Post by myopen » Sun Sep 13, 2009 5:56 pm

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.

Attachments

IE7.jpg

IE7.jpg (48.2 KiB) Viewed 4259 times

headlines_error.jpg

headlines_error.jpg (63.77 KiB) Viewed 4259 times


New member

Posts

Joined
Fri Aug 14, 2009 9:27 pm

Post by myopen » Sun Sep 13, 2009 10:19 pm

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?

New member

Posts

Joined
Fri Aug 14, 2009 9:27 pm

Post by myopen » Tue Sep 15, 2009 1:05 am

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

Attachments

faqs_button.jpg

faqs_button.jpg (51.09 KiB) Viewed 4167 times


New member

Posts

Joined
Fri Aug 14, 2009 9:27 pm

Post by fido-x » Wed Sep 16, 2009 12:44 pm

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.

Image
Modules for OpenCart 2.3.0.2
Homepage Module [Free - since OpenCart 0.7.7]
Multistore Extensions
Store Manager Multi-Vendor/Multi-Store management tool

If you're not living on the edge ... you're taking up too much space!


User avatar
Expert Member

Posts

Joined
Sat Jun 28, 2008 1:09 am
Location - Tasmania, Australia

Post by myopen » Wed Sep 16, 2009 4:49 pm

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!

New member

Posts

Joined
Fri Aug 14, 2009 9:27 pm

Post by kornovec » Wed Sep 16, 2009 8:39 pm

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.

New member

Posts

Joined
Mon Jun 15, 2009 5:02 pm
Who is online

Users browsing this forum: No registered users and 200 guests