Sorry to hear you’re facing problems
In order to help you as quickly as possible, before clicking Create Topic please provide as much of the below as you can. Feel free to use a pastebin service for logs, otherwise either indent short log examples with four spaces:
Or for longer, use three backticks above and below the code snippet:
longer example here
Some or all of the below information will be requested if it isn’t supplied; for fastest response please provide as much as you can
Nextcloud version (eg, 12.0.2):15.0
Operating system and version (eg, Ubuntu 17.04):?
Apache or nginx version (eg, Apache 2.4.25): ?
PHP version (eg, 7.1): 7.2
MySQL version: 5.7.21-nmm1-log - (Ubuntu)
The issue you are facing:
Modifications on the database as suggested by NextCloud often require some occ commands on the shell. When using a shared hosting provider the command shell usually is not available.
It would be helpful if next to the suggestion on what to change in the SQL database there were a button to download an *.sql file which contains the corresponding SQL commands to be executed on the database. This can usually easily be applied on some managment interface like phpMyAdmin even for instances running on a shared hosting.
Can you provide the commands for the conversion int -> bigint?
Is this the first time you’ve seen this error? (Y/N): N
Steps to replicate it:
- update from NexCloud 14.0.4 to version 15.0.0
- check th suggestions made on the settings tab
- phpMyAdmin: ALTER TABLE `prefix_activity` ALTER COLUMN `activity_id` bigint
- Error: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘bigint’ at line 1
The output of your Nextcloud log in Admin > Logging:
The output of your config.php file in
/path/to/nextcloud (make sure you remove any identifiable information!):
The output of your Apache/nginx/system log in