New Ad Agency update error

Ninja

DragAuth
Hi
The error is in the database tables, I need PHPMyadmin access to remove the adagency tables from database.
You can also delete the table with _ad_agency
Please note delete these table will remove older data of adagency.

Regards

DragAuth

I struggle logging in and navigating through the PHPAdmin with the Google Cloud Platform. I didn't have enough data or content in the tables to care about losing; it was all my own testing stuff anyway.

How would I delete the tables?

Ninja

DragAuth
Hi
I shared the thread with Development team to look over a possible solution as you do not have any access of cpanel.

Regards

DragAuth

Any update for this thread?

Ninja

DragAuth
Hi
Sorry its taking some more time due to limited access of site.
I will update you soon on it.

Regards

alindinca

Hi,

We also need database access to delete all AdAgency tables, I tried to update adagency from an old version to the latest version on our test sites and I can not replicate the issue.
You can use this SQL query to delete the database tables:
DROP TABLE jos_ad_agency_advertis
DROP TABLE jos_ad_agency_banners
....

PLEASE make sure that after you delete all these database tables you will lose all ald values, old banners, old campaigns, this delete action is not irreversible.
Please replace "jos" word with your database tables prefix.

Kind Regards,
Alin

DragAuth

alindinca What do I need to do to provide database access? I have been able to use filezilla sftp login through ssh to get to some files, but there are several folders, which include the joomla files, which I am still not able to open or get to.

SQL on Google Cloud Platform has really proven to be my learning downfall in all of this.

mabm2

What if I do NOT want to lose all my old data? I have several years worth. Is there some way to save or archive especially all my advertiser data?

alindinca

Hi,

In this case you should not delete adagency tables, if you want to not lose the values, but I will try to do a new install manually, for this I need FTP account access (host, username and password), I need to delete some folders from AdAgency and start a new update.

Kind Regards,
Alin

alindinca

Hi,

Unfortunately I can not log to ftp, I tried with FileZila and WinSCP but I received this:
Error: Disconnected: No supported authentication methods available (server sent: publickey)
Error: Could not connect to server
Please try to do this:
1. uninstall AdAgency (this action do not delete all AdAgency tables, all tables will remain in your database)
2. log to ftp and comment/rename these directories (if exist): "administrator\components\com_adagency", "components\com_adagency"
3. install the new AdAgency version

Please let me know if this is not ok.

Kind Regards,
Alin

DragAuth

I have uninstalled AdAgency, went through Fillzilla to the components\ and there are no directories for \com_adagency. I attemped to re-install Ad-Agency and the following errors still come up....

Ninja

DragAuth
Hi
Kindly check it now.
The extension is installed on your site.

Regards

DragAuth

Yeah! It's working again. Thank you very much.