[Could not submit to the online database]

Hello Floele,

Thanks for the return. It's working as it should now! =)

[Could not submit to the online database]

Hello floele,

The problem still continues.

Quote

 

28/01/2018 08:37:33: Could not submit 'Open Live Writer' to the online database: Unhandled Doctrine\DBAL\Exception\ConnectionException exception:An exception occurred while executing 'SELECT DeleteId 
                                    FROM app_deleted
                                   WHERE ApplicationGuid LIKE ?' with params [{"0":"3d37ea61-0dcf-4e25-9922-c8ff775259e4"}]:SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'ketarin'@'localhost' for table 'app_deleted'

 

 

[Could not submit to the online database]

When I check the box "Share this application online with others" into the "Advanced Settings" tab I receive the following error on Ketarin Log:

Quote

 

26/12/2017 23:23:51: Could not submit 'SQLite ODBC Driver' to the online database: Unhandled Doctrine\DBAL\Exception\ConnectionException exception:An exception occurred while executing 'SELECT DeleteId 
                                    FROM app_deleted
                                   WHERE ApplicationGuid LIKE ?' with params [{"0":"cd7699b7-2123-4d76-9dc9-589285cd8540"}]:

SQLSTATE[42000]: Syntax error or access violation: 1142 SELECT command denied to user 'ketarin'@'localhost' for table 'app_deleted'

 

I can add, update and install applications just fine: I just cannot contribute to the community sharing applications.

I already tried to use sqlite3 jobs.db "VACUUM;" on my DB to try to fix it as @shawn stated on:

I'm using Ketarin 1.8.8b4 on Windows 7 64-bit with .NET Framework 4.7.1 installed

I imported my jobs into a new DB using export/import funcions from Ketarin, filled the author GUID in Help > About on my forum profile and the error still remains.

And just a contribution to the Community: I'm not sure if the changes made on the way the users contribute to the User Database is benefic. 

I think it limits the way the people can contribute to the online database. There is no warning on Ketarin GUI informing about filling the Author GUID on the forum profile to send updates. And it justs add burocracy to the process and doesn't resolve the issue stated by @floele about application quality on the DB. I believe it would be better having it freely (anyone can send application updates) and having a score system as stated by @shawn and @floele would provide better results.

One question that I have about the online database is how it deals with updates. E.g: I imported an application from the online DB. I changed the setup instructions logic or fix a URL with error 404. This changes will be sent to the online database or only the author can change the application that it creates?