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
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
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.
Please check your server logs for the specific error being returned.
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.
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.

Paste contents of your htaccess file here
Your logs dont give any specific info other than a 500 error
Your logs dont give any specific info other than a 500 error
# 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
# 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
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.
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.
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
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
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..
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..
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.
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.
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
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. 

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.
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.
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 ?
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 ?
Who is online
Users browsing this forum: No registered users and 1 guest