1
kiwiguy
tables already exist?
  • 2004/5/12 14:17

  • kiwiguy

  • Friend of XOOPS

  • Posts: 295

  • Since: 2004/4/19


I re installing after accidently deleting my site i get close to the final part of the install and it comes up red saying i think tables for xoop2 already exist or databes for xoop2 already exists i have tried uploading a back up site but it will not do it i am operating from a sub-domain also would that be a problem?

2
Mithrandir
Re: tables already exist?

you accidently deleted the files on the site? But the database is still there?

If that is the case, you should just upload the XOOPS package with the modules, you used to have.
After that, just make sure that the information in mainfile.php is correct (paths, database settings) and you should be good to go.

All the installation does is write the information to mainfile.php and create the database tables, but if you have already the database, all that remains is the database, which you can edit manually.

3
kiwiguy
Re: tables already exist?
  • 2004/5/13 6:56

  • kiwiguy

  • Friend of XOOPS

  • Posts: 295

  • Since: 2004/4/19


I re uploaded the back up site no probs but get a blank screen I am able to get into my admin section via a seperate link I kept. I have no idea how to find out if the mainfile.php is correct as I am not php literate i will copy the mainfile.php here for you to look and let me know if it is ok. I have also blanked out my password for my security! Also this is what is said when I try to do a fresh install. I really need to know what to do as its been offline for 2 days now.

Quote:
Tables for xoops2 already exist


cheers
kiwiguy


Quote:
<?php
// $Id: mainfile.dist.php,v 1.5 2003/02/12 11:36:33 okazu Exp $
// ------------------------------------------------------------------------ //
// XOOPS - PHP Content Management System //
// Copyright (c) 2000 XOOPS.org //
// <https://xoops.org/> //
// ------------------------------------------------------------------------ //
// This program is free software; you can redistribute it and/or modify //
// it under the terms of the GNU General Public License as published by //
// the Free Software Foundation; either version 2 of the License, or //
// (at your option) any later version. //
// //
// You may not change or alter any portion of this comment or credits //
// of supporting developers from this source code or any supporting //
// source code which is considered copyrighted (c) material of the //
// original comment or credit authors. //
// //
// This program is distributed in the hope that it will be useful, //
// but WITHOUT ANY WARRANTY; without even the implied warranty of //
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the //
// GNU General Public License for more details. //
// //
// You should have received a copy of the GNU General Public License //
// along with this program; if not, write to the Free Software //
// Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA //
// ------------------------------------------------------------------------ //

if ( !defined("XOOPS_MAINFILE_INCLUDED") ) {
define("XOOPS_MAINFILE_INCLUDED",1);

// XOOPS Physical Path
// Physical path to your main XOOPS directory WITHOUT trailing slash
define('XOOPS_ROOT_PATH', '/home/httpd/vhosts/theboogary.com/subdomains/kiwisworld/httpdocs');

// XOOPS Virtual Path (URL)
// Virtual path to your main XOOPS directory WITHOUT trailing slash
define('XOOPS_URL', 'http://kiwisworld.theboogary.com');

// Database
// Choose the database to be used
define('XOOPS_DB_TYPE', 'mysql');

// Table Prefix
// This prefix will be added to all new tables created to avoid name conflict in the database. If you are unsure, just use the default 'xoops'.
define('XOOPS_DB_PREFIX', 'xoops');

// Database Hostname
// Hostname of the database server. If you are unsure, 'localhost' works in most cases.
define('XOOPS_DB_HOST', 'localhost');

// Database Username
// Your database user account on the host
define('XOOPS_DB_USER', 'kiwisworld');

// Database Password
// Password for your database user account
define('XOOPS_DB_PASS', 'xxxx');

// Database Name
// The name of database on the host. The installer will attempt to create the database if not exist
define('XOOPS_DB_NAME', 'kiwisworld');

// Use persistent connection? (Yes=1 No=0)
// Default is 'Yes'. Choose 'Yes' if you are unsure.
define('XOOPS_DB_PCONNECT', 0);

define('XOOPS_GROUP_ADMIN', '1');
define('XOOPS_GROUP_USERS', '2');
define('XOOPS_GROUP_ANONYMOUS', '3');

if (!isset($xoopsOption['nocommon'])) {
include XOOPS_ROOT_PATH."/include/common.php";
}
}
?>

4
Herko
Re: tables already exist?
  • 2004/5/13 7:43

  • Herko

  • XOOPS is my life!

  • Posts: 4238

  • Since: 2002/2/4 1


If you put this mainfile.php in your site's root folder, it doesn't work? You get a blank page? That is maybe because you used to have a different theme that is now missing, or modules that are now missing?

Herko

5
kiwiguy
Re: tables already exist?
  • 2004/5/13 7:48

  • kiwiguy

  • Friend of XOOPS

  • Posts: 295

  • Since: 2004/4/19


well yes that still does not answer my question does it so is there anything i can do as I am a sub domain at the end of the day will I have to wait for the domain owner to delete the tables from his end so i ca re install it??

6
Herko
Re: tables already exist?
  • 2004/5/13 7:51

  • Herko

  • XOOPS is my life!

  • Posts: 4238

  • Since: 2002/2/4 1


OK, if you can get into the site's admin section (the XOOPS admin, not the domain admin), then the mainfile.php is correct and can be left alone. Now go to the admin section of your site and turn on php-debug (system admin->preferences->general settings). Then open a new window and go to the homepage, and see what is causing the blank page (you'll get some error messages).

With those messages, we can work out a solution.

Herko

7
FlySwatter
Re: tables already exist?
  • 2004/6/8 12:09

  • FlySwatter

  • Just popping in

  • Posts: 71

  • Since: 2004/6/2 1


Sounds like you already have a MySQL db named xoops. One way is to go into phpmyadmin and DROP the db.

Login

Who's Online

234 user(s) are online (146 user(s) are browsing Support Forums)


Members: 0


Guests: 234


more...

Donat-O-Meter

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

Latest GitHub Commits