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 xoopsdb does not exists
Register
1
totalcy
Database xoopsdb does not exists

  • 2004/11/24 12:33

  • totalcy

  • Just popping in

  • Posts: 3

  • Since: 2004/11/24


Hi,

I am using cPanel X hosting with
PHP version 4.3.9
MySQL version 4.0.22-standard .

I have created a database using MySQL databases from my hosting control panel and started the installation.
First couble of screens went ok, but now i get the :

Connection to database server is OK.
Database xoopsdb does not exists.
The following database was not found on the server:
xoopsdb
Attempt to create it?

I press atempt to create database >> and i get :
Could not create database. Contact the server administrator for details

what can i do?

reagrds,
andy
2
wtravel
Re: Database xoopsdb does not exists

This may be not the case in your control panel but when I created a database named xoopsdb it actually was created as username_xoopsdb because of the settings for my hosting account.

Can you check in the control panel the name of the database?

Regards,

Martijn
3
totalcy
Re: Database xoopsdb does not exists

  • 2004/11/24 15:07

  • totalcy

  • Just popping in

  • Posts: 3

  • Since: 2004/11/24


done.. thank you very much
4
metta
Re: Database xoopsdb does not exists

  • 2006/3/17 2:26

  • metta

  • Just popping in

  • Posts: 3

  • Since: 2006/3/17


I have the same problem as Totalcy, and understand i have the correct database name from the control panel, yet the error message still comes up. What can i do? Please help.Quote:

wtravel wrote:
This may be not the case in your control panel but when I created a database named xoopsdb it actually was created as username_xoopsdb because of the settings for my hosting account.

Can you check in the control panel the name of the database?

Regards,

Martijn
5
Quest
Re: Database xoopsdb does not exists

  • 2006/3/17 2:41

  • Quest

  • Friend of XOOPS

  • Posts: 1034

  • Since: 2005/11/19


metta- I am not sure I understand what you are saying is happening for you. Could you do as totalcy did and post what comes up during the installation?

Quest
6
metta
Re: Database xoopsdb does not exists

  • 2006/3/17 3:27

  • metta

  • Just popping in

  • Posts: 3

  • Since: 2006/3/17


Sure, this is my current configuration:

Database Hostname localhost
Database Username australi_master
Database Name australi_asa
Table Prefix XOOPS

Also i went in phpMyAdmin (version 2.6.1-pl2) to check and the db is there. I even ran the mysql.structure and mysql.data provided in the "install/sql/" folder of xoops2.0.13.2 program. Now i have table structures and data in there.

Furthermore, called up my server administrator, and they couldn't help because clearly they can see in cPanel and phpMyAdmin that i have created a database called australi_asa.

This is the error message i keep getting:
####BEGIN####
check database
Connection to database server is OK.
Database australi_asa does not exists.

The following database was not found on the server:
australi_asa

Attempt to create it?
#####END#####

When i click on "next" to attempt to create (even though its there), i get this message:
####BEGIN####
Could not create database. Contact the server administrator for details.
#####END#####

Here is my server information if it helps:
OS: Linux
Apache: 1.3.33 (unix)
Perl: 5.8.1
PHP: 4.3.11
MySql: 4.0.22 standard
cPanel: 10.2.0 release 25

Any idea what i have done wrong?
(Very impressed by your fast response Quest)
7
Quest
Re: Database xoopsdb does not exists

  • 2006/3/17 4:00

  • Quest

  • Friend of XOOPS

  • Posts: 1034

  • Since: 2005/11/19


All seems in order. Could you have put an extra space or something along with either the database when creating it or in the database name during the install. It has to be something like that... I think. In other words the name you are entering into the install has something different (white space-something) which is not identical to the actual dbase name???
If that isn't it you may have to re-create things by dumping them off the server and then do a fresh install. Also, sometimes files can get corrupted during the download process of the version or modules you download.

Interesting...

Quest
8
metta
Re: Database xoopsdb does not exists

  • 2006/3/22 8:36

  • metta

  • Just popping in

  • Posts: 3

  • Since: 2006/3/17


Same error after re-downloading zip file, re-uploading html files, and re-installing. Maybe XOOPS doesnt work on all systems.
9
hmendez
Database xoopsdb does not exists

  • 2006/7/27 20:30

  • hmendez

  • Just popping in

  • Posts: 1

  • Since: 2006/7/13


Guys i "fixed" (avoided) this problem by introducing only the prefix provided by my hosting service. An example:
Your website its called http://www.something.com.
The hosting providers tells you that your username is "something".
Your database created its called something_xoopsdb. Just use the prefix "something" and it will work.
I hope you can fix this too.

hmendez
10
Quest
Re: Database xoopsdb does not exists

  • 2006/7/27 21:17

  • Quest

  • Friend of XOOPS

  • Posts: 1034

  • Since: 2005/11/19


It is very common that when a host provider creates an account for you it is also included with the prefix to the database you create.

Let's say you call your site xxxxxxxxx.com. They create your account and the actual account path is something like:
home/xxxxxxxxx/public_html. This is known as the Physical Path.

When you create your database and call it xoopsdb for example the host provider often adds to the name thus creating the database as xxxxxxxxx_xoopsdb. Note the underscore too.

So, your actual XOOPS database name becomes: xxxxxxxxx_xoopsdb

I hope this helps.
Quest
(1) 2 »

Login

Register now!  |  Lost Password?

Search

Advanced Search

Recent Posts

Who's Online

352 user(s) are online (259 user(s) are browsing Support Forums)

Members: 0

Guests: 352

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