I'm glad I found this thread when I searched for login problems. This morning on my site, suddenly, nobody could log in. Like a few others here, trying to log in would give the Thanks for Loggin In message, but then you'd be taken back to the login page. What I found, after being alerted to the possibility of a problem in the _session table, was that the latter was corrupted. Doing a Repair Database fixed it, I'm glad to say.

I think it would be useful to have an FAQ on this subject that points out that the _session table needs to be specifically checked.


Barry Cooper

Thanks for the suggestion. The problem is that all the data for each user is there, except group membership. I lost only one table, namely the one mentioned above. I do have an Excel file, fortunately, containing those individuals who are in the Members group (members of our organization). The problem is, I can't see any way I could use that to enter the group membership for each individual. I've embarked on the task of going through them and selecting the groups they belong to.

What I'd most like to know now is how this happened. I learned one lesson - don't trust a provider.

Barry

I have found where the problem lies. Somehow the data in the table *_groups_users_links has been deleted. The only entries that were there were four recently registered individuals, including two test registrations that I did. I am very concerned that this was malicious but don't know how to further investigate that possibility.

I tested this by adding a new entry to that table for my own uid, with the appropriate groupid. I think the linkid must just run sequentially, so I chose a value of 1 for that. Adding that entry to the table allows me to log in.

Now I'm faced with the task of rebuilding that table. At the moment I can't see any way to do that other than manually re-entering each one, with the appropriate group id.

If anyone has any suggestions to avoid that rather mammoth task, please tell me what they are.

Barry

The archival backup will include the database files but I'll do a separate db backup once that is finished.

I have tried deleting all files in templates_c but the problem persists.

I have tried logging in from a different computer and different browsers. Same result. I have also had messages from users that they are having the same problem.

Interestingly I just tried creating a new test account and was successful. When I initially replied to the account creation email message the page looped. That is, it didn't automatically reload. However, after logging off and trying again, I can log on using that test name. I could presumably go into the database and make that user account an admin account but I'm not sure how that would help me.

Still hoping for some help.

BC

I have been out of town for a couple of days and came back to find that I cannot log on to my site under either my admin login name or my test account name. When I try I get the usual message "Thank for for logging in <username>" but then I get an error message saying "Sorry, you don't have the permission to access this area. If the page does not automatically reload, please click here". The page does not reload and clicking on the here link doesn't work.

The worst of this is that I called my provider and they told me that they do not have any backups for my site and that they do backups but don't guarantee to do so for each account. That is news for me and will probably result in my moving to a new provider.

In the meantime, can anyone suggest a way to fix this problem. At present I am downloading a full archival backup of all my files. It would be an absolute disaster to lose all of the information on the site.

My site is running under XOOPS 2.2.4, PHP 4.4.8, mySQL 5.0.45

I hope someone can help me with this soon.

Barry Cooper

Hi all,

I hope someone out there with some experience with Formulaire might be able to advise me on this problem.

I am using formulaire 3.33 to set up some forms that I want to use to allow my users to submit information. It is installed on a site running XOOPS 2.0.13 (I know I need to update it), php 5.25, mySQL 5.0.45.

When I set up forms then set permissions for the forms, only webmasters can see the forms in the menu block. If logged in as a registered user you can't access the forms. I see the block heading but no forms listed. Also, I cannot access them using the complete URL to the form(s).

One thing that has puzzled me is that the docs say that you have to set the uploads folder to 777, but there doesn't seem to be an uploads folder installed with the module.

It appears that permissions are not being set correctly. Any advice on this?

Thanks,

Barry Cooper

Thanks Jere,

I'll take a look at efqDirectory.

BC

Thanks for the suggestion. I have been considering using a wiki and am in the process of testing mediawiki and dokuwiki. I have had problems getting the latter to run on my test site (both it and the live site run XOOPS 2.2.4).

A wiki would lend itself to displaying the information and could be edited. However, we definitely do NOT want anyone but authorized individuals to be able to edit. I won't go into details, but believe me, allowing everyone to edit it would end up as a mess. The texonomy of these fish is complex enough that even real experts can disagree. Therefore, we have to have an "authority" who is the final arbiter.

That raises a problem with mediawiki, because I can't see a way, in the small amount of time I've had to look at it so far, to limit who can edit the pages. I'm still studying it though.

I'll put up a couple of pages of content from the book on our web site, then post a URL here so that anyone interested can see what the display of data will have to mimic.

Barry Cooper

mboyden, thanks for your reply.

First, I'm aware of the value of a specific subject heading, but in this case it was hard to think of one that conveyed the need in a succinct way. Sometimes casting a wider net attracts more responses. Not arguing, just explaining.

Second, the information is not yet present on our site. We are interested in adding it. As I explained initially, the data is presently available in book form, although the author has the manuscripts in digital format. Perhaps I should have explained, "only in book form".

I agree that a currently existing module might well be modified to suit our purposes. If so that would presumably be less expensive and, of course, that would be welcome news. I would still need help from a programmer, as I am not one myself.

I'm hoping that someone will express interest in working with me on a paid project, creating a module, or modifying an existing one to produce a new one. Once I have someone who is interested, I could work with them to develop detailed requirements. I am a bit reluctant to try to express them in detail here as the post would become quite long, which I think could have a negative effect in that people sometimes skin over very long posts.

Barry Cooper

Hi all,

Excuse the preamble, but I think it is necessary to make sense of my request.

I maintain a web site for the American Killifish Association, using XOOPS 2.2.4 (soon to be updated to 2.2.6) at www.aka.org. This organization is a national hobbyist group that has, as one of its primary interests, the responsibility of maintaining records of the currently accepted scientific nomenclature pertaining to these fish (killifish).

We have a printed document, the Killifish Master Index, in which those current names are recorded. Each genus is listed and, under that, each species has an entry, with information such as common name, scientific references, etc. The book also has a "table of concordance" in which current and previous names can be cross-referenced.

Scientific names for fish (like many other organisms) are constantly changing as new research is done. That makes a book pretty much obsolete as soon as it appears. Keeping track of these changes is an obvious application for a database, which we'd like to be web accessible.

My question, therefore, is whether there is a XOOPS module available that would be used for this. The Document Management System module does not appear to be suitable, as it is designed to keep track of individual documents.

An entirely new module might have to be created to provide the online access to this data. If so, I would like to get some idea of whether there is someone out there in the XOOPS community who might wish to work with us on it, and a rough idea of what it might cost to do it.

Hope to hear from some of you programmers.

Barry Cooper