title: OpenCart suddenly stopped working: HTTP Error 500
body: <p>I use OpenCart v1.5.5.1 for the last month and a couple dozen orders came through fine.</p>
  
  <p>Suddenly today, I get a HTTP Error 500, when accessing www.domain.com/shop/*, but www.domain.com works fine. So far, I tried to no avail:</p>
  
  <ul>
  <li>rebooted the server</li>
  <li>cleaned out /logs/error.txt</li>
  <li>removed .htaccess</li>
  </ul>
  
  <p><strong>The last error in the logs were:</strong></p>
  
  <pre><code>2013-03-17 19:10:11 - PHP Notice:  Error: Table 'shop_db.geo' doesn't exist&lt;br /&gt;Error No: 1146&lt;br /&gt;SELECT g.id,g.full_name,g.name,g.postcode,z.zone_id,z.country_id FROM geo g LEFT JOIN zone z ON g.zone_id = z.zone_id WHERE g.name LIKE '99%' AND g.postcode &lt;&gt; '' ORDER BY population DESC LIMIT 12 in /var/www/domain.com/html/shop/system/database/mysql.php on line 50
  2013-03-17 19:10:11 - PHP Notice:  Error: Table 'shop_db.geo' doesn't exist&lt;br /&gt;Error No: 1146&lt;br /&gt;SELECT g.id,g.full_name,g.name,g.postcode,z.zone_id,z.country_id FROM geo g LEFT JOIN zone z ON g.zone_id = z.zone_id WHERE g.name LIKE '990%' AND g.postcode &lt;&gt; '' ORDER BY population DESC LIMIT 12 in /var/www/domain.com/html/shop/system/database/mysql.php on line 50
  </code></pre>
  
  <p><strong>Here is the .htaccess</strong></p>
  
  <pre><code># 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
  &lt;FilesMatch "\.(tpl|ini|log)"&gt;
   Order deny,allow
   Deny from all
  &lt;/FilesMatch&gt;
  
  # SEO URL Settings
  RewriteEngine On
  # If your opencart installation does not run on the main web folder make sure you folder it does run in ie. / becomes /shop/ 
  
  RewriteBase /
  RewriteRule ^sitemap.xml$ index.php?route=feed/google_sitemap [L]
  RewriteRule ^googlebase.xml$ index.php?route=feed/google_base [L]
  RewriteRule ^download/(.*) /index.php?route=error/not_found [L]
  RewriteCond %{REQUEST_FILENAME} !-f
  RewriteCond %{REQUEST_FILENAME} !-d
  RewriteCond %{REQUEST_URI} !.*\.(ico|gif|jpg|jpeg|png|js|css)
  RewriteRule ^([^?]*) index.php?_route_=$1 [L,QSA]
  
  ### 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 any of the following settings, 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. If your cart has magic quotes enabled, This may work to disable it:
  # php_flag magic_quotes_gpc Off
  
      # 3. Set max upload file size. Most hosts will limit this and not allow it to be overridden but you can try
      # php_value upload_max_filesize 999M
  
      # 4. set max post size. uncomment this line if you have a lot of product options or are getting errors where forms are not saving all fields
      # php_value post_max_size 999M
  
      # 5. set max time script can take. uncomment this line if you have a lot of product options or are getting errors where forms are not saving all fields
      # php_value max_execution_time 200
  
      # 6. set max time for input to be recieved. Uncomment this line if you have a lot of product options or are getting errors where forms are not saving all fields
      # php_value max_input_time 200
  
      # 7. disable open_basedir limitations
      # php_admin_value open_basedir none
  
      # 8. force the administration log-in screen to always load in HTTPS
      #RewriteEngine On
      #RewriteCond %{HTTPS} off
      #RewriteRule (.*) https://www.overair.ca/shop/admin/ [R]
  </code></pre>
  
  <p><strong>and php.ini</strong></p>
  
  <pre><code>magic_quotes_gpc = Off;
  register_globals = Off;
  default_charset = UTF-8;
  memory_limit = 64M;
  max_execution_time = 36000;
  upload_max_filesize = 999M;
  safe_mode = Off;
  mysql.connect_timeout = 20;
  session.use_cookies = On;
  session.use_trans_sid = Off;
  session.gc_maxlifetime = 172800;
  allow_url_fopen = on;
  ;display_errors = 1;
  ;error_reporting = E_ALL;
  </code></pre>
  
  <p>However, I noticed that they've been around for the last few days with no issues. Before I restore from a backup and lose a couple orders, I was hoping someone could help.</p>
  
  <p>Thank you for your time!</p>