AzuCloud - Long Tail SEO Cloud

Luke F · Dec 11, 2011

Veer said:
thanks for the updated version dark.
I have upgraded and now I can't open this link: /admin.php?azucloud/list
When I click on it, its keep loading loading loading.. I was able to access this link in old version, any idea?

Edit: Finally loaded after a few minutes, list shows 6963 pages. I tried it loading again and it same again taking too much time to load the list page.

See if the latest update helps, though your innodb buffer pool could do with an increase

0.1.2 (11/12/2011):

Optimised tag cloud generation query

Significantly optimised admin tag listing query

Andy.N · Dec 11, 2011

Yes, latest version 0.1.2 has much better tag listing page now.

Any query we can run to only keep tags for the last 30 days? Do I have to uninstall and reinstall to get this option to stick?

Luke F · Dec 11, 2011

Andy.N said:
Yes, latest version 0.1.2 has much better tag listing page now.

Any query we can run to only keep tags for the last 30 days? Do I have to uninstall and reinstall to get this option to stick?

Something like this: (untested)

Code:

delete from dark_azucloud_terms_pages where last_clicked < UNIX_TIMESTAMP()-60*60*24*30;
delete from dark_azucloud_terms terms where (select term_id from dark_azucloud_terms_pages pages where pages.term_id=terms.id limit 1) is null;

Veer · Dec 11, 2011

Darkimmortal said:
See if the latest update helps, though your innodb buffer pool could do with an increase

thanks dark, update worked, its much better now.

Anthony Parsons · Dec 11, 2011

Darkimmortal said:
delete from dark_azucloud_terms_pages where last_clicked < UNIX_TIMESTAMP()-60*60*24*30;

I used that one on the pages table, worked a treat. I changed mine to 60 though, not 30... really cut the ACP pages down from hundreds of thousands to under six figures, which was nice for managing recent keyword terms in the ACP.

Renegader · Dec 11, 2011

Darkimmortal said:
See if the latest update helps, though your innodb buffer pool could do with an increase

That's the exact same problem I got, it took like 5 minutes to load the page.

It's definitely better now, thanks a lot, Dark!

Andy.N · Dec 11, 2011

Anthony Parsons said:
I used that one on the pages table, worked a treat. I changed mine to 60 though, not 30... really cut the ACP pages down from hundreds of thousands to under six figures, which was nice for managing recent keyword terms in the ACP.

We shouldn't have to do it though. It's set in ACP how long the data should be kept in database. Looks like a small bug.

Anthony Parsons · Dec 12, 2011

Two different tables from my understanding. The actual table that is shown to the public on content, the data is removed as per the settings. The ACP table though stores everything and doesn't forget it, from what I can see.

I'm sure DI can confirm or not...

Maybe an easier method is a simple option whether to run a cron job and prune the ACP tabled data on a setting of days defined via the option!

Luke F · Dec 12, 2011

Anthony Parsons said:
Two different tables from my understanding. The actual table that is shown to the public on content, the data is removed as per the settings. The ACP table though stores everything and doesn't forget it, from what I can see.

I'm sure DI can confirm or not...

Maybe an easier method is a simple option whether to run a cron job and prune the ACP tabled data on a setting of days defined via the option!

Not exactly, there are two database tables yes - one for the search terms, and one relating each search term to a certain URL. They are used together on both the front and back ends.

The setting for number of days currently just affects what is shown, while everything continues to be stored. In a future update I'll add a separate option to delete terms older than x days (probably best to keep them separate to allow a bit of leeway etc.)

Veer · Dec 12, 2011

Hi Dark, could you please comment on a possible bug that I reported few pages back and still having it

Post #275 and #277

Divinum Fiat · Dec 15, 2011

I apologize if this has been asked before and I missed it. Does anyone know if the add-on is also supposed to work for the home page? My forum is 4 weeks old and I just started seeing some posts that were found but nothing on the home page. Does anyone know?

ddmmh · Dec 15, 2011

Blueprint4Love said:
I apologize if this has been asked before and I missed it. Does anyone know if the add-on is also supposed to work for the home page? My forum is 4 weeks old and I just started seeing some posts that were found but nothing on the home page. Does anyone know?

When you say home page do you mean the forums or the XenPortal?

Divinum Fiat · Dec 15, 2011

Yes, the XenPortal home.

Any way to figure out how that is found?

Luke F · Dec 15, 2011

Blueprint4Love said:
I apologize if this has been asked before and I missed it. Does anyone know if the add-on is also supposed to work for the home page? My forum is 4 weeks old and I just started seeing some posts that were found but nothing on the home page. Does anyone know?

You need to whitelist the necessary controller

Divinum Fiat · Dec 15, 2011

what does that mean, Darkimmortal?

Luke F · Dec 15, 2011

Blueprint4Love said:
what does that mean, Darkimmortal?

In azucloud's active controllers setting add:

Code:

EWRporta_ControllerPublic_Index:index

Divinum Fiat · Dec 15, 2011

Thank you!!!

kkm323 · Dec 16, 2011

I can't upgrade

Code:

Server Error
 
Mysqli statement execute error : Data truncated for column 'route' at row 6652
 
Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in Dark/AzuCloud/Install.php at line 139
Dark_AzuCloud_Install->_installVersion6() in Dark/AzuCloud/Install.php at line 83
Dark_AzuCloud_Install::install() in XenForo/Model/AddOn.php at line 214
XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 212
XenForo_ControllerAdmin_AddOn->actionUpgrade() in XenForo/FrontController.php at line 310
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
XenForo_FrontController->run() in /home/xxxx/public_html/admin.php at line 13

SchmitzIT · Dec 16, 2011

Thanks, DI

Works like a charm, and using the hook ensures even less work for future upgrades

Luke F · Dec 16, 2011

kkm323 said:

I can't upgrade

Code:

Server Error
 
Mysqli statement execute error : Data truncated for column 'route' at row 6652
 
Zend_Db_Statement_Mysqli->_execute() in Zend/Db/Statement.php at line 317
Zend_Db_Statement->execute() in Zend/Db/Adapter/Abstract.php at line 479
Zend_Db_Adapter_Abstract->query() in Dark/AzuCloud/Install.php at line 139
Dark_AzuCloud_Install->_installVersion6() in Dark/AzuCloud/Install.php at line 83
Dark_AzuCloud_Install::install() in XenForo/Model/AddOn.php at line 214
XenForo_Model_AddOn->installAddOnXml() in XenForo/Model/AddOn.php at line 169
XenForo_Model_AddOn->installAddOnXmlFromFile() in XenForo/ControllerAdmin/AddOn.php at line 212
XenForo_ControllerAdmin_AddOn->actionUpgrade() in XenForo/FrontController.php at line 310
XenForo_FrontController->dispatch() in XenForo/FrontController.php at line 132
XenForo_FrontController->run() in /home/xxxx/public_html/admin.php at line 13

Comment out lines 136-139 of install.php, you must have a really long url in there somewhere

AzuCloud - Long Tail SEO Cloud

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

Well-known member

We value your privacy