Additions:
Sales orders also have their own systype and the next sales order can be entered in the same way as above.
Deletions:
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.
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:
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:
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
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:
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:
--
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)
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:
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
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:
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
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
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:
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:
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:
Revision [491]
Edited on 2007-10-11 13:58:23 by PhilDaintree [Special instructions for running on 1and1 hosted server]Deletions:
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:
{{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');
-> 'yourMySQLusername'@'some_host' = OLD_PASSWORD('newpwd');
Deletions:
%%(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');