Re: [webERP-users] weberp 50 test and errors

[<aul...@sc...>]

ok
i download latest weberp version from github and make reinstall of weberp
.... 

-----Alkuperäinen viesti-----
Lähettäjä: aul...@sc... <aul...@sc...> 
Lähetetty: torstai 20. maaliskuuta 2025 7.08
Vastaanottaja: 'For the general discussion of webERP project'
<web...@li...>
Aihe: Re: [webERP-users] weberp 50 test and errors



-----Alkuperäinen viesti-----
Lähettäjä: aul...@sc... <aul...@sc...>
Lähetetty: torstai 20. maaliskuuta 2025 7.06
Vastaanottaja: 'For the general discussion of webERP project'
<web...@li...>
Aihe: VS: [webERP-users] weberp 50 test and errors

my weberp mysql  database not contains this fields i have reported and i
have installed weberp by using weberp ? 

CREATE TABLE `salesorderdetails` (
  `orderlineno` int NOT NULL DEFAULT '0',
  `orderno` int NOT NULL DEFAULT '0',
  `stkcode` varchar(20) NOT NULL DEFAULT '',
  `qtyinvoiced` double NOT NULL DEFAULT '0',
  `unitprice` double NOT NULL DEFAULT '0',
  `quantity` double NOT NULL DEFAULT '0',
  `estimate` tinyint NOT NULL DEFAULT '0',
  `discountpercent` double NOT NULL DEFAULT '0',
  `actualdispatchdate` datetime NOT NULL DEFAULT '1000-01-01 00:00:00',
  `completed` tinyint(1) NOT NULL DEFAULT '0',
  `narrative` text,
  `itemdue` date DEFAULT NULL COMMENT 'Due date for line item.  Some
customers require \r\nacknowledgements with due dates by line item',
  `poline` varchar(10) DEFAULT NULL COMMENT 'Some Customers require
acknowledgements with a PO line number for each sales line',
  PRIMARY KEY (`orderlineno`,`orderno`),
  KEY `OrderNo` (`orderno`),
  KEY `StkCode` (`stkcode`),
  KEY `Completed` (`completed`),
  CONSTRAINT `salesorderdetails_ibfk_1` FOREIGN KEY (`orderno`) REFERENCES
`salesorders` (`orderno`),
  CONSTRAINT `salesorderdetails_ibfk_2` FOREIGN KEY (`stkcode`) REFERENCES
`stockmaster` (`stockid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3
-----Alkuperäinen viesti-----
Lähettäjä: Tim Schofield <tim...@gm...>
Lähetetty: keskiviikko 19. maaliskuuta 2025 21.53
Vastaanottaja: For the general discussion of webERP project
<web...@li...>
Aihe: Re: [webERP-users] weberp 50 test and errors

On Wed, 19 Mar 2025 at 17:45, <aul...@sc...> wrote:
>
> is your purpose to update demo.sql with this now missin field defs ?
>

demo.sql only contains data, not structure. During the install, the
structure comes from the install/tables directory. These fields are included
in the tables that are there.

As I have mentioned a few times before you are better using the github site
to discuss issues. Most of the developers that could help you are there, so
you will get a much better turnaround for your questions.

Thanks
Tim


_______________________________________________
web-ERP-users mailing list
web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-users



_______________________________________________
web-ERP-users mailing list
web...@li...
https://lists.sourceforge.net/lists/listinfo/web-erp-users