Search options (Page 2 of 47)

With this code

 srand ((double) microtime( )*1000000); 

we are getting error like this in sometime Implicit conversion from float 517375.00000000006. due to the double in it. so lets convert this into int.

 srand ((int) microtime( )*1000000); 

make this change on items.php to take effect.

Both are possible with FA.  It's upto you, but it's good to have small financial for better year closing and balance forwarding process.

I am feeling this change will get it worked.

@joe consider checking it on php 8.1 and 8.2 with existing code and also my new function of db_query

function db_query($sql, $err_msg=null)
{
    global $db, $SysPrefs, $sql_queries, $Ajax,    $db_connections, $db_last_inserted_id;

    // set current db prefix
    $comp = isset($_SESSION["wa_current_user"]->cur_con) ? $_SESSION["wa_current_user"]->cur_con : 0;
    $cur_prefix = @$db_connections[$comp]['tbpref'];
    $sql = str_replace(TB_PREF, $cur_prefix, $sql);

    if ($SysPrefs->show_sql)
    {
        $Ajax->activate('footer_debug');
        $sql_queries .= "<pre>$sql</pre>\n<hr>";
    }

    db_profile(); // mysql profiling

    $retry = MAX_DEADLOCK_RETRY;
 try { //kvvaradha added try and catch 
    do {
        $result = mysqli_query($db, $sql);
        if (mysqli_errno($db) == 1213)    { // deadlock detected
            sleep(1); $retry--;
        } else {
            throw new mysqli_sql_exception("Deadlock detected: $sql", 1062); //kvvaradha added to through the error in an exception and handle it on catch 
            $retry = 0;
        }
    } while ($retry);

    db_profile($sql);

    if($SysPrefs->sql_trail) {
        $db_last_inserted_id = mysqli_insert_id($db);    // preserve in case trail insert is done
        if ($SysPrefs->select_trail || (strstr($sql, 'SELECT') === false)) {
            mysqli_query($db, "INSERT INTO ".$cur_prefix."sql_trail
                (`sql`, `result`, `msg`)
                VALUES(".db_escape($sql).",".($result ? 1 : 0).",
                ".db_escape($err_msg).")");
        }
    }
 } catch (mysqli_sql_exception $e) {. //kvvaradha added catch 
        $error_msg = $e->getMessage();
        $error_code = $e->getCode();
    if ($err_msg != null || $SysPrefs->go_debug) {
        $exit = $err_msg != null;
        if (function_exists('xdebug_call_file'))
            $err_msg = '<br>At file '.xdebug_call_file().':'.xdebug_call_line().':<br>'.$err_msg;
        check_db_error($err_msg, $sql, $exit);
    }
 throw $e; // rethrow the exception after handling
    }
    return $result;
}

I added error handling with try catch inorder to get the detailed query during the time of mysqli_sql_exception.

I have made a video for the demonstration.  You can get the overview of the app and fuctionalities from it.

Kvcodes POS Demonstration video

Issue is not with octet stream 

Open your FA/includes/session.inc

Find the top constant defined SECURE_ONLY as true. It will work . Suppose if it's true.

Your ssl May not work. Ask your hosting provider to fix ssl.

If that's not a problem. Try open the site with https. It will solve the problem. If still not the site has https.  Take screenshot and share it here.

Don't panic. It might be php updated or you might installed any extension or theme which crashed your FA.   Enable debugging mode

And open the same URL. You might see the errors. Copy the error information here.  And we will help you out with reason

ST_CHEQUE is  not a core constant. Looks like it's a customized version.  And you have not mention the file and function to understand it.

Time sheet was disabled by mistake in our CRM, I just enabled it again. 

Estimating Task to view the timesheet tab and there you can input the timesheet as well.

There is separate inquiry for timesheet Time Sheet From Kvcodes CRM .

And this will be billed when the task marked as completed.  and ofcourse the project progress should be 100 percent and status changed to completed. than only you can invoice this project and its associated tasks with its timesheet

If you need our immediate replies, Kindly chat from our Demo page itself, we will help you on the same time.

Hi welcome to FA  community.

If you have some knowledge of these. You can do well.  And we have some active developers to support you as well for some clarifications.