I plan to help rxu after updating other extensions.Mauron wrote:Is the development of this extension on hold?
What error?SalazarAG wrote:Gives a general SQL error
Hirxu wrote:What error?SalazarAG wrote:Gives a general SQL error
Code: Select all
SQL ERROR [ mysqli ]
Unknown column 'w.warning_status' in 'field list' [1054]
SQL
SELECT w.post_id, w.warning_time, w.warning_end, w.warning_type, w.warning_status, l.user_id, l.log_data, l.reportee_id, u.username, u.user_colour FROM phpbb_warnings w, phpbb_log l, phpbb_users u WHERE w.warning_status = 1 AND l.log_id = w.log_id AND u.user_id = l.user_id
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/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/ext/rxu/AdvancedWarnings/event/listener.php
LINE: 185
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/ext/rxu/AdvancedWarnings/event/listener.php
LINE: 72
CALL: rxu\AdvancedWarnings\event\listener->get_warnings_data()
FILE: [ROOT]/cache/container_0374ec857381230fa83049643ce3cdee.php
LINE: 2803
CALL: rxu\AdvancedWarnings\event\listener->__construct()
FILE: [ROOT]/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/Container.php
LINE: 314
CALL: phpbb_cache_container->getRxu_Advancedwarnings_ListenerService()
FILE: [ROOT]/vendor/symfony/dependency-injection/Symfony/Component/DependencyInjection/ContainerBuilder.php
LINE: 431
CALL: Symfony\Component\DependencyInjection\Container->get()
FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/ContainerAwareEventDispatcher.php
LINE: 176
CALL: Symfony\Component\DependencyInjection\ContainerBuilder->get()
FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/ContainerAwareEventDispatcher.php
LINE: 131
CALL: Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher->lazyLoad()
FILE: [ROOT]/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/EventDispatcher.php
LINE: 45
CALL: Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher->getListeners()
FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 60
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()
FILE: [ROOT]/includes/functions_module.php
LINE: 314
CALL: phpbb\event\dispatcher->trigger_event()
FILE: [ROOT]/memberlist.php
LINE: 635
CALL: p_master->list_modules()
The problem began to fail in 3.1.10.rxu wrote:That's weird as the column should exist (unless there was a problem with migration wasn't run).
Did you just installed the extension or did it work fine and started failing after 3.0.10 update or something?
Code: Select all
General Error
SQL ERROR [ mysqli ]
Unknown column 'w.warning_status' in 'field list' [1054]
SQL
SELECT w.post_id, w.warning_time, w.warning_end, w.warning_type, w.warning_status, l.user_id, l.log_data, l.reportee_id, u.username, u.user_colour FROM odti_warnings w, odti_log l, odti_users u WHERE w.warning_status = 1 AND l.log_id = w.log_id AND u.user_id = l.user_id
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/ext/rxu/AdvancedWarnings/event/listener.php
LINE: 185
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/ext/rxu/AdvancedWarnings/event/listener.php
LINE: 72
CALL: rxu\AdvancedWarnings\event\listener->get_warnings_data()
FILE: [ROOT]/cache/production/container_dbdbe80dc7030ae9bd39ee30cca82130.php
LINE: 3812
CALL: rxu\AdvancedWarnings\event\listener->__construct()
FILE: [ROOT]/vendor/symfony/dependency-injection/Container.php
LINE: 314
CALL: phpbb_cache_container->getRxu_Advancedwarnings_ListenerService()
FILE: [ROOT]/vendor/symfony/dependency-injection/ContainerBuilder.php
LINE: 447
CALL: Symfony\Component\DependencyInjection\Container->get()
FILE: [ROOT]/vendor/symfony/event-dispatcher/ContainerAwareEventDispatcher.php
LINE: 183
CALL: Symfony\Component\DependencyInjection\ContainerBuilder->get()
FILE: [ROOT]/vendor/symfony/event-dispatcher/ContainerAwareEventDispatcher.php
LINE: 128
CALL: Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher->lazyLoad()
FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 45
CALL: Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher->getListeners()
FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 60
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()
FILE: [ROOT]/includes/functions_module.php
LINE: 314
CALL: phpbb\event\dispatcher->trigger_event()
FILE: [ROOT]/adm/index.php
LINE: 72
CALL: p_master->list_modules()
Code: Select all
SQL ERROR [ mysqli ]
Unknown column 'w.warning_status' in 'field list' [1054]
SQL
SELECT w.post_id, w.warning_time, w.warning_end, w.warning_type, w.warning_status, l.user_id, l.log_data, l.reportee_id, u.username, u.user_colour FROM phpbb_warnings w, phpbb_log l, phpbb_users u WHERE w.warning_status = 1 AND l.log_id = w.log_id AND u.user_id = l.user_id
BACKTRACE
FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()
FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 999
CALL: trigger_error()
FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()
FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 329
CALL: phpbb\db\driver\mysqli->sql_query()
FILE: [ROOT]/ext/rxu/AdvancedWarnings/event/listener.php
LINE: 152
CALL: phpbb\db\driver\factory->sql_query()
FILE: [ROOT]/ext/rxu/AdvancedWarnings/event/listener.php
LINE: 58
CALL: rxu\AdvancedWarnings\event\listener->get_warnings_data()
FILE: [ROOT]/cache/production/container_dbdbe80dc7030ae9bd39ee30cca82130.php
LINE: 3954
CALL: rxu\AdvancedWarnings\event\listener->__construct()
FILE: [ROOT]/vendor/symfony/dependency-injection/Container.php
LINE: 314
CALL: phpbb_cache_container->getRxu_Advancedwarnings_ListenerService()
FILE: [ROOT]/vendor/symfony/dependency-injection/ContainerBuilder.php
LINE: 447
CALL: Symfony\Component\DependencyInjection\Container->get()
FILE: [ROOT]/vendor/symfony/event-dispatcher/ContainerAwareEventDispatcher.php
LINE: 183
CALL: Symfony\Component\DependencyInjection\ContainerBuilder->get()
FILE: [ROOT]/vendor/symfony/event-dispatcher/ContainerAwareEventDispatcher.php
LINE: 128
CALL: Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher->lazyLoad()
FILE: [ROOT]/vendor/symfony/event-dispatcher/EventDispatcher.php
LINE: 45
CALL: Symfony\Component\EventDispatcher\ContainerAwareEventDispatcher->getListeners()
FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 60
CALL: Symfony\Component\EventDispatcher\EventDispatcher->dispatch()
FILE: [ROOT]/phpbb/event/dispatcher.php
LINE: 46
CALL: phpbb\event\dispatcher->dispatch()
FILE: [ROOT]/includes/functions_module.php
LINE: 314
CALL: phpbb\event\dispatcher->trigger_event()
FILE: [ROOT]/adm/index.php
LINE: 72
CALL: p_master->list_modules()
You should never install extensions in development phase on production board.
Code: Select all
UPDATE phpbb_ext SET ext_active=0 WHERE ext_name=`rxu/AdvancedWarnings`