Hey Guys,
back again…
I think I’ve fixed this issue before but I can’t exactly remember how I fixed it.
Everytime I activate the SEO addon from the addons page I get “Service Unavailable” pages everywhere. Mod_rewrite seems to be working, I’ve turned off Modsec in the server just incase that’s the issue, which it isn’t.
I’m not sure what else I can do…
I get the following error when loading the page with dev mode.
-----------------------------------------------
Message
Unknown column ‘path’ in ‘field list’ b[/b]
SELECT name, path FROM cscart_seo_names WHERE object_id = 0 AND type = ‘s’ AND dispatch = ‘index.index’ AND lang_code = ‘en’
Error at
app/Tygh/Database.php, line: 677
Backtrace
File: app/Tygh/Database.php Line: 333 Function: _error File: app/Tygh/Database.php Line: 158 Function: query File: app/functions/fn.database.php Line: 54 Function: getRow File: app/addons/seo/func.php Line: 816 Function: db_get_row File: app/addons/seo/func.php Line: 1125 Function: fn_seo_get_name File: app/functions/fn.control.php Line: 84 Function: fn_seo_url_post File: app/functions/fn.common.php Line: 3281 Function: fn_set_hook File: app/addons/seo/func.php Line: 971 Function: fn_url File: app/functions/fn.init.php Line: 940 Function: fn_seo_check_dispatch File: app/functions/fn.init.php Line: 973 Function: fn_init File: init.php Line: 131 Function: fn_init File: index.php Line: 24 Function: require
------------------------------------------------------------------------
Here is the contents of .htaccess
<br />
DirectoryIndex index.html index.php<br />
<IfModule mod_headers.c><br />
<IfModule mod_rewrite.c><br />
AddEncoding gzip .gz<br />
RewriteCond %{REQUEST_FILENAME} \.(js|css)$<br />
RewriteCond %{HTTP:Accept-encoding} gzip<br />
RewriteCond %{REQUEST_FILENAME}.gz -f<br />
RewriteRule ^(.*)$ $1.gz [QSA,L]<br />
</IfModule><br />
<FilesMatch .*\.css.gz$><br />
<IfModule mod_expires.c><br />
Header unset ETag<br />
FileETag None<br />
ExpiresActive On<br />
ExpiresDefault "access plus 1 year"<br />
</IfModule><br />
ForceType text/css<br />
Header set Content-Encoding: gzip<br />
Header set Cache-control: private<br />
</FilesMatch><br />
<FilesMatch .*\.js.gz$><br />
<IfModule mod_expires.c><br />
Header unset ETag<br />
FileETag None<br />
ExpiresActive On<br />
ExpiresDefault "access plus 1 year"<br />
</IfModule><br />
<br />
ForceType text/javascript<br />
Header set Content-Encoding: gzip<br />
Header set Cache-control: private<br />
</FilesMatch><br />
<FilesMatch "\.(ttf|ttc|otf|eot|woff|css)$"><br />
Header set Access-Control-Allow-Origin "*"<br />
</FilesMatch><br />
</IfModule><br />
<IfModule mod_rewrite.c><br />
RewriteEngine on<br />
# Please note that RewriteBase setting is obsolete use it only in case you experience some problems with SEO addon.<br />
# Some hostings require RewriteBase to be uncommented<br />
# Example:<br />
# Your store url is http://www.yourcompany.com/store/cart<br />
# So "RewriteBase" should be:<br />
# RewriteBase /store/cart<br />
# RewriteBase /<br />
Options -MultiViews<br />
RewriteRule .* - [E=HTTP_AUTHORIZATION:%{HTTP:Authorization}]<br />
RewriteCond %{REQUEST_URI} ^api/(.*)$ [or]<br />
RewriteCond %{REQUEST_URI} .*/api/(.*)$<br />
RewriteCond %{REQUEST_FILENAME} !-f<br />
RewriteCond %{REQUEST_FILENAME} !-d<br />
RewriteRule .*api/(.*)$ api.php?_d=$1&ajax_custom=1 [L,QSA]<br />
RewriteCond %{REQUEST_URI} \.(png|gif|ico|swf|jpe?g|js|css|ttf|svg|eot|woff|yml|xml)$ [or]<br />
RewriteCond %{REQUEST_URI} store_closed.html$<br />
RewriteCond %{REQUEST_FILENAME} !-f<br />
RewriteCond %{REQUEST_FILENAME} !-d<br />
RewriteRule ^(.*?)\/(.*)$ $2 [L]<br />
RewriteCond %{REQUEST_FILENAME} !-f<br />
RewriteCond %{REQUEST_FILENAME} !-d<br />
RewriteRule . index.php [L,QSA]<br />
</IfModule><br />
```<br />
<br />
Any help appreciated.