https://www.posetteforever.com/viewtopic.php?f=11&t=2716
-----------------------------------
Tormie
Monday, 26 March 2007, 07:33 PM

Database moved
-----------------------------------
Hi friends  :notworthy: , I was bored of the slowness that sometimes affects the site so I decided to move the database on another server. The database of Posetteforever is not on a machine that has only its database, but there are many databases on the same PC. I suppose that something on that PC is slowing all the database, like a forum not working wll, so I create another database on a different PC hoping that this one runs better. This problem has occurred again in the past and probably will occur again in the future. If you notice periods of slowness of the site in a period, for example a week, please contact me and I'll do the same. I hope that the transfer went well, if you see something strange contact me as well  :wink: 

Tormie


-----------------------------------
JanReinar
Monday, 26 March 2007, 07:47 PM

Re: Database moved
-----------------------------------
All looks more fast Davide!  :notworthy: You really improve the speed!


-----------------------------------
GrouchoCaesar
Monday, 26 March 2007, 10:11 PM

Re: Database Moved
-----------------------------------
Ahhh, the things you do for us, sir. Much appreciated.


-----------------------------------
ahjah
Monday, 26 March 2007, 11:21 PM

Re: Database moved
-----------------------------------
:thumb: Good job! Works good so far :grin:


-----------------------------------
ahjah
Tuesday, 27 March 2007, 03:54 AM

Re: Database moved
-----------------------------------
:mmmh:  When clicking the statistics, there's:

"Warning: filemtime(): Stat failed for ./includes/stat_modules/average_posts_per_user/info.txt (errno=2 - No such file or directory) in /home/content/t/o/r/tormentor/html/includes/functions_stats.php on line 50

Warning: filemtime(): Stat failed for ./includes/stat_modules/average_posts_per_user/info.txt (errno=2 - No such file or directory) in /home/content/t/o/r/tormentor/html/includes/functions_stats.php on line 116"

and:

"Could not update Info Cache

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE module_id = 2' at line 4

UPDATE phpbb_stats_modules SET module_info_cache = 'a:2:{s:16:"condition_result";b:;s:19:"default_update_time";i:0;}', module_info_time = WHERE module_id = 2

Line : 121
File : functions_stats.php"

An old file path left somewhere, maybe :mmmh:


-----------------------------------
Tormie
Tuesday, 27 March 2007, 08:54 AM

Re: Database moved
-----------------------------------
:mmmh:  :mmmh:  :mmmh: I'll check soon ! Now time for errands :crybaby:


-----------------------------------
Tormie
Tuesday, 27 March 2007, 09:00 AM

Re: Database moved
-----------------------------------
It's ok now :) But it was strange : :mmmh:  :mmmh:  :mmmh: Thank you Andreas :hug2:


-----------------------------------
ahjah
Tuesday, 27 March 2007, 12:56 PM

Re: Database moved
-----------------------------------
:)  :thumb: