It's much more fun, when you can discuss your problems with others...
You are not logged in. Please login or register.
FrontAccounting forum → Items and Inventory → Orange Triangle
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?
Please look into the error.log file in the /tmp folder. It might give you some more information.
Joe
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
Hello.
We are looking into this.
Joe
Please usep hpMyAdmin and select the database. In the SQL form:
SET sql_mode = '';
Then try your operation and see if it helps. Please report back.
/Joe
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.
I guess you are using a MySql release greater than 5.6. These versions have been more restrict in handling SQL.
Please try to downgrade your MySql to 5.5 or less.
We are investigating this in the meantime.
Joe
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!
Are you using the latest version of FA, 2.3.20 ?
Joe
Yes, I am using v. 2.3.20!
I also am unable to run a backup, I get the orange triangle for that as well.
Please try to help a little more. Look into your /tmp/error.log.
Also look into the mysql server log.
There must be something else wrong in your setup.
Joe
Hello again.
I have now created a new test Environment
MySql 5.6.17
PHP 5.5.11
Server Type Microsoft-IIS/8.5
Server System WINNT
Frontaccounting 2.3.20
I have tested around and I found no problems at all. Especially your issues Went without problems.
/Joe
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
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')
It seems to be a permission error. Please rectify this and it should work.
Joe
The IIS user has write permission to the file.
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.
I am sorry that I cannot help you, but you can export the data by using phpMyAdmin.
Joe
Would it help if I gave you teamviewer access to my server?
No, not really. I cannot change the behaviour of the server.
Joe
Hi, I have also started getting this vicious orange triangle.
I have followed both steps.
1. Downgraded to SQL 5.5
2. Set mysql mode to ''
3. Check permissions
Also In my error log in /tmp I am not getting any entry for current date
Please advice how to proceed
In the file includes/db/connect_db.inc inside the said function db_fetch_assoc ($result) precede the line:
return mysql_fetch_assoc($result);with
if (is_bool($result) === true && $result === false) return false;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.
FrontAccounting forum → Items and Inventory → Orange Triangle
Powered by PunBB, supported by Informer Technologies, Inc.
Currently installed 4 official extensions. Copyright © 2003–2009 PunBB.