Search found 25 matches

Search found 25 matches

Re: Google Base txt file

Perfect. Just uninstalled and reinstalled it again and it works now.

Jump to post
  • Sat Jan 23, 2016 12:17 am
  • Replies 9
  • Views 2162
Re: Google Base txt file

There is no such table even in the original Opencart 2.1.0.1. I just downloaded it again and did a search.

Am I missing something?

Jump to post
  • Thu Jan 21, 2016 3:45 am
  • Replies 9
  • Views 2162
Re: Google Base txt file

I am having the same issue and as I looked at the error logs, this came up. I checked and the google_base_category_to_category table does not exist. This was a fresh install so how can I solve this? 2016-01-17 2:00:38 - PHP Notice: Error: Table 'table.ag_google_base_category_to_category' doesn't exi...

Jump to post
  • Thu Jan 21, 2016 2:53 am
  • Replies 9
  • Views 2162
Re: Opencart crashing my server

Finally managed to solve this. It looks like the version of PHP and Apache used in Ampps v3.3 was causing this issue. I decided to put my existing 1.5.3.1 stable site on this version and that site also crashed during confirm order - clearly indicating that the problem was with Apache/PHP and not wit...

Jump to post
  • Mon Jan 11, 2016 9:02 pm
  • Replies 37
  • Views 8511
Re: Opencart crashing my server

Sorry, I should have been clearer. It was catalog\model\checkout\order.php
and the server did not crash. It went through to the success page which is why it was odd or not immediately clear to me as to why the echo statements did not show up.

Jump to post
  • Mon Jan 11, 2016 7:34 am
  • Replies 37
  • Views 8511
Re: Opencart crashing my server

Ok, now this is odd.

I placed the alerts from line 349 onwards in order.php. No alert whatsover.

Jump to post
  • Sun Jan 10, 2016 7:05 pm
  • Replies 37
  • Views 8511
Re: Opencart crashing my server

It goes through all lines. Just as a question, I generally don't have a crash when I view an order. The crash generally happens when I place an order (one of the actions that definitely has a greater crash rate), so should we check something to do with confirm order. Again on the traffic - I am wond...

Jump to post
  • Sun Jan 10, 2016 6:34 pm
  • Replies 37
  • Views 8511
Re: Opencart crashing my server

I did that and the code does reach both the points - this is when I view a customer order in admin. Tried it multiple times and it executes at both the points.

Jump to post
  • Sun Jan 10, 2016 6:14 pm
  • Replies 37
  • Views 8511
Re: Opencart crashing my server

Confirm order crashed it. I do have a status 1 (Pending) INSERT INTO `ag_order_status` (`order_status_id`, `language_id`, `name`) VALUES (2, 1, 'Processing'), (3, 1, 'Shipped'), (7, 1, 'Canceled'), (5, 1, 'Complete'), (8, 1, 'Denied'), (9, 1, 'Canceled Reversal'), (10, 1, 'Failed'), (11, 1, 'Refunde...

Jump to post
  • Sun Jan 10, 2016 5:19 pm
  • Replies 37
  • Views 8511
Re: Opencart crashing my server

I had attempted to do two things - one I had placed an order and had pressed the confirm order button. Two, I had also clicked the Order list button in Admin at the same time.

Jump to post
  • Sun Jan 10, 2016 5:04 pm
  • Replies 37
  • Views 8511
Re: Opencart crashing my server

There is something I should note here - when I take my server offline and it is just me or maybe one more person testing, we have no crashes at all. When i take it online, the crashes start.

Jump to post
  • Sun Jan 10, 2016 5:03 pm
  • Replies 37
  • Views 8511
Re: Opencart crashing my server

Here is the log file - at the point of crash.

Jump to post
  • Sun Jan 10, 2016 4:43 pm
  • Replies 37
  • Views 8511
Re: Opencart crashing my server

No luck. I did an absolute fresh install - nothing installed, no memcache or any other plugin (except Opcache) and it still crashes. In most cases the crash occurs during Confirm Order. also if it helps, this is my httpd-mpm file - anything wrong here? Do you want to take a look at the http.conf and...

Jump to post
  • Sun Jan 10, 2016 3:34 pm
  • Replies 37
  • Views 8511
Re: Opencart crashing my server

No, I am on Firefox. I also tried Internet Explorer and it crashes on both.

Jump to post
  • Sat Jan 09, 2016 9:49 pm
  • Replies 37
  • Views 8511
Re: Opencart crashing my server

Sigh. I changed to v5.3, 5.4 and 5.5. No difference and it still crashes. I also have memcache enabled (which i disabled to check but didn't seem to improve the crash) and OpCache enabled.

Jump to post
  • Sat Jan 09, 2016 7:48 pm
  • Replies 37
  • Views 8511
Re: Opencart crashing my server

I have SSL enabled and it is a dedicated certificate. Here is the htaccess file RewriteEngine On #RewriteCond %{HTTPS} off #RewriteRule (.*) http://%{HTTP_HOST}%{REQUEST_URI} [L,R=301] RewriteCond %{HTTP_HOST} ^mysite\.com[NC] RewriteRule ^(.*) https://www.mysite.com/$1 [L,R=301] RewriteCond %{HTTP_...

Jump to post
  • Sat Jan 09, 2016 6:07 pm
  • Replies 37
  • Views 8511
Re: Opencart crashing my server

It is a 2 core, 4 gb VPS just running AMPPS and dedicated to my site. I have looked at the performance logs and there are no spikes or any heavy load at time of crashes.

I should also add that the site is on Cloudlfare CDN.

Jump to post
  • Sat Jan 09, 2016 5:50 pm
  • Replies 37
  • Views 8511
Re: Opencart crashing my server

My php.ini file in Opencart is as below - do I need to go above 64m? Or is there any other place I need to increase this? 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.connec...

Jump to post
  • Sat Jan 09, 2016 5:12 pm
  • Replies 37
  • Views 8511
Re: Opencart crashing my server

Hi Randem Ok let me correct that - it was a fresh install of Opencart. I was earlier on a different VPS on 1.5.3.1. I moved to a new VPS and had an out of the box 2.1.0.1 installation on Ammps. I later populated the Opencart MySQL database with only products, categories, options and attributes, and ...

Jump to post
  • Sat Jan 09, 2016 4:56 pm
  • Replies 37
  • Views 8511
Re: Opencart crashing my server

I was able to narrow this down to certain events: Apache crashes generally when an order is confirmed - the order confirmation email goes through but it does not move to the order Success page and instead crashes Apace (my guess is PHP crashes and since I am on AMPPS, the parent process, i.e Apache ...

Jump to post
  • Sat Jan 09, 2016 2:41 pm
  • Replies 37
  • Views 8511

Search found 25 matches