Loading...
 
Skip to main content

Architecture / Installation


no database selected in query

posts: 2

I believe I have followed the installation properly but I get this when I run
http://localhost/tiki/index.php
Does anyone know what this means.
Thanks

PS: I am on Windows Xp with IIS 6. I have created the virtual dir.
Mysql has a db called tiki and i have modified the apropriate .php files to tell it my db name, username and password.
I can login to mysql
mysql -u root -p passxxx
connect tiki
This works.
Also I have crated the tiki database using the script.
Here is the error.



Warning: MYSQL error: DB Error: no database selected in query:
select value from tiki_preferences where name='rememberme'
in C:\tikiwiki\lib\tikilib.php on line 101

posts: 4

I have the same problem, but my tiki is on redhat 9


any answers?


posts: 6 Belgium

I saw this message also before I created the tables within the database tiki, if I recollect correctly.
But I'm running tiki on a hosted linux server which has phpMyadmin.
Or you sure that all the necessary tables or in the database tiki!?
If not try to use a MySQL database administration tool wich works in XP. You have to use a PHP/MySQL servvices anyway which can read php and can connect to you're databases!.
If you have installed MySQL you should also install PhpMyadmin, I think.
See: PHPMyAdmin homepage


Hope this is usefull info!


posts: 4

well I dont know why or how but in the tiki-db.php file i moved the:
?>
EOF

to just below the database connection section and I get a whole list of different errors


posts: 4

well i moved the EOF and ?> back to where it should be, and then i edited the /tiki-1.7/db/local.php to the correct mysql stuff and now I have some progress, the new error is:

Unable to login to the MySQL database 'tiki' on 'localhost' as user 'wiki' go here to begin the installation process, if you havent done so already

DB Error: connect failed


posts: 2

I'm sure I have all tables and still get the same message.

Warning: MYSQL error: DB Error: no database selected in query:
select value from tiki_preferences where name='rememberme'
in C:\tikiwiki\lib\tikilib.php on line 101

I have phpMyAdmin and I checked

Any other ideas please

Thanks


> theweb:
> Or you sure that all the necessary tables or in the database tiki!?