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 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

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

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

Ok. I found it.. it was in the theme css directory - content.css
Hope that it helps other.

The Questions in SmartFAQ come out in Italic font and underlined. Does anyone know where to change this.? It is not in the stylesheet. Does anyone know of another place to change this?

thank you

I am using XOOPS 2.4.3 with the Theme SD Green.. (not sure what one this is called, Im guessing) the file name is: xoops_thm_sd-001-green-xoops.zip. anyways.... In Internet Explorer 7 the drop down menu disappears. I click on the drop down menu the menu would pop up, as soon as I dragged the curser down to select something the menu would disappear. Does anyone have a fix for this? Everything works fine in Chrome, Mozilla and Internet Explorer 8...

thanks,
Amy

thank you.. but that did not work either.

here is the smartfaq.css that is supplied with the module:

/**
* $Id: smartfaq.css,v 1.11 2004/12/30 22:34:08 malanciault Exp $
* Module: SmartFAQ
* Author: The SmartFactory <www.smartfactory.ca>
* Licence: GNU
*/

.sf_headertable {padding: 0; margin: 0; border-bottom: 1px solid;}
.sf_modulename {font-size: 10px; text-align: left; font-weight: bold; padding-right: 0.3em; line-height: 18px; text-decoration:none;}
.sf_breadcrumb {font-size: 10px; line-height: 18px; text-decoration:none;}

.sf_infotitle {margin-top: 8px; margin-bottom: 8px; font-size: 18px; line-height: 18px; font-weight: bold; display: block; text-decoration:none;}
.sf_infotext {line-height: 130%; display: block; text-decoration:none !important;}
.sf_infotext a {text-decoration:none !important;}

.sf_faq_head_cat {padding-top: 0px; text-align: right; font-style:normal; vertical-align: middle; display: block; text-decoration:none;}
.sf_faq_head_who {padding-top: 5px; text-align: right; font-style:normal; vertical-align: middle; display: block; text-decoration:none;}

.sf_collaps_title {margin-bottom: 8px; margin-top: 10px; font-size: 16px; line-height: 16px; font-weight: bold; display: block; text-decoration:none;}
.sf_collaps_info {margin: 3px 0 12px 0; font-size: small; display: block; text-decoration:none;}
.sf_collaps_info a {text-decoration:none !important;}

.sf_category_dsc {margin: 3px 0 10px 0; font-size: small; display: block; text-decoration:none;}
.sf_adminlinks {font-size: 10px; text-align: center; line-height: 18px; text-decoration:none;}

.itemFoot {text-align: right; padding:3px; border:1px solid #808080; text-decoration:none; }
.itemFoot {text-align: right; padding:3px; border:1px solid #808080; text-decoration:none;}

.modfooter{text-align: center; padding-top: 6px; font-size: 9px; border-top: 0px solid #ccc; text-decoration:none;}

I hope you can help me on this.

I am trying to change the stylesheet in smartFAQ's so the links are not Underlined.. I have found the smartfaq.css but when I add the code text-decoration:none; they still show as underlined. Can someone help me with this please.

Thank you for the explanation. I appreciate it. Again, thank you for the help.