I have several companies listed. Now, when I try to go to page 2 by clicking on the arrows, it still keeps me on Page 1.
Anyone have a solution for this? Appreciated. Thanks
Thank you for logging this bug. Can you provide a bit more information? Are you using the stable XRMS release or the CVS? Where is the problem occurring, exactly? Can you describe the action sequence that produced the problem (click here, select this, etc.). Also, any modifications or custom preferences you may have applied to your installation?
I just tested the /companies/some.php on my dev machine (CVS) - it is a default install - and it is working as expected. I don't mind trying different scenarios but I would need to know what I am looking for.
Thanks a lot for your response, Ivaylo.
I used MediaTemple's standard install. How do I find out if it is stable of CVS?
Here is the workflow:
-- I have added around 100 companies
-- Now, when i search using no parameters, it lists all companies across several pages
-- Now, I click on the signs for the Next page and it loads the 1st page of companies again
-- Now, I click on the signs for the Last page and it loads the 1st page of companies again
We have not done any custom preferences (should we have?) - it was the standard install that MediaTemple offered.
If there is any other information you want from my side, please let me know.
I appreciate your help here - it is a bit frustrating.
I was not even aware that Media Temple offered XRMS as SaaS. Did you, by any chance, install XRMS using the Plesk Control Panel? Plesk packages a really old version of XRMS.
I did some digging and, as long as my information is correct, Media Temple offers version xrms-1.19-80018 which is much earlier than even the current stable version (1.99.2). You can confirm that by logging in as administrator into the system and then going to "Administration > System Preferences"; you should see the version number at the bottom of the page.
If you have entered a considerable amount of data into XRMS, at this point, your best option would be to have someone upgrade your XRMS installation but make sure that they back up your data (and any files you may have uploaded in the system) first!
If you don't mind me asking (for my own benefit here): How much are you paying for hosting at Media Temple? Is XRMS the only thing you are using on their servers?
Thanks a LOT for your kind help.
I just checked with MediaTemple and they do have this version installedd through Plesk which we used: 1.19-82023
Is there anything I can do to update and upgrade myself?
I checked under Administration and just have the following options available to me:
Database Structure Update
RE: Export. These are the options available to me:
Export Companies/Contacts as LDAP/LDIF
Export Companies with address and phone info
Once I export and then upgrade, can I easily import it back in?
Also, is there a reliable way to take a back of of the data of the 100 companies we have listed in it?
I pay approx $26/mo for the DV server and host a lot of other business and enterprise applications also including some of our customer facing sites.
Thanks again and appreciate your help and support here.
As I suspected, this is a version dating back to before the time I was even on the project. I am not acquainted with the functionality available in XRMS at that time but I'll hope my advice may be of some use.
Before I go further, however, I should point out that running XRMS over HTTP is not advisable since all data communicated between the server and the user's browser is transmitted in plain text. If you have not done so already, you should set XRMS to be served over HTTPS only. Certain sensitive directories should be located outside the webroot, too, most importantly /include, /storage, /tmp and /export. Depending on the functionality and structure of XRMS at the time, as well as the structure of the Plesk XRMS template, that may have been done (or not!) so you will have to try and see where those directories are located in your installation. Upgrading from your version of XRMS to the current stable version, especially depending on your system administration skills may prove to be far from routine and, if you are not well-versed in system administration you may be better off seeking professional help.
I would advise of the following general steps - some of those may have to be modified based on the XRMS functionality and mode of installation you are faced with:
1. Using phpMyAdmin, backup the XRMS database and offload it from the server to a safe place. Also, download all files you may have uploaded to the system in the /storage directory (you may be better off to gzip them first).
2. Backup the entire XRMS directory tree including any directories that may have been moved outside the webroot (again, this depends on the Plesk installation template - I would not know how the package is structured there).
3. Delete all of the XRMS code directories.
4. Download the latest stable version of XRMS (1.99.2) available here at SourceForge and, following the INSTALL instructions in located at the root of the /xrms directory, install XRMS from scratch noting the following:
- enter the correct database connection credentials in /include/vars.php pointing to the database where your current XRMS data is located.
- note where your /include, /storage, /tmp, and /export directories are located and enter the correct paths in /include/vars.php (as mentioned before, they should be outside the webserver tree; even if Plesk had not put them there, you should - it is a security risk to have them exposed to the web!)
- when running the /install/install.php script, you will likely receive a whole host of warnings that certain tables cannot be created because they exist already. Do not panic - that is a good thing! XRMS's install script is non-destructive and should not wipe out any of your existing data but just add any missing tables. If something goes wrong, however, you would still have your database backup from step 1.
- after you have run the /install/install.php script, log into XRMS as an Administrator and, from the Administration page run: Database Upgrade and Database Clean.
5. Upload the contents of the /storage directory back to where the directory is located now.
Unless I have forgotten anything, with a bit of luck (as I said, I am not versed in what is available in that version of XRMS), this should do the trick.
The above-described approach is preferred to going through export/import and I may be able to help even less if you decide to export/import since I do not know the extent to which XRMS supports exporting in that version and since export/import always leads to loosing some data - you may be able to export/import companies and contacts but not the activities associated with them. So, try what I suggested and hopefully you should be OK. Do let us know how it works out so at least we have some reference point if anyone encounters this in the future.
I hope this helps!