Search options

Hi,

I try to install Asset Register but I found the problem. The sql error show bellow:
DATABASE ERROR : could not get all asset types
error code : 1146
error message : Table 'ptsk.0_asset_types' doesn't exist
sql that failed was : SELECT * FROM 0_asset_types WHERE !inactive

How I fix this error?

Thanks

Thanks Joe,

When I click Asset Types Entries show error message as follow "DATABASE ERROR : could not get all asset types
error code : 1146
error message : Table 'ptsk.0_asset_types' doesn't exist
sql that failed was : SELECT * FROM 0_asset_types WHERE !inactive"

and also when I click Assets Entries show error message as follow "DATABASE ERROR : could not get all assets
error code : 1146
error message : Table 'ptsk.0_asset_types' doesn't exist
sql that failed was : SELECT *, 0_get_asset_value(a.asset_id, YEAR(now())) as current_value FROM 0_asset_types at INNER JOIN 0_assets a ON at.asset_type_id = a.asset_type_id WHERE !a.inactive"

My PHP.ini files settings like this:

allow_call_time_pass_reference
;   Default Value: On
;   Development Value: Off
;   Production Value: Off

; display_errors
;   Default Value: On
;   Development Value: On
;   Production Value: Off

; display_startup_errors
;   Default Value: Off
;   Development Value: On
;   Production Value: Off

; error_reporting
;   Default Value: E_ALL & ~E_NOTICE
;   Development Value: E_ALL | E_STRICT
;   Production Value: E_ALL & ~E_DEPRECATED

; html_errors
;   Default Value: On
;   Development Value: On
;   Production value: Off

; log_errors
;   Default Value: Off
;   Development Value: On
;   Production Value: On

; magic_quotes_gpc
;   Default Value: On
;   Development Value: Off
;   Production Value: Off

; max_input_time
;   Default Value: -1 (Unlimited)
;   Development Value: 60 (60 seconds)
;   Production Value: 60 (60 seconds)

; output_buffering
;   Default Value: Off
;   Development Value: 4096
;   Production Value: 4096

; register_argc_argv
;   Default Value: On
;   Development Value: Off
;   Production Value: Off

; register_long_arrays
;   Default Value: On
;   Development Value: Off
;   Production Value: Off

; request_order
;   Default Value: None
;   Development Value:

Joe,

Thanks before, But I am still can't solve my problem. Bellow my extension in php.

;extension=php_bz2.dll
;extension=php_curl.dll
;extension=php_fileinfo.dll
extension=php_gd2.dll
extension=php_gettext.dll
;extension=php_gmp.dll
;extension=php_intl.dll
extension=php_imap.dll
;extension=php_interbase.dll
;extension=php_ldap.dll
extension=php_mbstring.dll
;extension=php_exif.dll      ; Must be after mbstring as it depends on it
extension=php_mysql.dll
extension=php_mysqli.dll
;extension=php_oci8.dll      ; Use with Oracle 10gR2 Instant Client
;extension=php_oci8_11g.dll  ; Use with Oracle 11g Instant Client
extension=php_openssl.dll
;extension=php_pdo_firebird.dll
;extension=php_pdo_mssql.dll
extension=php_pdo_mysql.dll
;extension=php_pdo_oci.dll
;extension=php_pdo_odbc.dll
;extension=php_pdo_pgsql.dll
;extension=php_pdo_sqlite.dll
extension=php_pgsql.dll
;extension=php_phar.dll
extension=php_pspell.dll
;extension=php_shmop.dll
;extension=php_soap.dll
;extension=php_sockets.dll
extension=php_sqlite.dll
;extension=php_sqlite3.dll
;extension=php_sybase_ct.dll
;extension=php_tidy.dll
extension=php_xmlrpc.dll
;extension=php_xsl.dll
extension=php_zip.dll

Joe,

When I spend money for down payment to supplier I will record journal as follow:

Dr   Down Payment - Supplier (Current asset)
                  Cr     Bank / Cash
(To Record Down Payment to supplier)

And then when I receive Supplier Invoice I will record journal as follow:

Dr, Goods Receive Clearing Account
              Cr   Account Payable (supplier)
              Cr   Down Payment - Supplier
( To Record Invoice receive and allocate down payment)

Joe,

I don't understand what should I do to solve my problem?

Thanks,

Hi Lena,

Could you please send me php.ini that has been updated to activate instal/update to my email? please send to andriana.cdc@gmail.com.

Many Thanks for your help