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.  / Problem creating table in Xoops 2.2.5
Register
1
melsampah
Problem creating table in Xoops 2.2.5

  • 2007/9/9 3:41

  • melsampah

  • Just popping in

  • Posts: 3

  • Since: 2006/3/23


Hi,
I get error during Installation at the creating tables stage. Failed to create 2 tables but other tables ok.

ie.
Failed creating table x225_user_profile_field.
Failed creating table x225_block_instance.


Database tables created.


Im using Apache 2.2.5, PHP 5.2.4, MySQL 5.0.45 on Win XP.
Kindly advise.
Thanks
2
MartinF
Re: Problem creating table in Xoops 2.2.5

  • 2007/9/12 17:17

  • MartinF

  • Just popping in

  • Posts: 2

  • Since: 2007/9/12


Look at this:

change /install/sql/mysql_structure.sql
like this:
At->
CREATE TABLE `user_profile_field` ( ..
change
`field_options` text NOT NULL default '',

in

`field_options` text,

and at
CREATE TABLE `block_instance` (..


`options` text NOT NULL default '',

in
`options` text,


This will install your Tables, but XOOPS 2.2.5 will not run under MySQL 5.

There are more Problems next Step
I think its better use MySQL 4.x
3
McDonald
Re: Problem creating table in Xoops 2.2.5

  • 2007/9/12 18:48

  • McDonald

  • Home away from home

  • Posts: 1072

  • Since: 2005/8/15


Try it by removing
default ''

from the following sql-files:
\modules\system\sql\mysql.sql
\modules\system\sql\upgrade205.sql
4
MartinF
Re: Problem creating table in Xoops 2.2.5

  • 2007/9/14 15:59

  • MartinF

  • Just popping in

  • Posts: 2

  • Since: 2007/9/12


Quote:

McDonald wrote:
Try it by removing
default ''

from the following sql-files:
\modules\system\sql\mysql.sql
\modules\system\sql\upgrade205.sql


Only i have:
\modules\system\sql\upgrade205.sql
\modules\system\sql\upgrade.sql

But no "\modules\system\sql\mysql.sql

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

377 user(s) are online (64 user(s) are browsing Support Forums)

Members: 0

Guests: 377

more...

Donat-O-Meter

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

Latest GitHub Commits