Menu
▾
▴
Re: [webERP-users] weberp 50 test and errors
|
From: Tim S. <tim...@gm...> - 2025-03-23 17:49:56
|
You can, but there may be conflicts. Best to do it via the installer.
Tim
On Sun, 23 Mar 2025 at 11:11, <aul...@sc...> wrote:
>
> 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
>
--
www.weberp.org
@TimSchofield.or.uk - bsky.app
Blog: https://kwamoja.home.blog/
|
