1
chefry
Tables not created
  • 2011/7/2 19:30

  • chefry

  • Home away from home

  • Posts: 1005

  • Since: 2006/10/14


I'm trying to set up a testbed, using xoops 2.4.4 and wamp server as a localhost.

I created the database and set the user privileges, etc

But when I get to the "Table Creating" section of the install wizard I have problems

I get the message (in green) XOOPS system tables have been created. Press next to go to the next step.

But Under it I get (in red)
Unable to create table xf2f_avatar
Unable to create table xf2f_avatar_user_link
Unable to create table xf2f_banner
Unable to create table xf2f_bannerclient
Unable to create table xf2f_bannerfinish
Unable to create table xf2f_block_module_link
Unable to create table xf2f_xoopscomments
Unable to create table xf2f_xoopsnotifications
Unable to create table xf2f_config
Unable to create table xf2f_configcategory
Unable to create table xf2f_configoption
Unable to create table xf2f_groups
Unable to create table xf2f_group_permission
Unable to create table xf2f_groups_users_link
Unable to create table xf2f_image
Unable to create table xf2f_imagebody
Unable to create table xf2f_imagecategory
Unable to create table xf2f_imgset
Unable to create table xf2f_imgset_tplset_link
Unable to create table xf2f_imgsetimg
Unable to create table xf2f_modules
Unable to create table xf2f_newblocks
Unable to create table xf2f_online
Unable to create table xf2f_priv_msgs
Unable to create table xf2f_ranks
Unable to create table xf2f_session
Unable to create table xf2f_smiles
Unable to create table xf2f_tplset
Unable to create table xf2f_tplfile
Unable to create table xf2f_tplsource
Unable to create table xf2f_users
Unable to create table xf2f_cache_model

And when I check the table in phpmyadmin, there are no table created.

Clicking "NEXT" send me to "Initial Settings"
Clicking on "Next" again takes me back to "Database Configuration"

I'm using the latest wamp v2.1
apache 2.2.17
php 5.3.5
mysql 5.5.8

2
webmystar
Re: Tables not created
  • 2011/7/3 19:55

  • webmystar

  • Friend of XOOPS

  • Posts: 415

  • Since: 2008/6/23


i think you have an permission problem. check the privileges of your database user.

3
chefry
Re: Tables not created
  • 2011/7/3 20:13

  • chefry

  • Home away from home

  • Posts: 1005

  • Since: 2006/10/14


i set up a user with all priveledges

4
chefry
Re: Tables not created
  • 2011/7/5 8:31

  • chefry

  • Home away from home

  • Posts: 1005

  • Since: 2006/10/14


bump!

5
deepak267
Re: Tables not created

Chefry,

To me it looks like user previlage issue. try the follwoing test.

use the same database user credential and try to run the SQL script or atleast one SQL statement.

Check if the user has the previlage to execute the Create table statements. if you are not able to execute with your user, run the script with root user.


Good Luck,

Deepak

6
Mamba
Re: Tables not created
  • 2011/7/5 8:53

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


I never had problems with WAMP, unless:

- the database setup was wrong
- the user permissions were wrong
- the tables already existed

Try to create it with the Admin or Root login/password and see if you can install it. If you do, then your "user" privileges are wrong.

Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs

7
iHackCode
Re: Tables not created

the installer isn't compatible with that version of mysql, try XOOPS 2.5
CBB / LatestNews / Publisher / XM-Spotlight

(ノ◕ヮ◕)ノ*:・゚✧

8
chefry
Re: Tables not created
  • 2011/7/5 12:56

  • chefry

  • Home away from home

  • Posts: 1005

  • Since: 2006/10/14


reducing MySQL to 5.0.88 did the trick
Thanks :)

9
deepak267
Re: Tables not created
  • 2011/7/5 15:48

  • deepak267

  • Quite a regular

  • Posts: 352

  • Since: 2008/8/15


Good to know that you could resolve this issue.

What was the previosu version of MySQL?

Deepak

10
Mamba
Re: Tables not created
  • 2011/7/5 16:45

  • Mamba

  • Moderator

  • Posts: 11409

  • Since: 2004/4/23


He had mysql 5.5.8

Kudos to iHackCode for finding the solution.
Support XOOPS => DONATE
Use 2.5.11 | Docs | Modules | Bugs

Login

Who's Online

178 user(s) are online (123 user(s) are browsing Support Forums)


Members: 0


Guests: 178


more...

Donat-O-Meter

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

Latest GitHub Commits