Ledger DB

[Jakes]

Good day,

I have for some reason not a phpvms_ledger table. I do not understand why, maybe because I doesnt have the latest update. I did not do the update due to the many modifations. The site function fine, but the finances does not update when selling/repairing aircraft, not showing the expenses, sales income.

Any help, or a SQL query that can add the table?

Best Regards,

Jakes

[Vangelis]

I just cheked my db and i do not have it and as far as i know it is not in a standart phpvms setup

do you use a custom module or something else ?

[Jakes]

I am not sure, Don't this update have something to do with it?

http://forum.phpvms.net/topic/4967-rev-v21934-112-g46862a2-moved-ledger-into-its-own-data-class/page__hl__ledger

I will runt rhrough my mods installations maye Ive missed a SQL query

[Jakes]

Here is the error log:

(all my tables have a prefix MySQL)

Time: 10.22.13 13:31:58

Backtrace: DB::write_debug > DB::get_row > LedgerData::getPaymentForMonth > FinanceData::calculateFinances > PIREPData::getIntervalDataByMonth > Finance->viewmonthchart > call_user_func_array > MainController::RunAllActions

Query: SELECT SUM(`amount`) as `total` FROM `phpvms_MySQLledger` WHERE DATE_FORMAT(submitdate, '%Y-%m') = DATE_FORMAT(FROM_UNIXTIME(1374509881), '%Y-%m') AND `paysource` = 2

Error: (1146) - Table 'jdsarcco_UVSAAF.phpvms_MySQLledger' doesn't exist

[simpilot]

This should fix you up. If you are not using phpvms_ as a table prefix you will have to change that part but other than that it should create the missing table.

CREATE TABLE IF NOT EXISTS `phpvms_ledger` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`pilotid` int(11) NOT NULL,
`pirepid` int(11) NOT NULL DEFAULT '0',
`paysource` tinyint(4) NOT NULL,
`paytype` int(11) NOT NULL DEFAULT '3',
`amount` float(7,2) NOT NULL DEFAULT '0.00',
`submitdate` datetime NOT NULL,
`modifieddate` datetime NOT NULL,
PRIMARY KEY (`id`),
KEY `pilot_id` (`pilotid`),
KEY `pirepid` (`pirepid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

[Strider]

That would be a beta not a stable release.

[Jakes]

Thanks gents. Where did this tale come from? I have searched all my add ons, couldn't find the query?