In setup, display setup, I have it set for 2 decimal places for quantities, but every time I try and enter a quantity with a decimal point it either rounds up or down to a whole number. Is there a way to fix this?
1 01/21/2015 10:42:42 pm
Topic: Decimal Point in Item Quantity Field (4 replies, posted in Accounts Receivable)
2 06/19/2014 07:54:30 pm
Re: Orange Triangle (23 replies, posted in Items and Inventory)
I made the like look like
function db_fetch_assoc ($result)
{
if (is_bool($result) === true && $result === false) return false;
return mysql_fetch_assoc($result);
}
function db_fetch ($result)and it made no difference. Still getting the orange triangle when trying to edit/add items.
3 05/08/2014 06:50:38 am
Re: Orange Triangle (23 replies, posted in Items and Inventory)
Would it help if I gave you teamviewer access to my server?
4 05/05/2014 04:08:05 pm
Re: Orange Triangle (23 replies, posted in Items and Inventory)
I still need to figure out why I'm getting the triangle on the old installation so that I can add/edit items and run a backup. I have almost a year's worth of data that I can't loose.
5 05/05/2014 04:06:58 pm
Re: Orange Triangle (23 replies, posted in Items and Inventory)
The IIS user has write permission to the file.
6 05/05/2014 12:23:47 am
Re: Orange Triangle (23 replies, posted in Items and Inventory)
On a brand new installation, I get the red/orange triangle when trying to add/edit items, and most other operations.
Here is all that is in the error log and the faillog file does exist.
[03-May-2014 23:43:48 Europe/Berlin] 0::session.inc:372: include_once(./tmp/faillog.php): failed to open stream: No such file or directory
[03-May-2014 23:43:48 Europe/Berlin] 0::session.inc:372: include_once(): Failed opening './tmp/faillog.php' for inclusion (include_path='.;C:\php\pear')
[05-May-2014 02:12:48 Europe/Berlin] 0::session.inc:372: include_once(./tmp/faillog.php): failed to open stream: No such file or directory
[05-May-2014 02:12:48 Europe/Berlin] 0::session.inc:372: include_once(): Failed opening './tmp/faillog.php' for inclusion (include_path='.;C:\php\pear')
[05-May-2014 02:12:59 Europe/Berlin] 0::session.inc:372: include_once(./tmp/faillog.php): failed to open stream: No such file or directory
[05-May-2014 02:12:59 Europe/Berlin] 0::session.inc:372: include_once(): Failed opening './tmp/faillog.php' for inclusion (include_path='.;C:\php\pear')
7 05/04/2014 01:52:06 am
Re: Install Errors (17 replies, posted in Installation)
Tried the install a few more times, it worked on the 3rd try. No clue why.
8 05/03/2014 09:43:57 pm
Re: Install Errors (17 replies, posted in Installation)
It creates all the tables in the database, but ends with a blank white screen in IE.
9 05/03/2014 08:39:55 pm
Re: Orange Triangle (23 replies, posted in Items and Inventory)
This is my entire error log:
[30-Apr-2014 13:37:19 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[30-Apr-2014 13:37:22 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[30-Apr-2014 13:37:22 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[30-Apr-2014 18:58:07 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[30-Apr-2014 18:59:01 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[30-Apr-2014 18:59:01 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[30-Apr-2014 20:18:48 America/New_York] 1::logout.php:47: session_destroy(): Session object destruction failed
[30-Apr-2014 20:23:58 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[30-Apr-2014 20:24:04 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[30-Apr-2014 20:24:04 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[30-Apr-2014 20:26:08 America/New_York] 1::logout.php:47: session_destroy(): Session object destruction failed
[30-Apr-2014 20:46:55 America/New_York] 1:pspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[01-May-2014 13:35:29 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[01-May-2014 13:35:33 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[01-May-2014 13:35:33 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[01-May-2014 18:31:17 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[01-May-2014 18:31:21 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[01-May-2014 18:31:21 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[01-May-2014 18:53:02 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[01-May-2014 18:53:05 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[01-May-2014 18:53:05 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[01-May-2014 18:53:44 America/New_York] 1::logout.php:47: session_destroy(): Session object destruction failed
[01-May-2014 19:05:11 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[01-May-2014 19:05:15 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[01-May-2014 19:05:15 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[01-May-2014 19:05:21 America/New_York] 1::logout.php:47: session_destroy(): Session object destruction failed
[01-May-2014 19:06:28 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[01-May-2014 19:06:32 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[01-May-2014 19:06:32 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
10 05/02/2014 07:58:50 pm
Re: Install Errors (17 replies, posted in Installation)
Now when I install, it finishes with a blank blue screen.
11 05/02/2014 05:47:50 pm
Re: Orange Triangle (23 replies, posted in Items and Inventory)
I also am unable to run a backup, I get the orange triangle for that as well.
12 05/02/2014 05:46:28 pm
Re: Orange Triangle (23 replies, posted in Items and Inventory)
Yes, I am using v. 2.3.20!
13 05/01/2014 10:55:26 pm
Re: Orange Triangle (23 replies, posted in Items and Inventory)
Downgraded to MySQL 5.5 and still received orange triangles when trying to update items or add new items. This is a business critical function!
14 05/01/2014 05:39:38 pm
Re: Orange Triangle (23 replies, posted in Items and Inventory)
This is the result from the query: MySQL returned an empty result set (i.e. zero rows). (Query took 0.0003 sec)
And when I retried my operation I got the same result.
15 05/01/2014 05:36:23 pm
Re: Install Errors (17 replies, posted in Installation)
after using the two SQL Queries I get:
Number of rows: 2550100250500
+ Options
@@sql_mode
STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_...
16 05/01/2014 12:26:18 am
Re: Install Errors (17 replies, posted in Installation)
I edited the en_us-demo.sql and en_us-new.sql and now I'm getting this result:
Debug mode database warning:
error code : 1067
error message : Invalid default value for 'last_reconciled_date'
sql that failed was : CREATE TABLE `0_bank_accounts` ( `account_code` varchar(15) NOT NULL default '', `account_type` smallint(6) NOT NULL default '0', `bank_account_name` varchar(60) NOT NULL default '', `bank_account_number` varchar(100) NOT NULL default '', `bank_name` varchar(60) NOT NULL default '', `bank_address` tinytext, `bank_curr_code` char(3) NOT NULL default '', `dflt_curr_act` tinyint(1) NOT NULL default '0', `id` smallint(6) NOT NULL auto_increment, `last_reconciled_date` timestamp NOT NULL default '1001-01-01 01:01:01', `ending_reconcile_balance` double NOT NULL default '0', `inactive` tinyint(1) NOT NULL default '0', PRIMARY KEY (`id`), KEY `bank_account_name` (`bank_account_name`), KEY `bank_account_number` (`bank_account_number`), KEY `account_code` (`account_code`) ) ENGINE=MyISAM AUTO_INCREMENT=3
Debug mode database warning:
error code : 1146
error message : Table 'acct.0_bank_accounts' doesn't exist
sql that failed was : INSERT INTO `0_bank_accounts` VALUES ('11000', '0', 'Current account', 'N/A', 'N/A', NULL, 'USD', '0', '1', '1001-01-01 01:01:01', '0', '0')
Debug mode database warning:
error code : 1146
error message : Table 'acct.0_bank_accounts' doesn't exist
sql that failed was : INSERT INTO `0_bank_accounts` VALUES ('10200', '0', 'Petty Cash account', 'N/A', 'N/A', NULL, 'USD', '0', '2', '1001-01-01 01:01:01', '0', '0')
SQL script execution failed in line 79:
17 04/30/2014 11:58:25 pm
Re: Install Errors (17 replies, posted in Installation)
Where do I find the account.sql file?
18 04/30/2014 05:44:01 pm
Re: Orange Triangle (23 replies, posted in Items and Inventory)
Error log shows:
[30-Apr-2014 13:37:19 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[30-Apr-2014 13:37:22 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[30-Apr-2014 13:37:22 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
19 04/30/2014 05:39:37 pm
Topic: Install Errors (17 replies, posted in Installation)
Doing a new install, I'm getting these errors:
Debug mode database warning:
error code : 1067
error message : Invalid default value for 'tran_date'
sql that failed was : CREATE TABLE IF NOT EXISTS `0_attachments` ( `id` int(11) unsigned NOT NULL auto_increment, `description` varchar(60) NOT NULL default '', `type_no` int(11) NOT NULL default '0', `trans_no` int(11) NOT NULL default '0', `unique_name` varchar(60) NOT NULL default '', `tran_date` date NOT NULL default '0000-00-00', `filename` varchar(60) NOT NULL default '', `filesize` int(11) NOT NULL default '0', `filetype` varchar(60) NOT NULL default '', PRIMARY KEY (`id`), KEY `type_no` (`type_no`,`trans_no`) ) ENGINE=MyISAM AUTO_INCREMENT=1
Debug mode database warning:
error code : 1067
error message : Invalid default value for 'gl_date'
sql that failed was : CREATE TABLE IF NOT EXISTS `0_audit_trail` ( `id` int(11) NOT NULL auto_increment, `type` smallint(6) unsigned NOT NULL default '0', `trans_no` int(11) unsigned NOT NULL default '0', `user` smallint(6) unsigned NOT NULL default '0', `stamp` timestamp NOT NULL, `description` varchar(60) default NULL, `fiscal_year` int(11) NOT NULL, `gl_date` date NOT NULL default '0000-00-00', `gl_seq` int(11) unsigned default NULL, PRIMARY KEY (`id`), KEY `Seq` (`fiscal_year`,`gl_date`,`gl_seq`), KEY `Type_and_Number` (`type`,`trans_no`) ) ENGINE=InnoDB AUTO_INCREMENT=1
and so on for every table including a default date value of '0000-00-00'......
SQL script execution failed in line 42:
20 04/29/2014 11:24:21 pm
Topic: Maximum execution time of 180 seconds exceeded (0 replies, posted in Installation)
Every time I try and install FA I get this error, Maximum execution time of 180 seconds exceeded in C:\inetpub\wwwroot\acct\includes\db\connect_db.inc on line 51.
My error.log:
[30-Apr-2014 00:35:40 Europe/Berlin] PHP Fatal error: Maximum execution time of 180 seconds exceeded in C:\inetpub\wwwroot\acct\includes\db\connect_db.inc on line 51
[30-Apr-2014 00:35:40 Europe/Berlin] PHP Fatal error: Maximum execution time of 180 seconds exceeded in C:\inetpub\wwwroot\acct\includes\errors.inc on line 155
[30-Apr-2014 00:58:56 Europe/Berlin] PHP Fatal error: Maximum execution time of 180 seconds exceeded in C:\inetpub\wwwroot\acct\includes\db\connect_db.inc on line 51
Other scripts are able to access and use MySQL with no problem at all.
I have a Win 2012 R2 server, IIS, MySQL 5.6.14
21 04/29/2014 08:54:26 pm
Topic: Orange Triangle (23 replies, posted in Items and Inventory)
Every time I try and enter a new item, I just get an orange triangle come up after the working arrows and the new item is not created. I used to be able to add items with no problem, anyone have any idea why this has started happening?
22 04/04/2014 05:27:48 pm
Re: Error working with Sales Quotation (7 replies, posted in Accounts Receivable)
I can reproduce this error at will by going to Sales Quotation then hitting Cancel, but if I just hit back it exits out with no problem.
23 04/04/2014 05:23:26 pm
Re: Error Adding New Item or Editing Existing Item (7 replies, posted in Items and Inventory)
PHP = 5.3.27
MySQL = 5.6.14 Community
OS = Windows Server 2012 R2 x64
It has all worked fine in the past, this just started happening and I can't think of anything that has changed.
24 04/03/2014 05:27:24 pm
Topic: Error working with Sales Quotation (7 replies, posted in Accounts Receivable)
I tried to Cancel/Void a Sales Quotation and received a big red box with the following error:
DATABASE ERROR : Cannot add audit info
error code : 1366
error message : Incorrect integer value: '' for column 'trans_no' at row 1
sql that failed was : INSERT INTO 9_audit_trail (type, trans_no, user, fiscal_year, gl_date, description, gl_seq) VALUES('32', '',2,7,'2014-04-03','Deleted.', 0)
Any help would be appreciated!!
Version 2.3.19
25 04/03/2014 05:01:14 pm
Re: Error Adding New Item or Editing Existing Item (7 replies, posted in Items and Inventory)
After completing that fix, I still get the red triangle but no longer get error messages in the log. When I try and change an existing item, I get the red triangle and this in the error log:
[03-Apr-2014 12:55:27 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[03-Apr-2014 12:55:27 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[03-Apr-2014 12:56:02 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given
[03-Apr-2014 12:56:02 America/New_York] 1:crspencer:connect_db.inc:89: mysql_fetch_array() expects parameter 1 to be resource, boolean given