[ABD] Log Searches

[wkuzma]

I noticed a minor error

when you go to delete the search log and do not select any searches to delete however hit the delete button anyway you get this error. The error only happens if you do not check any searches to be deleted.


General Error
SQL ERROR [ mysql4 ]

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 '' at line 2 [1064]

SQL

DELETE FROM phpbb_search_log WHERE

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 855
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysql.php
LINE: 181
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysql->sql_query()

FILE: [ROOT]/ext/david63/logsearches/controller/admin_controller.php
LINE: 267
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/david63/logsearches/controller/admin_controller.php
LINE: 164
CALL: david63\logsearches\controller\admin_controller->search_log_delete()

FILE: [ROOT]/ext/david63/logsearches/acp/logsearches_module.php
LINE: 30
CALL: david63\logsearches\controller\admin_controller->display_output()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: david63\logsearches\acp\logsearches_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()

[david63]

Thanks for that. Fixed in download.

[wkuzma]

Thanks for that. Fixed in download.

Thanks for fixing it fast and great extension.

[Webwatcher_eu]

David
did you request this event? so it can be used without touching the code? maybe in 3.1.16?

for me it works fine i can also live with this filechange

[svennson]

This mod works nicely, would it be possible to add sort of export function ? tab seperated or comma seperated would be nice ...

[david63]

The event has been updated in phpBB 3.1.6 therefore the edit in the second post of this topic is no longer required.

[Dragosvr92]

Just installed on 3.3.3, used the search, but it sadly doesnt log anything.
The extension is awesome, i used to have the old Searchlog mod on phpbb 3.0

[stone23]

Just installed on 3.3.3, used the search, but it sadly doesnt log anything.

Hello, use the github link for compatibility with 3.3.3. It works fine for me.

[david63]

sadly doesnt log anything

Have you set the options?

[Dragosvr92]

sadly doesnt log anything

Have you set the options?

It works now, i thought it works out of the box. Thanks.