Revision [1739]

Last edited on 2009-12-29 22:45:36 by PhilDaintree
Additions:
Sales orders also have their own systype and the next sales order can be entered in the same way as above.
Deletions:
====Q8: How about sales order numbers? - I wish these to start from x how can I do this?====
The sales order number is an auto-incrment field in salesorders table. To make it start at a particular point you need to enter a specific number into that field - using SQL similar to this to make the next order 10,000.
INSERT INTO SalesOrders (OrderNo) VALUES (9999);

Then run

DELETE FROM SalesOrders WHERE OrderNo=9999;
to remove this bogus order.


Revision [1297]

Edited on 2008-09-20 18:58:54 by PhilDaintree
Additions:
In order to make modifications to the operation of PHP on a 1and1 hosted account and hostgator (and potentially others), a php.ini file is required. These hosts do not allow a .htaccess file to modify the php configuration - a 500 error is returned - in particular we wish to disable magic quotes and register globals.
The solution is to delete the entries in the existing .htaccess file, and place into a new file titled php.ini, the following two lines:
Deletions:
In order to make modifications to the operation of PHP on a 1and1 hosted account, a php.ini file is required.
Delete the entries in the existing .htaccess file, and place into a new file titled php.ini, the following two lines:


Revision [1296]

Edited on 2008-09-19 12:44:44 by GregorJennings [Special instructions for running on 1and1 hosted server]
Additions:
====Q22: The .htaccess file causes an error when hosting with 1and1 ====
In order to make modifications to the operation of PHP on a 1and1 hosted account, a php.ini file is required.
Delete the entries in the existing .htaccess file, and place into a new file titled php.ini, the following two lines:
magic_quotes_gpc = off
register_globals = off
Upload this php.ini file to the root directory.
Additionally, you can force 1and1 to interpret the .php files using PHP5 by entering the following into the .htaccess file:
AddType x-mapp-php5 .php


Revision [1187]

Edited on 2008-03-02 00:57:40 by TimSchofield [Special instructions for running on 1and1 hosted server]
Additions:
====Q21: I want to install using a different company name without first installing company weberp====
Deletions:
====Q21: I want to install using a different company name than weberp====


Revision [1181]

Edited on 2008-02-29 13:15:42 by PhilDaintree [Special instructions for running on 1and1 hosted server]
Additions:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near ""-----""
Deletions:
You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '---------------------------------------------------------
--


Revision [1180]

Edited on 2008-02-29 13:14:38 by PhilDaintree [Special instructions for running on 1and1 hosted server]
Additions:
The web-server may need to be restarted - a CGI installation will not need to be restarted. This setting is now enabled by default using a configuration directive in config.php that turns notices off. This error is unlikely to resurface in versions since 2.8
In fact this is now the default error_reporting setting used by webERP - this error reporting mode is activated when PHP parses the file config.php which is included in every script (by includes/session.inc)
Deletions:
The web-server may need to be restarted - a CGI installation will not need to be restarted. This setting is now enabled by default using a configuration directive in config.php that [[[[[[[[[[[[]]]]]]]]]]]][[[[[[[[[[[[turns notices off. This error is unlikely to resurface in versions since 2.8
In fact this is now the default error_reporting setting used by webERP - this is activate when PHP parses the file config.php


Revision [1179]

Edited on 2008-02-29 13:12:54 by PhilDaintree [Special instructions for running on 1and1 hosted server]
Additions:
You could then use the script Z_MakeNewCompany.php - just type this script name over index.php in the URL location bar of your browser. This script creates the new directories described above and the new database. If the config.php script has the option
directory and all directories under it from the web-server (you can also drop the weberp database - as a new one is created by Z_MakeNewCompany.php) - the new company will have its own
Deletions:
You could then use the script Z_MakeNewCompany.php - just type this script name over index.php in the URL location bar of your browser. This script creates the new directories described above and the new database. If the config.php script the option
directory and all directories under it from the web-server - the new company will have its own


Revision [1178]

Edited on 2008-02-29 13:10:48 by PhilDaintree [Special instructions for running on 1and1 hosted server]
Additions:
**Another option if you have webERP installed using the demo database**
You could then use the script Z_MakeNewCompany.php - just type this script name over index.php in the URL location bar of your browser. This script creates the new directories described above and the new database. If the config.php script the option
As it is by default then you will be able to choose between logging into the weberp database or the new company database you created when running the Z_MakeNewCompany.php script above. If you only want to run the new company then you can delete the
webERP/companies/weberp
directory and all directories under it from the web-server - the new company will have its own
webERP/companies/YourNewCompany
directory and sub-directories created when running the Z_MakeNewCompany.php


Revision [1177]

Edited on 2008-02-29 11:06:12 by TimSchofield [Special instructions for running on 1and1 hosted server]
Additions:
====Q21: I want to install using a different company name than weberp====
The steps you need to take are :
1 log into mysql, as described in the install doc.
2 Create a database named whatever you want, eg CREATE DATABASE mycompany;
3 Change to using that database eg use mycompany;
4 run the sql script to generate tables. eg weberp-new.sql
5 rename the companies/weberp folder to be companies/mycompany or create
a copy of the old one with this name.
6 change $defaultcompany in config.php to be mycompany.
7 login as demo.
Its important that the database name and the company name, and the folder
in companies/ are all the same


Revision [628]

Edited on 2007-10-16 21:10:57 by PhilDaintree [Special instructions for running on 1and1 hosted server]
Additions:
FaqCatgegory
Deletions:
FAQCatgegory


Revision [627]

Edited on 2007-10-16 21:09:54 by PhilDaintree [Special instructions for running on 1and1 hosted server]
Additions:
FAQCatgegory


Revision [595]

Edited on 2007-10-13 18:38:35 by PhilDaintree [Special instructions for running on 1and1 hosted server]
Additions:
====Q2: I can't use [[http://www.phpmyadmin.net PHP MyAdmin]] to create the database I get the message:====
Deletions:
====Q2: I can't use [[http://www.phpmyadmin.org PHP MyAdmin]] to create the database I get the message:====


Revision [594]

Edited on 2007-10-13 18:37:53 by PhilDaintree [Special instructions for running on 1and1 hosted server]
Additions:
====Q2: I can't use [[http://www.phpmyadmin.org PHP MyAdmin]] to create the database I get the message:====
Deletions:
====Q2: I can't use PHPMyAdmin to create the database I get the message:====


Revision [491]

Edited on 2007-10-11 13:58:23 by PhilDaintree [Special instructions for running on 1and1 hosted server]
Deletions:
deloudaror


Revision [469]

Edited on 2007-10-11 06:33:37 by ElactRocac [Special instructions for running on 1and1 hosted server]
Additions:
deloudaror


Revision [334]

Edited on 2007-10-08 00:38:25 by PhilDaintree [Special instructions for running on 1and1 hosted server]
Additions:
=====FAQ - Installation=====
Deletions:
===FAQ - Installation===
{{TOC}}


Revision [273]

Edited on 2007-10-05 11:30:00 by PhilDaintree [Special instructions for running on 1and1 hosted server]
Additions:
The web-server may need to be restarted - a CGI installation will not need to be restarted. This setting is now enabled by default using a configuration directive in config.php that [[[[[[[[[[[[]]]]]]]]]]]][[[[[[[[[[[[turns notices off. This error is unlikely to resurface in versions since 2.8
-> 'yourMySQLusername'@'some_host' = OLD_PASSWORD('newpwd');
Deletions:
trouricalcna
%%(noautolinks)
The web-server may need to be restarted - a CGI installation will not need to be restarted. This setting is now enabled by default using a configuratio[[[[[[[[[[[[]]]]]]]]]]]][[[[[[[[[[[[n directive in config.php that turns notices off. This error is unlikely to resurface in versions since 2.8
-> 'yourMySQLusername'@'some_host' = OLD_PASSWORD('newpwd');


Revision [158]

The oldest known version of this page was created on 2007-09-27 19:18:39 by PhilDaintree [Special instructions for running on 1and1 hosted server]
Valid XHTML :: Valid CSS: :: Powered by WikkaWikiGet webERP Accounting & Business Management at SourceForge.net. Fast, secure and Free Open Source software downloads