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.  / Database - Tables already exsist - how to reset?
Register
1
totallyretar
Database - Tables already exsist - how to reset?

"Tables for XOOPS2 already exist in your database."

anyone know how to reset this because I had to reinstall. thanx.
2
m0nty
Re: Database - Tables already exsist - how to reset?

  • 2004/7/26 3:04

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


hmmmm

if you're not bothered about saving all your posts and content, then just drop all the tables using phpmyadmin and then go thru the install process again.

what reason did u have for reinstalling? as if it was just user problems that messed the site up etc, then it shud be possible to just copy all the XOOPS files except mainfile.php and it shud then work.. so u cud just re-enter the MySQL info back into mainfile.php.. ie db host, db user and db password..
3
totallyretar
Re: Database - Tables already exsist - how to reset?

well. i have zencart on the same database, so its a little tricky. check out www.qualitystuffcheap.com

I am trying to figure out how to drop just the XOOPS tables. I have phpmyadmin installed, but not sure were to do that at. can you tell me where. thanx

4
m0nty
Re: Database - Tables already exsist - how to reset?

  • 2004/7/26 5:00

  • m0nty

  • XOOPS is my life!

  • Posts: 3337

  • Since: 2003/10/24


ahh ok, well if u have phpmyadmin.. click on the database name in the left column..
or select if u have that option..

then in the right column you'll then see the table structure of the database

ie.

Table Action Records Type Size
xoops_avatar Browse Select Insert Properties Drop Empty 0 MyISAM 1.0 KB


with tick boxes down the left

tick all the boxes that have the XOOPS prefix to them and then at the bottom of the page you'll see a selection box that says with selected.. click that and select drop and it will drop the tables that you ticked..
5
totallyretar
Re: Database - Tables already exsist - how to reset?

basicley, everything is functional, but I have a blank page when I click homepage.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

163 user(s) are online (93 user(s) are browsing Support Forums)

Members: 0

Guests: 163

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