Fixed it. The table was damaged somehow.

I found a problem with my sessions table

Error

SQL query: Edit

SHOW INDEX FROM `xoops_session` ;

MySQL said: Documentation
#1016 - Can't open file: 'xoops_session.MYI' (errno: 145)

Hi,

I'm unsure if this is the cause.. a few days ago I upgraded PHP 5.2.1 to 5.2.2, after a couple days I noticed the current ppl visiting the site wasn't shown anymore, and I couldn't access the admin area anymore. I then upgraded to 5.2.3 to see if it fixed it, but it was even worse, the site wouldn't load at all.

So I went back to 5.2.1, but the admin area problem remains. After I log in, I get the msg "thanks for logging bla bla" and get sent back to the main page and it's like I didn't log in at all.

Any suggestions?

Thanks, email form sent :)

I'm looking for an advanced php/mysql programmer who can fix a website with a XOOPS portal.

It's a XOOPS portal version 2.0.9.2 that used to run on mysql3/php4/ensim.
It runs on PHP 5.1.4 / MySQL 4.1.19 / CPanel 10 now

Every attempt at upgrading makes it even worse.

Some of the things that aren't working:

Problems:

- New user registrations don't work, trying to register tells you the user already exists, no matter what user you type in
- Phpmyads module: (modules/myAds) - can't add new ads. - the script sends massive emails to users when their add has expired, dozens a day, sometimes a few within 1 minute.
- "Comunicados" (modules/weblog) : can't post news, it says it is for registered users only, even being logged in as admin
- Pictures module (modules/myalbum): can't add new pictures
- modules/addresses: it's a module with files with data about companies, aka hotels, restaurants etc. We set their ID's from 0-1000 as paid customers, so they should pop first in the search results, but they don't.

- Can't update. Trying so gets many things broken, ads stop showing up and eventually nothing does. The first symptom of that happens when upgrading to the next version, 2.0.10, with header.php


There might be other problems I forgot.

If you are willing to upgrade our portal to latest version and fix those problems for a fee, please let me know and an estimated fee you are asking for

Note: the portal is in spanish

Thanks

I tried Xoops-2.0.9.2-to-2.0.9.3 first then so on. It left the site with a blank page. Since the site can't be down for too long and there's also many modules and it's highly customized ( I didn't cust. it ), trying to upgrade it will take a lot more efforts.

It's 2.0.9.2

I tried upgrading but that brought a whole lot more of problems so if it can be fixed I'd rather do that since it's a big and crowded site and fixing all the upgrading problems might take a while.

Thanks

I am having a problem with new users registering, no matter what user they type in, they get an error that the username is already in use.

Any suggestions ?

PHP 5.1.2
MySQL 4.1.18
Apache 1.3.34
CentOS 4.3
CPanel10

Thanks