Troubleshooting for the current version

#599 – Database Error on Fields

Posted in ‘Support’
This is a public ticket. Everybody will be able to see its contents. Do not include usernames, passwords or any other sensitive information.
Thursday, 09 May 2019 00:34 CEST
thirdsun
Joomla! version : 3.9.5
PHP version : 7.2
AdsManager version : 3.2.3

When I attempt to edit any fields I get this error:

All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

I can't find a "NULL" primary key, but obviously missing something. Any ideas? Thanks
Custom Fields
Joomla Version
3.9.5
PHP Version
7.2
Product
AdsManager
Product Version
3.2.3
Thursday, 09 May 2019 13:54 CEST
loic
Hello,

I think a adsmanager plugin field is causing the error.

In the 'plugin' page, could you try to remove the gmap and youtube fields ?

If it resolve the error, then try to reinstall the component to reinstall the plugins and see if it works.

Best regards.
 
Thursday, 09 May 2019 18:21 CEST
thirdsun
Yes, deleting those plugins fixed it. I don't need them, so didn't try to reinstall. Thanks!
Friday, 10 May 2019 08:37 CEST
loic
Hello,

Great news, I close that ticket :)

Best regards.
 
This ticket is closed, therefore read-only. You can no longer reply to it. If you need to provide more information, please open a new ticket and mention this ticket's number.