Hello I am setting up a new server and transferring programs from old server to new. I am install an Xoops older version 2.4.3 on the new server to upgrade to the newest version. I want the new version to work before I transfer the domain that will be running the software. Here is my dilemma. The install all goes well until this step:
Database tables creation
XOOPS system tables have been created.
Press next to go to the next step.
But below that is shows:
Unable to create table wayne__avatar
Unable to create table wayne__avatar_user_link
Unable to create table wayne__banner
Unable to create table wayne__bannerclient
Unable to create table wayne__bannerfinish
Unable to create table wayne__block_module_link
Unable to create table wayne__xoopscomments
Unable to create table wayne__xoopsnotifications
Unable to create table wayne__config
Unable to create table wayne__configcategory
Unable to create table wayne__configoption
Unable to create table wayne__groups
Unable to create table wayne__group_permission
Unable to create table wayne__groups_users_link
Unable to create table wayne__image
Unable to create table wayne__imagebody
Unable to create table wayne__imagecategory
Unable to create table wayne__imgset
Unable to create table wayne__imgset_tplset_link
Unable to create table wayne__imgsetimg
Unable to create table wayne__modules
Unable to create table wayne__newblocks
Unable to create table wayne__online
Unable to create table wayne__priv_msgs
Unable to create table wayne__ranks
Unable to create table wayne__session
Unable to create table wayne__smiles
Unable to create table wayne__tplset
Unable to create table wayne__tplfile
Unable to create table wayne__tplsource
Unable to create table wayne__users
Unable to create table wayne__cache_model
with all red "X"'s next to them
When I click on the next button I get the admin setup option I add all that information and then the installation goes back to the Database configuration step. I am running apache22, mysql5.5.11, php5, on a FreeBSD server. Any help would be appreciated.. thank you

When your transferring between services, you have to run the installation manually.

Basically you will need to make a copy of your database, with something like the export function of phpMyAdmin and then recreate the database on the new server.

Then you will have to copy your filebase over and modify mainfile.php to reflect the new server information including database information and you should find it is up and running fine in those couple of steps.

Does this count for a NEW INSTALL? I am doing a new install manually on the new server. I can not finish the installation process and don't know why. I have set up the database with the database name and used it while running the installation. It connects because I get past that point in the install.
I can not get to these steps in the new install:
Data insertion
Site configuration
Select theme
Modules installation
Welcome
Do these steps not matter? I do have a backup.sql of the old server, but the installation does not finish to add the data.

thank you,
Amy

With a new install you should have to enter the name of the database, your name and password to access it. I always make a name special for that database and give it rights to all that it needs for just that database. More secure than just giving it the root access.

During the install it will tell you that it connected to the database. If this step fails you did not enter the correct database access information.

If you ARE getting the connection fine but not able to create the fields and such then you need to check what privileges your user has. Unless I am missing something from what you typed I am guessing the user you have to access your database does not have the proper privileges, assuming you are installing with the right name and password.

I did the new install by entering a database name that is unique, The connection to the database worked, The privileges are correct.
and it still doesn't work.

So I did it your way :
Basically you will need to make a copy of your database, with something like the export function of phpMyAdmin and then recreate the database on the new server.
I did that
Then you will have to copy your filebase over and modify mainfile.php to reflect the new server information including database information and you should find it is up and running fine in those couple of steps.
and now I have a WHITE PAGE...
any suggestions?

thank you

In order to switch the databases in mainfile.php, you first need to make sure that a brand new installation does work, which is not the case here.

Quote:
I would say that there are two options:

1) You don't have the right permission to create tables
2) the tables already exist

Can you check that the database is actually empty, before you start the installation?

But I suspect that since the installer goes back to the DB part, then more probable is that there are no tables, because you didn't have the rights to create them.

I am using phpMyAdmin to create the database and the user with the right permissions to create these database tables, but it still does not work. I tried even using root but that did not work either. I have tried a mysql.php file to see if mysql was connecting and it is. So I have no idea why this is not working. The database is empty after I create it. The user has these following privileges:
SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, FILE, INDEX, ALTER, CREATE TEMPORARY TABLES, CREATE VIEW, EVENT, TRIGGER, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, EXECUTE
What am I doing wrong?

thank you,
Amy

i had an issue with creating tables using MySQL 5.5.8 before on XOOPS 2.4.5 using my WAMP setup. i had to use a lower version of MySQL or install XOOPS 2.5x.

i didn't look into the issue more though. simon would probably know why, i'll direct him here.

simon suggests of an upgrade to 2.4.5 or 2.5.1a

If I do that can I use the backup sql file to insert data. Or do I have to start over again????

Ok I installed version 2.5.1a and it installed perfectly. Now my question is can I use the backup.sql file from version 2.4.3 on this version?