XOOPS 
Forum
Forum Index General Forums Community Support Modules Support Themes Support Development International Support Module Hack Reviews Theme Designer Talk
  1. Board index / 
  2. XOOPS Community Support forums / 
  3. Installation Troubleshooting 
  4.  / Failed creating database tables
Register
1
essenz
Failed creating database tables

  • 2004/11/1 13:22

  • essenz

  • Just popping in

  • Posts: 10

  • Since: 2004/11/1


I worked through the install wizard and got all the green led's to this page:

Connection to database server is OK.
Database essenz_drmem exists and connectable.

Database connection is OK.
Press the button below to create database tables.

When I click on the "Next" button I get this message:

Failed creating database tables.

Tried all the suggestions concerning db connections etc.. found in this forum, checked "mainfile.php" and everything is correct. I get a db connection and check the db with MySQLAdmin and everything is all good, including the "Privilages - ALL" when I setup the database and user in cPanel.

Any suggestions?

NB: Apache 1.3.31 / MySQL 4.0.22 / PHP 4.3.9
2
DonXoop
Re: Failed creating database tables

Are there any tables already in the db (conflicting table names)? Or can you create new tables and then delete them manually? Are you sure that you can connect and create tables manually with the same user/pass that is in your mainfile.php (not the cPanel account)?

I prefer a stand alone phpMysqladmin (put in a subdirectory) vs a cPanel interface. Better simulates what you apps must do.

Carefully check the naming conventions, you might have an underscore in the names "essenz_xoops", "essenz_user" etc.
3
DonXoop
Re: Failed creating database tables

oops, is your profile website really bizhhelp.com? not one of those..... At least my email isn't in my profile or I might be "invited" to make money the "easy" way..
4
essenz
Re:Failed creating database tables

  • 2004/11/1 13:56

  • essenz

  • Just popping in

  • Posts: 10

  • Since: 2004/11/1


OK I found the reason for it.. when I uploaded the files to the server, it didn't upload the sql directory contents.. I got looking at the error and thought if I could run the queries manually, when I went looking for them they weren't there. After uploading the sql files I ran the install wizard and all is good.
5
essenz
Re: Failed creating database tables

  • 2004/11/1 13:57

  • essenz

  • Just popping in

  • Posts: 10

  • Since: 2004/11/1


Quote:

DonXoop wrote:
oops, is your profile website really bizhhelp.com? not one of those..... At least my email isn't in my profile or I might be "invited" to make money the "easy" way..


No it ain't one of those....

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

248 user(s) are online (208 user(s) are browsing Support Forums)

Members: 0

Guests: 248

more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits