I am using Property management 14.0.2.28. The List Room View cannot be loaded. It seems to be stuck. After uninstalling Property Management and reinstalling to the latest one, the problems still exist. If anyone knows how to fix this, please let me knos.
About the issue with the database, iāve some doubts but why not. That wanna say that you have problems that do not concern this module but your system.
If thereās a specific install , version, distroā¦ please let me know.
Anyway, if you follow the manual to set this module, it should work.
You have helped me in the past. I have installed the Property Management several times. This time, I tried to reinstalled it because the List - Room Page will not load. It keeps on waiting for the database. Can you tell me how to reindex or fixed the database?
You issue is for the page :Menu/List/Rooms right?
Whatās your browser?
Can you pass your browser in debug console and get any errors from this page?
Anyway, if you start to get some error from database, then you maybe your system start to be unstable caused by a disk failed. (bad sector ā¦Etc).
Just an idea like that.
Ususally, if you unsitall and remove the module, the table are removed.
So, after the new install, the table are createde and empty excepted pms_config which include some basic settings.
If this action has been performed, iām prety sure thatās not a database issue.
To check if the data is good in the database, you can use this cmd line : # fwconsole mysql
And next, type some SQL requests like : MariaDB [asterisk]> SELECT * FROM pms_rooms;
To quick mysql, type : MariaDB [asterisk]> quit;
If all data are present into each one of table, then your database is good.
The best way to be sure, is to make another install on a new virtual server like VMWare or VirtualBox.
Make a fresh install and configure your module.
If thereās no issue, the problem is elsewhere.
Thanks for your help. I uninstalled Property Management for the 2nd time and did a remove afterward. After downloading and reinstalling Property Management, the Room List is working. I do not know why it quit before, when it has been running for 7 months. Then after a reinstall it still did not work. Well anyway, it seems to be working now. I have not test everything, but the main portion is working.
Maybe the issue came from a corrupted or a wrong data inside the database. Or maybe a file.
Sometimes, some issue come from the cache.
All is possible.
In the old versions, you allowed to remove and add a same room. But this action is no longer allowed, because the risk was to break the index of the room.
Once the room is created, itās prefered to avoid to keep this one.
Itās rare to remove add and remove any rooms often.
Sure you can change the type of room but this one need to be available and not occupied.
Anyway, you could chech the content of these tables if the data are right at first.
If all is right, then the issue come from elsewhere.
You could try to find out any error from your browser (FireFox = F12) and go to on the console.
Usually , if thereās an error somewhere, it could give you a clue, but maybe notā¦
I get an error with pms_connectors. Database does not exist
ERROR 1146 (42S02): Table āasterisk.pms_connectorsā doesnāt exist
All other databases on the list are fine or show empty. In addition, I cannot use the room extension to access bar *37 (a recording says ājob numberā, or maid services *44 get disconnection.
Yep, Thereās a new version to fix this bug. ( pms_connectors )
Try to see if thereās this one in the edge and install it.
This one is not out yet. But it should be in edge for test.
Otherwise, downgrade until the new version will be out.
I am sorry to disappoint you. The list room is not working again. After adding each check-in, I check the status. The fourth one seems to hit a problem. I check the pms_rooms table and there seems to be no problem and showed me a list of rooms.
Please, Give me the steps to reproduce it (exactly).
We will try to reproduce it.
I will update you asap. (iām so busy right now).
If we find any bug, iāll fix it quickly. Donāt worry
But itās weirdā¦ this is the first time that I see this kind of stuff.
If you are sure that SPM is fully configured (even if some features are not used).
With the edge update, the minibar module is functioning. The maid or housekeeping service is not. In āFeature Code Adminā and under PMS, the āSend a message number to the receptionistā cannot be customized like all the other Feature code. I think this is causing the error when you type in *44 in the room which cause a disconnection.