Post by Vackerdag » Sun Sep 18, 2011 7:24 pm

Hi

My first question here, because i can't find any answer here anywhere..

I use this great CMS OpenCart Version 1.4.9.6. (I'm to scarred to upgrade to 1.5 because some plugins/modules)
Anyway, I need help with the Google_sitemap function. Before I used a external program who generated my sitemap.XML but when I changed anything in the shop I had to generate a new XMl. So now I would like to use OpenCart Google_sitemap but it seems not to work? It comes out nothing, And Google (in webmaster tool) says nothing it just search and search with no error for days?
I need help!
Is it the SEO-enginge or is it that i have redirected my site to www.geen.se instead of www.geen.se/index... etc ?

Please help me someone!..

(BTW great CMS, i have tested Joomla/VirtueMart, OsCommerce and OpenCart rules!)
Kind Regards Vackerdag /ww.geen.se

Newbie

Posts

Joined
Wed Feb 23, 2011 5:43 am

Post by uksitebuilder » Mon Sep 19, 2011 1:09 am

I looked at your sitemap and it is returning an error 500 Internal Server error.

Please check your server logs for the specific error being returned.

User avatar
Guru Member

Posts

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

Post by Vackerdag » Mon Sep 19, 2011 3:41 am

Hi,
Okey thank you. I can see thousens of of lines in the logs that looks like this:

geen.se 66.249.71.177 - - [16/Sep/2011:18:01:13 +0200] "GET /robots.txt HTTP/1.1" 301 237 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"

http://www.geen.se 66.249.71.225 - - [16/Sep/2011:18:01:14 +0200] "GET /robots.txt HTTP/1.1" 200 170 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"

geen.se 66.249.71.174 - - [16/Sep/2011:18:01:14 +0200] "GET /index.php?route=feed/google_sitemap HTTP/1.1" 301 262 "-" "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"

http://www.geen.se 66.249.71.155 - - [16/Sep/2011:18:01:33 +0200] "GET /index.php?route=feed/google_sitemap HTTP/1.1" 500 - "-" "Mozilla/5.0 (compatible; Googlebot/2.1; +http://www.google.com/bot.html)"

So you think it's not any wrong in OpenCart?
I think mayby it is some problem with the redirection in the .htaccess file, and if it's not i should talk to my ISP because they have some hard rules. :(

Newbie

Posts

Joined
Wed Feb 23, 2011 5:43 am

Post by uksitebuilder » Mon Sep 19, 2011 4:26 am

Paste contents of your htaccess file here

Your logs dont give any specific info other than a 500 error

User avatar
Guru Member

Posts

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

Post by Vackerdag » Mon Sep 19, 2011 4:59 am

# 1.To use URL Alias you need to be running apache with mod_rewrite enabled.

# 2. In your opencart directory rename htaccess.txt to .htaccess

# For any support issues please visit: http://www.opencart.com

# Options +FollowSymlinks

# Prevent Directoy listing
# Options -Indexes

# Prevent Direct Access to files
<FilesMatch "\.(tpl|ini)">
Order deny,allow
Deny from all
</FilesMatch>

# SEO URL Settings
RewriteEngine On
RewriteBase /
RewriteRule ^sitemap.xml$ index.php?route=feed/google_sitemap [L,QSA]
RewriteCond %{REQUEST_FILENAME} !-f
RewriteCond %{REQUEST_FILENAME} !-d
RewriteRule ^([^?]*) index.php?_route_=$1 [L,QSA]
RewriteCond %{QUERY_STRING} ^route=common/home$
RewriteRule ^index\.php$ http://www.geen.se? [R=301,L]
RewriteCond %{HTTP_HOST} ^geen.se
RewriteRule (.*) http://www.geen.se/$1 [R=301,L]



### Additional Settings that may need to be enabled for some servers
### Uncomment the commands by removing the # sign in front of it.
### If you get an "Internal Server Error 500" after enabling, then restore the # as this means your host doesn't allow that.

# 1. If your cart only allows you to add one item at a time, it is possible register_globals is on. This may work to disable it:
# php_flag register_globals off

Newbie

Posts

Joined
Wed Feb 23, 2011 5:43 am

Post by uksitebuilder » Mon Sep 19, 2011 5:26 am

There is no need to put the following line

RewriteRule ^sitemap.xml$ index.php?route=feed/google_sitemap [L,QSA]

I was trying to run your sitemap on http://geen.se/index.php?route=feed/google_sitemap

I was getting a 500 Internal Error because your htaccess is trying to rewrite to http://www.geen.se........

Now if I try http://www.geen.se/index.php?route=feed/google_sitemap

i.e. with the www...

I get an out of memory error

Therefore, try increasing your memory in your php.ini if possible.

User avatar
Guru Member

Posts

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

Post by Vackerdag » Mon Sep 19, 2011 7:17 pm

Aha, okey.
Yes I can see that in Crome now (not in Firefox?).
Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 47 bytes) in /customers/geen.se/geen.se/httpd.www/system/database/mysql.php on line 29

Yes I can extend the memory in the PHP.ini but I don't think my ISP (one.com) is allowing that. I have a similar problem whit the OC backup function. Time to change ISP mayby. I must to talk them (again)..

UKSB, thanks alot for taking your time. I can baby sit for your 14 children.. hehe. A donate will come.

Kind Regards Vackerdag / www.geen.se

Newbie

Posts

Joined
Wed Feb 23, 2011 5:43 am

Post by Vackerdag » Mon Sep 19, 2011 7:41 pm

Some info from my ISP (one.com) In Swedish.

Välkommen till One.com chatsupport. Vi gör vårt bästa för att svara på dina frågor så snart som möjligt. Vi ber om förståelse för att våra svar ibland försenas vid tider då det är mycket folk på chatten.
Du chattar nu med 'X.'
X.: Hej, hur kan jag hjälpa dig?
Du: Hej supporten!
Du: Hej X
X.: Hejsan
Du: Jo är det möjligt att förstora upp minnet för min site?
Du: Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 41 bytes) in /customers/geen.se/geen.se/httpd.www/system/database/mysql.php on line 29
X.: Nej. Detta är inte möjligt.
Du: inte heller via php.ini?
X.: Ni måste hitta vad det är som orsakar den loaden. Ett vanligt phpscript ska inte kunna använda upp så mycket minne.
Du: Det är för att jag har över 30000sidor och detta ska generera en sitemap.xml via:
X.: Nej. Det går inte att ändra tyvärr.
Du: http://www.geen.se/index.php?route=feed/google_sitemap
Du: Problemet att det går inte att köra vackup heller via php pga detta.. :(
Du: backup
Du: Om man betalar mer pengar dp?
Du: då?
X.: Ett ögonblick.
Du: ok
X.: Din server har följande: memory_limit 64M
X.: Det är redan väldigt högt. Det är alltså någonting med ditt script. Så pass mycket minne ska den inte ta upp oavsett hur stora poster det handlar om.
X.: Mitt tips är att du kontaktar dom som skrivit koden och ber dem att effektivisera scriptet.
Du: okej. Jag kör en sväng via dem igen. :)
Du: Tackar.

Conclusion: I've 64M as memory_limit, and One.com says that is very very much and they think it is some problem with the script somehow?
Oh I'm so tired..

Newbie

Posts

Joined
Wed Feb 23, 2011 5:43 am

Post by uksitebuilder » Mon Sep 19, 2011 7:57 pm

It takes quite some time just to load your home page

So personally I would say the server is not good enough. It is not very often I say that, so it must not be a good server.

User avatar
Guru Member

Posts

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

Post by Vackerdag » Mon Sep 19, 2011 8:05 pm

i agree.

Newbie

Posts

Joined
Wed Feb 23, 2011 5:43 am

Post by Xsecrets » Mon Sep 19, 2011 8:06 pm

yes I agree the whole site loads painfully slow, so It may indeed be time for a new host, but unfortunately it is going to be very difficult to find a shared host that will go above 64M. You must have a bunch of products.

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 Vackerdag » Mon Sep 19, 2011 8:19 pm

Yes we got over 11 000 articles in the store. So it is some problem when the site is so slow, because Google and other sites don't like that. Every Sunday we updates the stock amount, prices, etc. direct into the database. It is a bit frustrating that we can't use backup, sitemap, mail template direct into OC. Now i will dig deeper and test all our extensions/modules/plugins to see if it something in that who can make the system faster. A weekend with a nice bottle of wine and OC on localhost. :)

Newbie

Posts

Joined
Wed Feb 23, 2011 5:43 am

Post by uksitebuilder » Mon Sep 19, 2011 8:31 pm

OC on localhost will probably work fine, it has totally different resources.

It is going to be simply the amount of products that you have and probably categories too that is causing the slow down.

This has been discussed a fair bit on the forum. There is a free vqmod solution that removes the category counts and sql queries that do the counts for each category. This goes some way in to speeding up the site.

Also, the google_sitemap.php controller file can have a few functions removed from it.

For instance, it is pointless listing all links to product by category and by manufacturer when it already lists al products links anyway. Especially as the product page has canonical head link. All these extra links are a waste of time and resources.

Having said all of the above, at the end of the day, you should look for a better hosting environment for your site.

User avatar
Guru Member

Posts

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

Post by pirate » Fri Oct 21, 2011 4:06 am

Getting following error while loading http://www.myweb.com/index.php?route=fe ... le_sitemap

Fatal error: Allowed memory size of 67108864 bytes exhausted (tried to allocate 17480140 bytes) in /root/html/system/library/cache.php on line 37


What is the the reason ?

New member

Posts

Joined
Sat Sep 03, 2011 1:28 pm

Post by uksitebuilder » Fri Oct 21, 2011 3:01 pm

not enough memory

try increasing memory limit from 64M to 128M in your php.ini file

User avatar
Guru Member

Posts

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

Users browsing this forum: No registered users and 1 guest