web-erp-users — User general webERP discussion list

Re: [Web-erp-users] can't print invoice

[Daintree F. <p.d...@xt...>]

Hi Henry,

I would have thought that Chinese PDF should be possible - I guess =
reformating of the invoice may be required though.

The problem with the no invoice to print is new to me. Could it be that =
the underlying order has been deleted ? The order header record is =
required to get the delivery address information to print on invoices - =
if it is deleted then the reprint won't work - this is probably a bad =
thing, I will make it so the invoice prints without delivery information =
if the sales order has been deleted/purged in a future version. Is the =
problem isolated to a specific invoice or do other invoices not print?

Thanks for your feedback - I hope together we can resolve this issue.
Regards
Phil Daintree
Logicworks Ltd
  ----- Original Message -----=20
  From: Henry Lin=20
  To: web...@li...=20
  Sent: Thursday, March 20, 2003 10:52 PM
  Subject: [Web-erp-users] can't print invoice


  Hi,

  I install web-erp  0.1.5.1 this week on red hat linux 8.0 and it works =
well. But I try to print out the invoice,  it shows following code:

  SELECT DebtorTrans.TranDate, DebtorTrans.OvAmount, =
DebtorTrans.OvDiscount, DebtorTrans.OvFreight, DebtorTrans.OvGST, =
DebtorTrans.Rate, DebtorTrans.InvText, DebtorsMaster.Name, =
DebtorsMaster.Address1, DebtorsMaster.Address2, DebtorsMaster.Address3, =
DebtorsMaster.Address4, DebtorsMaster.CurrCode, SalesOrders.DeliverTo, =
SalesOrders.DelAdd1, SalesOrders.DelAdd2, SalesOrders.DelAdd3, =
SalesOrders.CustomerRef, SalesOrders.OrderNo, SalesOrders.OrdDate, =
Shippers.ShipperName, CustBranch.BrName, CustBranch.BrAddress1, =
CustBranch.BrAddress2, CustBranch.BrAddress3, CustBranch.BrAddress4, =
Salesman.SalesmanName, DebtorTrans.DebtorNo FROM DebtorTrans, =
DebtorsMaster, CustBranch, SalesOrders, Shippers, Salesman WHERE =
DebtorTrans.Order_ =3D SalesOrders.OrderNo AND DebtorTrans.Type=3D10 AND =
DebtorTrans.TransNo=3D10 AND DebtorTrans.ShipVia=3DShippers.Shipper_ID =
AND DebtorTrans.DebtorNo=3DDebtorsMaster.DebtorNo AND =
DebtorTrans.DebtorNo=3DCustBranch.DebtorNo AND =
DebtorTrans.BranchCode=3DCustBranch.BranchCode AND =
CustBranch.Salesman=3DSalesman.SalesmanCode

  If I try to print it to PDF document (I install PDFlib and compile it =
wth PHP module ), it shows=20


  Fatal error: PDFlib error: Empty document in =
/var/www/html/web-erp/PrintCustTrans.php on line 205

  It seems no invoice document is created. But I use phpmyadmin to check =
the records on DebtorTrans, =
DebtorsMaster,CustBranch,SalesOrders,Shippers,Salesman and it seems all =
right.

  For comparison, I can print the credit notes without problem =
(actually, the PDF document is ok except the Chinese characters can't =
show on PDF document)

  Does anyone have this problem?

  Any help will be appreciated.

  Henry

[Web-erp-users] can't print invoice

[Henry L. <he...@Li...>]

Hi,

I install web-erp  0.1.5.1 this week on red hat linux 8.0 and it works =
well. But I try to print out the invoice,  it shows following code:

SELECT DebtorTrans.TranDate, DebtorTrans.OvAmount, =
DebtorTrans.OvDiscount, DebtorTrans.OvFreight, DebtorTrans.OvGST, =
DebtorTrans.Rate, DebtorTrans.InvText, DebtorsMaster.Name, =
DebtorsMaster.Address1, DebtorsMaster.Address2, DebtorsMaster.Address3, =
DebtorsMaster.Address4, DebtorsMaster.CurrCode, SalesOrders.DeliverTo, =
SalesOrders.DelAdd1, SalesOrders.DelAdd2, SalesOrders.DelAdd3, =
SalesOrders.CustomerRef, SalesOrders.OrderNo, SalesOrders.OrdDate, =
Shippers.ShipperName, CustBranch.BrName, CustBranch.BrAddress1, =
CustBranch.BrAddress2, CustBranch.BrAddress3, CustBranch.BrAddress4, =
Salesman.SalesmanName, DebtorTrans.DebtorNo FROM DebtorTrans, =
DebtorsMaster, CustBranch, SalesOrders, Shippers, Salesman WHERE =
DebtorTrans.Order_ =3D SalesOrders.OrderNo AND DebtorTrans.Type=3D10 AND =
DebtorTrans.TransNo=3D10 AND DebtorTrans.ShipVia=3DShippers.Shipper_ID =
AND DebtorTrans.DebtorNo=3DDebtorsMaster.DebtorNo AND =
DebtorTrans.DebtorNo=3DCustBranch.DebtorNo AND =
DebtorTrans.BranchCode=3DCustBranch.BranchCode AND =
CustBranch.Salesman=3DSalesman.SalesmanCode

If I try to print it to PDF document (I install PDFlib and compile it =
wth PHP module ), it shows=20


Fatal error: PDFlib error: Empty document in =
/var/www/html/web-erp/PrintCustTrans.php on line 205

It seems no invoice document is created. But I use phpmyadmin to check =
the records on DebtorTrans, =
DebtorsMaster,CustBranch,SalesOrders,Shippers,Salesman and it seems all =
right.

For comparison, I can print the credit notes without problem (actually, =
the PDF document is ok except the Chinese characters can't show on PDF =
document)

Does anyone have this problem?

Any help will be appreciated.

Henry

[Web-erp-users] Insalled it!

[tony <ton...@tb...>]

Hi

This is great, after NOLA and Compiere this just works. I'm in the UK, 
and not a programmer - can I help?

Tony

[Web-erp-users] =?iso-8859-1?Q?Traducci=F3n_al_Espa=F1ol?=

[Federico V. <fed...@ar...>]

Necesito contactarme con  Francisco Javier Garc=EDa de Rua

[Web-erp-users] Logging in

[Phil D. <ph...@du...>]

Dear Francisco,

I think I understand, you are attempting to log in from the same computer a 2nd or 3rd time and no log in is required. However if you attempt to log in from a different computer you would be presented with a login. PHP handles sessions by reference to individual computer connections. It is my understanding that different computers with seperate ip addresses will require seperate logins. I will double check this when I get chance. The log off is done by exiting the browser. Starting the browser again will require a new login, starting a 2nd window or another instance of a browser on the same machine will not require a second login since there is already a session establised from the same machine on the server.

I will send Federico you email address and he will contact you assuming he also wants to half his own translation effort.

Regards
Phil Daintree



Regards
Phil Daintree
Dux Industries Ltd Ph: +64 (04) 567 8900 Fax: +64 (04) 567 8904

[Web-erp-users] Fw: All runing ok!

[Daintree F. <p.d...@xt...>]

Hi Federico,

Great.- so glad you got up and running after all the effort you put in.
Yes the system was designed to be run with the register_globals set to off -
the problem with on is that users can pass variables to the scripts
directly - a potential security issue - but also quite handy too!

Could I use your name for a contact for a spanish version ?

Regards
Phil
----- Original Message -----
From: "Federico Vera" <fed...@ar...>
To: "Daintree Family" <p.d...@xt...>
Sent: Thursday, March 13, 2003 1:52 AM
Subject: All runing ok!


> Dear Phil
>
> I fixed the problem, I find out that variable arguments start with "&" and
> some others don't start in a A HREF  line, after the SID .
>
> I added  this simbol  and the problem was fixed.
>
> I had some problems with the session too, and I did a directory
c:/php/tmp,
> and the problem was fixed.
>
> Now I'm working on the translation, because I need this system in Spanish.
>
> Can the sistem work with global setting off?
>
> My idea to find out a sistem with Apache-php-mysql, was the independence
of
> plataform, I  Ican run a server in windows-linux , I can expand network
> without problems in a Intranet. and the workstations only need to run a
web
> browser in windows-linux.
>
> I'll be in contact with you.
>
> Thanks a lot for your help, in this way is easier to fix a problem.
>
>
> Federico Vera - Argentina
>
>
>
>
>
>
> ----- Original Message -----
> From: "Daintree Family" <p.d...@xt...>
> To: "Web-ERP List" <web...@li...>; "Federico Vera"
> <fed...@ar...>
> Sent: Wednesday, March 12, 2003 3:39 AM
> Subject: Re: now runing!, but with some problems
>
>
> > Hi Federico,
> >
> > I cannot simulate this problem.
> >
> > I got this message:
> >
> > Warning: session_start() [function.session-start]:
> > open(/tmp\sess_467e0da7dc4b471479be32ea0acf8cda, O_RDWR) failed: No such
> > file or directory (2) in c:\program files\apache
> > group\apache\htdocs\web-erp\header.inc on line 6
> >
> > when I removed the file php.ini from the C:\windows directory
altogether.
> >
> > All I had to do to fix it is to copy the file php.ini-dist to
> > C:\Windows\php.ini
> > and modified the line
> >
> > ;extension=php_pdf.dll
> > to
> > extension=php_pdf.dll
> >
> > to ensure that the pdf creation functionality in php was enabled. Many
of
> > the reports depend upon this. Also, I changed the  line that read:
> >
> > session.save_path = /tmp
> > to
> > session.save_path = C:\Temp
> >
> > and I created the directory C:\Temp
> >
> > other than that the whole php.ini-dist file was unchanged. Then I
> restarted
> > apache from the Services in the control panel.
> > I tried to get it to repeat your problem with register_globals on and
off
> > but as expected it works either way. Security-wise it is best to leave
the
> > default setting to off.
> >
> > I am sorry I cannot get my system to duplicate your problem.
> > Have you compared your php.ini file to the default php.ini-dist file -
in
> > particular the variables surrounding the use of sessions?
> >
> > Regards
> > Phil
> >
> > ----- Original Message -----
> > From: "Federico Vera" <fed...@ar...>
> > To: "Daintree Family" <p.d...@xt...>
> > Cc: <web...@li...>
> > Sent: Wednesday, March 12, 2003 3:18 AM
> > Subject: now runing!, but with some problems
> >
> >
> > > Hi Phil
> > >
> > >
> > > I have bee working the whole weekend in the apllication, I think that
my
> > > problem was to install php from the executable installation, I have
> > > installed  php from the zip file now, and it's working now!
> > >
> > > But somethings aren't working, and the problem is the following
> > >
> > > When I enter in a link with with session ID and another variable, the
> > sistem
> > > give me the followinr error:
> > >
> > > Warning: session_start() [function.session-start]: The session id
> contains
> > > illegal characters, valid characters are only a-z, A-Z and 0-9 in
> > > c:\inetpub\wwwroot\apache\web-erp\header.inc on line 6
> > >
> > >
> > > I discover that the variable follow to the session ID and the browser
> > cann't
> > > detect the diference betwen the variable and the sesion ID.  But I
don't
> > > don't how to fix it.
> > >
> > >
> > >
> >
>
.../web-erp/index.php?PHPSESSID=7978376d09d8be5a66a51d70ec1ce7a3Application=
> > > stock
> > >
> > >
> > > when I open a link with only the session ID all work fine
> > >
> > > .../web-erp/index.php?PHPSESSID=7978376d09d8be5a66a51d70ec1ce7a3
> > >
> > >
> > > Any suggestion?
> > >
> > > Thanks a lot for the previus mail
> > >
> > >
> > > Federico Vera
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > >
> > > ----- Original Message -----
> > > From: "Daintree Family" <p.d...@xt...>
> > > To: "Andreas Berner" <an...@ne...>; "Federico Vera"
> > > <fed...@ar...>; "Web-ERP List" <>
> > > Sent: Sunday, March 09, 2003 5:27 AM
> > > Subject: Re: [Web-erp-users] installation problems
> > >
> > >
> > > > Hi Andreas and Frederico,
> > > >
> > > > To get a handle on the windows installation, I installed it today on
> > > Windows
> > > > using Apache 1.3.27
> > > > PHP 4.3.1 from the zip file
> > > > MySql Max 3.23.54 on Windows XP.
> > > >
> > > > The traps I found were:
> > > >
> > > > I installed PHP as a module and editing the C:\Program Files\Apache
> > > > Group\Apache\conf\httpd.conf file to
> > > > LoadModule php4_module C:/Program
> > > Files/php-4.3.1-Win32/sapi/php4apache.dll
> > > > failed for me so I moved the file php4apache.dll and the file
> php4ts.dll
> > > > (the file php4apache.dll needs this file) to C:\Windows (it could be
> > > > C:\Winnt in NT or 2000) and edited httpd.conf to:
> > > > LoadModule php4_module C:/Windows/php4apache.dll
> > > >
> > > > The next problem was that having edited the extensions section of
the
> > > > php-dist.ini file so that pdf extension was activated - by taking
out
> > the
> > > > semi colon before the line:
> > > >
> > > > extension=php_pdf.dll
> > > >
> > > > When Apache started it couldn't find the necessary php_pdf.dll
> > > > I moved the file from the php distribution files under extensions to
> > > > C:\Windows\System32 (this directory could be C:\Winnt\System32 or
> > > something
> > > > else on other versions - I am using XP).
> > > >
> > > > Apache and PHP ran sweetly.
> > > > I tested the Apache PHP and MySQL were running by installing
> phpMyAdmin
> > > > 2.4.0
> > > > I had modified the file C:/mysql/my-medium by uncommenting the line
> > > >
> > > > # Uncomment the following if you are NOT using BDB tables
> > > > skip-bdb
> > > >
> > > > then I uncommented the lines for innodb:
> > > >
> > > > # Uncomment the following if you are using Innobase tables
> > > >
> > > > innodb_data_file_path = ibdata1:40M
> > > >
> > > > innodb_data_home_dir = c:\mysql\ibdata
> > > >
> > > > innodb_log_group_home_dir = c:\mysql\iblogs
> > > >
> > > > innodb_log_arch_dir = c:\mysql\iblogs
> > > >
> > > > set-variable = innodb_mirrored_log_groups=1
> > > >
> > > > set-variable = innodb_log_files_in_group=3
> > > >
> > > > set-variable = innodb_log_file_size=5M
> > > >
> > > > set-variable = innodb_log_buffer_size=8M
> > > >
> > > > innodb_flush_log_at_trx_commit=1
> > > >
> > > > innodb_log_archive=0
> > > >
> > > > set-variable = innodb_buffer_pool_size=16M
> > > >
> > > > set-variable = innodb_additional_mem_pool_size=2M
> > > >
> > > > set-variable = innodb_file_io_threads=4
> > > >
> > > > set-variable = innodb_lock_wait_timeout=50
> > > >
> > > > I created the directories for C:/mysql/ibdata and C:/mysql/iblogs
> > > >
> > > > and changed its name to my.ini
> > > >
> > > > Using the phpMyAdmin utility under the Show MySQL System variables
> link
> > I
> > > > could see that the my.ini I had created under C:/mysql/my.ini was
not
> > > being
> > > > read because the HAVE-BDB was not set to OFF and
innodb_data_home_dir
> > was
> > > > not set so I moved it and renamed it to:
> > > >
> > > > C:/my.cnf
> > > >
> > > > ie right under the root directory. I restarted MySql from the
control
> > > panel
> > > > services.
> > > >
> > > > Using phpMyAdmin utility under the Show MySQL System variables link,
I
> > > could
> > > > now see that the my.cnf had been read and innodb variables were
> properly
> > > set
> > > > in particular HAVE-BDB was set to OFF and innodb_data_home_dir was
set
> > to
> > > > c:\mysql\ibdata
> > > >
> > > > It was also evident that Innodb was working because 40Meg data file
> had
> > > been
> > > > created under C:/mysql/ibdata
> > > >
> > > > I had been able to create the database in MySQL without Innodb
> enabled.
> > > you
> > > > can check that Innodb tables have been created using phpMyAdmin to
> > enquire
> > > > upon the database weberp created. It will list the tables with the
> type
> > of
> > > > table. The default is MyISAM the first one in the list to be an
Innodb
> > is
> > > > chartdetails - this was set to be a MyISAM type table, so I dropped
> the
> > > > database using phpMyAdmin and re-ran the web-erp-demo.sql script
from
> a
> > > > command box knowing that Innodb was now operational:
> > > >
> > > > C:/mysql/bin/mysql.exe --user=weberp --password=weberp < "C:/Program
> > > > Files/Apache Group/Apache/htdocs/web-erp/web-erp-demo.sql"
> > > >
> > > > I got nasty messages about using the database weberp so I manually
> > created
> > > > the database weberp using phpMyAdmin then edited out the line in
> > > > web-erp-demo.sql that creates the database.
> > > >
> > > > Re-running it worked happily and away I went.
> > > >
> > > > With Frederico's problem I am guessing that the table StockMaster is
a
> > > > MyISAM type table and that Innodb only became operational subsequent
> to
> > > > creating the db. You need to drop it and re-create the db now you
have
> > > > innodb going.
> > > >
> > > > I hope this narrative helps,
> > > >
> > > > Regards
> > > >
> > > > Phil Daintree
> > > >
> > > >
> > > > ----- Original Message -----
> > > > From: Federico Vera
> > > > To: web...@li...
> > > > Sent: Sunday, March 09, 2003 9:22 AM
> > > > Subject: [Web-erp-users] installation problems
> > > >
> > > >
> > > > Hello
> > > >
> > > > I'm trying to setup the web-erp solution but I have some problems.
> > > >
> > > > I have a Apache server under W98with php extension and  mysql with
> > innodb
> > > > enable
> > > >
> > > > I start the server with mysqld-max on the shell, I verified the show
> > > > variables and innodb is enable
> > > >
> > > > This kind of messages that I put under this text appear on all the
> > pages,
> > > I
> > > > have been lookin around for a week, I really don't what more I have
to
> > do,
> > > I
> > > > have global_setting on in the php config file too.
> > > >
> > > >
> > > >
> > > >
> > > > Notice: Undefined index: submit in
> > > > c:\inetpub\wwwroot\apache\web-erp\stocks.php on line 17
> > > >
> > > >
> > > > Notice: Undefined variable: StockID in
> > > > c:\inetpub\wwwroot\apache\web-erp\stocks.php on line 254
> > > >
> > > >
> > > >
> > > >
> > > > Could you give to me some clues.
> > > >
> > > > I hope that you can help me
> > > >
> > > > Regards
> > > >
> > > > Federico Vera
> > > >
> > >
> > >
> >
>
>

[Web-erp-users] Re: now runing!, but with some problems

[Daintree F. <p.d...@xt...>]

Hi Federico,

I cannot simulate this problem.

I got this message:

Warning: session_start() [function.session-start]:
open(/tmp\sess_467e0da7dc4b471479be32ea0acf8cda, O_RDWR) failed: No such
file or directory (2) in c:\program files\apache
group\apache\htdocs\web-erp\header.inc on line 6

when I removed the file php.ini from the C:\windows directory altogether.

All I had to do to fix it is to copy the file php.ini-dist to
C:\Windows\php.ini
and modified the line

;extension=php_pdf.dll
to
extension=php_pdf.dll

to ensure that the pdf creation functionality in php was enabled. Many of
the reports depend upon this. Also, I changed the  line that read:

session.save_path = /tmp
to
session.save_path = C:\Temp

and I created the directory C:\Temp

other than that the whole php.ini-dist file was unchanged. Then I restarted
apache from the Services in the control panel.
I tried to get it to repeat your problem with register_globals on and off
but as expected it works either way. Security-wise it is best to leave the
default setting to off.

I am sorry I cannot get my system to duplicate your problem.
Have you compared your php.ini file to the default php.ini-dist file - in
particular the variables surrounding the use of sessions?

Regards
Phil

----- Original Message -----
From: "Federico Vera" <fed...@ar...>
To: "Daintree Family" <p.d...@xt...>
Cc: <web...@li...>
Sent: Wednesday, March 12, 2003 3:18 AM
Subject: now runing!, but with some problems


> Hi Phil
>
>
> I have bee working the whole weekend in the apllication, I think that my
> problem was to install php from the executable installation, I have
> installed  php from the zip file now, and it's working now!
>
> But somethings aren't working, and the problem is the following
>
> When I enter in a link with with session ID and another variable, the
sistem
> give me the followinr error:
>
> Warning: session_start() [function.session-start]: The session id contains
> illegal characters, valid characters are only a-z, A-Z and 0-9 in
> c:\inetpub\wwwroot\apache\web-erp\header.inc on line 6
>
>
> I discover that the variable follow to the session ID and the browser
cann't
> detect the diference betwen the variable and the sesion ID.  But I don't
> don't how to fix it.
>
>
>
.../web-erp/index.php?PHPSESSID=7978376d09d8be5a66a51d70ec1ce7a3Application=
> stock
>
>
> when I open a link with only the session ID all work fine
>
> .../web-erp/index.php?PHPSESSID=7978376d09d8be5a66a51d70ec1ce7a3
>
>
> Any suggestion?
>
> Thanks a lot for the previus mail
>
>
> Federico Vera
>
>
>
>
>
>
>
>
> ----- Original Message -----
> From: "Daintree Family" <p.d...@xt...>
> To: "Andreas Berner" <an...@ne...>; "Federico Vera"
> <fed...@ar...>; "Web-ERP List" <>
> Sent: Sunday, March 09, 2003 5:27 AM
> Subject: Re: [Web-erp-users] installation problems
>
>
> > Hi Andreas and Frederico,
> >
> > To get a handle on the windows installation, I installed it today on
> Windows
> > using Apache 1.3.27
> > PHP 4.3.1 from the zip file
> > MySql Max 3.23.54 on Windows XP.
> >
> > The traps I found were:
> >
> > I installed PHP as a module and editing the C:\Program Files\Apache
> > Group\Apache\conf\httpd.conf file to
> > LoadModule php4_module C:/Program
> Files/php-4.3.1-Win32/sapi/php4apache.dll
> > failed for me so I moved the file php4apache.dll and the file php4ts.dll
> > (the file php4apache.dll needs this file) to C:\Windows (it could be
> > C:\Winnt in NT or 2000) and edited httpd.conf to:
> > LoadModule php4_module C:/Windows/php4apache.dll
> >
> > The next problem was that having edited the extensions section of the
> > php-dist.ini file so that pdf extension was activated - by taking out
the
> > semi colon before the line:
> >
> > extension=php_pdf.dll
> >
> > When Apache started it couldn't find the necessary php_pdf.dll
> > I moved the file from the php distribution files under extensions to
> > C:\Windows\System32 (this directory could be C:\Winnt\System32 or
> something
> > else on other versions - I am using XP).
> >
> > Apache and PHP ran sweetly.
> > I tested the Apache PHP and MySQL were running by installing phpMyAdmin
> > 2.4.0
> > I had modified the file C:/mysql/my-medium by uncommenting the line
> >
> > # Uncomment the following if you are NOT using BDB tables
> > skip-bdb
> >
> > then I uncommented the lines for innodb:
> >
> > # Uncomment the following if you are using Innobase tables
> >
> > innodb_data_file_path = ibdata1:40M
> >
> > innodb_data_home_dir = c:\mysql\ibdata
> >
> > innodb_log_group_home_dir = c:\mysql\iblogs
> >
> > innodb_log_arch_dir = c:\mysql\iblogs
> >
> > set-variable = innodb_mirrored_log_groups=1
> >
> > set-variable = innodb_log_files_in_group=3
> >
> > set-variable = innodb_log_file_size=5M
> >
> > set-variable = innodb_log_buffer_size=8M
> >
> > innodb_flush_log_at_trx_commit=1
> >
> > innodb_log_archive=0
> >
> > set-variable = innodb_buffer_pool_size=16M
> >
> > set-variable = innodb_additional_mem_pool_size=2M
> >
> > set-variable = innodb_file_io_threads=4
> >
> > set-variable = innodb_lock_wait_timeout=50
> >
> > I created the directories for C:/mysql/ibdata and C:/mysql/iblogs
> >
> > and changed its name to my.ini
> >
> > Using the phpMyAdmin utility under the Show MySQL System variables link
I
> > could see that the my.ini I had created under C:/mysql/my.ini was not
> being
> > read because the HAVE-BDB was not set to OFF and innodb_data_home_dir
was
> > not set so I moved it and renamed it to:
> >
> > C:/my.cnf
> >
> > ie right under the root directory. I restarted MySql from the control
> panel
> > services.
> >
> > Using phpMyAdmin utility under the Show MySQL System variables link, I
> could
> > now see that the my.cnf had been read and innodb variables were properly
> set
> > in particular HAVE-BDB was set to OFF and innodb_data_home_dir was set
to
> > c:\mysql\ibdata
> >
> > It was also evident that Innodb was working because 40Meg data file had
> been
> > created under C:/mysql/ibdata
> >
> > I had been able to create the database in MySQL without Innodb enabled.
> you
> > can check that Innodb tables have been created using phpMyAdmin to
enquire
> > upon the database weberp created. It will list the tables with the type
of
> > table. The default is MyISAM the first one in the list to be an Innodb
is
> > chartdetails - this was set to be a MyISAM type table, so I dropped the
> > database using phpMyAdmin and re-ran the web-erp-demo.sql script from a
> > command box knowing that Innodb was now operational:
> >
> > C:/mysql/bin/mysql.exe --user=weberp --password=weberp < "C:/Program
> > Files/Apache Group/Apache/htdocs/web-erp/web-erp-demo.sql"
> >
> > I got nasty messages about using the database weberp so I manually
created
> > the database weberp using phpMyAdmin then edited out the line in
> > web-erp-demo.sql that creates the database.
> >
> > Re-running it worked happily and away I went.
> >
> > With Frederico's problem I am guessing that the table StockMaster is a
> > MyISAM type table and that Innodb only became operational subsequent to
> > creating the db. You need to drop it and re-create the db now you have
> > innodb going.
> >
> > I hope this narrative helps,
> >
> > Regards
> >
> > Phil Daintree
> >
> >
> > ----- Original Message -----
> > From: Federico Vera
> > To: web...@li...
> > Sent: Sunday, March 09, 2003 9:22 AM
> > Subject: [Web-erp-users] installation problems
> >
> >
> > Hello
> >
> > I'm trying to setup the web-erp solution but I have some problems.
> >
> > I have a Apache server under W98with php extension and  mysql with
innodb
> > enable
> >
> > I start the server with mysqld-max on the shell, I verified the show
> > variables and innodb is enable
> >
> > This kind of messages that I put under this text appear on all the
pages,
> I
> > have been lookin around for a week, I really don't what more I have to
do,
> I
> > have global_setting on in the php config file too.
> >
> >
> >
> >
> > Notice: Undefined index: submit in
> > c:\inetpub\wwwroot\apache\web-erp\stocks.php on line 17
> >
> >
> > Notice: Undefined variable: StockID in
> > c:\inetpub\wwwroot\apache\web-erp\stocks.php on line 254
> >
> >
> >
> >
> > Could you give to me some clues.
> >
> > I hope that you can help me
> >
> > Regards
> >
> > Federico Vera
> >
>
>

Re: [Web-erp-users] now runing!, but with some problems

[Phil D. <ph...@du...>]

Hi Federico,

So sorry you have had such a struggle to get going with the system. Many
thanks for persevering and feeding back on the issues you are facing.

Most pages are called with the session id already specified as the system
variable SID. However, under linux there is no visible sign of the sessionid
string in the link shown in the browser. I wonder if there may be a
different default set up of php.ini for the windows vs the linux versions of
PHP. I will look into this and report back.

The register globals variable should be off - it is by default in versions
of PHP since 4.1 I think. Some older systems requrie register globals to be
on. I actually though it wouldn't matter if it was on or off. I know there
is also a variable in php.ini that automatically sends the sessionid with
each page to ensure sessions are propogated between pages - this should not
be required to be set in  my system since the session is explicitly stated
in the links provided.

If you are changing php.ini, after each modification to php.ini I think that
apache will need to be restarted.

Are these pages you have modified to send in a different way or are they
standard pages being called with the sessionid spelt out in full in the
browser?

Regards
Phil

----- Original Message -----
From: "Federico Vera" <fed...@ar...>
To: "Daintree Family" <p.d...@xt...>
Cc: <web...@li...>
Sent: Wednesday, March 12, 2003 3:18 AM
Subject: [Web-erp-users] now runing!, but with some problems


> Hi Phil
>
>
> I have bee working the whole weekend in the apllication, I think that my
> problem was to install php from the executable installation, I have
> installed  php from the zip file now, and it's working now!
>
> But somethings aren't working, and the problem is the following
>
> When I enter in a link with with session ID and another variable, the
sistem
> give me the followinr error:
>
> Warning: session_start() [function.session-start]: The session id contains
> illegal characters, valid characters are only a-z, A-Z and 0-9 in
> c:\inetpub\wwwroot\apache\web-erp\header.inc on line 6
>
>
> I discover that the variable follow to the session ID and the browser
cann't
> detect the diference betwen the variable and the sesion ID.  But I don't
> don't how to fix it.
>
>
>
.../web-erp/index.php?PHPSESSID=7978376d09d8be5a66a51d70ec1ce7a3Application=
> stock
>
>
> when I open a link with only the session ID all work fine
>
> .../web-erp/index.php?PHPSESSID=7978376d09d8be5a66a51d70ec1ce7a3
>
>
> Any suggestion?
>
> Thanks a lot for the previus mail
>
>
> Federico Vera
>
>
>
>
>
>
>
>
> ----- Original Message -----
> From: "Daintree Family" <p.d...@xt...>
> To: "Andreas Berner" <an...@ne...>; "Federico Vera"
> <fed...@ar...>; "Web-ERP List" <>
> Sent: Sunday, March 09, 2003 5:27 AM
> Subject: Re: [Web-erp-users] installation problems
>
>
> > Hi Andreas and Frederico,
> >
> > To get a handle on the windows installation, I installed it today on
> Windows
> > using Apache 1.3.27
> > PHP 4.3.1 from the zip file
> > MySql Max 3.23.54 on Windows XP.
> >
> > The traps I found were:
> >
> > I installed PHP as a module and editing the C:\Program Files\Apache
> > Group\Apache\conf\httpd.conf file to
> > LoadModule php4_module C:/Program
> Files/php-4.3.1-Win32/sapi/php4apache.dll
> > failed for me so I moved the file php4apache.dll and the file php4ts.dll
> > (the file php4apache.dll needs this file) to C:\Windows (it could be
> > C:\Winnt in NT or 2000) and edited httpd.conf to:
> > LoadModule php4_module C:/Windows/php4apache.dll
> >
> > The next problem was that having edited the extensions section of the
> > php-dist.ini file so that pdf extension was activated - by taking out
the
> > semi colon before the line:
> >
> > extension=php_pdf.dll
> >
> > When Apache started it couldn't find the necessary php_pdf.dll
> > I moved the file from the php distribution files under extensions to
> > C:\Windows\System32 (this directory could be C:\Winnt\System32 or
> something
> > else on other versions - I am using XP).
> >
> > Apache and PHP ran sweetly.
> > I tested the Apache PHP and MySQL were running by installing phpMyAdmin
> > 2.4.0
> > I had modified the file C:/mysql/my-medium by uncommenting the line
> >
> > # Uncomment the following if you are NOT using BDB tables
> > skip-bdb
> >
> > then I uncommented the lines for innodb:
> >
> > # Uncomment the following if you are using Innobase tables
> >
> > innodb_data_file_path = ibdata1:40M
> >
> > innodb_data_home_dir = c:\mysql\ibdata
> >
> > innodb_log_group_home_dir = c:\mysql\iblogs
> >
> > innodb_log_arch_dir = c:\mysql\iblogs
> >
> > set-variable = innodb_mirrored_log_groups=1
> >
> > set-variable = innodb_log_files_in_group=3
> >
> > set-variable = innodb_log_file_size=5M
> >
> > set-variable = innodb_log_buffer_size=8M
> >
> > innodb_flush_log_at_trx_commit=1
> >
> > innodb_log_archive=0
> >
> > set-variable = innodb_buffer_pool_size=16M
> >
> > set-variable = innodb_additional_mem_pool_size=2M
> >
> > set-variable = innodb_file_io_threads=4
> >
> > set-variable = innodb_lock_wait_timeout=50
> >
> > I created the directories for C:/mysql/ibdata and C:/mysql/iblogs
> >
> > and changed its name to my.ini
> >
> > Using the phpMyAdmin utility under the Show MySQL System variables link
I
> > could see that the my.ini I had created under C:/mysql/my.ini was not
> being
> > read because the HAVE-BDB was not set to OFF and innodb_data_home_dir
was
> > not set so I moved it and renamed it to:
> >
> > C:/my.cnf
> >
> > ie right under the root directory. I restarted MySql from the control
> panel
> > services.
> >
> > Using phpMyAdmin utility under the Show MySQL System variables link, I
> could
> > now see that the my.cnf had been read and innodb variables were properly
> set
> > in particular HAVE-BDB was set to OFF and innodb_data_home_dir was set
to
> > c:\mysql\ibdata
> >
> > It was also evident that Innodb was working because 40Meg data file had
> been
> > created under C:/mysql/ibdata
> >
> > I had been able to create the database in MySQL without Innodb enabled.
> you
> > can check that Innodb tables have been created using phpMyAdmin to
enquire
> > upon the database weberp created. It will list the tables with the type
of
> > table. The default is MyISAM the first one in the list to be an Innodb
is
> > chartdetails - this was set to be a MyISAM type table, so I dropped the
> > database using phpMyAdmin and re-ran the web-erp-demo.sql script from a
> > command box knowing that Innodb was now operational:
> >
> > C:/mysql/bin/mysql.exe --user=weberp --password=weberp < "C:/Program
> > Files/Apache Group/Apache/htdocs/web-erp/web-erp-demo.sql"
> >
> > I got nasty messages about using the database weberp so I manually
created
> > the database weberp using phpMyAdmin then edited out the line in
> > web-erp-demo.sql that creates the database.
> >
> > Re-running it worked happily and away I went.
> >
> > With Frederico's problem I am guessing that the table StockMaster is a
> > MyISAM type table and that Innodb only became operational subsequent to
> > creating the db. You need to drop it and re-create the db now you have
> > innodb going.
> >
> > I hope this narrative helps,
> >
> > Regards
> >
> > Phil Daintree
> >
> >
> > ----- Original Message -----
> > From: Federico Vera
> > To: web...@li...
> > Sent: Sunday, March 09, 2003 9:22 AM
> > Subject: [Web-erp-users] installation problems
> >
> >
> > Hello
> >
> > I'm trying to setup the web-erp solution but I have some problems.
> >
> > I have a Apache server under W98with php extension and  mysql with
innodb
> > enable
> >
> > I start the server with mysqld-max on the shell, I verified the show
> > variables and innodb is enable
> >
> > This kind of messages that I put under this text appear on all the
pages,
> I
> > have been lookin around for a week, I really don't what more I have to
do,
> I
> > have global_setting on in the php config file too.
> >
> >
> >
> >
> > Notice: Undefined index: submit in
> > c:\inetpub\wwwroot\apache\web-erp\stocks.php on line 17
> >
> >
> > Notice: Undefined variable: StockID in
> > c:\inetpub\wwwroot\apache\web-erp\stocks.php on line 254
> >
> >
> >
> >
> > Could you give to me some clues.
> >
> > I hope that you can help me
> >
> > Regards
> >
> > Federico Vera
> >
>
>
>
>
> -------------------------------------------------------
> This SF.net email is sponsored by:Crypto Challenge is now open!
> Get cracking and register here for some mind boggling fun and
> the chance of winning an Apple iPod:
> http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0031en
> _______________________________________________
> Web-erp-users mailing list
> Web...@li...
> https://lists.sourceforge.net/lists/listinfo/web-erp-users
>

[Web-erp-users] now runing!, but with some problems

[Federico V. <fed...@ar...>]

Hi Phil


I have bee working the whole weekend in the apllication, I think that my
problem was to install php from the executable installation, I have
installed  php from the zip file now, and it's working now!

But somethings aren't working, and the problem is the following

When I enter in a link with with session ID and another variable, the sistem
give me the followinr error:

Warning: session_start() [function.session-start]: The session id contains
illegal characters, valid characters are only a-z, A-Z and 0-9 in
c:\inetpub\wwwroot\apache\web-erp\header.inc on line 6


I discover that the variable follow to the session ID and the browser cann't
detect the diference betwen the variable and the sesion ID.  But I don't
don't how to fix it.


.../web-erp/index.php?PHPSESSID=7978376d09d8be5a66a51d70ec1ce7a3Application=
stock


when I open a link with only the session ID all work fine

.../web-erp/index.php?PHPSESSID=7978376d09d8be5a66a51d70ec1ce7a3


Any suggestion?

Thanks a lot for the previus mail


Federico Vera








----- Original Message -----
From: "Daintree Family" <p.d...@xt...>
To: "Andreas Berner" <an...@ne...>; "Federico Vera"
<fed...@ar...>; "Web-ERP List" <>
Sent: Sunday, March 09, 2003 5:27 AM
Subject: Re: [Web-erp-users] installation problems


> Hi Andreas and Frederico,
>
> To get a handle on the windows installation, I installed it today on
Windows
> using Apache 1.3.27
> PHP 4.3.1 from the zip file
> MySql Max 3.23.54 on Windows XP.
>
> The traps I found were:
>
> I installed PHP as a module and editing the C:\Program Files\Apache
> Group\Apache\conf\httpd.conf file to
> LoadModule php4_module C:/Program
Files/php-4.3.1-Win32/sapi/php4apache.dll
> failed for me so I moved the file php4apache.dll and the file php4ts.dll
> (the file php4apache.dll needs this file) to C:\Windows (it could be
> C:\Winnt in NT or 2000) and edited httpd.conf to:
> LoadModule php4_module C:/Windows/php4apache.dll
>
> The next problem was that having edited the extensions section of the
> php-dist.ini file so that pdf extension was activated - by taking out the
> semi colon before the line:
>
> extension=php_pdf.dll
>
> When Apache started it couldn't find the necessary php_pdf.dll
> I moved the file from the php distribution files under extensions to
> C:\Windows\System32 (this directory could be C:\Winnt\System32 or
something
> else on other versions - I am using XP).
>
> Apache and PHP ran sweetly.
> I tested the Apache PHP and MySQL were running by installing phpMyAdmin
> 2.4.0
> I had modified the file C:/mysql/my-medium by uncommenting the line
>
> # Uncomment the following if you are NOT using BDB tables
> skip-bdb
>
> then I uncommented the lines for innodb:
>
> # Uncomment the following if you are using Innobase tables
>
> innodb_data_file_path = ibdata1:40M
>
> innodb_data_home_dir = c:\mysql\ibdata
>
> innodb_log_group_home_dir = c:\mysql\iblogs
>
> innodb_log_arch_dir = c:\mysql\iblogs
>
> set-variable = innodb_mirrored_log_groups=1
>
> set-variable = innodb_log_files_in_group=3
>
> set-variable = innodb_log_file_size=5M
>
> set-variable = innodb_log_buffer_size=8M
>
> innodb_flush_log_at_trx_commit=1
>
> innodb_log_archive=0
>
> set-variable = innodb_buffer_pool_size=16M
>
> set-variable = innodb_additional_mem_pool_size=2M
>
> set-variable = innodb_file_io_threads=4
>
> set-variable = innodb_lock_wait_timeout=50
>
> I created the directories for C:/mysql/ibdata and C:/mysql/iblogs
>
> and changed its name to my.ini
>
> Using the phpMyAdmin utility under the Show MySQL System variables link I
> could see that the my.ini I had created under C:/mysql/my.ini was not
being
> read because the HAVE-BDB was not set to OFF and innodb_data_home_dir was
> not set so I moved it and renamed it to:
>
> C:/my.cnf
>
> ie right under the root directory. I restarted MySql from the control
panel
> services.
>
> Using phpMyAdmin utility under the Show MySQL System variables link, I
could
> now see that the my.cnf had been read and innodb variables were properly
set
> in particular HAVE-BDB was set to OFF and innodb_data_home_dir was set to
> c:\mysql\ibdata
>
> It was also evident that Innodb was working because 40Meg data file had
been
> created under C:/mysql/ibdata
>
> I had been able to create the database in MySQL without Innodb enabled.
you
> can check that Innodb tables have been created using phpMyAdmin to enquire
> upon the database weberp created. It will list the tables with the type of
> table. The default is MyISAM the first one in the list to be an Innodb is
> chartdetails - this was set to be a MyISAM type table, so I dropped the
> database using phpMyAdmin and re-ran the web-erp-demo.sql script from a
> command box knowing that Innodb was now operational:
>
> C:/mysql/bin/mysql.exe --user=weberp --password=weberp < "C:/Program
> Files/Apache Group/Apache/htdocs/web-erp/web-erp-demo.sql"
>
> I got nasty messages about using the database weberp so I manually created
> the database weberp using phpMyAdmin then edited out the line in
> web-erp-demo.sql that creates the database.
>
> Re-running it worked happily and away I went.
>
> With Frederico's problem I am guessing that the table StockMaster is a
> MyISAM type table and that Innodb only became operational subsequent to
> creating the db. You need to drop it and re-create the db now you have
> innodb going.
>
> I hope this narrative helps,
>
> Regards
>
> Phil Daintree
>
>
> ----- Original Message -----
> From: Federico Vera
> To: web...@li...
> Sent: Sunday, March 09, 2003 9:22 AM
> Subject: [Web-erp-users] installation problems
>
>
> Hello
>
> I'm trying to setup the web-erp solution but I have some problems.
>
> I have a Apache server under W98with php extension and  mysql with innodb
> enable
>
> I start the server with mysqld-max on the shell, I verified the show
> variables and innodb is enable
>
> This kind of messages that I put under this text appear on all the pages,
I
> have been lookin around for a week, I really don't what more I have to do,
I
> have global_setting on in the php config file too.
>
>
>
>
> Notice: Undefined index: submit in
> c:\inetpub\wwwroot\apache\web-erp\stocks.php on line 17
>
>
> Notice: Undefined variable: StockID in
> c:\inetpub\wwwroot\apache\web-erp\stocks.php on line 254
>
>
>
>
> Could you give to me some clues.
>
> I hope that you can help me
>
> Regards
>
> Federico Vera
>

Re: [Web-erp-users] installation problems

[Daintree F. <p.d...@xt...>]

Hi Andreas and Frederico,

To get a handle on the windows installation, I installed it today on Windows
using Apache 1.3.27
PHP 4.3.1 from the zip file
MySql Max 3.23.54 on Windows XP.

The traps I found were:

I installed PHP as a module and editing the C:\Program Files\Apache
Group\Apache\conf\httpd.conf file to
LoadModule php4_module C:/Program Files/php-4.3.1-Win32/sapi/php4apache.dll
failed for me so I moved the file php4apache.dll and the file php4ts.dll
(the file php4apache.dll needs this file) to C:\Windows (it could be
C:\Winnt in NT or 2000) and edited httpd.conf to:
LoadModule php4_module C:/Windows/php4apache.dll

The next problem was that having edited the extensions section of the
php-dist.ini file so that pdf extension was activated - by taking out the
semi colon before the line:

extension=php_pdf.dll

When Apache started it couldn't find the necessary php_pdf.dll
I moved the file from the php distribution files under extensions to
C:\Windows\System32 (this directory could be C:\Winnt\System32 or something
else on other versions - I am using XP).

Apache and PHP ran sweetly.
I tested the Apache PHP and MySQL were running by installing phpMyAdmin
2.4.0
I had modified the file C:/mysql/my-medium by uncommenting the line

# Uncomment the following if you are NOT using BDB tables
skip-bdb

then I uncommented the lines for innodb:

# Uncomment the following if you are using Innobase tables

innodb_data_file_path = ibdata1:40M

innodb_data_home_dir = c:\mysql\ibdata

innodb_log_group_home_dir = c:\mysql\iblogs

innodb_log_arch_dir = c:\mysql\iblogs

set-variable = innodb_mirrored_log_groups=1

set-variable = innodb_log_files_in_group=3

set-variable = innodb_log_file_size=5M

set-variable = innodb_log_buffer_size=8M

innodb_flush_log_at_trx_commit=1

innodb_log_archive=0

set-variable = innodb_buffer_pool_size=16M

set-variable = innodb_additional_mem_pool_size=2M

set-variable = innodb_file_io_threads=4

set-variable = innodb_lock_wait_timeout=50

I created the directories for C:/mysql/ibdata and C:/mysql/iblogs

and changed its name to my.ini

Using the phpMyAdmin utility under the Show MySQL System variables link I
could see that the my.ini I had created under C:/mysql/my.ini was not being
read because the HAVE-BDB was not set to OFF and innodb_data_home_dir was
not set so I moved it and renamed it to:

C:/my.cnf

ie right under the root directory. I restarted MySql from the control panel
services.

Using phpMyAdmin utility under the Show MySQL System variables link, I could
now see that the my.cnf had been read and innodb variables were properly set
in particular HAVE-BDB was set to OFF and innodb_data_home_dir was set to
c:\mysql\ibdata

It was also evident that Innodb was working because 40Meg data file had been
created under C:/mysql/ibdata

I had been able to create the database in MySQL without Innodb enabled. you
can check that Innodb tables have been created using phpMyAdmin to enquire
upon the database weberp created. It will list the tables with the type of
table. The default is MyISAM the first one in the list to be an Innodb is
chartdetails - this was set to be a MyISAM type table, so I dropped the
database using phpMyAdmin and re-ran the web-erp-demo.sql script from a
command box knowing that Innodb was now operational:

C:/mysql/bin/mysql.exe --user=weberp --password=weberp < "C:/Program
Files/Apache Group/Apache/htdocs/web-erp/web-erp-demo.sql"

I got nasty messages about using the database weberp so I manually created
the database weberp using phpMyAdmin then edited out the line in
web-erp-demo.sql that creates the database.

Re-running it worked happily and away I went.

With Frederico's problem I am guessing that the table StockMaster is a
MyISAM type table and that Innodb only became operational subsequent to
creating the db. You need to drop it and re-create the db now you have
innodb going.

I hope this narrative helps,

Regards

Phil Daintree


----- Original Message -----
From: Federico Vera
To: web...@li...
Sent: Sunday, March 09, 2003 9:22 AM
Subject: [Web-erp-users] installation problems


Hello

I'm trying to setup the web-erp solution but I have some problems.

I have a Apache server under W98with php extension and  mysql with innodb
enable

I start the server with mysqld-max on the shell, I verified the show
variables and innodb is enable

This kind of messages that I put under this text appear on all the pages, I
have been lookin around for a week, I really don't what more I have to do, I
have global_setting on in the php config file too.




Notice: Undefined index: submit in
c:\inetpub\wwwroot\apache\web-erp\stocks.php on line 17


Notice: Undefined variable: StockID in
c:\inetpub\wwwroot\apache\web-erp\stocks.php on line 254




Could you give to me some clues.

I hope that you can help me

Regards

Federico Vera

Re: [Web-erp-users] installation problems

[Daintree F. <p.d...@xt...>]

Hi Andreas and Frederico,

To get a handle on the windows installation, I installed it today on Windows
using Apache 1.3.27
PHP 4.3.1 from the zip file
MySql Max 3.23.54 on Windows XP.

The traps I found were:

I installed PHP as a module and editing the C:\Program Files\Apache
Group\Apache\conf\httpd.conf file to
LoadModule php4_module C:/Program Files/php-4.3.1-Win32/sapi/php4apache.dll
failed for me so I moved the file php4apache.dll and the file php4ts.dll
(the file php4apache.dll needs this file) to C:\Windows (it could be
C:\Winnt in NT or 2000) and edited httpd.conf to:
LoadModule php4_module C:/Windows/php4apache.dll

The next problem was that having edited the extensions section of the
php-dist.ini file so that pdf extension was activated - by taking out the
semi colon before the line:

extension=php_pdf.dll

When Apache started it couldn't find the necessary php_pdf.dll
I moved the file from the php distribution files under extensions to
C:\Windows\System32 (this directory could be C:\Winnt\System32 or something
else on other versions - I am using XP).

Apache and PHP ran sweetly.
I tested the Apache PHP and MySQL were running by installing phpMyAdmin
2.4.0
I had modified the file C:/mysql/my-medium by uncommenting the line

# Uncomment the following if you are NOT using BDB tables
skip-bdb

then I uncommented the lines for innodb:

# Uncomment the following if you are using Innobase tables

innodb_data_file_path = ibdata1:40M

innodb_data_home_dir = c:\mysql\ibdata

innodb_log_group_home_dir = c:\mysql\iblogs

innodb_log_arch_dir = c:\mysql\iblogs

set-variable = innodb_mirrored_log_groups=1

set-variable = innodb_log_files_in_group=3

set-variable = innodb_log_file_size=5M

set-variable = innodb_log_buffer_size=8M

innodb_flush_log_at_trx_commit=1

innodb_log_archive=0

set-variable = innodb_buffer_pool_size=16M

set-variable = innodb_additional_mem_pool_size=2M

set-variable = innodb_file_io_threads=4

set-variable = innodb_lock_wait_timeout=50

I created the directories for C:/mysql/ibdata and C:/mysql/iblogs

and changed its name to my.ini

Using the phpMyAdmin utility under the Show MySQL System variables link I
could see that the my.ini I had created under C:/mysql/my.ini was not being
read because the HAVE-BDB was not set to OFF and innodb_data_home_dir was
not set so I moved it and renamed it to:

C:/my.cnf

ie right under the root directory. I restarted MySql from the control panel
services.

Using phpMyAdmin utility under the Show MySQL System variables link, I could
now see that the my.cnf had been read and innodb variables were properly set
in particular HAVE-BDB was set to OFF and innodb_data_home_dir was set to
c:\mysql\ibdata

It was also evident that Innodb was working because 40Meg data file had been
created under C:/mysql/ibdata

I had been able to create the database in MySQL without Innodb enabled. you
can check that Innodb tables have been created using phpMyAdmin to enquire
upon the database weberp created. It will list the tables with the type of
table. The default is MyISAM the first one in the list to be an Innodb is
chartdetails - this was set to be a MyISAM type table, so I dropped the
database using phpMyAdmin and re-ran the web-erp-demo.sql script from a
command box knowing that Innodb was now operational:

C:/mysql/bin/mysql.exe --user=weberp --password=weberp < "C:/Program
Files/Apache Group/Apache/htdocs/web-erp/web-erp-demo.sql"

I got nasty messages about using the database weberp so I manually created
the database weberp using phpMyAdmin then edited out the line in
web-erp-demo.sql that creates the database.

Re-running it worked happily and away I went.

With Frederico's problem I am guessing that the table StockMaster is a
MyISAM type table and that Innodb only became operational subsequent to
creating the db. You need to drop it and re-create the db now you have
innodb going.

I hope this narrative helps,

Regards

Phil Daintree


----- Original Message -----
From: Federico Vera
To: web...@li...
Sent: Sunday, March 09, 2003 9:22 AM
Subject: [Web-erp-users] installation problems


Hello

I'm trying to setup the web-erp solution but I have some problems.

I have a Apache server under W98with php extension and  mysql with innodb
enable

I start the server with mysqld-max on the shell, I verified the show
variables and innodb is enable

This kind of messages that I put under this text appear on all the pages, I
have been lookin around for a week, I really don't what more I have to do, I
have global_setting on in the php config file too.




Notice: Undefined index: submit in
c:\inetpub\wwwroot\apache\web-erp\stocks.php on line 17


Notice: Undefined variable: StockID in
c:\inetpub\wwwroot\apache\web-erp\stocks.php on line 254




Could you give to me some clues.

I hope that you can help me

Regards

Federico Vera

[Web-erp-users] installation problems

[Federico V. <fed...@ar...>]

Hello

I'm trying to setup the web-erp solution but I have some problems.

I have a Apache server under W98with php extension and  mysql with =
innodb enable

I start the server with mysqld-max on the shell, I verified the show =
variables and innodb is enable

This kind of messages that I put under this text appear on all the =
pages, I have been lookin around for a week, I really don't what more I =
have to do, I have global_setting on in the php config file too.


-------------------------------------------------------------------------=
-------

Notice: Undefined index: submit in =
c:\inetpub\wwwroot\apache\web-erp\stocks.php on line 17


  Notice: Undefined variable: StockID in =
c:\inetpub\wwwroot\apache\web-erp\stocks.php on line 254
  =20

-------------------------------------------------------------------------=
-------

Could you give to me some clues.

I hope that you can help me

Regards

Federico Vera

[Web-erp-users] Test

[G L. <ga...@co...>]

Test!

[Web-erp-users] Project start

[Phil D. <ph...@du...>]

Welcome to the WEB-ERP project.