Database Connection...
 
Notifications
Clear all

Database Connection Problem

4 Posts
3 Users
0 Reactions
2,136 Views
(@sneddy)
Posts: 9
Active Member
Topic starter
 

I installed and upgraded to the latest version of efiction and that worked fine.  The database was also created without any problems.  It was when I imported the database from version 2.x of efiction that I ran across this problem...

A fatal MySQL error was encountered.
Query: SELECT ap.*, author.uid as uid, author.penname as penname, author.email as email, author.password as password FROM fanfiction_authors as author LEFT JOIN fanfiction_authorprefs as ap ON ap.uid = author.uid WHERE author.uid = '1'
Error: (1146) Table 'library.fanfiction_authors' doesn't exist

For some reason it is not recognising the table prefix which is ef_ 

"library" is the name of the database.

The version of php is 4.3.11

I have no idea what the problem is or why this is happening.  Is there a fix or will I have to start all over again.


 
Posted : 02/03/2007 12:49 am
(@carissa)
Posts: 791
Member Moderator
 

I installed and upgraded to the latest version of efiction and that worked fine.  The database was also created without any problems.  It was when I imported the database from version 2.x of efiction that I ran across this problem...

Why were you trying to import a 2.x database into a 3.x site?

Do you have a tableprefix set it your settings?


 
Posted : 02/03/2007 1:07 am
(@sneddy)
Posts: 9
Active Member
Topic starter
 

yeah I was trying to import the database we had for the 2.x library to the new version.  It had the same table prefix as the new one.


 
Posted : 02/03/2007 1:26 am
Jan_AQ
(@jan_aq)
Posts: 1300
Noble Member
 

3.0 updates the 2.0 database, so you have to let the 2.0 database exist while you update the 2.0 archive to 3.0.


Whoever said nothing is impossible never tried slamming a revolving door.

url: https://www.potionsandsnitches.org/fanfiction
php: 7.4.33 msql: 5.6.51-community GPL
efic version: 3.5.5 latest patches: yes
bridges: none mods: challenges, tracker, story end, beta, word

 
Posted : 02/03/2007 4:32 pm
Share: