Bugs -> file includes\funzioni_mysql.php on line 104

Post here if you think you have found a bug in hoteldruid or error in its documentation.

Moderator: marco

Post Reply
m4d
Posts: 22
Joined: Wed Aug 09, 2006 11:32 am

Bugs -> file includes\funzioni_mysql.php on line 104

Post by m4d »

Unless error, I think that there is a bug in the users privileges

I have three users : "admin, test1, test2" + one group "test" with test1 et test2

For "test1" user, I use the default privilèges with 3 changes :

Reservations that can be modified: Only (from his group)
Possibility to modify the extra costs permitted to him: Yes
Possibility to view the table with the periods and the rates: Yes Only with rates permitted (to his group)

The problem : when I can change an extra cost, I have the error message follow :

ERROR IN: select idgruppo from where idutente = '2' and idgruppo is not NULL
1064: Erreur de syntaxe pr?s de 'where idutente = '2' and idgruppo is not NULL' ? la ligne 1

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in C:\Program Files\EasyPHP 2.0b1\www\DEV\php-residence\includes\funzioni_mysql.php on line 104

Other problem : for change the rates i must put "to him" and not "to his group" in "Possibility to view the table with the periods and the rates"

By advance, thanks for your help !
marco
Posts: 1332
Joined: Tue Jul 05, 2005 6:00 pm
Location: Roma, Italia

Re: Bugs -> file includes\funzioni_mysql.php on line 104

Post by marco »

The first bug was already solved in version 1.2, please upgrade. For the second bug you can replace the visualizza_tabelle.php file from php-residence 1.2 with this file:

http://www.digitaldruid.net/download/vi ... lle120.zip

Regards,
Marco
Problems installing, configuring, upgrading?
Try the easiest way to use HotelDruid:
https://www.digitaldruid.net/hosted/index.php
Post Reply