Forum

Ask, reply and learn. Join the community of Akaunting.

New Discussion

Update not working? Is there a manual way?

Erez Zabusky   ( User )

Commented 6 years ago

Hi All,


Your help is greatly appreciated. Update button does not work. (DEBUG below) Is there a way of manually updating and copying the database across? does anyonw have a fix or detailed proceedure?


..Orange button on update screen shows "Update Akaunting to 0.0.0 version" I am currently on 1.27 would like to go to 1.29.


 


Thanks


 


 


 


format


html

content_type


text/html; charset=UTF-8

status_text


OK

status_code200request_query


[]

request_request


[]

request_headers


array:9 [
"host" => array:1 [
0 => "10.135.89.11"
]
"connection" => array:1 [
0 => "keep-alive"
]
"upgrade-insecure-requests" => array:1 [
0 => "1"
]
"user-agent" => array:1 [
0 => "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36"
]
"accept" => array:1 [
0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8"
]
"referer" => array:1 [
0 => "http://10.135.89.11/index.php/install/updates"
]
"accept-encoding" => array:1 [
0 => "gzip, deflate"
]
"accept-language" => array:1 [
0 => "en-US,en;q=0.9"
]
"cookie" => array:1 [
0 => "XSRF-TOKEN=eyJpdiI6IkV0NlFcL3owcms4YndQNFlQQTE5dXNBPT0iLCJ2YWx1ZSI6IldpXC85dGtcL0NFdzhGZzQyNjM0N2c3NTNSbTRXRVQraXg4WmVCWmZPRFlic2lyR2ZPNmhwNGV5MDgzNFVOb2x4ajUwMkkxaHpPd254ZzBBdVVvc1huSGc9PSIsIm1hYyI6ImI2NWNlNjFjMWZlYjM5OTQzYjkxOWE3NzM2OTFjMmRhYjM1MjU1YzdjNGM0MmYxNTU3ZDMyODlhODY1MGQ2NWYifQ%3D%3D; laravel_session=eyJpdiI6InczQXFrWXpxTlprQ0RSZTZkRFZWZFE9PSIsInZhbHVlIjoiVGsyVDZPUTBuWHVpaHJEUVd4VmI0ek0rZ1NVVkQ2KzRUakQwSlgrUmxmNWhGd1BGbnhOQlBkeEVJUFJnZmVpbW5hbExlelUwTFBcLzhVVVJaNzczdmh3PT0iLCJtYWMiOiJiOWRhMDlmNDljNzY1ZjkxM2JiYzM1YTE5YzI3MWE2Y2I1NjVmNDI0MzYzZDgwNmFkZDY2YWQ2NGE1NWY2MDgzIn0%3D"
]
]

request_server


array:37 [
"HTTP_HOST" => "10.135.89.11"
"HTTP_CONNECTION" => "keep-alive"
"HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
"HTTP_USER_AGENT" => "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36"
"HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,image/apng,*/*;q=0.8"
"HTTP_REFERER" => "http://10.135.89.11/index.php/install/updates"
"HTTP_ACCEPT_ENCODING" => "gzip, deflate"
"HTTP_ACCEPT_LANGUAGE" => "en-US,en;q=0.9"
"HTTP_COOKIE" => "XSRF-TOKEN=eyJpdiI6IkV0NlFcL3owcms4YndQNFlQQTE5dXNBPT0iLCJ2YWx1ZSI6IldpXC85dGtcL0NFdzhGZzQyNjM0N2c3NTNSbTRXRVQraXg4WmVCWmZPRFlic2lyR2ZPNmhwNGV5MDgzNFVOb2x4ajUwMkkxaHpPd254ZzBBdVVvc1huSGc9PSIsIm1hYyI6ImI2NWNlNjFjMWZlYjM5OTQzYjkxOWE3NzM2OTFjMmRhYjM1MjU1YzdjNGM0MmYxNTU3ZDMyODlhODY1MGQ2NWYifQ%3D%3D; laravel_session=eyJpdiI6InczQXFrWXpxTlprQ0RSZTZkRFZWZFE9PSIsInZhbHVlIjoiVGsyVDZPUTBuWHVpaHJEUVd4VmI0ek0rZ1NVVkQ2KzRUakQwSlgrUmxmNWhGd1BGbnhOQlBkeEVJUFJnZmVpbW5hbExlelUwTFBcLzhVVVJaNzczdmh3PT0iLCJtYWMiOiJiOWRhMDlmNDljNzY1ZjkxM2JiYzM1YTE5YzI3MWE2Y2I1NjVmNDI0MzYzZDgwNmFkZDY2YWQ2NGE1NWY2MDgzIn0%3D"
"PATH" => "/sbin:/bin:/usr/sbin:/usr/bin"
"LD_LIBRARY_PATH" => "/usr/local/lib"
"SERVER_SIGNATURE" => ""
"SERVER_SOFTWARE" => "Apache/2.4.33 (FreeBSD) PHP/7.0.30"
"SERVER_NAME" => "10.135.89.11"
"SERVER_ADDR" => "10.135.89.11"
"SERVER_PORT" => "80"
"REMOTE_ADDR" => "10.135.89.179"
"DOCUMENT_ROOT" => "/usr/local/www/apache24/data"
"REQUEST_SCHEME" => "http"
"CONTEXT_PREFIX" => ""
"CONTEXT_DOCUMENT_ROOT" => "/usr/local/www/apache24/data"
"SERVER_ADMIN" => "[email protected]"
"SCRIPT_FILENAME" => "/usr/local/www/apache24/data/index.php"
"REMOTE_PORT" => "54477"
"GATEWAY_INTERFACE" => "CGI/1.1"
"SERVER_PROTOCOL" => "HTTP/1.1"
"REQUEST_METHOD" => "GET"
"QUERY_STRING" => ""
"REQUEST_URI" => "/index.php/install/updates"
"SCRIPT_NAME" => "/index.php"
"PATH_INFO" => "/install/updates"
"PATH_TRANSLATED" => "/usr/local/www/apache24/data/install/updates"
"PHP_SELF" => "/index.php/install/updates"
"REQUEST_TIME_FLOAT" => 1530506508.158
"REQUEST_TIME" => 1530506508
"argv" => []
"argc" => 0
]

request_cookies


array:2 [
"XSRF-TOKEN" => "wPanaWOIo2nKtgg1WflMO2sY5ufxicChg9lHeZWm"
"laravel_session" => "eJ0hlA9aZUm7v7NZ8jjhOlLZPwQT6PYkJ6NBq6bH"
]

response_headers


array:6 [
"cache-control" => array:1 [
0 => "no-cache, private"
]
"date" => array:1 [
0 => "Mon, 02 Jul 2018 04:41:51 GMT"
]
"content-type" => array:1 [
0 => "text/html; charset=UTF-8"
]
"x-akaunting" => array:1 [
0 => "Free Accounting Software"
]
"set-cookie" => array:2 [
0 => "XSRF-TOKEN=eyJpdiI6IndzY2pQR3lDUWZcL2VkVEJlT1hzNmpRPT0iLCJ2YWx1ZSI6IjdUb2RTWUlaNmlaM1NyYXhhNUplMFhkbFdDRUVQUDZvNUFrV1VFXC9iMnFOU0g3dEZZZnArSms2SHhrQzF6NU1jbmRxREtrVFwvbFpKejJmb1dcL2lMK3pnPT0iLCJtYWMiOiJhZTJlZjMwYWJmYzdiNjNiY2QwZjJlMzNhZjE2MWFjNGU4NmVjZGI1YjkyZmJlNDMwNjE0MmE1OGJmYTlhOWMzIn0%3D; expires=Mon, 02-Jul-2018 05:11:52 GMT; Max-Age=1800; path=/"
1 => "laravel_session=eyJpdiI6Im9cLysyVkZBaTZNWmJBTWVqczM3Y2ZnPT0iLCJ2YWx1ZSI6IjdGVnZsOW1XRmFYK1BJc1VaMWVJbHJkUGNMeWUwbm1tcURzUkplbUxyaTcyS1ZMeTVuY2pQazF1QXJvckdwcGl1TUpQeFR3dUZNajFOY2FVajZuN2VRPT0iLCJtYWMiOiJiODQ0ZTk0NmNkNjlhMjU3ZmExMTJjZGQ1ODU0NjUxYzFmODUwZGFiYzcyODhmYWUxMWE5N2U1NGZiYjI1ZmY2In0%3D; expires=Mon, 02-Jul-2018 05:11:52 GMT; Max-Age=1800; path=/; httponly"
]
"Set-Cookie" => array:2 [
0 => "XSRF-TOKEN=eyJpdiI6IndzY2pQR3lDUWZcL2VkVEJlT1hzNmpRPT0iLCJ2YWx1ZSI6IjdUb2RTWUlaNmlaM1NyYXhhNUplMFhkbFdDRUVQUDZvNUFrV1VFXC9iMnFOU0g3dEZZZnArSms2SHhrQzF6NU1jbmRxREtrVFwvbFpKejJmb1dcL2lMK3pnPT0iLCJtYWMiOiJhZTJlZjMwYWJmYzdiNjNiY2QwZjJlMzNhZjE2MWFjNGU4NmVjZGI1YjkyZmJlNDMwNjE0MmE1OGJmYTlhOWMzIn0%3D; expires=Mon, 02-Jul-2018 05:11:52 GMT; path=/"
1 => "laravel_session=eyJpdiI6Im9cLysyVkZBaTZNWmJBTWVqczM3Y2ZnPT0iLCJ2YWx1ZSI6IjdGVnZsOW1XRmFYK1BJc1VaMWVJbHJkUGNMeWUwbm1tcURzUkplbUxyaTcyS1ZMeTVuY2pQazF1QXJvckdwcGl1TUpQeFR3dUZNajFOY2FVajZuN2VRPT0iLCJtYWMiOiJiODQ0ZTk0NmNkNjlhMjU3ZmExMTJjZGQ1ODU0NjUxYzFmODUwZGFiYzcyODhmYWUxMWE5N2U1NGZiYjI1ZmY2In0%3D; expires=Mon, 02-Jul-2018 05:11:52 GMT; path=/; httponly"
]
]

path_info/install/updatessession_attributes


array:6 [
"_token" => "wPanaWOIo2nKtgg1WflMO2sY5ufxicChg9lHeZWm"
"url" => array:1 [
"intended" => "http://10.135.89.11/index.php"
]
"_previous" => array:1 [
"url" => "http://10.135.89.11/index.php/install/updates"
]
"_flash" => array:2 [
"old" => []
"new" => []
]
"login_web_59ba36addc2b2f9401580f014c7f58ea4e30989d" => 1
"company_id" => 1
]

Grasia Primardhika   ( User )

Commented 6 years ago

Backup first, if you haven't done so. Extract the new version dont upload to your server yet. Look for database changes in /database/migrations, notice how the filenames are in date format? find the file with filename that correspond with the new Akaunting version (eg. for the 1.2.10 release the corresponding file are 2018_06_23_000000_modify_email_column.php) easiest way is by comparing the /database/migrations folder content of the version currently running on your server vs the new version. Open the file(s) to view the changes and apply it to your database after that just upload the extracted files to your server overwriting the previous version. If anyone has other method please share, thank you.  

Erez Zabusky   ( User )

Commented 6 years ago

Thanks Grasia,


Followed above and change the tables as per additional file however received the error:


SQLSTATE[23000]: Integrity constraint violation: 1022 Can't write; duplicate key in table '#sql-15621_a' (SQL: alter table `uth_user_roles` add constraint `user_roles_role_id_foreign` foreign key (`role_id`) references `uth_roles` (`id`) on delete cascade on update cascade)


 


 

Emilio   ( User )

Commented 6 years ago


What is the change in the database? I still do not discover it. please I could not update it automatically either .. there must be some other manual way

 



Erez Zabusky   ( User )

Commented 6 years ago

Hi Emilio,


As Grasia mentioned, if you download and extract the new files and compare the directory /database/migration in the new file set to the same directory in your current installation, you will discover new files. Opening these files will reveal the changees required and in which table. For instance between 1.2.7 and 1.2.9 the only new file 2018_06_23_000000_modify_email_column.php . If you open it then you will see something like this: 


Schema::table('customers', function (Blueprint $table) {


$table->string('email')->nullable()->change();


});


Which means you need to make the column 'email' in table 'customers' nullable. You can do this in sql with this command: alter table sm5_customers modify email varchar(191) null;


Then continue making changes to all other tables as specified in the file and so on..


 


The issue I have is that there seems to be a prefix to each table for example for me its "sm5_" however when the files are copied and services restarted, a new prefix is added, likewise when recovering from backup.sql new prefix added hence above error. Might just be me... but not sure how to overcome it...yet.


Below references will help you: (always make sure you backup)


http://www.mysqltutorial.org/mysql-copy-database/


https://avdeo.com/tag/error-1840-hy000-global-gtid_purged-can-only-be-set-when/


https://laravel.com/docs/5.0/schema


 

Erez Zabusky   ( User )

Commented 6 years ago

Hey just following up.... does anyone have any ideas? Also is there anyone else seeing this in the update section of the GUI? any ideas how to actually fix?




Akaunting



An updated version of Akaunting is available.   Update Akaunting to 0.0.0 version   Changelog



 

Apps































Name Category Installed Version Latest Version Actions
OfflinePayment payment-gateways 1.0.0 0.0.0  Update
PaypalStandard payment-gateways 1.0.0 0.0.0  Update




Update screen

Emilio   ( User )

Commented 6 years ago

Exact! that's what I see when wanting to update the application. And I do not see any solution around here for the forum. The manual update is not easy for everyone.


Thanks in advance

Nicolas Holmes   ( User )

Commented 5 years ago

this is an error not actual an update ..how can you go from 1...to... 0

Zeeshan Javed   ( User )

Commented 4 years ago

Hello, I can help with upgrade, migration and backup of your akaunting software and database to any new server or cloud instance, for details email me at : [email protected]

Please login or register to leave a response.

Showing 1 to 9 of 9 discussions