Forum
Ask, reply and learn. Join the community of Akaunting.
Update not working? Is there a manual way?
Erez Zabusky ( User )
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
htmlcontent_type
text/html; charset=UTF-8status_text
OKstatus_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 )
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 )
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 )
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 )
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 )
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?
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 |
Emilio ( User )
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 )
this is an error not actual an update ..how can you go from 1...to... 0
Zeeshan Javed ( User )
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]
Showing 1 to 9 of 9 discussions