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 Modules Support forums / 
  3. Module troubleshooting 
  4.  / Table 'xb22_wfdownloads_mirrors' already exists
Register
1
xuanyuu
Table 'xb22_wfdownloads_mirrors' already exists

  • 2009/8/15 13:38

  • xuanyuu

  • Just popping in

  • Posts: 53

  • Since: 2009/8/15


Dear guys,
i install the WF_ downloads and then i uninstall it. when i want to reinstall the module, it come out error
Table 'xb22_wfdownloads_mirrors' already exists
please help on how i can solve it and enable me to reinstall the WF_download. BTW, the version is 3.2

thank you
2
ghia
Re: Table 'xb22_wfdownloads_mirrors' already exists

  • 2009/8/15 14:00

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


xuanyuu, welcome to the XOOPS forum!

It seems something went wrong during uninstall and some tables are left behind in the database.
You need to erase them first, before a new install will succeed.
Use eg phpMyAdin to drop this tables. You can look up the names (without prefix) in the /modules/wfdownloads/sql/mysql.sql file.

Put also PHP debug on in the preferences, so you are informed at errors during the installation.
3
xuanyuu
Re: Table 'xb22_wfdownloads_mirrors' already exists

  • 2009/8/15 14:31

  • xuanyuu

  • Just popping in

  • Posts: 53

  • Since: 2009/8/15


thanks ghia
but my /modules/wfdownloads/sql
doesn't hv mysql.sql.
only index.html and wfdownload.sql.
please teach me step by step, am still new to XOOPS and alot to learn..
thank you
4
ghia
Re: Table 'xb22_wfdownloads_mirrors' already exists

  • 2009/8/15 15:52

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


Probably you must look into that file. The names are following the 'create table' directives.
Probably they start all with prefix_wfdownloads_ as in your example in the first post.
A tutorial on how to drop tables in phpMyAdmin is here.

Backup your site (files and database) first!
5
xuanyuu
Re: Table 'xb22_wfdownloads_mirrors' already exists

  • 2009/8/15 16:44

  • xuanyuu

  • Just popping in

  • Posts: 53

  • Since: 2009/8/15


in phpmyadmin. when i click on database, it said no database exist.
so waht can i do now?
thanks.
6
ghia
Re: Table 'xb22_wfdownloads_mirrors' already exists

  • 2009/8/15 23:52

  • ghia

  • Community Support Member

  • Posts: 4953

  • Since: 2008/7/3 1


(Do you have a server with cPanel as server administration panel and/or was the phpMyAdmin part of the administration tools of your server?)
If you look in /mainfile.php, you see the definitions for XOOPS_DB_HOST and XOOPS_DB_USER. Normally XOOPS_DB_HOST is localhost.
Do these values correspond to what you see in the phpMyAdmin home page?
If not, you may be using the phpMyAdmin of the wrong server. Reconnect to the correct server with the username and password as defined in /mainfile.php .
Then you should see the database (with the name as defined by XOOPS_DB_NAME).
PS: do NOT publish the values of these definitions here.

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

349 user(s) are online (289 user(s) are browsing Support Forums)

Members: 0

Guests: 349

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