Banner plugin 2.4.0 bug or very slow?

[Athanasios Christou]

Hi,

i installed some updates last days for plugins including the banner plug in version 2.4.0.

In the admin area, the query in the banner plugin is very slow.
Frontuser-Interface loading time is also very slow when running this plugin.

Specifically, admin panel - Banners - List of banners

List will be empty.

after some time you can click on listboxes, entries are shown.
I click again on List of Banner, the plugin shows the entries immediately.

I click again on List of Banners, everything starts all over again, very long wait.

See also slow-log of MySQL.

# Time: 130926 18:23:23
# User@Host: *******[******] @ localhost []
# Query_time: 162.232385 Lock_time: 0.000140 Rows_sent: 20 Rows_examined: 40959132
SET timestamp=1380205403;
SELECT SQL_CALC_FOUND_ROWS DISTINCT `T1`.`ID`, `T1`.`Account_ID`, `T1`.`Html`, `T1`.`Image` AS `thumbnail`, `T1`.`Type`, `T1`.`Date_release`, `T1`.`Status`, `T1`.`Last_show`, `T1`.`Shows`, `T1`.`Pay_date`, `T2`.`Value` AS `name`, `T3`.`Username`, `T4`.`Key` AS `Plan_key`, `T4`.`Price`, `T4`.`Period`, `T4`.`Plan_Type`, `T5`.`Banners` FROM `fl_banners` AS `T1` LEFT JOIN `fl_lang_keys` AS `T2` ON CONCAT('banners+name+',`T1`.`ID`) = `T2`.`Key` AND `T2`.`Code` = 'en' LEFT JOIN `fl_accounts` AS `T3` ON `T1`.`Account_ID` = `T3`.`ID` LEFT JOIN `fl_banner_plans` AS `T4` ON `T1`.`Plan_ID` = `T4`.`ID` LEFT JOIN `fl_blocks` AS `T5` ON `T1`.`Box` = `T5`.`Key` AND `T1`.`Type` = 'flash' WHERE `T1`.`Status` <> 'trash' LIMIT 40, 20;


Please Help.

Thanks !!!

Best regards.
Sakis

[Alex]

Hi,

In the latest update of this plugin we have done everything possible that he was working as quickly as possible in the FrontEnd
But in the admin panel no optimizations for him not to do..
I hope for you that's not really a big problem; and we are on our side will work on optimization.

[Athanasios Christou]

Hi Alex,

I am fully on your side, the Flynax team makes a very good job.

Maybe I expressed myself wrong in the first post.

1. I have updated the plugin.
2. I have import Countrie-datas from the Flynax server, in Multi-field/Geo filtering plugin.

Later i noticed in the banner plugin something is wrong.

In the admin area the banner will not load, the FrontEnd takes a long time to load.

See also the video.

http://screencast.com/t/8UMQ99xgka


Does anyone have this problem too?

Please help, is there a solution?

best regards

Sakis.

[Athanasios Christou]

Hi,

i got the plugin running again.

1. Plugin uninstalled.
2. Updated mysql from 5.1 to 5.5.
3. Optimized mysql
3. Plugin installed.
4.Plugin works again.

now I have another question:

How do i get a new column to show the clicks of the banners?

banners_grid.jpg


Best regards

Sakis

[Alex]

You should add the code that is highlighted in bold green.
(!) Before you change the files, back up the files to be modified.

Open the file /plugins/banners/admin/banners.inc.php
[line: ~133]

Only registered members can view the code.

Open the file /plugins/banners/admin/banners.tpl
[Line: ~567]

Only registered members can view the code.

The next change in the same file slightly below:

Only registered members can view the code.

After these steps you should see a new column in the manager.