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.  / xoops post-installation error messege ?
Register
1
Numan
xoops post-installation error messege ?

  • 2004/6/20 21:15

  • Numan

  • Just popping in

  • Posts: 6

  • Since: 2004/6/20


I just have installed XOOPS version 2.0.7
and at the end I got this msg:
-----------
Failed creating table xps_xoopscomments.
Failed creating table xps_group_permission.
Failed creating table xps_imgset_tplset_link.
Failed creating table xps_tplfile.
-----------
what should i do to get past this stage?

Would be highly obliged.

Thanks.
2
tl
Re: xoops post-installation error messege ?

  • 2004/6/20 21:24

  • tl

  • Friend of XOOPS

  • Posts: 999

  • Since: 2002/6/23


Just the four tables or all tables?

If just the four tables, does your host limit how many tables you can create with your database. There should be no limit from your host, but you never know
3
Numan
Re: xoops post-installation error messege ?

  • 2004/6/20 22:01

  • Numan

  • Just popping in

  • Posts: 6

  • Since: 2004/6/20


Yes it is just these 4 tables. Nothing more, nothing less. I don't see any limitations on the table either, because I tried creating another DB in MySQL and it happened the same. Installation doesn't go any further! Have u got any idea on it?
4
tl
Re: xoops post-installation error messege ?

  • 2004/6/20 22:05

  • tl

  • Friend of XOOPS

  • Posts: 999

  • Since: 2002/6/23


Can you manually create a table or tables in the XOOPS DB? This will make sure if there is a limit as to how many tables you can create within a single db. If you can, then we need to figure out other causes.
5
Numan
Re: xoops post-installation error messege ?

  • 2004/6/20 22:08

  • Numan

  • Just popping in

  • Posts: 6

  • Since: 2004/6/20


Yes that's possible. How do i create the tables then? The fields I mean?
6
tl
Re: xoops post-installation error messege ?

  • 2004/6/20 22:18

  • tl

  • Friend of XOOPS

  • Posts: 999

  • Since: 2002/6/23


If you really don't know how to, then you will have to learn. Phpmyadmin is a very handy tool for managing MySQL databases, so you may want to try that.

Meanwhile, you may want to check with your host to see if they limit the number of tables in a single database or they misconfigured the settings.
7
Numan
Re: xoops post-installation error messege ?

  • 2004/6/20 23:07

  • Numan

  • Just popping in

  • Posts: 6

  • Since: 2004/6/20


I am confident enough to creat tables and fields in PHPMyAdmin, but the question is where in XOOPS have you got the FIELD names for the tables to create?
Because in order to create the tables I need the number & name of the fields!
8
jlm69
Re: xoops post-installation error messege ?

  • 2004/6/20 23:23

  • jlm69

  • Module Developer

  • Posts: 719

  • Since: 2002/7/19


Use the info in the sql file at install/sql/

First use the mysql.structure.sql and create the tables you need (cut and paste).

Second use the mysql.data.sql and insert(cut and paste) the info you need.

Hope that helps.
9
Numan
Re: xoops post-installation error messege ?

  • 2004/6/21 0:04

  • Numan

  • Just popping in

  • Posts: 6

  • Since: 2004/6/20


I have got the soln.

The problem was not in xoops.

If you have recently updated your MySQL to version 5 then there is a need to Update the grant too!

http://dev.mysql.com/doc/mysql/en/Upgrading-grant-tables.html

Then the problems I have had will not be there.

Hope this help some other people.

10
Numan
Re: xoops post-installation error messege ?

  • 2004/6/22 16:06

  • Numan

  • Just popping in

  • Posts: 6

  • Since: 2004/6/20


Thanks jlm69, Yup, that's what I tried when I found the error msg came out -- due to the fact that I have updated my MySQL to version 5 & it was giving an error with grant permission or sth. Hence I looked for the soln and got one that i have mentioned.

Thanks to all for quick help.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

166 user(s) are online (144 user(s) are browsing Support Forums)

Members: 0

Guests: 166

more...

Donat-O-Meter

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

Latest GitHub Commits