Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.

Messages - Pandos
301
Documentation / Re: PrettyURLs on nginx
« on February 1st, 2014, 02:03 AM »
I don't think so.
First rule should be enough....
302
Importing into Wedge / Re: Importer tool
« on January 31st, 2014, 04:08 PM »
Quote from Nao on January 31st, 2014, 02:45 PM
Pandos, I'm asking for the result of that query... not for the query itself... I'm not a SQL champ but I can still write those without help... I hope :lol:
Hope so too! :lol: :lol:
My answer was related to:
Quote from MultiformeIngegno on January 30th, 2014, 09:49 PM
Can someone help me with the query I need to run to show the value? Can't install phpmyadmin right now..
So I'm not so blind at all :)
303
Documentation / PrettyURLs on nginx
« on January 31st, 2014, 11:19 AM »
Setup PrettyURls for nginx is straight forward.
It's the same setup as for Wordpress.
Thanks to MultiformeIngegno
Code: [Select]
server {
   server_name .DOMAIN.TLD;
   index index.php;
   root /var/www/WEDGE_INSTALLATION_DIR;

   error_log /var/www/WEDGE_INSTALLATION_DIR/error.log;
   
   #Specify a charset
   charset utf-8;
   
   location / {
      try_files $uri $uri/ /index.php?$args;
   }

   location ~ \.php$ {
      try_files $uri =404;
      fastcgi_split_path_info ^(.+\.php)(/.+)$;
      fastcgi_read_timeout 180;
      include fastcgi.conf;
      fastcgi_pass unix:/var/run/php5-fpm.sock;
   }
   
   ## Deny dot files:
   location ~ /\. {
      deny all;
   }

   ## favicon.ico not found
   location = /favicon.ico {
      access_log off;
      log_not_found off;
   }

   ## robots.txt not found
   location = /robots.txt {
      access_log off;
      log_not_found off;
   }

}
304
Importing into Wedge / Re: MyBB Import
« on January 31st, 2014, 10:29 AM »
Quote from Bunstonious on January 31st, 2014, 03:55 AM


Fixed the first one by deleting the poll choices, other one not sure what's wrong but I think it times out after that.

Also, the boards all import but sub boards are just dumped in the main section and you can't see them in the list of "boards" available to move them.

Edit1: I also noticed that users don't get added to the "post count" positions.
As far as I can see there are two things that went wrong:
1. id_attach is autoincrement. So there are duplicate entries for different attachments?
2. Column count doesn't match means that there are 5 columns in wedge table, but e.g. your last line refers only two columns.
305
Importing into Wedge / Re: Importer tool
« on January 31st, 2014, 09:55 AM »
Quote from MultiformeIngegno on January 30th, 2014, 11:51 PM
Insert? I think Nao wanted to just know the values I had. So we can understand what caused wrong links.. Doesn't INSERT add something?
Sorry, was a hard day... :)
Code: [Select]
SELECT variable, value FROM wedge_settings WHERE variable LIKE 'smiley%';
306
The Pub / Re: What I LIKE in Wedge!
« on January 30th, 2014, 10:23 PM »
Quote from MultiformeIngegno on January 27th, 2014, 07:19 PM
Quote from Pandos on January 23rd, 2014, 06:15 PM
Quote from MultiformeIngegno on January 23rd, 2014, 05:46 PM
Nao you know at some point it will be needed that someone looks for the directive to make pURLS work on nginx too..? :D

Its market share now is almost 18%
Would you please give it a try?
Code: [Select]
location / { try_files $uri $uri/ /index.php; }
Yeah I was wrong, purls work just fine on nginx. "WordPress style" config works fine on wedge too :)
If needed here's my wedge config file:

Code: [Select]
server {

   server_name .DOMAIN.TLD;
   index index.php;
   root /var/www/WEDGE_INSTALLATION_DIR;

   error_log /var/www/WEDGE_INSTALLATION_DIR/error.log;
   
   #Specify a charset
   charset utf-8;
   
   location / {
      try_files $uri $uri/ /index.php?$args;
   }

   location ~ \.php$ {
      try_files $uri =404;
      fastcgi_split_path_info ^(.+\.php)(/.+)$;
      fastcgi_read_timeout 180;
      include fastcgi.conf;
      fastcgi_pass unix:/var/run/php5-fpm.sock;
   }
   
   ## Deny dot files:
   location ~ /\. {
      deny all;
   }
   
   # Deny access to apache .htaccess files
   location ~ /\.ht {
      deny all;
   }

   ## favicon.ico not found
   location = /favicon.ico {
      access_log off;
      log_not_found off;
   }

   ## robots.txt not found
   location = /robots.txt {
      access_log off;
      log_not_found off;
   }
}
I should make this a topic in documentation before it gets lost...
307
Importing into Wedge / Re: Importer tool
« on January 30th, 2014, 10:21 PM »
Quote from MultiformeIngegno on January 30th, 2014, 09:49 PM
Quote from Nao on January 30th, 2014, 07:41 PM
Quote from MultiformeIngegno on January 30th, 2014, 01:25 AM
the dots are in the url, I just changed the domain.tld part
What's the value of $settings['smileys_dir'] and 'smileys_url' in the {db_prefix}settings table..?
Can someone help me with the query I need to run to show the value? Can't install phpmyadmin right now..
You mean for wedge?
Please change path and URL!
Code: [Select]
INSERT INTO `wedge_settings` VALUES ('smileys_dir','/***YOUR***PATH***TO***WEDGE/assets/smileys'),('smileys_url','http://***YOUR***URL***/wedge/assets/smileys'),('smiley_sets_default','default'),('smiley_sets_known','default,aaron'),('smiley_sets_names','Alienine\'s Set\nAaron\'s Set');
308
Importing into Wedge / Re: Database permissions
« on January 29th, 2014, 11:57 PM »
Quote from MultiformeIngegno on January 29th, 2014, 09:25 PM
So, I have SMF installed in the same VPS of Wedge. They are on 2 different databases run by (respectively) say smfuser and wedgeuser (same mysql server).
Both smfuser and wedgeuser have GRANT ALL privileges on their respective databases (say smfdb and wedgedb).

To be sure Wedge Importer had the right permissions to access the SMF database I run:
Code: [Select]
GRANT ALL PRIVILEGES ON smfdb.* To 'wedgeuser'@'localhost' IDENTIFIED BY 'wedgeuserPASSWORD';

I still get this..:
Quote
Sorry, the database connection information used in the specified installation of Wedge cannot access the installation of %1. This may either mean that the installation doesn't exist, or that the MySQL account used does not have permissions to access it.

The error MySQL gave was: 'SELECT command denied to user 'wedgeuser'@'localhost' for table 'smf_members'
Posted: January 29th, 2014, 09:20 PM

Updated the post to be more clear.. reload page :P
Did you do the following?:
Code: [Select]
flush privileges;
Please run the following statement and post the output:
Code: [Select]
select host, user from user;
309
Archived fixes / Re: Wedge submits reply on mobile
« on January 29th, 2014, 11:40 PM »
ββ
Test with Wireless Skin.
Android  4.1.2, App: Chrome 32.0.1700.99
Can't reproduce
310
Archived fixes / Re: Wedge submits reply on mobile
« on January 29th, 2014, 10:21 PM »
Quote from Nao on January 29th, 2014, 10:17 PM
Quote from Pandos on January 29th, 2014, 08:45 PM
Sorry, can't reproduce. Using Android with Chrome.
How come your ββββββ post doesn't have the Android icon next to it, then..? :-/

Also, could writing a 'β' simply be associated with typing Alt+S or maybe CtrlGr+S on a German keyboard? β is like 'ss', right..?
It's postet from my ASUS Fonepad with Chrome. Don't know why it's missing the icon...
ß is like ss right!
Will try it later on wireless skin. Posting was from Wilde. :)

311
Archived fixes / Re: Wedge submits reply on mobile
« on January 29th, 2014, 08:45 PM »
Sorry, can't reproduce. Using Android with Chrome.
Are you on default skin or wireless?
312
Archived fixes / Re: Wedge submits reply on mobile
« on January 29th, 2014, 08:43 PM »
ββββββ

313
Archived fixes / Re: Wedge submits reply on mobile
« on January 29th, 2014, 08:31 PM »
Thank you for reporting.
Will look if I can reproduce it.
314
Archived fixes / Re: Twice in online list?
« on January 29th, 2014, 07:00 PM »
Hmm.. strange.
Now I'm online with Chrome and IE. But I'm once in the list.
Perhaps it's the first point you mentioned :)
315
Archived fixes / Twice in online list?
« on January 29th, 2014, 04:45 PM »
OK, I'm not into alcohol, but I see Norodo twice?