MySQL + OpenBookings.org #1046 - No database selected
Hejsa,Sidder lige og prøver at forbinde/konfigurere et booking system fra Openbookings.org på en vens hjemmeside på surftown.
Det virker ikke og jeg får underlige fejl:
SQL-forespørgsel:
-- phpMyAdmin SQL Dump
-- version 2.8.1
-- http://www.phpmyadmin.net
--
-- Host: 212.97.132.73
-- Generation Time: Oct 23, 2006 at 12:34 PM
-- Server version: 4.1.18
-- PHP Version: 5.1.6
--
-- Database: `svan1_openbookings
--
-- --------------------------------------------------------
--
-- Table structure for table `rs_data_bookings`
--
CREATE TABLE `rs_data_bookings` (
`book_id` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`rand_code` smallint( 5 ) unsigned default NULL ,
`book_date` datetime NOT NULL default '0000-00-00 00:00:00',
`object_id` smallint( 5 ) unsigned NOT NULL default '0',
`user_id` smallint( 5 ) unsigned NOT NULL default '0',
`book_start` datetime NOT NULL default '0000-00-00 00:00:00',
`book_end` datetime NOT NULL default '0000-00-00 00:00:00',
`validated` tinyint( 1 ) unsigned NOT NULL default '0',
`misc_info` varchar( 255 ) NOT NULL default '',
PRIMARY KEY ( `book_id` ) ,
KEY `book_date` ( `book_date` ) ,
KEY `object_id` ( `object_id` ) ,
KEY `user_id` ( `user_id` ) ,
KEY `book_start` ( `book_start` ) ,
KEY `book_end` ( `book_end` ) ,
KEY `rand_code` ( `rand_code` )
) ENGINE = MYISAM AUTO_INCREMENT =34
MySQL returnerede:
#1046 - No database selected
Config.php er ændret til:
//path to the bookings application folders (used for email validation system)
$app_path = "http://www.kropogtrivsel.dk/openbookings/";
// Database Settings
// Name or IP adress of the mysql server (default : "localhost" if both database and web server are installed on the same machine)
$db_server_address = "212.97.132.XXX";
// Name of the MySQL database or ODBC source (default : "openbookings")
$database_name = "svan1_openbookings";
// Store once your database connection credentials here
$db_user = "user";
$db_password = "password";
// Choose your connection mode ("mysql" or "odbc")
$db_connection_type = "mysql"; // "odbc";
// Use this setting to correct timezone troubles (ie your server is not in you country)
// time offset = (Server timezone - User timezone) * 3600
// You live in Paris (GMT+1) and the server is in Moscow (GMT+3)
// time offset = (3 - 1) * 3600
// default is 0 if your server is local
$time_offset = 0; // seconds
?>
er der een der kan hjælpe??