uplink42 / etmv2

A web based trading manager for the Eve Online MMORPG
https://www.evetrademaster.com
GNU Affero General Public License v3.0
20 stars 7 forks source link

CRONS #129

Closed hilocz closed 7 years ago

hilocz commented 7 years ago

There is text in readme

Crons: There are several crons used to maintain the application. These can be found inside the /application/controllers/internal folder.

Should be these PHP scripts croned like

cd application/controllers/internal; php Maintenance.php >> some_log 2&>1

?

uplink42 commented 7 years ago

Your crons should look something like this

00 14 cd /var/www/html/v2 && php index.php internal/Autoexec_outposts 00 23 cd /var/www/html/v2 && php index.php internal/Autoexec_outposts 30 09 cd /var/www/html/v2 && php index.php internal/Autoexec_pricedata 00 22 cd /var/www/html/v2 && php index.php internal/Autoexec_pricedata 55 23 * cd /var/www/html/v2 && php index.php internal/Async_updater

hilocz commented 7 years ago

Thanks, look like DB update is needed >

php index.php internal/Autoexec_pricedata

Database error: A Database Error Occurred

        Error Number: 1146
        Table 'trader.fixed_prices' doesn't exist
        SELECT *
FROM `fixed_prices`
        Filename: models/internal/Autoexec_pricedata_model.php
        Line Number: 38
uplink42 commented 7 years ago

I have updated master with the up to date schema and seeders.

hilocz commented 7 years ago

After updating schema I´m getting this error >

php index.php internal/Autoexec_pricedata

An uncaught Exception was encountered

Type:        Error
Message:     Call to undefined function chunk()
Filename:    /pub/www/htdocs/etm/application/models/internal/Autoexec_pricedata_model.php
Line Number: 50

Backtrace:
        File: /pub/www/htdocs/etm/application/controllers/internal/Autoexec_pricedata.php
        Line: 30
        Function: getPrices

        File: /pub/www/htdocs/etm/index.php
        Line: 315
        Function: require_once
uplink42 commented 7 years ago

I've added a missing file (in application/helpers) that should solve this error. I generally don't test crons on my windows development machine which is why some files were missing from the repo.

hilocz commented 7 years ago

I had this file already, not sure why, maybe I had one update from dev branch.

uplink42 commented 7 years ago

heads up: I've just updated the file structure to only use 1 gulp file. Make sure to follow the new readme file for instructions on how to update (should be simpler now).

hilocz commented 7 years ago

I think I will dump whole install and DB, will start over.