From: Federico V. <fed...@ar...> - 2003-03-11 14:18:34
|
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 > |