Announcement on Index

Error Code SQL ERROR [ mysql4 ] - Announcement on Index

Error Code SQL ERROR [ mysql4 ]

by njallison » Fri Apr 17, 2015 2:26 pm

After installing this extension it appears to have a conflict with the "Top Five" extension which results in the SQL error below, quite literally the BBS is unreachable no one can login.

I was able to login using the http://"mybbslink"/phpBB3/ucp.php?mode=login

and was by trial and error able to turn off the extensions one by one to fix this...note simply turning off Announcement on Index did not fix the issue I had to turn off the "Top Five" extension to make the BBS come back and I have the Announcement on Index actually active.

Here is the backtrace:

General Error
SQL ERROR [ mysql4 ]

[0]

SQL

No values specified for SQL IN comparison

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

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

FILE: [ROOT]/ext/rmcgirr83/topfive/core/functions_topfive.php
LINE: 124
CALL: phpbb\db\driver\factory->sql_in_set()

FILE: [ROOT]/ext/rmcgirr83/topfive/event/listener.php
LINE: 55
CALL: rmcgirr83\topfive\core\functions_topfive->toptopics()

FILE: (not given by php)
LINE: (not given by php)
CALL: rmcgirr83\topfive\event\listener->main()

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php
LINE: 164
CALL: call_user_func()

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php
LINE: 53
CALL: Symfony\Component\EventDispatcher\EventDispatcher->doDispatch()

FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/ContainerAwareEventDispatcher.php
LINE: 167
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 60
CALL: Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher->dispatch()

FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()

FILE: [ROOT]/index.php
LINE: 198
CALL: phpbb\event\dispatcher->trigger_event()
User avatar
njallison
Registered User
Posts: 58
Joined: Fri Jan 23, 2015 7:37 pm
Name: Nelson Allison
Contact:

Re: Error Code SQL ERROR [ mysql4 ]

by david63 » Fri Apr 17, 2015 2:52 pm

I cannot recreate that error and in any event the error relates to the "Top Five" extension - there is nothing in that error message relating to this extension.
David
Remember: You only know what you know and - you don't know what you don't know!
My CDB Contributions | How to install an extension
I will not be accepting translations for any of my extensions in Github - please post any translations in the appropriate topic.
No support requests via PM or email as they will be ignored
User avatar
david63
Registered User
Posts: 16535
Joined: Thu Dec 19, 2002 8:08 am
Location: Lancashire, UK
Name: David Wood
Contact:

Re: Error Code SQL ERROR [ mysql4 ]

by njallison » Wed Apr 22, 2015 5:18 pm

David:
Yeah I realize that there is no error message related to this extension but the "Top Five" extension and the BBS was working fine until I installed the "Announcement on Index" extension.

Disabling the Top Five" extension corrects the issue.
User avatar
njallison
Registered User
Posts: 58
Joined: Fri Jan 23, 2015 7:37 pm
Name: Nelson Allison
Contact:

Re: Error Code SQL ERROR [ mysql4 ]

by RMcGirr83 » Tue Apr 28, 2015 10:39 am

Concerning the top five extension, it is because your forums have no topics. This has been corrected in the latest version that is waiting for validation.
In times of change, learners inherit the earth, while the learned find themselves beautifully equipped to deal with a world that no longer exists - Eric Hoffer
Former Modifications/Extensions Team Member | My extensions
Appreciate the extensions/mods/support then buy me a beer
All requests for support via PM will be ignored
User avatar
RMcGirr83
Recognised Extension Developer
Posts: 21034
Joined: Wed Jun 22, 2005 4:33 pm
Location: Your display
Name: Rich McGirr
Contact: