Hi
After uploading and installing joodatabase, when I try to add a new database, the following happens:
Step 1 (Choose your database):
The names of the tables of my Joomla DB (the standard Joomla tables plus 4 custom tables (one of them is reproduced below)) appear in the second drop down menu, so there is no problem with the connection). I then click on one of these.
(BTW, some more guidance as to WHICH of these tables to choose would be appreciated for newbies to Joomla such as myself).
Step 2 (Define important fields):
Having filled out the 3 fields, I click on "Continue" and...nothing happens, except a small "Error on page" message in the bottom left corner. When i then try to access this new DB anywhere in Joomla (eg via the Menu Manager), I can't find it.
I am sure (from the reviews) that the product is "ausgezeichnet", so would appreciate any help you can give.
Many thanks
Tim.
(System: Windows 7;PHP 5.3.8 (installed via XAMPP, Joomla 1.7).
/*Table structure for table `cities` */
DROP TABLE IF EXISTS `cities`;
CREATE TABLE `cities` (
`C_No` int(11) unsigned NOT NULL AUTO_INCREMENT,
`C_Code` varchar(3) NOT NULL,
`C_ID` varchar(30) NOT NULL,
`CountryID` mediumtext NOT NULL,
`SectorID` char(8) NOT NULL,
`SizeID` char(5) NOT NULL,
`Direct_from_London?` char(3) NOT NULL,
`Direct_from_Brussels?` char(3) NOT NULL,
`Direct_from_Lille?` char(3) NOT NULL,
`Direct_from_Paris?` char(3) NOT NULL,
`Realistic_via_Brussels_from_London?` char(3) NOT NULL,
`Realistic_via_Lille_from_London?` char(3) NOT NULL,
`Realistic_via_Paris_from_London?` char(3) NOT NULL,
`DB_station_name` char(30) NOT NULL,
`Is_IDTGV_City?` char(3) NOT NULL,
`Is_Thalys_City?` char(3) NOT NULL,
PRIMARY KEY (`C_No`),
KEY `C_ID` (`C_ID`)
) ENGINE=MyISAM AUTO_INCREMENT=59 DEFAULT CHARSET=latin1;
/*Data for the table `cities` */
