Post by antminds » Wed Oct 26, 2011 2:53 pm

Hi All

I have installed and tested on my box. I get blank page when i click on the category with product.

http://nobigdeal.sg/index.php?route=pro ... path=59_60 with problem
http://nobigdeal.sg/index.php?route=pro ... ry&path=17 no problem

Please help

Anthony

Newbie

Posts

Joined
Wed Oct 26, 2011 2:39 pm

Post by uksitebuilder » Wed Oct 26, 2011 6:28 pm

Internal Server error 500 - Check your server error log for specific details

try re-uploading the default OC files

ImageImageImageImageImage

For Friendly Professional Support - Click Here


User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by antminds » Wed Oct 26, 2011 7:09 pm

It is newly installed

Newbie

Posts

Joined
Wed Oct 26, 2011 2:39 pm

Post by uksitebuilder » Wed Oct 26, 2011 7:56 pm

well, it could be that all the files did not upload correctly.

what do you server error logs say ?

ImageImageImageImageImage

For Friendly Professional Support - Click Here


User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by antminds » Wed Oct 26, 2011 9:18 pm

It says

[Wed Oct 26 15:09:44 2011] [error] [client 66.249.69.156] File does not exist: /home/nobigdeal/public_html/robots.txt
[Wed Oct 26 15:35:48 2011] [warn] [client 65.200.47.4] mod_fcgid: stderr: PHP Fatal error: Call to undefined function mb_substr() in /home/nobigdeal/public_html/catalog/controller/product/category.php on line 191, referer: http://nobigdeal.sg/
[Wed Oct 26 15:35:52 2011] [warn] [client 65.200.47.6] mod_fcgid: stderr: PHP Fatal error: Call to undefined function mb_substr() in /home/nobigdeal/public_html/catalog/controller/product/category.php on line 191, referer: http://nobigdeal.sg/
[Wed Oct 26 15:39:32 2011] [error] [client 209.249.53.32] File does not exist: /home/nobigdeal/public_html/robots.txt
[Wed Oct 26 15:52:05 2011] [error] [client 63.110.158.53] File does not exist: /home/nobigdeal/public_html/catalog/view/javascript/jquery/fancybox/jquery.fancybox-1.3.4-iefix.js, referer: http://nobigdeal.sg/index.php?route=pro ... ry&path=17
[Wed Oct 26 15:59:54 2011] [warn] [client 83.22.138.48] mod_fcgid: stderr: PHP Fatal error: Call to undefined function mb_substr() in /home/nobigdeal/public_html/catalog/controller/product/category.php on line 191, referer: http://nobigdeal.sg/index.php?route=pro ... path=59_60
[Wed Oct 26 15:59:54 2011] [error] [client 83.22.138.48] File does not exist: /home/nobigdeal/public_html/favicon.ico
[Wed Oct 26 15:59:55 2011] [error] [client 83.22.138.48] File does not exist: /home/nobigdeal/public_html/favicon.ico
[Wed Oct 26 17:19:36 2011] [warn] [client 66.249.69.156] mod_fcgid: stderr: PHP Fatal error: Call to undefined function mb_substr() in /home/nobigdeal/public_html/catalog/controller/product/category.php on line 191
[Wed Oct 26 17:27:42 2011] [warn] [client 66.249.69.156] mod_fcgid: stderr: PHP Fatal error: Call to undefined function mb_substr() in /home/nobigdeal/public_html/catalog/controller/product/category.php on line 191
[Wed Oct 26 17:39:08 2011] [warn] [client 66.249.69.156] mod_fcgid: stderr: PHP Fatal error: Call to undefined function mb_substr() in /home/nobigdeal/public_html/catalog/controller/product/category.php on line 191
[Wed Oct 26 17:41:19 2011] [warn] [client 66.249.69.156] mod_fcgid: stderr: PHP Fatal error: Call to undefined function mb_substr() in /home/nobigdeal/public_html/catalog/controller/product/category.php on line 191
[Wed Oct 26 17:51:13 2011] [warn] [client 182.55.237.11] mod_fcgid: stderr: PHP Fatal error: Call to undefined function mb_substr() in /home/nobigdeal/public_html/catalog/controller/product/category.php on line 191, referer: http://nobigdeal.sg/index.php?route=pro ... path=59_60
[Wed Oct 26 17:56:41 2011] [warn] [client 66.249.69.156] mod_fcgid: stderr: PHP Fatal error: Call to undefined function mb_substr() in /home/nobigdeal/public_html/catalog/controller/product/category.php on line 191
[Wed Oct 26 18:15:47 2011] [warn] [client 66.249.69.156] mod_fcgid: stderr: PHP Fatal error: Call to undefined function mb_substr() in /home/nobigdeal/public_html/catalog/controller/product/category.php on line 191
[Wed Oct 26 18:17:55 2011] [warn] [client 66.249.69.156] mod_fcgid: stderr: PHP Fatal error: Call to undefined function mb_substr() in /home/nobigdeal/public_html/catalog/controller/product/category.php on line 191
[Wed Oct 26 18:25:34 2011] [warn] [client 78.105.225.172] mod_fcgid: stderr: PHP Fatal error: Call to undefined function mb_substr() in /home/nobigdeal/public_html/catalog/controller/product/category.php on line 191, referer: http://nobigdeal.sg/index.php?route=pro ... path=59_60
[Wed Oct 26 18:25:35 2011] [error] [client 78.105.225.172] File does not exist: /home/nobigdeal/public_html/favicon.ico
[Wed Oct 26 18:25:35 2011] [error] [client 78.105.225.172] File does not exist: /home/nobigdeal/public_html/favicon.ico
[Wed Oct 26 18:25:40 2011] [warn] [client 78.105.225.172] mod_fcgid: stderr: PHP Fatal error: Call to undefined function mb_substr() in /home/nobigdeal/public_html/catalog/controller/product/category.php on line 191, referer: http://nobigdeal.sg/index.php?route=pro ... path=59_60

Newbie

Posts

Joined
Wed Oct 26, 2011 2:39 pm

Post by Xsecrets » Wed Oct 26, 2011 9:19 pm

you don't have the php mbstring extension installed. What version of opencart are you using? I thought all the mbstring stuff was supposed to be removed from the latest one, though to be honest all decent hosts should have the mbstring functions loaded.

OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter


Guru Member

Posts

Joined
Sun Oct 25, 2009 3:51 am
Location - FL US

Post by uksitebuilder » Wed Oct 26, 2011 9:33 pm

Assuming you are using 1.5.1.3

there was one mb_string function left in by mistake - Daniel swore at me when I told him lol

Fixed in SVN, but basically edit catalog/controller/product/category.php

find

Code: Select all

'description' => mb_substr(strip_tags(html_entity_decode($result['description'], ENT_QUOTES, 'UTF-8')), 0, 100) . '..',
change to

Code: Select all

'description' => utf8_substr(strip_tags(html_entity_decode($result['description']), 0, 100) . '..',
the favicon.ico is something your browser is trying to fetch invisibly, so don't worry about that unless you want to upload one to the root

the robots.txt one is either the same scenario as the favicon.ico above or you have specified in your .htaccess something to do with maybe blocking access to robots.txt for non-bots

ImageImageImageImageImage

For Friendly Professional Support - Click Here


User avatar
Guru Member

Posts

Joined
Thu Jun 09, 2011 11:37 pm
Location - United Kindgom

Post by antminds » Wed Oct 26, 2011 9:44 pm

i got it working! thanks for your help

Newbie

Posts

Joined
Wed Oct 26, 2011 2:39 pm

Post by joelowe » Sat Nov 05, 2011 6:11 am

Hi, I have the same problem as above,

'description' => mb_substr(strip_tags(html_entity_decode($result['description'], ENT_QUOTES, 'UTF-8')), 0, 100) . '..',

I have changed it as mention
'description' => utf8_substr(strip_tags(html_entity_decode($result['description']), 0, 100) . '..',

However, now on line 192,195.196 and 198 I am getting some errors, when change the next error is;


Parse error: syntax error, unexpected T_DOUBLE_ARROW in public_html/catalog/controller/product/category.php on line 192

Any Idea how to fix this. I am using the latest version of oc

Newbie

Posts

Joined
Thu Oct 27, 2011 8:02 pm

Post by JAY6390 » Sat Nov 05, 2011 6:19 am

You can add a second closing brace after the $result['description] since it's missing or just save this file
http://opencart.googlecode.com/svn/trun ... tegory.php
to your server under /catalog/controller/product/category.php

Image


User avatar
Guru Member

Posts

Joined
Wed May 26, 2010 11:47 pm
Location - United Kingdom

Post by bcurlee@gmail.com » Wed Feb 15, 2012 7:22 am

I checked and mb-string was not enabled on my php install. I have Fedora 16 so I ran the following:
sudo yum install php-mbstring

Then restarted apache:
sudo systemctl stop httpd.service
sudo systemctl start httpd.service

Site is working great!
Thx


Posts

Joined
Wed Feb 15, 2012 4:16 am

Post by JAY6390 » Wed Feb 15, 2012 8:16 am

ah nice one! Glad its all working again!

Image


User avatar
Guru Member

Posts

Joined
Wed May 26, 2010 11:47 pm
Location - United Kingdom

Post by balram » Tue Feb 21, 2012 4:03 pm

i don't know coding. can anyone help me in a simplest way step by step? this is bothering me like anything, and stopping my website to get published !

Many thanks,
Balram

Newbie

Posts

Joined
Thu Nov 10, 2011 6:30 pm

Post by balram » Sun Mar 18, 2012 12:41 am

balram wrote:i don't know coding. can anyone help me in a simplest way step by step? this is bothering me like anything, and stopping my website to get published !

Many thanks,
Balram

Newbie

Posts

Joined
Thu Nov 10, 2011 6:30 pm

Post by milanashna » Sat Mar 24, 2012 1:24 am

First time posting, sorry if its in the wrong place.

I am having a similar problem. After a clean install of 1.5.2.1, everything was working fine until I restored my database. Now the product pages are blank. Everything else shows up perfectly, except any of the product pages.


Here is the server error I am getting.

2012-03-23 11:58:02 - PHP Notice: Error: Unknown column 'sort_order' in 'order clause'<br />Error No: 1054<br />SELECT * FROM product_image WHERE product_id = '80' ORDER BY sort_order ASC in /Library/Server/Web/Data/Sites/am/system/database/mysql.php on line 49

2012-03-23 11:48:53 - PHP Notice: Undefined index: count in /Library/Server/Web/Data/Sites/am/admin/view/template/module/category.tpl on line 65

Any help would be greatly appreciated.

Newbie

Posts

Joined
Thu Jul 21, 2011 4:14 am
Who is online

Users browsing this forum: No registered users and 38 guests