Fresh Install not loading "billing>Services" page

[xuhaibkhan]

 general.ERROR: PDOException: SQLSTATE[42000]: Syntax error or access violation: 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 ') AND `client_groups`.`company_id`='1' GROUP BY `services`.`id`)) AS `t_70034306'

[Paul]

On 12/4/2021 at 4:03 AM, xuhaibkhan said:

 general.ERROR: PDOException: SQLSTATE[42000]: Syntax error or access violation: 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 ') AND `client_groups`.`company_id`='1' GROUP BY `services`.`id`)) AS `t_70034306'

Do you have any services? What version of PHP and MySQL are you running? Please check the MySQL requirements here https://docs.blesta.com/display/user/Requirements

[lighttouchtech]

Hi. I have verion 4.7.0 of Blesta and I got the plugin COOKIECTTR from Blesta Add-ons. I downloaded the zip, then put the zip in my "/plugins". I then went to /settings/plugins and saw the plugin there in my Blesta admin... I then clicked on INSTALL.

At that point my browser window went white and the URL is: https://lighttouch-server.com/admin/settings/company/plugins/installed/.

I am unable to go to INSTALLED tab. Stopped working and my plugins page shows broken html. I can't send the screenshot...paperclip is there but won't work at this forum. So there is a corruption. What can I do about this without reinstalling my Blesta and configuring it all over again with my clients. Any help would be great. Thanks.

Jeff.

[lighttouchtech]

From Jeff again.... here is the screenshot.

[Paul]

4 hours ago, lighttouchtech said:

Hi. I have verion 4.7.0 of Blesta and I got the plugin COOKIECTTR from Blesta Add-ons. I downloaded the zip, then put the zip in my "/plugins". I then went to /settings/plugins and saw the plugin there in my Blesta admin... I then clicked on INSTALL.

At that point my browser window went white and the URL is: https://lighttouch-server.com/admin/settings/company/plugins/installed/.

I am unable to go to INSTALLED tab. Stopped working and my plugins page shows broken html. I can't send the screenshot...paperclip is there but won't work at this forum. So there is a corruption. What can I do about this without reinstalling my Blesta and configuring it all over again with my clients. Any help would be great. Thanks.

Jeff.

It sounds like there's a problem with that plugin.

You can try this.. in MySQL, change the plugin in the plugins table from enabled=1 to enabled=0, then see if the page loads. If it doesn't, you will need to delete the record from the plugins table for the plugin and delete the plugin files.

Backup everything first, database + files.

To do a thorough job of removing it, any/all tables the plugin may have created should be deleted manually as well. Because it's a 3rd party plugin, I have no idea what those are though. But, this shouldn't be necessary if you are not going to try re-installing it later.