phpBB • Free and Open Source Forum Software

BeardedPilot · by **BeardedPilot** » Fri Jul 01, 2016 6:47 pm

I installed into EXT file via ftp then went to acp and enabled it and found this.
My first attempt at phpbb so i hope i didnt mess up.
thanks Tim

General Error
SQL ERROR [ mysqli ]

Table 'db633501314.l190_flags' doesn't exist [1146]

SQL

SELECT * FROM l190_flags ORDER BY flag_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/rmcgirr83/nationalflags/core/nationalflags.php
LINE: 121
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/rmcgirr83/nationalflags/event/listener.php
LINE: 144
CALL: rmcgirr83\nationalflags\core\nationalflags->cache_flags()

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

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

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

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]/phpbb/user.php
LINE: 184
CALL: phpbb\event\dispatcher->trigger_event()

FILE: [ROOT]/index.php
LINE: 29
CALL: phpbb\user->setup()

RMcGirr83 · by **RMcGirr83** » Sun Jul 03, 2016 3:52 pm

Where did you see this error. You must extract all files from the download into the ext directory retaining the directory structure eg, ext/rmcgirr83/nationalflags.

kaspir · by **kaspir** » Fri Jul 15, 2016 7:10 pm

Um yea, I just installed this on 3.1.9, and I got the same exact error. Re-uploaded the files from a fresh download again, same thing. It happens, directly after enabling the extension. My entire site is down now, can't access site or ACP... *pulling my hair out*

Code: Select all

[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/class_loader.php on line 160: require(./ext/rmcgirr83/elonw/event/listener.php): failed to open stream: No such file or directory
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/class_loader.php on line 160: require(./ext/rmcgirr83/elonw/event/listener.php): failed to open stream: No such file or directory

Fatal error: require(): Failed opening required './ext/rmcgirr83/elonw/event/listener.php' (include_path='.:/usr/local/php56/pear') in /home/www.example.com/forums/phpbb/class_loader.php on line 160

You can see above I was on PHP version 5.6, I just tried switching my domain back to 5.4 and 5.5. Got no results with that.

Um yea, I'm stuck. I can tell you that I DO see this line:
rmcgirr83/nationalflags 1 b:0; AND LINE:
rmcgirr83/elonw 1 b:0;

in mySQL table: phpbb6n_extensions. Also I can not get past the PHP error above to ACP or site. All I got is FTP.

I can't even delete this ext form FTP, still gives same PHP error on entire domain.

So I created the directory the PHP error is asking for, and threw the listener.php in there.. now I get this:

Code: Select all


Fatal error: Class 'rmcgirr83\elonw\event\listener' not found in /home/example.com/forums/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/ContainerAwareEventDispatcher.php on line 145

*tears* Okay, I follwed the readme here: https://github.com/rmcgirr83/phpBB-3.1- ... lflags.git, and downloaded the zip. I can't login as I said to disable (if it got far as enabling, who knows), but I did delete everything under /nationalflags/ and upload the new folder structure. Still.. no change.

I just noticed, the zip github gave me is missing some of the files listed on the list.

Lastly, I deleted the two lines from mySQL table. And deleted the entire /rmcgirr83/ from /etx/ and I still got no site, no ACP. I'm going to sleep frustrated...

RMcGirr83 · by **RMcGirr83** » Sat Jul 16, 2016 1:23 am

Look at and read the error

/ext/rmcgirr83/elonw/event/listener.php

You deleted the files of the External Links open in new window extension. Upload the files from that extension and then see what happens.

It actually helps if you read and comprehend the errors that are displaying.

kaspir · by **kaspir** » Sat Jul 16, 2016 5:40 am

Thank you so much for the speeding reply! It shows you care! :wub:

I didn't delete anything before this error happened. I only deleted everything at last option last night.. because I couldn't think of anything to do to get my site back, and still CAN NOT! Even still, now that I deleted it all, I'm getting the same error, lol.

I'm not sure if you understand what I wrote, but there is NO dir named: /elonw/ within your ext file structure when downloaded. And I DID CREATE the path manually, and put the listener.php inside of it, I THEN shown you the new error it gave. (2nd one my last post) And even tho, it still says not found, it was there! And the error message had changed, so it read something.... so, please spare me when you advise to 'just read the errors'. I'm familiar how common that can be already!

-----------------

Okay, so now I will record step, by step what I do today:

I start where I left off, with everything that I removed yesterday.

1st off, I just reinsert the two rows I deleted form the TABLE, as they were like so:

2nd, I re-download a copy from this site: https://www.phpbb.com/customise/db/exte ... nal_flags/ and extract to desktop. Upload via FTP to /ext/ dir, and now file path for listener.php looks like this: forums/ext/rmcgirr83/nationalflags/event/listener.php and that was done as it supposed to be.
(refreshed my domain here, still the same 1st error in last post.)

3rd, I READ THE ERROR (more like stare at it in dis-belief now), and create the path
ext/rmcgirr83/elonw/event/ and copy the listener.php from /nationalflags/event/ to the new path I just created. NOW, I get this error:

Code: Select all

Fatal error: Class 'rmcgirr83\elonw\event\listener' not found in /forums/vendor/symfony/event-dispatcher/Symfony/Component/EventDispatcher/ContainerAwareEventDispatcher.php on line 145

4th, I now have a NEW error. I read it, and immediately notice there is no .php extension to the 'listener'. Why is that? So, I open the ContainerAwareEventDispatcher.php and find that line 145 is the function getSubscribedEvents()'. Like so:

Code: Select all

    public function addSubscriberService($serviceId, $class)
    {
        foreach ($class::getSubscribedEvents() as $eventName => $params) {
            if (is_string($params)) {
                $this->listenerIds[$eventName][] = array($serviceId, $params, 0);
            } elseif (is_string($params[0])) {
                $this->listenerIds[$eventName][] = array($serviceId, $params[0], isset($params[1]) ? $params[1] : 0);
            } else {
                foreach ($params as $listener) {
                    $this->listenerIds[$eventName][] = array($serviceId, $listener[0], isset($listener[1]) ? $listener[1] : 0);
                }
            }
        }
    }

I am not going to edit any phpbb board files. Just referencing.

5th, I purge my cache dir. Refresh the page, and NOW I GET A NEW ERROR! An SQL error, saying that 'phpbb6n_flags' doesn't exist [1146]' doesn't exist... okay, but it never did (cause I looked last night and again now, and I know for certain I only removed the two lines I stated).

kaspir · by **kaspir** » Sat Jul 16, 2016 6:57 am

Just to be clear, the files from github go to: ext/rmcgirr83/elonw/ AND the files form the extension you DL here go to: ext/rmcgirr83/nationalflags/ ??? Is that correct?

I'm kinda at a loss at to where files actually go anymore. There is the download link here, which is different from githubs development DL, then the master DLs are different as well. I'm more confused than when I started, lol.

I'll wait your response. I have much faith in you, more so than my own right now! HA!

//EDIT
Okay, so I can't wait when I got so many hours of free time ahead of me. I rearranged the uploads, getting this error now:

Code: Select all

Fatal error: Uncaught exception 'InvalidArgumentException' with message 'The file "ext/rmcgirr83/elonw/config/routing.yml" does not exist

WAIT A SEC.. do you overwrite the files from the development DLs, with the master DLs from github? Update. Nope. I don't think so, I've tried multiple possibilities.

Apologize for all the frustration, I gotta learn patience. I just hope to supply you with everything I know.

kaspir · by **kaspir** » Sat Jul 16, 2016 9:54 am

RMcGirr83 fixed me right up! Like poof, out of no where she appears like a multi-colored unicorn!

Thanks a bunch, don't know what you did, I just know the _flags DB never existed before you swooped in there and also uploaded it correctly, :facepalm:

Enjoy your beer, madam.

ext works great!

RMcGirr83 · by **RMcGirr83** » Sat Jul 16, 2016 11:03 am

I'm a guy and thanks for the beer

kaspir · by **kaspir** » Sat Jul 16, 2016 11:42 am

RMcGirr83 wrote:I'm a guy and thanks for the beer

My apologies.

phpBB • Free and Open Source Forum Software

National Flags

Problem with MYSQL - National Flags

Problem with MYSQL

Re: Problem with MYSQL

Re: Problem with MYSQL

Re: Problem with MYSQL

Re: Problem with MYSQL

Re: Problem with MYSQL

Re: Problem with MYSQL

Re: Problem with MYSQL

Re: Problem with MYSQL

advertisements