Login
Ratjoy.com » Forums » Suggestions, Technical Support and Feedback » Stores stopped selling for a few ticks

Stores stopped selling for a few ticks


Somalian Road Corporation
RJ: SRC

Post Rating: 0
+ / -

Total Posts: 20
Karma: 35
Joined: Apr 3, 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
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
Yeah it happened to me as well
Blast Hardcheese
RJ: Blast Hardcheese

Post Rating: 0
+ / -

Total Posts: 24
Karma: 36
Joined: Apr 5, 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
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
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
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
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
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
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
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.