Menu
▾
▴
web-erp-users — User general webERP discussion list
You can subscribe to this list here.
| 2003 |
Jan
(1) |
Feb
|
Mar
(20) |
Apr
(24) |
May
(7) |
Jun
(5) |
Jul
(4) |
Aug
(35) |
Sep
(34) |
Oct
(21) |
Nov
(39) |
Dec
(15) |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2004 |
Jan
(11) |
Feb
(30) |
Mar
(60) |
Apr
(98) |
May
(61) |
Jun
(33) |
Jul
(44) |
Aug
(102) |
Sep
(59) |
Oct
(152) |
Nov
(86) |
Dec
(39) |
| 2005 |
Jan
(96) |
Feb
(117) |
Mar
(75) |
Apr
(144) |
May
(78) |
Jun
(47) |
Jul
(58) |
Aug
(87) |
Sep
(89) |
Oct
(120) |
Nov
(43) |
Dec
(15) |
| 2006 |
Jan
(142) |
Feb
(55) |
Mar
(67) |
Apr
(79) |
May
(44) |
Jun
(62) |
Jul
(104) |
Aug
(90) |
Sep
(38) |
Oct
(70) |
Nov
(17) |
Dec
(80) |
| 2007 |
Jan
(108) |
Feb
(121) |
Mar
(33) |
Apr
(17) |
May
(18) |
Jun
(60) |
Jul
(62) |
Aug
(101) |
Sep
(94) |
Oct
(117) |
Nov
(44) |
Dec
(23) |
| 2008 |
Jan
(106) |
Feb
(67) |
Mar
(169) |
Apr
(73) |
May
(101) |
Jun
(112) |
Jul
(125) |
Aug
(149) |
Sep
(139) |
Oct
(162) |
Nov
(92) |
Dec
(88) |
| 2009 |
Jan
(199) |
Feb
(219) |
Mar
(372) |
Apr
(246) |
May
(146) |
Jun
(159) |
Jul
(276) |
Aug
(146) |
Sep
(143) |
Oct
(76) |
Nov
(65) |
Dec
(208) |
| 2010 |
Jan
(129) |
Feb
(76) |
Mar
(127) |
Apr
(131) |
May
(90) |
Jun
(237) |
Jul
(108) |
Aug
(75) |
Sep
(39) |
Oct
(92) |
Nov
(118) |
Dec
(63) |
| 2011 |
Jan
(96) |
Feb
(146) |
Mar
(190) |
Apr
(141) |
May
(142) |
Jun
(109) |
Jul
(112) |
Aug
(182) |
Sep
(115) |
Oct
(100) |
Nov
(278) |
Dec
(169) |
| 2012 |
Jan
(134) |
Feb
(156) |
Mar
(161) |
Apr
(81) |
May
(16) |
Jun
(72) |
Jul
(99) |
Aug
(64) |
Sep
(90) |
Oct
(47) |
Nov
(86) |
Dec
(49) |
| 2013 |
Jan
(29) |
Feb
(14) |
Mar
(12) |
Apr
(25) |
May
(10) |
Jun
(26) |
Jul
(12) |
Aug
(17) |
Sep
(6) |
Oct
(3) |
Nov
(13) |
Dec
(27) |
| 2014 |
Jan
(18) |
Feb
(14) |
Mar
(17) |
Apr
(17) |
May
(23) |
Jun
(25) |
Jul
(25) |
Aug
(12) |
Sep
(7) |
Oct
(33) |
Nov
(39) |
Dec
(12) |
| 2015 |
Jan
(21) |
Feb
(39) |
Mar
(41) |
Apr
(9) |
May
(16) |
Jun
(7) |
Jul
(8) |
Aug
(2) |
Sep
|
Oct
|
Nov
(24) |
Dec
(12) |
| 2016 |
Jan
(15) |
Feb
(17) |
Mar
(23) |
Apr
(11) |
May
(3) |
Jun
(7) |
Jul
(3) |
Aug
|
Sep
(5) |
Oct
(5) |
Nov
(2) |
Dec
|
| 2017 |
Jan
|
Feb
(12) |
Mar
(14) |
Apr
|
May
(1) |
Jun
(10) |
Jul
(7) |
Aug
(5) |
Sep
(3) |
Oct
(1) |
Nov
|
Dec
|
| 2018 |
Jan
|
Feb
|
Mar
|
Apr
|
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2019 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
(2) |
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2020 |
Jan
|
Feb
(1) |
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
| 2021 |
Jan
|
Feb
|
Mar
|
Apr
(1) |
May
(1) |
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(1) |
| 2024 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
(27) |
Nov
|
Dec
(5) |
| 2025 |
Jan
|
Feb
(56) |
Mar
(28) |
Apr
|
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|
From: ExsonQu <hex...@gm...> - 2017-09-06 06:23:23
|
*Hi, Heinrich,*
It's a bug and fixed in the trunk.
You can fixed it by issue following statements:
ALTER table supptrans DROP KEY `TypeTransNo`;
ALTER table supptrans ADD KEY `TypeTransNo`(`transno`,`type`);
Thanks and best regards!
Exson
Heinrich Steuber wrote
> Database Error 1062 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
> ASSISTANCE: The supplier invoice transaction could not be added to the
> database because
> Duplicate entry '1003-20' for key 'TypeTransNo'
> Database SQL Failure : The following SQL to insert the supplier invoice
> was used
> INSERT INTO supptrans (transno, type, supplierno, suppreference, trandate,
> duedate, ovamount, ovgst, rate, transtext, inputdate) VALUES ( '1003', 20
> , 'RE01', '123822', '2017-08-21', '2017-09-30', '1367.4', '205.11',
> '1.00000000', '', '2017-08-21')
> Database Rollback Due to Error Above : Rolling Back Transaction OK
--
Sent from: http://weberp-accounting.1478800.n4.nabble.com/web-ERP-users-f1478801.html
|
|
From: ExsonQu <hex...@gm...> - 2017-09-06 06:01:57
|
*Hi, Heinrich,*
It's a bug.
You can alter the table in mysql by following statement:
ALTER table supptrans DROP KEY `TypeTransNo`;
ALTER table supptrans ADD KEY `TypeTransNo`(`transno`,`type`);
Thanks and best regards!
Exson
Heinrich Steuber wrote
> Database Error 1062 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK
> ASSISTANCE: The supplier invoice transaction could not be added to the
> database because
> Duplicate entry '1003-20' for key 'TypeTransNo'
> Database SQL Failure : The following SQL to insert the supplier invoice
> was used
> INSERT INTO supptrans (transno, type, supplierno, suppreference, trandate,
> duedate, ovamount, ovgst, rate, transtext, inputdate) VALUES ( '1003', 20
> , 'RE01', '123822', '2017-08-21', '2017-09-30', '1367.4', '205.11',
> '1.00000000', '', '2017-08-21')
> Database Rollback Due to Error Above : Rolling Back Transaction OK
--
Sent from: http://weberp-accounting.1478800.n4.nabble.com/web-ERP-users-f1478801.html
|
|
From: <ph...@lo...> - 2017-08-21 22:14:14
|
You may have to manually increment the transno in systypes for typeno=20 to be able to process further AP invoices. Run the SQL UPDATE systypes SET typeno='1004' WHERE typeid='20' then give it another go. How did it happen .... would like to know? Phil On 2017-08-21 05:39, Heinrich Steuber wrote: > Database Error 1062 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK > ASSISTANCE: The supplier invoice transaction could not be added to the > database because > Duplicate entry '1003-20' for key 'TypeTransNo' > Database SQL Failure : The following SQL to insert the supplier invoice > was > used > INSERT INTO supptrans (transno, type, supplierno, suppreference, > trandate, > duedate, ovamount, ovgst, rate, transtext, inputdate) VALUES ( '1003', > 20 , > 'RE01', '123822', '2017-08-21', '2017-09-30', '1367.4', '205.11', > '1.00000000', '', '2017-08-21') > Database Rollback Due to Error Above : Rolling Back Transaction OK > > > > ----- > using webERP v4.11.2 > Apache version 2.4 > Mysql 5.7.19 > Ubuntu 16.04 > -- > View this message in context: > http://weberp-accounting.1478800.n4.nabble.com/database-error-what-is-wrong-tp4658834.html > Sent from the web-ERP-users mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users |
|
From: Heinrich S. <Mr...@gm...> - 2017-08-21 11:41:47
|
Database Error 1062 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK ASSISTANCE: The supplier invoice transaction could not be added to the database because Duplicate entry '1003-20' for key 'TypeTransNo' Database SQL Failure : The following SQL to insert the supplier invoice was used INSERT INTO supptrans (transno, type, supplierno, suppreference, trandate, duedate, ovamount, ovgst, rate, transtext, inputdate) VALUES ( '1003', 20 , 'RE01', '123822', '2017-08-21', '2017-09-30', '1367.4', '205.11', '1.00000000', '', '2017-08-21') Database Rollback Due to Error Above : Rolling Back Transaction OK ----- using webERP v4.11.2 Apache version 2.4 Mysql 5.7.19 Ubuntu 16.04 -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/database-error-what-is-wrong-tp4658834.html Sent from the web-ERP-users mailing list archive at Nabble.com. |
|
From: Heinrich S. <Mr...@gm...> - 2017-08-21 11:37:47
|
Database Error 1062 : CRITICAL ERROR! NOTE DOWN THIS ERROR AND SEEK ASSISTANCE: The supplier invoice transaction could not be added to the database because Duplicate entry '1003-20' for key 'TypeTransNo' Database SQL Failure : The following SQL to insert the supplier invoice was used INSERT INTO supptrans (transno, type, supplierno, suppreference, trandate, duedate, ovamount, ovgst, rate, transtext, inputdate) VALUES ( '1003', 20 , 'RE01', '123822', '2017-08-21', '2017-09-30', '1367.4', '205.11', '1.00000000', '', '2017-08-21') Database Rollback Due to Error Above : Rolling Back Transaction OK ----- using webERP v4.11.2 Apache version 2.4 Mysql 5.7.19 Ubuntu 16.04 -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/database-error-what-is-wrong-tp4658833.html Sent from the web-ERP-users mailing list archive at Nabble.com. |
|
From: Steve K. <St...@st...> - 2017-08-04 07:34:35
|
Hi Prerak No. We have done no work on webERP's Indian Taxation, nor are we likely to do so. Please send emails to <mailto:st...@st...> st...@st..., not to mango5.co.za - a client. Thanks and best regards Steve Killer for Strelitzia System Services cc Reg No 2001/009528/23 VAT 4770256784 https://ci6.googleusercontent.com/proxy/jd3AWSIqvlGHN1TDn8qv2MuzIIl16zYVSkTN Z4F4szIYtVDay0d4Aphr7GBVa4ihUiPOG8v5e_hCdAaAeLVi7Q=s0-d-e1-ft#http://steve.s trelitzia.org/strelitzia.png e-mail: <mailto:st...@st...> st...@st... cell: <tel:%2B27%2072%20257%206662> +27 72 257 6662 home: <tel:%2B27%2021%20448%203045> +27 21 685 0716 skype: stevekiller268 21 Clifton Road, Little Mowbray CAPE TOWN South Africa 7700 From: Prerak Shah.S [mailto:pre...@he...] Sent: 04 August 2017 07:17 To: web...@li... Subject: [webERP-users] Indian Taxation Configuration Importance: High Dear Team, I would like to know if any user setup complete finance module with Indian Taxation configured in system. cid:image001.png@01D2E460.A6158FF0 Prerak Shah Chief Information Officer -IT cid:image002.png@01D2E460.A6158FF0 <mailto:pre...@he...%20> pre...@he... Address Plot No. B11, Phase1,MEPZ - SEZ Tambaram, Chennai -600 045 Visit us at <http://hexagonnutrition.com/> hexagonnutrition.com cid:image003.png@01D2E460.A6158FF0 Mobile +91 7550177377 cid:image004.png@01D2E460.A6158FF0 Board +91(044) 22625250 / 52 For current openings : <http://careers.hexagonnutrition.com/jobs/> http://careers.hexagonnutrition.com/jobs/ |
|
From: Prerak Shah.S <pre...@he...> - 2017-08-04 05:49:49
|
Dear Team, I would like to know if any user setup complete finance module with Indian Taxation configured in system. Prerak Shah Chief Information Officer -IT <mailto:pre...@he...%20> pre...@he... Address Plot No. B11, Phase1,MEPZ - SEZ Tambaram, Chennai -600 045 Visit us at <http://hexagonnutrition.com/> hexagonnutrition.com Mobile +91 7550177377 Board +91(044) 22625250 / 52 For current openings : <http://careers.hexagonnutrition.com/jobs/> http://careers.hexagonnutrition.com/jobs/ |
|
From: R2-G <r2g...@gm...> - 2017-07-07 13:49:22
|
Thanks gsavix that worked R2-g -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/WebERP-4-14-not-list-Chart-of-Accounts-tp4658825p4658831.html Sent from the web-ERP-users mailing list archive at Nabble.com. |
|
From: ExsonQu <hex...@gm...> - 2017-07-06 01:18:09
|
*Dear all,*
I've received a report that the supplier invoice cannot be issued
in PHP 7.1 environment.
It's fixed in the trunk and you can download the attached file to
replace with the original one.
SupplierInvoice.zip
<http://weberp-accounting.1478800.n4.nabble.com/file/n4658830/SupplierInvoice.zip>
Thanks and best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Supplier-Invoice-does-not-work-in-php7-1-tp4658830.html
Sent from the web-ERP-users mailing list archive at Nabble.com.
|
|
From: ExsonQu <hex...@gm...> - 2017-07-06 01:14:04
|
*Dear all,*
webERP4.14.1 was rolled up to source forge last Monday.
It fixed the update failure bug and not listed the chart of
account problem in GL accounts.
Best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/webERP4-14-1-released-tp4658829.html
Sent from the web-ERP-users mailing list archive at Nabble.com.
|
|
From: gilberto d. s. a. <gs...@gm...> - 2017-07-04 19:27:14
|
change line 322 DB_fetch_array() is correct. DB_fech_arrary() <==== wrong word fech -- gilberto dos santos alves +5511986465049 2017-07-04 16:15 GMT-03:00 gilberto dos santos alves <gs...@gm...>: > [1] https://drive.google.com/open?id=0B7RGseydrhtyNHJIOUxEWUJCb3c > link with show image error. > > -- > gilberto dos santos alves > +5511986465049 <(11)%2098646-5049> > > > > > > > 2017-07-04 15:49 GMT-03:00 gilberto dos santos alves <gs...@gm...>: > >> hi. after install fresh version 4.14 see line 322 of GLAccounts.php do >> call undefined function DB_fech_array(). >> you can see this message if you active your log options. >> >> -- >> gilberto dos santos alves >> +5511986465049 <(11)%2098646-5049> >> >> >> >> >> >> >> 2017-07-04 6:09 GMT-03:00 R2-G <r2g...@gm...>: >> >>> I upgraded to webERP 4.14 recently and when I go to >>> >>> MAIN MENU --> GENERAL LEDGER --> GL ACCOUNTS >>> >>> the system does not list the accounts but gives the new account creation >>> screen as below. >>> I have checked th DB via phpmyadmin and all the accounts are in the DB >>> chartmaster table. >>> >>> <http://weberp-accounting.1478800.n4.nabble.com/file/n465882 >>> 5/bytronscr.png> >>> >>> any ideas what could be wrong ? >>> >>> >>> Thanks in advance >>> >>> >>> R2-g >>> >>> >>> >>> -- >>> View this message in context: http://weberp-accounting.14788 >>> 00.n4.nabble.com/WebERP-4-14-not-list-Chart-of-Accounts-tp4658825.html >>> Sent from the web-ERP-users mailing list archive at Nabble.com. >>> >>> ------------------------------------------------------------ >>> ------------------ >>> Check out the vibrant tech community on one of the world's most >>> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >>> _______________________________________________ >>> web-ERP-users mailing list >>> web...@li... >>> https://lists.sourceforge.net/lists/listinfo/web-erp-users >>> >> >> > |
|
From: gilberto d. s. a. <gs...@gm...> - 2017-07-04 19:15:29
|
[1] https://drive.google.com/open?id=0B7RGseydrhtyNHJIOUxEWUJCb3c link with show image error. -- gilberto dos santos alves +5511986465049 2017-07-04 15:49 GMT-03:00 gilberto dos santos alves <gs...@gm...>: > hi. after install fresh version 4.14 see line 322 of GLAccounts.php do > call undefined function DB_fech_array(). > you can see this message if you active your log options. > > -- > gilberto dos santos alves > +5511986465049 <(11)%2098646-5049> > > > > > > > 2017-07-04 6:09 GMT-03:00 R2-G <r2g...@gm...>: > >> I upgraded to webERP 4.14 recently and when I go to >> >> MAIN MENU --> GENERAL LEDGER --> GL ACCOUNTS >> >> the system does not list the accounts but gives the new account creation >> screen as below. >> I have checked th DB via phpmyadmin and all the accounts are in the DB >> chartmaster table. >> >> <http://weberp-accounting.1478800.n4.nabble.com/file/n465882 >> 5/bytronscr.png> >> >> any ideas what could be wrong ? >> >> >> Thanks in advance >> >> >> R2-g >> >> >> >> -- >> View this message in context: http://weberp-accounting.14788 >> 00.n4.nabble.com/WebERP-4-14-not-list-Chart-of-Accounts-tp4658825.html >> Sent from the web-ERP-users mailing list archive at Nabble.com. >> >> ------------------------------------------------------------ >> ------------------ >> Check out the vibrant tech community on one of the world's most >> engaging tech sites, Slashdot.org! http://sdm.link/slashdot >> _______________________________________________ >> web-ERP-users mailing list >> web...@li... >> https://lists.sourceforge.net/lists/listinfo/web-erp-users >> > > |
|
From: gilberto d. s. a. <gs...@gm...> - 2017-07-04 18:49:36
|
hi. after install fresh version 4.14 see line 322 of GLAccounts.php do call undefined function DB_fech_array(). you can see this message if you active your log options. -- gilberto dos santos alves +5511986465049 2017-07-04 6:09 GMT-03:00 R2-G <r2g...@gm...>: > I upgraded to webERP 4.14 recently and when I go to > > MAIN MENU --> GENERAL LEDGER --> GL ACCOUNTS > > the system does not list the accounts but gives the new account creation > screen as below. > I have checked th DB via phpmyadmin and all the accounts are in the DB > chartmaster table. > > <http://weberp-accounting.1478800.n4.nabble.com/file/ > n4658825/bytronscr.png> > > any ideas what could be wrong ? > > > Thanks in advance > > > R2-g > > > > -- > View this message in context: http://weberp-accounting. > 1478800.n4.nabble.com/WebERP-4-14-not-list-Chart-of- > Accounts-tp4658825.html > Sent from the web-ERP-users mailing list archive at Nabble.com. > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > |
|
From: R2-G <r2g...@gm...> - 2017-07-04 09:27:16
|
I upgraded to webERP 4.14 recently and when I go to MAIN MENU --> GENERAL LEDGER --> GL ACCOUNTS the system does not list the accounts but gives the new account creation screen as below. I have checked th DB via phpmyadmin and all the accounts are in the DB chartmaster table. <http://weberp-accounting.1478800.n4.nabble.com/file/n4658825/bytronscr.png> any ideas what could be wrong ? Thanks in advance R2-g -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/WebERP-4-14-not-list-Chart-of-Accounts-tp4658825.html Sent from the web-ERP-users mailing list archive at Nabble.com. |
|
From: ExsonQu <hex...@gm...> - 2017-06-26 07:02:25
|
*Dear all,*
I've roll up 4.14.1 to SF.
Sorry for any inconvenience caused.
Best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Fwd-Re-webERP-4-14-tp4658816p4658821.html
Sent from the web-ERP-users mailing list archive at Nabble.com.
|
|
From: Phil D. <ph...@lo...> - 2017-06-26 01:25:06
|
Yes that makes more sense Phil Phil Daintree +64 (0)275 567 890 > On 26/06/2017, at 12:59 PM, ExsonQu <hex...@gm...> wrote: > > *Hi, Phil,* > > Thank you for your quick response. > I think we can change the GetConfigure.php just to judge the > version number, if the number is 4.13.1, then let is skip this part to make > the SQL update possible. I have not test it. Will test the idea and make a > release soon. > Thanks and best regards! > Exson > > > > -- > View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Fwd-Re-webERP-4-14-tp4658816p4658819.html > Sent from the web-ERP-users mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users |
|
From: ExsonQu <hex...@gm...> - 2017-06-26 01:17:06
|
*Hi, Phil,*
Thank you for your quick response.
I think we can change the GetConfigure.php just to judge the
version number, if the number is 4.13.1, then let is skip this part to make
the SQL update possible. I have not test it. Will test the idea and make a
release soon.
Thanks and best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Fwd-Re-webERP-4-14-tp4658816p4658819.html
Sent from the web-ERP-users mailing list archive at Nabble.com.
|
|
From: Arwan <r1g...@gm...> - 2017-06-24 11:22:31
|
Thanks a whole bunch gsavix I ren the upgrade script manually and now webERP4.14 is working OK Thanks Arwan ----- WebTech Resources Nairobi Kenya +254 724659244 Email :in...@we... WEB :weberp.co.ke -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Problem-upgrading-from-4-13-1-to-4-14-tp4658814p4658818.html Sent from the web-ERP-users mailing list archive at Nabble.com. |
|
From: Phil D. <ph...@lo...> - 2017-06-24 00:13:36
|
The version upgrade fails without running the SQL manually first.
As a temporary fix, I've added a check to insert the new table inside
GetConfig.php - even though this is mysql specific SQL (Engine=INNODB) -
so not an ideal solution and open to other options??
I am not sure how the favourites thing works so would be good to see
some description of what this does and how to use it - I can add to the
manual as needed.
Run the SQL
CREATE table favourites (userid varchar(20) NOT NULL DEFAULT '',
caption varchar(50) NOT NULL DEFAULT '',
href varchar(200) NOT NULL DEFAULT '#',
PRIMARY KEY (userid,caption)) Engine=InnoDB DEFAULT CHARSET=utf8;
against your database manually then try again through the browser - it
is an error with this latest release.
Phil
Phil Daintree
Logic Works Ltd - +64 (0)275 567890
http://www.logicworks.co.nz
On 24/06/17 10:14, BioAcyl Corp wrote:
>
> 23-06-2017
> Hi there,
> i am running a laboratory under GMP rules and webERP is just ideal for
> snall/mediun sized establishments. It is a very fine system and among
> the best.
>
> The recent version 4.14 is giving problems to upgrade from 4.13.1 The
> distribution download yields only 29.44 M and when extracted for the
> database upgrade it gives sql error for missing favourites table.
>
> I would like very much to upgrade. What should I do?
>
>
|
|
From: gilberto d. s. a. <gs...@gm...> - 2017-06-23 19:14:13
|
if you have access to phpmyadmin run sql script manual way. if not phpmyadmin access open terminal and run mysql -u your-user -pyour-pass < your-script-update-sql -- gilberto dos santos alves +5511986465049 2017-06-23 14:39 GMT-03:00 Arwan <r1g...@gm...>: > Hi, > > I had a working webERP 4.13.1 setup > then I took the following steps > 1. unziped the new webERP4.14 version to a new folder > 2. copied the contents of oldwebERP/companies to newebERP/companies > 3. coped the config.php from old to new folder > > then pointed by browser to newwebERP and got > > Database Error 1146 : > Table 'weberpco_multitrade.favourites' doesn't exist > Database SQL Failure : The SQL that failed was > SELECT href, caption FROM favourites WHERE userid='webtech' > > then went to newwebERP/sql/mysql/upgrade4.13.1-4.14.sql and coped > > CREATE table favourites (userid varchar(20) NOT NULL DEFAULT '', > caption varchar(50) NOT NULL DEFAULT '', > href varchar(200) NOT NULL DEFAULT '#', > PRIMARY KEY (userid,caption)) Engine=InnoDB DEFAULT CHARSET=utf8; > > and ren it on the DB and now am able to login to webERP and get > > <http://weberp-accounting.1478800.n4.nabble.com/file/n4658814/414-1.png> > > when I click on perform database upgrade, it does not seem to do the > upgrade > and I get > > <http://weberp-accounting.1478800.n4.nabble.com/file/n4658814/414-2.png> > > from here clicking on MAIN MENU simply takes me back to the first page and > just goes round the process again. > > <http://weberp-accounting.1478800.n4.nabble.com/file/n4658814/414-1.png> > > any assistance greatly appreciated > > > Arwan > > > > > > > ----- > WebTech Resources > Nairobi Kenya > +254 724659244 > Email :in...@we... > WEB :weberp.co.ke > > -- > View this message in context: http://weberp-accounting. > 1478800.n4.nabble.com/Problem-upgrading-from-4-13-1-to-4-14-tp4658814.html > Sent from the web-ERP-users mailing list archive at Nabble.com. > > ------------------------------------------------------------ > ------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users > |
|
From: Arwan <r1g...@gm...> - 2017-06-23 17:57:03
|
Hi, I had a working webERP 4.13.1 setup then I took the following steps 1. unziped the new webERP4.14 version to a new folder 2. copied the contents of oldwebERP/companies to newebERP/companies 3. coped the config.php from old to new folder then pointed by browser to newwebERP and got Database Error 1146 : Table 'weberpco_multitrade.favourites' doesn't exist Database SQL Failure : The SQL that failed was SELECT href, caption FROM favourites WHERE userid='webtech' then went to newwebERP/sql/mysql/upgrade4.13.1-4.14.sql and coped CREATE table favourites (userid varchar(20) NOT NULL DEFAULT '', caption varchar(50) NOT NULL DEFAULT '', href varchar(200) NOT NULL DEFAULT '#', PRIMARY KEY (userid,caption)) Engine=InnoDB DEFAULT CHARSET=utf8; and ren it on the DB and now am able to login to webERP and get <http://weberp-accounting.1478800.n4.nabble.com/file/n4658814/414-1.png> when I click on perform database upgrade, it does not seem to do the upgrade and I get <http://weberp-accounting.1478800.n4.nabble.com/file/n4658814/414-2.png> from here clicking on MAIN MENU simply takes me back to the first page and just goes round the process again. <http://weberp-accounting.1478800.n4.nabble.com/file/n4658814/414-1.png> any assistance greatly appreciated Arwan ----- WebTech Resources Nairobi Kenya +254 724659244 Email :in...@we... WEB :weberp.co.ke -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Problem-upgrading-from-4-13-1-to-4-14-tp4658814.html Sent from the web-ERP-users mailing list archive at Nabble.com. |
|
From: Phil D. <ph...@lo...> - 2017-06-22 04:27:33
|
Thanks Exson 😀 Phil Phil Daintree +64 (0)275 567 890 > On 21/06/2017, at 4:24 PM, ExsonQu <hex...@gm...> wrote: > > *Dear all,* > > I'm glad to announce that webERP4.14 has been released. > > Some key points in this release including: > > 1. PHP 7 complaint. It run properly in PHP 7 without any annoying > deprecated notice. > 2. Safety enhancement by revise session.inc, footer.inc, > header.inc to session.php, footer.php, header.php. > 3. A new theme added to this release. > 4. An experimental feature-- users can add/remove their favorite > scripts to the main menu. > 5. As usual, some bugs fixed. > > You can download it from here: > https://sourceforge.net/projects/web-erp/files/webERP4.14.zip/download > <https://sourceforge.net/projects/web-erp/files/webERP4.14.zip/download> > > Thank you very much for your contribution to the project. > > > Best regards! > Exson > > > > > -- > View this message in context: http://weberp-accounting.1478800.n4.nabble.com/webERP4-14-has-been-released-tp4658805.html > Sent from the web-ERP-users mailing list archive at Nabble.com. > > ------------------------------------------------------------------------------ > Check out the vibrant tech community on one of the world's most > engaging tech sites, Slashdot.org! http://sdm.link/slashdot > _______________________________________________ > web-ERP-users mailing list > web...@li... > https://lists.sourceforge.net/lists/listinfo/web-erp-users |
|
From: ExsonQu <hex...@gm...> - 2017-06-21 04:41:03
|
*Dear all,*
I'm glad to announce that webERP4.14 has been released.
Some key points in this release including:
1. PHP 7 complaint. It run properly in PHP 7 without any annoying
deprecated notice.
2. Safety enhancement by revise session.inc, footer.inc,
header.inc to session.php, footer.php, header.php.
3. A new theme added to this release.
4. An experimental feature-- users can add/remove their favorite
scripts to the main menu.
5. As usual, some bugs fixed.
You can download it from here:
https://sourceforge.net/projects/web-erp/files/webERP4.14.zip/download
<https://sourceforge.net/projects/web-erp/files/webERP4.14.zip/download>
Thank you very much for your contribution to the project.
Best regards!
Exson
--
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/webERP4-14-has-been-released-tp4658805.html
Sent from the web-ERP-users mailing list archive at Nabble.com.
|
|
From: akshaygujar <aks...@gm...> - 2017-06-12 16:37:34
|
Any updates on this issue? -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Credits-not-including-TAX-tp4658621p4658802.html Sent from the web-ERP-users mailing list archive at Nabble.com. |
|
From: akshaygujar <aks...@gm...> - 2017-05-24 03:25:37
|
How do we get the details of once entered supplier invoice. Like the supplier invoice number etc after entering the supplier invoice. -- View this message in context: http://weberp-accounting.1478800.n4.nabble.com/Process-Help-Please-tp3318545p4658800.html Sent from the web-ERP-users mailing list archive at Nabble.com. |
221 messages has been excluded from this view by a project administrator.
