Re: database corrupt after update to v4.00RC1
Sorry for my rush to reply, it's a little late here. Just for your
error 1: It seems that there is no factorcompany whose id is 1, please
error 2: Have you try other mail format？such as soltec <at> soltec.com? It
maybe a bug. Let me find some time to check it tommorrow.
BTW, please join the mail list, otherwise lots of users or developers
will not see your questions. You can register it here
Heinrich Steuber wrote:
> I have upgraded from Version = '3.11.3' to webERP v4.00RC1
> copied the old database to the new name,
> run the script: upgrade3.11.1-4.00.sql as you so nicely instruct and now
> have a couple of errors, that are setting me back a bit:
> 1. under http://.../Suppliers.php, when I try to add a new supplier :
>> Database Error : The supplier SL Steel Sales could not be added because
>> Cannot add or update a child row: a foreign key constraint fails
>> (`solacc2011`.`suppliers`, CONSTRAINT `suppliers_ibfk_4` FOREIGN KEY
>> (`factorcompanyid`) REFERENCES `factorcompanies` (`id`))
>> Database SQL Failure : The SQL that was used to insert the supplier but
>> failed was
>> INSERT INTO suppliers (supplierid, suppname, address1, address2,
>> address3, address4, telephone, fax, email, supptype, currcode,
>> suppliersince, paymentterms, bankpartics, bankref, bankact, remittance,
>> taxgroupid, factorcompanyid, lat, lng, taxref) VALUES ('SL01', 'SL Steel
>> Sales', 'Eadiestr 5', 'Windhoek', '', '', '+264 (81) 1283149', '', '',
>> '1', 'NAD', '2011-02-07', '30', '', '0', '', '1', '1', '0', '0', '0', '')
> 2. under http://.../SystemParameters.php, when I am trying to save the
> settings, even without any changes:
>> ERROR Message Report : The Factory Manager Email address does not appear
>> to be valid
> the email address in question looks like this: soltec <at> soltec.com.na
> would it make sense to attach the sql-dump?
> you help is very much appreciated &
> I do thank you in anticipation!
> Best regards!
View this message in context: http://weberp-accounting.1478800.n4.nabble.com/database-corrupt-after-update-to-v4-00RC1-tp3264332p3264421.html
Sent from the web-erp-users mailing list archive at Nabble.com.
The modern datacenter depends on network connectivity to access resources
and provide services. The best practices for maximizing a physical server's
connectivity to a physical network are well understood - see how these
rules translate into the virtual world?
web-ERP-users mailing list
web-ERP-users <at> lists.sourceforge.net