Jump to content

To move on another server


Recommended Posts

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

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

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

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

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

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

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

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

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

Archived

This topic is now archived and is closed to further replies.

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...