|v 2.7.7 Step 2: CREATE UNIQUE INDEX [message #40203]
||Tue, 22 January 2008 08:13
Registered: January 2008
||add to buddy list
ignore all messages by this user
thank you for a great software. I never had to post a significant problem with fudforum (up till 2.7.6) yet.
After removal to new server (on my other servers fudforum 277 is all nice and dandy), second step of installation says:
Failed to create table "fud_users" ("CREATE UNIQUE INDEX fud277_users_i_l ON fud277_users (login)"),
SQL Reason: Access denied for user 'whatever'@'' to database 'something'
Database dropdown-options were:
MySQL (this one selected in first scenario)
A look with phpMyAdmin confirms one incomplete table.
After "deleting" install.php forum says
Query: Failed to establish database connection, PDO says: invalid data source name
Some (shared hosting) server info:
MySQL server version: 4.1.13-standard-log
MySQL host info: server.whatever.net via TCP/IP
MySQL client info: 4.1.9
PHP Version: 5.2.5 (via CGI)
Now the "phantom" second scenario:
selected database type "PDO: SQLite" and installation went through. Forum running, add users no problem, topics, posting, OK.
However, I can't see any tables with phpMyAdmin nor can the friendly admin of the hosting company. But the data has to be stored somewhere...
Well, I wouldn't mind it working so far, but I really want to dump back the contents of my forum though...
btw, the hosting admin claims "PDO: SQLite" is definitely not available. (And I would like to run it with MySQL for compatibility reasons)
Is there a way to get it working with this configuration? Or what is the problem anyway?
Better alone in the dark, than collective insanity.