Re: [webERP-users] Problem upgrading from 4.13.1 to 4.14

[gilberto d. s. a. <gs...@gm...>]

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
>