Error downloading files

Support für Extensions für phpBB 3.1.x von Entwickler OXPUS
Antworten
Smithyy1987
Beiträge: 2
Registriert: Mo 14. Dez 2015, 10:22

Error downloading files

Beitrag von Smithyy1987 »

Firstly let me say thank you for making such a great extension as i have been looking for this for some time now so i really appreciate your work.

I installed everything fine and can add & remove downloads but when trying to download files i get tge following error...
SQL ERROR [ mysqli ]

The used table type doesn't support FULLTEXT indexes [1214]

SQL

SELECT id, description, desc_uid, desc_bitfield, desc_flags FROM phpbb_downloads WHERE MATCH (description) AGAINST ('Test file') AND id <> 2 AND cat = 6 ORDER BY description LIMIT 10

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/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/mysql_base.php
LINE: 45
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 261
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 321
CALL: phpbb\db\driver\driver->sql_query_limit()

FILE: [ROOT]/ext/oxpus/dl_ext/includes/modules/dl_details.php
LINE: 1186
CALL: phpbb\db\driver\factory->sql_query_limit()

FILE: [ROOT]/ext/oxpus/dl_ext/controller/main.php
LINE: 943
CALL: include('[ROOT]/ext/oxpus/dl_ext/includes/modules/dl_details.php')

FILE: (not given by php)
LINE: (not given by php)
CALL: oxpus\dl_ext\controller\main->handle()

FILE: [ROOT]/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpKernel.php
LINE: 117
CALL: call_user_func_array()

FILE: [ROOT]/vendor/symfony/http-kernel/Symfony/Component/HttpKernel/HttpKernel.php
LINE: 61
CALL: Symfony\Component\HttpKernel\HttpKernel->handleRaw()

FILE: [ROOT]/app.php
LINE: 33
CALL: Symfony\Component\HttpKernel\HttpKernel->handle()
Could anyone advise how i can fix this ?

Kind regards,
Smithyy1987
Benutzeravatar
oxpus
Chief handy-man
Beiträge: 2660
Registriert: Do 13. Dez 2007, 23:06
Wohnort: Irgendwo im I-Net
Kontaktdaten:

Re: Error downloading files

Beitrag von oxpus »

Hello,,
please execute these SQL in your database:

Code: Alles auswählen

ALTER TABLE phpbb_downloads ENGINE = MyISAM;
ALTER TABLE phpbb_downloads CHANGE COLUMN description description MEDIUMTEXT NOT NULL;
ALTER TABLE phpbb_downloads ADD FULLTEXT INDEX desc_search(description);
This solves the error.
Karsten Ude
Kein Support per Messenger, Email oder PN! Unaufgeforderte Nachrichten werden ignoriert!
No support per Messenger, Email or PM. Each unasked message will be ignored!
Smithyy1987
Beiträge: 2
Registriert: Mo 14. Dez 2015, 10:22

Re: Error downloading files

Beitrag von Smithyy1987 »

Sorry for the delay oxpus i have been full of man flu :).

I executed the query you mentioned and test it again and it worked!

Thanks alot friend i appreciate it!

Regards,
Smithyy1987
Benutzeravatar
oxpus
Chief handy-man
Beiträge: 2660
Registriert: Do 13. Dez 2007, 23:06
Wohnort: Irgendwo im I-Net
Kontaktdaten:

Re: Error downloading files

Beitrag von oxpus »

No problem.
Fine to read that everything works now.
Karsten Ude
Kein Support per Messenger, Email oder PN! Unaufgeforderte Nachrichten werden ignoriert!
No support per Messenger, Email or PM. Each unasked message will be ignored!
Benutzeravatar
oxpus
Chief handy-man
Beiträge: 2660
Registriert: Do 13. Dez 2007, 23:06
Wohnort: Irgendwo im I-Net
Kontaktdaten:

Re: Error downloading files

Beitrag von oxpus »

No problem.
Fine to read that everything works now.
Karsten Ude
Kein Support per Messenger, Email oder PN! Unaufgeforderte Nachrichten werden ignoriert!
No support per Messenger, Email or PM. Each unasked message will be ignored!
Antworten