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.  / Database Connection OK - Can't create tables
Register
1
cakoala
Database Connection OK - Can't create tables

  • 2004/8/16 6:27

  • cakoala

  • Just popping in

  • Posts: 6

  • Since: 2004/8/12


First, thanks for all the help you gave others. My first issue was a lack of the php4-mysql module in Debian. This was giving me one of the famous "blank page" errors. I got that corrected and went on to try and create the tables. The database check says that it is able to connect and that the database is already created.

But,

The next step is to create the tables. It blows up with all tables having the errors of: "Failed creating table ". Not a real informative error (sorry Haruki) so it is almost impossible to guess what the real error is.

This much I know:

I can log into mySQL as XOOPS and create a table from the MySQL command line.

User XOOPS has all priveleges (a little overboard but hey...)

I noticed that Haruki is parsing some file that appears to have the output of the failed SQL commands. Where is this file ($sql_file_path)?

Thanks, Keith.
2
hervet
Re: Database Connection OK - Can't create tables

  • 2004/8/16 7:58

  • hervet

  • Friend of XOOPS

  • Posts: 2267

  • Since: 2003/11/4


Try to create the database, if it does not exists
3
cakoala
Re: Database Connection OK - Can't create tables

  • 2004/8/16 20:30

  • cakoala

  • Just popping in

  • Posts: 6

  • Since: 2004/8/12


It exists, and I am able to create tables in it IF I do it from an external tool like MySQL or mysqlcc.

Another thing I forgot to mention is the mySQL log never shows any connections from the install utility. Yet, all my other activities from other tools are all log in there. Makes me wonder if I really am getting a database connection or if the install script is being fooled.

Which script actually creates the tables and does it leave any trace or debug information behind?
4
tl
Re: Database Connection OK - Can't create tables

  • 2004/8/17 0:54

  • tl

  • Friend of XOOPS

  • Posts: 999

  • Since: 2002/6/23


You might still have a php-mysql problem. To confirm if php-mysql is okay, see if your phpinfo has the MySQL properly configured - you have two sections in the middle of the page describing MySQL.

Another thing to check - if php4-session is required. SuSE 9.1 apparently needs php4-session enabled. You could check
THIS THREAD
5
cakoala
Re: Database Connection OK - Can't create tables

  • 2004/8/18 3:50

  • cakoala

  • Just popping in

  • Posts: 6

  • Since: 2004/8/12


GOT IT!

I was using an invalid table name (no dashes allowed). I found it by using phpmyadmin to test connectivity and create tables.

Suggestion for installer development team:

PLEASE echo the full error up to the web page.


Thanks to all!

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

150 user(s) are online (95 user(s) are browsing Support Forums)

Members: 0

Guests: 150

more...

Donat-O-Meter

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

Latest GitHub Commits