Ratjoy.com » Forums » Suggestions, Technical Support and Feedback » Stores stopped selling for a few ticks
You need to register or login to post a reply.
Stores stopped selling for a few ticks
|
Somalian Road Corporation RJ: SRC Post Rating: 0 + / - Total Posts: 20 Karma: 35 Joined: Apr 3, 2012 |
Posted on Apr 16, 2012 (Last edited on Apr 16, 2012) At 8359 until right now all my stores completely stopped selling, and are now selling at a reduced rate than before the stoppage. Blast Hardcheese and Spartacus also apparently had the same issue.EDIT: didn't see the notice in gen. disc |
|
Control Volume RJ: ControlVolume CO: Control Volume Post Rating: 0 + / - Total Posts: 43 Karma: 122 Joined: Mar 31, 2012 |
Posted on Apr 16, 2012 Same issue here as well, just started up again.
|
|
G HFH RJ: Jailbreak Post Rating: 0 + / - Total Posts: 1 Karma: 10 Joined: Apr 16, 2012 |
Posted on Apr 16, 2012 Yeah it happened to me as well
|
|
Blast Hardcheese RJ: Blast Hardcheese Post Rating: 0 + / - Total Posts: 24 Karma: 36 Joined: Apr 5, 2012 |
Posted on Apr 16, 2012 (Last edited on Apr 16, 2012) It's happened to me too. As SRC said.
|
|
Control Volume RJ: ControlVolume CO: Control Volume Post Rating: 0 + / - Total Posts: 43 Karma: 122 Joined: Mar 31, 2012 |
Posted on Apr 16, 2012 Guess it's a database change.spoooOOOOoooky |
|
Scott (Admin) RJ: Ratan Joyce CO: Ratan Joyce Post Rating: 0 + / - Total Posts: 1175 Karma: 5083 Joined: Jan 13, 2012 |
Posted on Apr 16, 2012 (Last edited on Apr 16, 2012) Actual sales did happen, I just transferred the 2GB logs into another table to record ONLY sales.The bad display is caused by a timezone difference when I generated the new table, and unfortunately there doesn't seem to be any real way to fix it when the database is this big. As of now I've decided to let it just remain there until 12 hours pass by and the thing moves off of the screen. Here's what it looked like when I made the 2nd table on my local test machine (slower but with much less data): 8050676 rows inserted. Inserted row id: 8050676 ( Query took 3215.8919 sec ) The DB on www.ratjoy.com took about 15 minutes with 37,229,084 rows |
|
Alexia Perdhaer RJ: Alexia Perdhaer Post Rating: 0 + / - Total Posts: 100 Karma: 30 Joined: Apr 6, 2012 |
Posted on Apr 16, 2012 (Last edited on Apr 16, 2012) should the last few ticks be normal? Because for the last 3 ticks my sales are a tiny fraction (1/10 or less) of what they were.This is reflected in my cash on hand as well, not just what the graphs are showing. |
|
Aaron Barr RJ: Aaron CO: Aaron Post Rating: 0 + / - Total Posts: 81 Karma: 74 Joined: Apr 13, 2012 |
Posted on Apr 16, 2012 yeah, not trying to sound like I'm complaining, I'm fine with some growing pains, but I'm not receiving money from sales. Theres definitely some sales ticks not recording at all. I've been sitting at the same cash on hand for a while now.
|
|
Scott (Admin) RJ: Ratan Joyce CO: Ratan Joyce Post Rating: 0 + / - Total Posts: 1175 Karma: 5083 Joined: Jan 13, 2012 |
Posted on Apr 16, 2012 I noticed it... the updater script is ruining my DB queries.I'll issue some reimbursements in an hour or so. |
|
Alexia Perdhaer RJ: Alexia Perdhaer Post Rating: 0 + / - Total Posts: 100 Karma: 30 Joined: Apr 6, 2012 |
Posted on Apr 16, 2012 cool! um, influence > cash :P
|
|
Scott (Admin) RJ: Ratan Joyce CO: Ratan Joyce Post Rating: 0 + / - Total Posts: 1175 Karma: 5083 Joined: Jan 13, 2012 |
Posted on Apr 16, 2012 Anything I'm doing on the table is taking hours and still it's not working, so my final solution...TRUNCATE `log_sales` |
You need to register or login to post a reply.