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.  / help! failed creating table at install
Register
1
12lamat
help! failed creating table at install

  • 2005/2/5 10:24

  • 12lamat

  • Just popping in

  • Posts: 4

  • Since: 2005/2/5 1


I try new install XOOPS 2.0.9.2

http://www.tinyweb.nl

I have apache virtual server with MySQL 3.23.58

This occurs:

check database

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

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

Create Tables >> next


Failed creating table #*?_nl_-__avatar.
Failed creating table #*?_nl_-__avatar_user_link.
Failed creating table #*?_nl_-__banner.
Failed creating table #*?_nl_-__bannerclient.
Failed creating table #*?_nl_-__bannerfinish.
Failed creating table #*?_nl_-__block_module_link.
etcetera, etcetera

Database tables created.
 
admin user setting >> next


Please choose your site admin's name and password.

Admin Name

Admin Email

Admin Password

Confirm Password
 
insert data >> next


Warning: Invalid argument supplied for foreach() in //install/index.php on line 1223

Warning: Cannot modify header information - headers already sent by (output started at //install/index.php:1223) in //install/index.php on line 1231

insert data


Failed inserting 1 entries to table ?*#_nl_-__bannerclient.
Failed inserting 6 entries to table ?*#_nl_-__configcategory.
Failed inserting 27 entries to table ?*#_nl_-__configoption.
Failed inserting 1 entries to table ?*#_nl_-__imgset.
 
finish >> next

And now what?
please could anyone help me?
2
jdseymour
Re: help! failed creating table at install

What version of PHP is running on your server?
3
12lamat
Re: help! failed creating table at install

  • 2005/2/6 15:06

  • 12lamat

  • Just popping in

  • Posts: 4

  • Since: 2005/2/5 1


PHP 4.3.3
Bedankt,
4
search-marke
Help I had the same exact error, I followed the directions???

Help I had the same exact error, I followed the directions???
Please help I am running the below

PHP 4.3.10 WITH phpsuexec

MySQL 4.0.22



Thanks in Advance
5
rowdie
Re: Help I had the same exact error, I followed the directions???

  • 2005/2/10 12:20

  • rowdie

  • Just can't stay away

  • Posts: 846

  • Since: 2004/7/21


I'm just guessing here, but it sounds like the known Zend Optimiser problem, where it conflicts with PHP 4.3.10.

If your host is running PHP 4.3.10 ask them if they are also running the latest Zend Optimiser. The earlier versions of the optimiser have a bug that affects 'foreach' calls in PHP 4.3.10.

The original poster mentioned trouble with foreach calls, which makes me suspect that their host might have upgraded their PHP version to 4.3.10. .... is that possible?

References:
XOOPS FAQ

Zend website

PHP bug report

Hope this helps,

Rowd
6
12lamat
Re: Original poster still have the problem

  • 2005/2/10 13:13

  • 12lamat

  • Just popping in

  • Posts: 4

  • Since: 2005/2/5 1


I have php 4.3.3 running, any help welcome, thank you very much
7
jdseymour
Re: Original poster still have the problem

I know that I have seen that error before. But I am not sure what would cause it with PHP 4.3.3

Anyone have ideas on the cause of this?
8
m0nty
Re: help! failed creating table at install

  • 2005/2/11 17:44

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


if it's not zend (altho it would be great if you could inform us of the zend version if ur running 4.3.10)

with the other issue 12lamats, i can't think of it being zend in your case.. but a likely candidate is the old MySQL version.. but i can't be sure about it as i'm running 4.1.9 myself..

to be secure tho, i would really recommend upgrading to php 4.3.10 as it has lots of security fixes, if it's a hosted server i would contact them and really push for them to upgrade their servers as it is a big security risk.. if they refuse i would think about finding a new host.. but regarding these issues i can't think of any reasons other than those aforementioned.. sorry..
9
Mithrandir
Re: help! failed creating table at install

#*?_nl_- is your actual database prefix? Is that valid for MySQL database table names? I don't know, but try with a different, all-letters, prefix and see if that changes things.
10
12lamat
Re: help! failed creating table at install

  • 2005/2/11 18:27

  • 12lamat

  • Just popping in

  • Posts: 4

  • Since: 2005/2/5 1


I do have an all letter prefix, Thanks I'll check with my host for the possibilities of upgrading. Would that be the solution for this problem? I will let you know. I can't just switch host I payed for a year for a Virtual Private Server. The got to XOOPS through my provider, I'll ask them. Once again thanks for replying.
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

249 user(s) are online (193 user(s) are browsing Support Forums)

Members: 0

Guests: 249

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