Jump to content

jeff8j

Members
  • Content Count

    222
  • Joined

  • Last visited

Community Reputation

0 Neutral

About jeff8j

  • Rank
    Advanced Member

Contact Methods

  • Website URL
    http://www.centrexity.com

Profile Information

  • Gender
    Not Telling
  1. That was it! I thought it was something more complicated I didnt make these sql statements im just converting a script so didnt have any say in the or Thank you guys!
  2. @Jacques1 would that be more efficient? Also did you format that by hand or use a tool? I came across another one that throws something into the mix I dont know anything about the LEFT JOIN SELECT `or`.order_recurring_id, `or`.order_id, `or`.reference, `or`.`status`, `or`.`date_added`, CONCAT(`o`.firstname, ' ', `o`.lastname) AS customer FROM `order_recurring` `or` LEFT JOIN `order` `o` ON (`or`.order_id = `o`.order_id) ORDER BY or.order_recurring_id DESC LIMIT 0,20 Query Error: near "or": syntax error Unable to execute statement Im assuming its the first `or` where the error is but it looks good to me (is there a way to tell where a sqlite error occured? like character count or something)
  3. Took some trys but I think that might just have been the issue SELECT a.key, a.data, a.date_added FROM (SELECT ('customer_' || ca.key) AS `key`, ca.data, ca.date_added FROM `customer_activity` ca UNION SELECT ('affiliate_' || aa.key) AS `key`, aa.data, aa.date_added FROM `affiliate_activity` aa) a ORDER BY a.date_added DESC LIMIT 0,5 That looks like it works! Thanks so much!
  4. I have been converting mysql to sqlite and for basic queries have had good success but I ran across this one I can figure out how to convert its a bit over my head can someone help SELECT a.key, a.data, a.date_added FROM ((SELECT ('customer_' || ca.key) AS `key`, ca.data, ca.date_added FROM `customer_activity` ca) UNION (SELECT ('affiliate_' || aa.key) AS `key`, aa.data, aa.date_added FROM `affiliate_activity` aa)) a ORDER BY a.date_added DESC LIMIT 0,5 I get this error Query Error: near "UNION": syntax error Unable to execute statement Thanks
  5. I figured it out! It was php was set to only have 5 servers and I was going over that so I guess they were pooling up I made it so it can do more and problem solved!
  6. I added this to the apache.conf <Directory /usr/lib/cgi-bin> Require all granted </Directory> and I think that gets me a bit further but now it sits there for a long time and gives a 500 error in the apache error log I see [Thu Aug 11 07:45:13.043220 2016] [fastcgi:error] [pid 11579:tid 139675982276352] [client 71.1.15.53:50752] FastCGI: comm with server "/usr/lib/cgi-bin/php7-fcgi" aborted: idle timeout (30 sec) [Thu Aug 11 07:45:13.043247 2016] [fastcgi:error] [pid 11579:tid 139675982276352] [client 71.1.15.53:50752] FastCGI: incomplete headers (0 bytes) received from server "/usr/lib/cgi-bin/php7-fcgi" not sure what to do now
  7. I am trying to get mpm with php7 going I have apache in worker mode now and in my apache.conf I have this <IfModule mod_fastcgi.c> AddHandler php7-fcgi .php Action php7-fcgi /php7-fcgi Alias /php7-fcgi /usr/lib/cgi-bin/php7-fcgi FastCgiExternalServer /usr/lib/cgi-bin/php7-fcgi -socket /var/run/php/php7.0-fpm.sock -pass-header Authorization </IfModule> when I load a page it says ForbiddenYou don't have permission to access /php7-fcgi/test.php on this server. Its following the alias path and im not sure what this is do I have to set it manually to the absolute path for each virtual host? is there a way I can make it work across the board? Thanks
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.