new year problem

[cioop]

Hi,
I imported php-res from my test server onto the 'proper" one and right after new year's eve, php-res pompts me to add 2007 to the database.
I added it and it I can see it via phpmyadmin, however the prompt re-appears when I try to login again after deleting cookies.
On the ather hand, even if I don't add 2007 for the 2nd or 3rd time it is still visible in the calendar when I turn in inizio.php

Code: Select all

$show_bar = "YES";

So it seems as there was a problem with selecting the 2007 year from mysql database right after logging into php-res.
What is even more surprising, is that I have never added any 2007 on the test server and it works correctly without any prompts. Does it mean that there is a server-side problem with the installation on the 'proper' server? I use scp instead ftp and I know that the server admin blocked ip acces, but the rest seems to be working without any limitations.
Thanks in advanced for your help and looking forward to hearing from you!

[marco]

which procedure have you followed to import from one server to another?

Marco

[cioop]

First I uploaded the files with winscp then I exported mysql database via phpmyadmin and imported it also by phpmyadmin onto a new server.

[marco]

You should use the php-residence backup system (main menu -> configure and customize -> backup system). Install php-residence on the second server from scratch (with just 1 apartment is ok), then create the backup file on the first server and upload and restore it on the second server.

Marco

[cioop]

Thanks for reply
I've just tried it, but it still doesn't work.
First I couldn't upload the backup file, but then I managed after having changed chmod to 777. Finally when I uploaded the backup file, the problem occured again after logging out, deleting cookies, clearing cache and logging in again.
I see 27 tables in mysql:

• * _anni
  * _appartamenti
  * _clienti
  * _contratti
  * _costi2006
  * _costi2007
  * _costiprenota2006
  * _costiprenota2007
  * _descrizioni
  * _messaggi
  * _ntariffe2006
  * _ntariffe2007
  * _periodi2006
  * _periodi2007
  * _personalizza
  * _prenota2006
  * _prenota2007
  * _privilegi
  * _regole2006
  * _regole2007
  * _sessioni
  * _soldi2006
  * _soldi2007
  * _transazioni
  * _transazioniweb
  * _utenti
  * _versioni

and there's year 2007 in _anni, thus I don't ubderstand why the script doesn't select it after logging?
Thanks again and look forward to hearing from you.

[marco]

What did you chmod to 777? Are you sure that the dati directory has the right write permissions, as descibed in the README? When a new year is created some files are created and modified in the dati directory, not only the tables. Php-residence does not use cookies.

Marco

[cioop]

yes I did chmod dati to 777

[marco]

If you did chmod dati to upload the backup then probably you didn't install php-residence from scatch as I told you (webserver needs to have write permissions on dati to be able to make a new install). Try making a new install (delete all files and database tables) and then restore the backup.

Marco