Photo Club Paris Posted November 14, 2016 Share Posted November 14, 2016 Hi, I would like to move IPS to another server. I have install mysql & PHP. I have runninp ips4.php to check my system and it's OK. I copy /var/www/html/* from a new server and dump/restore my database. I change conf_global.php with the new Mysql. But i have an error and i don't understand: [Mon Nov 14 15:42:16.553996 2016] [:error] [pid 5996] [client 164.177.14.49:56071] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 262112 bytes) in /var/www/html/forum/system/Log/Log.php on line 135 My server have 8Go and i configure php.ini with 512MB Thank Stephane Link to comment Share on other sites More sharing options...
AnnieLeonheart Posted November 14, 2016 Share Posted November 14, 2016 Increase memory_limit to 1024MB or 2048MB and see if it works. Link to comment Share on other sites More sharing options...
Photo Club Paris Posted November 14, 2016 Author Share Posted November 14, 2016 I have the same error: [Mon Nov 14 16:41:30.066210 2016] [:error] [pid 6333] [client 164.177.14.49:56989] PHP Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 262112 bytes) in /var/www/html/forum/system/Log/Log.php on line 135 root@lux:/var/log/apache2# php -i |grep memory memory_limit => 1024M => 1024M Link to comment Share on other sites More sharing options...
Adlago Posted November 14, 2016 Share Posted November 14, 2016 Remove all files from the directory 'datastore' and check again for this error Link to comment Share on other sites More sharing options...
TDBF Posted November 14, 2016 Share Posted November 14, 2016 8 hours ago, Photo Club Paris said: Hi, I would like to move IPS to another server. I have install mysql & PHP. I have runninp ips4.php to check my system and it's OK. I copy /var/www/html/* from a new server and dump/restore my database. I change conf_global.php with the new Mysql. But i have an error and i don't understand: [Mon Nov 14 15:42:16.553996 2016] [:error] [pid 5996] [client 164.177.14.49:56071] PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 262112 bytes) in /var/www/html/forum/system/Log/Log.php on line 135 My server have 8Go and i configure php.ini with 512MB Thank Stephane I don't think this is a memory issue as 515mb should be more than ample to run IPS software. Sounds like you have an infinite loop error somewhere, this will increase the amount of memory used on each loop recursion until PHP runs out of memory. Only increase the amount of memory until you can get the script running again and return it to your original value after you fix the issue. I would suggest that you upload all your files , check for white space on the end of your PHP files and clear out any cache (as suggested by Adlago above). If you cannot get into your site to disable applications and widgets, I would suggest doing this via your database (MyPHPAdmin) as a temporary measure. If you don't feel comfortable doing this, I would suggest that you contact support for help to get your site moved over and up and running. Link to comment Share on other sites More sharing options...
Photo Club Paris Posted November 15, 2016 Author Share Posted November 15, 2016 I have progress in my error. The .htaccess was fault. I set the .htaccess and now /calendar/ and /discover/ it's OK but the home it's fault, i have error: .htaccess <IfModule mod_rewrite.c> Options -MultiViews RewriteEngine On RewriteBase / RewriteCond %{REQUEST_FILENAME} !-f RewriteRule \.(js|css|jpeg|jpg|gif|png|ico|map)(\?|$) /404error.php [L,NC] RewriteCond %{REQUEST_FILENAME} !-f RewriteCond %{REQUEST_FILENAME} !-d RewriteRule . /index.php [L] </IfModule> Error: La page lux.forumphotoparis.fr ne fonctionne pas Impossible de traiter cette demande via lux.forumphotoparis.fr à l'heure actuelle. HTTP ERROR 500 apachelog: ==> error.log <== [Tue Nov 15 09:07:58.882499 2016] [:error] [pid 10435] [client 164.177.14.49:60403] PHP Fatal error: Allowed memory size of 1073741824 bytes exhausted (tried to allocate 1140892 bytes) in /var/www/html/forum/system/Log/Log.php on line 135 ==> access.log <== 164.177.14.49 - - [15/Nov/2016:09:07:35 +0100] "GET / HTTP/1.1" 500 313 "-" "Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/54.0.2840.99 Safari/537.36" Link to comment Share on other sites More sharing options...
Adlago Posted November 15, 2016 Share Posted November 15, 2016 Could your server (Apache/2.4.10) don't support MultiViews Remove Options -MultiViews from htaccess and try again Link to comment Share on other sites More sharing options...
Photo Club Paris Posted November 15, 2016 Author Share Posted November 15, 2016 it's already KO I have activated rewrite log: ==> error.log <== [Tue Nov 15 10:26:43.362571 2016] [rewrite:trace3] [pid 15079] mod_rewrite.c(475): [client 164.177.14.49:62465] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7fe2fd34a5c8][rid#7fe2fd2860a0/subreq] [perdir /var/www/html/forum/] strip per-dir prefix: /var/www/html/forum/index.pl -> index.pl [Tue Nov 15 10:26:43.362577 2016] [rewrite:trace3] [pid 15079] mod_rewrite.c(475): [client 164.177.14.49:62465] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7fe2fd34a5c8][rid#7fe2fd2860a0/subreq] [perdir /var/www/html/forum/] applying pattern '.' to uri 'index.pl' [Tue Nov 15 10:26:43.362587 2016] [rewrite:trace2] [pid 15079] mod_rewrite.c(475): [client 164.177.14.49:62465] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7fe2fd34a5c8][rid#7fe2fd2860a0/subreq] [perdir /var/www/html/forum/] rewrite 'index.pl' -> '/index.php' [Tue Nov 15 10:26:43.362594 2016] [rewrite:trace2] [pid 15079] mod_rewrite.c(475): [client 164.177.14.49:62465] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7fe2fd34a5c8][rid#7fe2fd2860a0/subreq] [perdir /var/www/html/forum/] trying to replace prefix /var/www/html/forum/ with / [Tue Nov 15 10:26:43.362600 2016] [rewrite:trace1] [pid 15079] mod_rewrite.c(475): [client 164.177.14.49:62465] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7fe2fd34a5c8][rid#7fe2fd2860a0/subreq] [perdir /var/www/html/forum/] internal redirect with /index.php [INTERNAL REDIRECT] [Tue Nov 15 10:26:43.362624 2016] [rewrite:trace3] [pid 15079] mod_rewrite.c(475): [client 164.177.14.49:62465] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7fe2fd34a5c8][rid#7fe2fd2840a0/subreq] [perdir /var/www/html/forum/] strip per-dir prefix: /var/www/html/forum/index.php -> index.php [Tue Nov 15 10:26:43.362631 2016] [rewrite:trace3] [pid 15079] mod_rewrite.c(475): [client 164.177.14.49:62465] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7fe2fd34a5c8][rid#7fe2fd2840a0/subreq] [perdir /var/www/html/forum/] applying pattern '\\.(js|css|jpeg|jpg|gif|png|ico|map)(\\?|$)' to uri 'index.php' [Tue Nov 15 10:26:43.362638 2016] [rewrite:trace3] [pid 15079] mod_rewrite.c(475): [client 164.177.14.49:62465] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7fe2fd34a5c8][rid#7fe2fd2840a0/subreq] [perdir /var/www/html/forum/] strip per-dir prefix: /var/www/html/forum/index.php -> index.php [Tue Nov 15 10:26:43.362644 2016] [rewrite:trace3] [pid 15079] mod_rewrite.c(475): [client 164.177.14.49:62465] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7fe2fd34a5c8][rid#7fe2fd2840a0/subreq] [perdir /var/www/html/forum/] applying pattern '.' to uri 'index.php' [Tue Nov 15 10:26:43.362653 2016] [rewrite:trace1] [pid 15079] mod_rewrite.c(475): [client 164.177.14.49:62465] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7fe2fd34a5c8][rid#7fe2fd2840a0/subreq] [perdir /var/www/html/forum/] pass through /var/www/html/forum/index.php Link to comment Share on other sites More sharing options...
Adlago Posted November 15, 2016 Share Posted November 15, 2016 Your favcion.ico don't here .../forum/favicon.ico But http://lux.forumphotoparis.fr/favicon.ico work perfectly Chech your FURLs Link to comment Share on other sites More sharing options...
Photo Club Paris Posted November 15, 2016 Author Share Posted November 15, 2016 I dont' understand, my documentRoot is /var/ww/html/forum: http://lux.forumphotoparis.fr -> /var/www/html/forum <VirtualHost *:80> ServerName lux.forumphotoparis.fr ServerAdmin contact@forumphotoparis.fr DocumentRoot /var/www/html/forum LogLevel alert rewrite:trace3 ErrorLog ${APACHE_LOG_DIR}/error.log CustomLog ${APACHE_LOG_DIR}/access.log combined <Directory /var/www/html/forum> Options Indexes FollowSymLinks AllowOverride All Order allow,deny allow from all </Directory> </VirtualHost> My favicon is in documentRoot /var/www/html/forum/ forum@lux:~/forum$ pwd /var/www/html/forum forum@lux:~/forum$ ls favicon.ico favicon.ico ==> error.log <== [Tue Nov 15 10:56:30.710428 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719bb0a0/initial] [perdir /var/www/html/forum/] strip per-dir prefix: /var/www/html/forum/ -> [Tue Nov 15 10:56:30.710571 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719bb0a0/initial] [perdir /var/www/html/forum/] applying pattern '\\.(js|css|jpeg|jpg|gif|png|ico|map)(\\?|$)' to uri '' [Tue Nov 15 10:56:30.710606 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719bb0a0/initial] [perdir /var/www/html/forum/] strip per-dir prefix: /var/www/html/forum/ -> [Tue Nov 15 10:56:30.710614 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719bb0a0/initial] [perdir /var/www/html/forum/] applying pattern '.' to uri '' [Tue Nov 15 10:56:30.710621 2016] [rewrite:trace1] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719bb0a0/initial] [perdir /var/www/html/forum/] pass through /var/www/html/forum/ [Tue Nov 15 10:56:30.710752 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b30a0/subreq] [perdir /var/www/html/forum/] strip per-dir prefix: /var/www/html/forum/index.html -> index.html [Tue Nov 15 10:56:30.710763 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b30a0/subreq] [perdir /var/www/html/forum/] applying pattern '\\.(js|css|jpeg|jpg|gif|png|ico|map)(\\?|$)' to uri 'index.html' [Tue Nov 15 10:56:30.710771 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b30a0/subreq] [perdir /var/www/html/forum/] strip per-dir prefix: /var/www/html/forum/index.html -> index.html [Tue Nov 15 10:56:30.710948 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b30a0/subreq] [perdir /var/www/html/forum/] applying pattern '.' to uri 'index.html' [Tue Nov 15 10:56:30.710969 2016] [rewrite:trace2] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b30a0/subreq] [perdir /var/www/html/forum/] rewrite 'index.html' -> '/index.php' [Tue Nov 15 10:56:30.710977 2016] [rewrite:trace2] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b30a0/subreq] [perdir /var/www/html/forum/] trying to replace prefix /var/www/html/forum/ with / [Tue Nov 15 10:56:30.710998 2016] [rewrite:trace1] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b30a0/subreq] [perdir /var/www/html/forum/] internal redirect with /index.php [INTERNAL REDIRECT] [Tue Nov 15 10:56:30.711048 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b10a0/subreq] [perdir /var/www/html/forum/] strip per-dir prefix: /var/www/html/forum/index.cgi -> index.cgi [Tue Nov 15 10:56:30.711056 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b10a0/subreq] [perdir /var/www/html/forum/] applying pattern '\\.(js|css|jpeg|jpg|gif|png|ico|map)(\\?|$)' to uri 'index.cgi' [Tue Nov 15 10:56:30.711063 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b10a0/subreq] [perdir /var/www/html/forum/] strip per-dir prefix: /var/www/html/forum/index.cgi -> index.cgi [Tue Nov 15 10:56:30.711069 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b10a0/subreq] [perdir /var/www/html/forum/] applying pattern '.' to uri 'index.cgi' [Tue Nov 15 10:56:30.711077 2016] [rewrite:trace2] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b10a0/subreq] [perdir /var/www/html/forum/] rewrite 'index.cgi' -> '/index.php' [Tue Nov 15 10:56:30.711084 2016] [rewrite:trace2] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b10a0/subreq] [perdir /var/www/html/forum/] trying to replace prefix /var/www/html/forum/ with / [Tue Nov 15 10:56:30.711090 2016] [rewrite:trace1] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b10a0/subreq] [perdir /var/www/html/forum/] internal redirect with /index.php [INTERNAL REDIRECT] [Tue Nov 15 10:56:30.711119 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b30a0/subreq] [perdir /var/www/html/forum/] strip per-dir prefix: /var/www/html/forum/index.pl -> index.pl [Tue Nov 15 10:56:30.711126 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b30a0/subreq] [perdir /var/www/html/forum/] applying pattern '\\.(js|css|jpeg|jpg|gif|png|ico|map)(\\?|$)' to uri 'index.pl' [Tue Nov 15 10:56:30.711133 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b30a0/subreq] [perdir /var/www/html/forum/] strip per-dir prefix: /var/www/html/forum/index.pl -> index.pl [Tue Nov 15 10:56:30.711157 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b30a0/subreq] [perdir /var/www/html/forum/] applying pattern '.' to uri 'index.pl' [Tue Nov 15 10:56:30.711168 2016] [rewrite:trace2] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b30a0/subreq] [perdir /var/www/html/forum/] rewrite 'index.pl' -> '/index.php' [Tue Nov 15 10:56:30.711174 2016] [rewrite:trace2] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b30a0/subreq] [perdir /var/www/html/forum/] trying to replace prefix /var/www/html/forum/ with / [Tue Nov 15 10:56:30.711180 2016] [rewrite:trace1] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b30a0/subreq] [perdir /var/www/html/forum/] internal redirect with /index.php [INTERNAL REDIRECT] [Tue Nov 15 10:56:30.711211 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b10a0/subreq] [perdir /var/www/html/forum/] strip per-dir prefix: /var/www/html/forum/index.php -> index.php [Tue Nov 15 10:56:30.711219 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b10a0/subreq] [perdir /var/www/html/forum/] applying pattern '\\.(js|css|jpeg|jpg|gif|png|ico|map)(\\?|$)' to uri 'index.php' [Tue Nov 15 10:56:30.711226 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b10a0/subreq] [perdir /var/www/html/forum/] strip per-dir prefix: /var/www/html/forum/index.php -> index.php [Tue Nov 15 10:56:30.711231 2016] [rewrite:trace3] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b10a0/subreq] [perdir /var/www/html/forum/] applying pattern '.' to uri 'index.php' [Tue Nov 15 10:56:30.711239 2016] [rewrite:trace1] [pid 15483] mod_rewrite.c(475): [client 164.177.14.49:63546] 164.177.14.49 - - [lux.forumphotoparis.fr/sid#7f4c71a775c8][rid#7f4c719b10a0/subreq] [perdir /var/www/html/forum/] pass through /var/www/html/forum/index.php ==> access.log <== 164.177.14.49 - - [15/Nov/2016:10:56:30 +0100] "GET / HTTP/1.1" 500 392 "-" "Mozilla/5.0 (Windows NT 10.0; WOW64; rv:49.0) Gecko/20100101 Firefox/49.0" Link to comment Share on other sites More sharing options...
GriefCode Posted November 15, 2016 Share Posted November 15, 2016 @Photo Club Paris you may wanna hide these ips. The forum is limited by require a login but this is still public... Link to comment Share on other sites More sharing options...
Photo Club Paris Posted November 15, 2016 Author Share Posted November 15, 2016 I don't want to hide. I just test my new hosted before the real migration friday. Link to comment Share on other sites More sharing options...
Adlago Posted November 15, 2016 Share Posted November 15, 2016 Check whether your application Forums is the default application PP. Whether you remove all files from your directory datastore? Link to comment Share on other sites More sharing options...
Photo Club Paris Posted November 15, 2016 Author Share Posted November 15, 2016 I have check and remove files in datastore but i have the same problems Link to comment Share on other sites More sharing options...
Adlago Posted November 15, 2016 Share Posted November 15, 2016 Making experiment - do APP Calendar your default application. Link to comment Share on other sites More sharing options...
Photo Club Paris Posted November 15, 2016 Author Share Posted November 15, 2016 I have test, the default pge calendar is OK. I have the realy probleme with the module Forum. I wiil test to copy to prod server. prehaps i have forget a file or directory. Link to comment Share on other sites More sharing options...
Adlago Posted November 15, 2016 Share Posted November 15, 2016 It may want to download your directories from old server and upload them again to a new server. applications and system Link to comment Share on other sites More sharing options...
Photo Club Paris Posted November 16, 2016 Author Share Posted November 16, 2016 Hi @Adlago, I have migrate my site on the new server. I have the problem the home forum not view but i have the link on topic it's OK : http://www.forumphotoparis.fr/topic/6499-cadavérique/ The other page it's OK: http://www.forumphotoparis.fr/calendar/, http://www.forumphotoparis.fr/staff/ I have copy all files and dump/restore database. Link to comment Share on other sites More sharing options...
Adlago Posted November 16, 2016 Share Posted November 16, 2016 I've seen that all your pages work correctly. Only the home page is a problem. I wrote to make APP Calendar - default APP. Please do it - for me to do tests. Link to comment Share on other sites More sharing options...
Photo Club Paris Posted November 16, 2016 Author Share Posted November 16, 2016 APP calendar is default, it's OK, but the APP forum ot work Link to comment Share on other sites More sharing options...
Adlago Posted November 16, 2016 Share Posted November 16, 2016 I saw. Back forums. FURLs correct. Link to comment Share on other sites More sharing options...
Photo Club Paris Posted November 16, 2016 Author Share Posted November 16, 2016 i back to forum default. in log uploads/logs/2016_11_16_sql.php Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'forum.core_attachments.attach_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by SELECT core_attachments.*, core_members.*, core_attachments_map.*, forums_posts.*, forums_topics.* FROM `core_attachments` LEFT JOIN `core_members` ON core_attachments.attach_member_id=core_members.member_id LEFT JOIN `core_attachments_map` ON core_attachments_map.attachment_id=core_attachments.attach_id LEFT JOIN `forums_posts` ON forums_posts.pid=core_attachments_map.id2 LEFT JOIN `forums_topics` ON forums_topics.forum_id IN (56,77,40,53,69,78,63,64,65,66,67,68,70,30,31,72,73,74,75) AND forums_posts.topic_id=forums_topics.tid AND forums_topics.forum_id NOT IN (12,30,31,40,45,50,51,54,55,56,60,62,69,70,71,72,73,74,75,76,77,78,79) LEFT JOIN `core_permission_index` ON core_permission_index.app='forums' AND core_permission_index.perm_type='forum' AND core_permission_index.perm_type_id=forums_topics.forum_id WHERE core_attachments.attach_img_height > 250 AND core_attachments.attach_img_width > 250 AND core_attachments.attach_is_image=1 AND core_attachments_map.location_key='forums_Forums' AND core_attachments.attach_is_archived=0 AND forums_posts.queued=0 AND forums_topics.approved=1 AND forums_posts.new_topic=1 GROUP BY `id2` ORDER BY core_attachments.attach_date DESC LIMIT 0,10 Link to comment Share on other sites More sharing options...
Adlago Posted November 16, 2016 Share Posted November 16, 2016 Try this ACP - Support - mark 'Something isn't working correctly.' - Continue This remove cache. Then continue to click 'The problem is not resolved' Write what result Link to comment Share on other sites More sharing options...
Photo Club Paris Posted November 16, 2016 Author Share Posted November 16, 2016 I have found. My Mysql Databse it's configure to: mysql> SELECT @@sql_mode; +-------------------------------------------------------------------------------------------------------------------------------------------+ | @@sql_mode | +-------------------------------------------------------------------------------------------------------------------------------------------+ | ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION | +-------------------------------------------------------------------------------------------------------------------------------------------+ I have config to: mysql> SELECT @@sql_mode; +-------------------------------------------------------------------------------------------------------------------------------------------+ | @@sql_mode | +-------------------------------------------------------------------------------------------------------------------------------------------+ | | +-------------------------------------------------------------------------------------------------------------------------------------------+ Thank you veru much @Adlago for your help. Link to comment Share on other sites More sharing options...
Adlago Posted November 17, 2016 Share Posted November 17, 2016 1 minute ago, Photo Club Paris said: Thank you veru much @Adlago for your help. Glad that you will sleep peacefully. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.