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

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

can i run import by using phpmyadmin import sql function ? install/demo.sql
which contains insert demo data content

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

if i not selected demo db install was ok, but demo db data content should
help to understand weberb functions better.... 

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

i select demo database in install

[20-Mar-2025 06:18:14 Africa/Abidjan] PHP Fatal error:  Uncaught
mysqli_sql_exception: Column count doesn't match value count at row 1 in
C:\wamp64\www\webERP\includes\ConnectDB_mysqli.inc:58
Stack trace:
#0 C:\wamp64\www\webERP\includes\ConnectDB_mysqli.inc(58):
mysqli_query(Object(mysqli), ' INSERT INTO `d...')
#1 C:\wamp64\www\webERP\install\pages\page_6.php(551): DB_query(' INSERT
INTO `d...')
#2 C:\wamp64\www\webERP\install\pages\page_6.php(414):
PopulateSQLDataBySQL('demo.sql')
#3 C:\wamp64\www\webERP\install\pages\page_6.php(489): UploadData('Yes',
'weberp', 'admin', 'in...@ex......', 'en_GB.utf8', 'coa/en_GB.utf8....',
'weberp oy', '..', 'weberp')
#4 C:\wamp64\www\webERP\install\index.php(77):
include('C:\\wamp64\\www\\w...')
#5 {main}
  thrown in C:\wamp64\www\webERP\includes\ConnectDB_mysqli.inc on line 58


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

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



_______________________________________________
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