Thanks for taking the time to reply jd. I just this very moment managed to get things installed. However it was not a permission problem. The ONLY thing I did differently was change the setup so that the database table prefix included and underscore.

In other words, previously the setting was:
database name: bcwa
table prefix: bcwa
I changed to:
database name: bcwa
table prefix: wa_ <- note the underscore

Apparently this made a world of difference to the installer.

Well I've been working on installing XOOPS now for several hours, have been trawling through the docs and forums and still have made no progress with this problem. I've successfully installed XOOPS 3 or 4 times on other machines and have a production site running, yet this one has me stumped!

THE PROBLEM: Install is all fine up until the "confirm database settings" step. Green lights all the way. Then I go to the "Check database" step and I get a blank page (the html is this (replace curly brackets with triangle brackets): Quote:
I log onto the database I've created and it shows an "empty set". No error message and no indication of what's gone wrong.

WHAT I'M USING: PHP4.3 / MySQL 4.0.3 (nb: was 4.1, but downgraded when I saw a forum post that suggested this might be the problem. i purged everything before reinstalling) / XOOPS 2.0.10 / Debian Linux (Sarge) / Apache 1.3

This is a freshly installed server, so I haven't had time to do anything exotic with its configuration , except that I've set up an Quote: in httpd.conf for this site until I setup the sites domain. This shouldn't be a problem though because I've done this on a testing site twice before and it worked. But this is all I can think of to provide info for anyone trying to debug this.

Help appreciated.

I've just installed one of the shopping cart modules into my site and I have to be honest and say I'm not happy with it. XOOPS is brilliant over all and I'm happy with the many modules I'm using, but not this one.

I've just been reading the threads about "zshop" and integrating zen-cart, and I just wanted to add my voice to the calls for the porting of zen-cart which is IMHO the best of the PHP shopping carts available. And I'm prepared to step up to the plate and offer my assistance to anyone who's taking this job on.

I have a basic grasp on PHP, but I've never contributed to an Open Source project. I guess it's about time I did given how much of it I use. But I don't feel confident about spearheading such a project cos I don't have the skill to port something as big as zen-cart. If there are any PHP propellerheads out there thinking of taking this on, note that I'm ready to help out where I can.

And big ups to the XOOPS developers for creating such a great CMS!

Thanks Christian for your prompt and helpful reply.


This seems to have worked. Thanks


This query won't work.

I tried this:

and MySQL complains about a syntax error, which seems odd to me. Anyway, based on this advice I can see now what the nature of the problem is with the migrated users and I think I can fix it.

Thanks again; sol

First I want to let the XOOPS team know that a new XOOPS site hit the net yesterday: www.bswa.org. Thanks to the whole XOOPS community for creating such a great CMS.

We've already got close to 300 registered users

BUT

most of those who are registering can't log in.

These users fall into 2 categories. The first are the 150 users I migrated from our previous installation of phpbb2. I used the script phpBB2_XoopsBB_converter.sql kindly provided courtesy Randall Emery. It's a bit old but all seemed to migrate everything okay. I instucted old phpbb2 users to log in using old name and password, but they've been reporting that they can only go as far as their user profile page and no further.

The other group are the 100+ users that have signed up since the site migration yesterday and haven't received email confirmation. This is really strange because it's not effecting all users, but so far as I can tell it's effecting most users. The complaints have only just started rolling in.

I'm using "sendmail" as the mail delivery method and I have a working version of exim (which provides sendmail) installed on Debian Linux server. I've noticed that in the xoops_users table of MySQL most of the users don't have activation keys. But I'm guessing this is because they haven't received their confirmation emails.

Any ideas on how I can troubleshoot this? Is there a db update query I can run that will activate all those who've registered but haven't confirmed yet?

thanks in advance;