webERP Accounting & Business Management

I recently moved our webERP installation to a new server with loads more
memory, quad core CPU, upgraded mysql from 4.x to 5.x, upgraded PHP, etc.
BUT the daily database administration and optimisation routine
(DB_maintenance in ConnectDB_mysql.inc) is now painfully slow -- taking a
good 20-30 minutes where before it took only a couple of minutes. Does
anyone have suggestions why that might be?
-- 
View this message in context: http://www.nabble.com/Database-Administration---Optimisation-Routine-Painfully-Slow-tp25696899p25696899.html
Sent from the web-erp-users mailing list archive at Nabble.com.

Hi there!
I've started setting up a new instance of weberp and although there is
already some data in the system, I cannot display a balance sheet.
The GLBalanceSheet page displays no eom date in the select menu, the "detail
of summary" select does not display at all and, if that helps, the weberp
version (3.10) does not display, nor the company logo... Any clue?

Thanks,
Jean-Marc

HI Phil

FAQ Q14  Indicates that the database name, the config $DefaultCompany
variable and the subdirectory under the company directory should all be the
same name. But changing the $allow_demo_mode to false fixed the problem.
Now I get this error
 *Database Error* :
Unknown column 'www_users.salesman' in 'field list'

-- 
Allen Hicks
RR#1 Site 4 Box 10
Millarville AB T0L-1K0 Canada
Phone: 403-931-3610
Cell: 403-816-5251
E-mail: ahicks2@...
Web: http://www.polocrosse.ca