WanWizard

a.k.a. WanWizard

Query builder subquery in join?
What is the exact SQL that is generated using that syntax?

Comment by WanWizard October 2016 permalink
Query builder subquery in join?
https://github.com/fuel/core/commit/f1db7c9a8b27cd2afd6ceb223909610bfebf8902 Now all three options work: subqueries, and DB::expr() with and without brackets.

Comment by WanWizard October 2016 permalink
Query builder subquery in join?
Ah, but you added the brackets, and the TS didn't, so that is why it didn't work for you. Good to know this is being used, because I've implemented DB::expr() explicitly, which would break your code because it would add brackets agai…

Comment by WanWizard October 2016 permalink
Query builder subquery in join?
Have you managed to test this solution yet?

Comment by WanWizard October 2016 permalink
Query builder subquery in join?
Is not supported at the moment. If you are on 1.9/develop, you can try to replace L#123 in /core/classes/database/query/builder/join.php by this: if ($this->_table instanceof \Database_Query_Builder_Select) { // Comp…

Comment by WanWizard October 2016 permalink
Remove EAV properties from DB?
Unset is the way to do it. But with all changes to the model, you need to save the model to save it's changes, and that includes EAV data.

Comment by WanWizard October 2016 permalink
Error with email packaging
Maybe you have an intermittent problem, with a poor response from the mailserver. Can you write $data to a logfile, and check the logfile when you have an exception? Then you could see exacty which response is causing it to fail.

Comment by WanWizard October 2016 permalink
Error with email packaging
Yeah, so that works as advertised. So what is the problem then?

Comment by WanWizard October 2016 permalink
Error with email packaging
Then why does smtp_get_response() not return the "220" in your case? https://github.com/fuel/email/blob/1.9/develop/classes/email/driver/smtp.php#L335 should strip the first 3 characters from the response and return that, could you do som…

Comment by WanWizard October 2016 permalink
Error with email packaging
The normal response from a mailserver is: Trying 149.202.16.145... Connected to mail.flexcoders.co.uk. Escape character is '^]'. 220 mail.flexcoders.co.uk ESMTP Postfix EHLO example.org 250-mail.flexcoders.co.uk

Comment by WanWizard October 2016 permalink
Error with email packaging
Without a number in front of it? What is this for mailserver? Do you know? That looks like a Microsoft Exchange server, but that should reply "220 mail.example.com Microsoft SMTP MAIL Service ready at Wed 5 Oct 2016 17:23:00 +0100"

Comment by WanWizard October 2016 permalink
Error with email packaging
There seems to be clearly something wrong with it, as it doesn't send any response to commands. You might want to add some debugging to smtp_get_response() to log exactly what the server responds to each command. And as it is not public, cou…

Comment by WanWizard October 2016 permalink
version 2
Don't ask me... ;-)

Comment by WanWizard October 2016 permalink
Error with email packaging
Which mailserver are you communicating with? Is that a public one I can test with?

Comment by WanWizard October 2016 permalink
version 2
That is a repeat of your previous post?

Comment by WanWizard October 2016 permalink
version 2
More DB drivers were being developed by Fuel users (Postgresql, MSSQL and Informix), I believe you yourself were one of them. But we never saw a contribution, or a question for help. The problem is that you need to have these environments, and some …

Comment by WanWizard October 2016 permalink
version 2
I'm afraid you'll have to wait for quite a bit more. I have severe health problems which makes me spend most of my time in bed, unable to do virtually anything for more than an hour a day, time which I spend bugfixing and optimizing v1. S…

Comment by WanWizard October 2016 permalink
Error with email packaging
When an email client sends the SMTP command "QUIT", the server should return with "221 Bye" or some other text before closing the connection. The Email class expects that, but appearently there are mailservers (qmail is an exampl…

Comment by WanWizard October 2016 permalink
Conflicting queries
Ah, wait, I think I see what you mean. Your first query uses select(). Although you can do that, you should NOT use it in normal circumstances, the ORM is not a query builder. ORM objects are cached for performance, your first query creates the p…

Comment by WanWizard September 2016 permalink
Conflicting queries
Can you be more specific? I can see three queries in that code, what do you mean by "both"?

Comment by WanWizard September 2016 permalink
Session problem with upgrade 1.7.3 to 1.8
Ok, thanks. We'll post the release of the hostfix on Twitter and Facebook.

Comment by WanWizard September 2016 permalink
Session problem with upgrade 1.7.3 to 1.8
Are you using native session emulation by any chance? Because there were some fixes there recently. We'll backport the 1.9/dev fixes to a new 1.8.0.x hotfix soon, so whatever this issue was, that would solve it.

Comment by WanWizard September 2016 permalink
Session problem with upgrade 1.7.3 to 1.8
If you need code completion, place https://gist.github.com/ryu-blacknd/3283072 in the root of your project (and in .gitignore). It's a few years old, so you might have to add one or two missing ones, but it fixes your problem. As to the sessi…

Comment by WanWizard September 2016 permalink
Session problem with upgrade 1.7.3 to 1.8
p.s. NEVER use direct references to \Fuel\Core classes! Always use the aliased version, otherwise core class extensions will go very wrong...

Comment by WanWizard September 2016 permalink
Session problem with upgrade 1.7.3 to 1.8
I can't reproduce it. I took a new install (1.9/dev), replaced the welcome controller with this: public function action_index() { \Session::delete('user_id'); \Response::redirect('/welcome/test1'); …

Comment by WanWizard September 2016 permalink

More Comments

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

About

Username: WanWizard
Joined: January 2011
Visits: 2,368
Last Active: 11:45PM
Roles: Administrator

FuelPHP Forums

Ask your question about FuelPHP in the appropriate forum, or help others by answering their questions.

WanWizard

Howdy, Stranger!

About