Menu
▾
▴
Re: [webERP-users] weberp 50 test and errors
|
From: <aul...@sc...> - 2025-03-23 11:11:41
|
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
|
