FUDforum: Converters » The database disappears when I log out and back in

Home » FUDforum Development » Converters » The database disappears when I log out and back in

Show: Today's Messages :: Polls :: Message Navigator

The database disappears when I log out and back in [message #166541]

Thu, 12 January 2012 01:11

bbnewbie

Messages: 27
Registered: December 2011

Karma: 0

Junior Member

I've been able to import all of the user names into the fud30_users file.

It seems to work just fine. I can star manipulating the data immediately, BUT if I log back out and log back in it clears out all of the logins except 4 that I manually entered.

Any help would be greatly appreciated. Thanks!

[Updated on: Thu, 12 January 2012 01:11]

Report message to a moderator

Re: The database disappears when I log out and back in [message #166543 is a reply to message #166541]

Thu, 12 January 2012 05:17

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

FUDforum will delete old session data (based on your settings), but won't remove users (unless specifically requested by an admin).

Report message to a moderator

Re: The database disappears when I log out and back in [message #166544 is a reply to message #166543]

Thu, 12 January 2012 10:36

bbnewbie

Messages: 27
Registered: December 2011

Karma: 0

Junior Member

I wonder why it's happening then. It happens when I log out or log back in. The three manually entered users stay, but the 10,000 other users vanish. Could there be a data inconsistency causing this? Thanks.

Report message to a moderator

Re: The database disappears when I log out and back in [message #166545 is a reply to message #166544]

Thu, 12 January 2012 10:52

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

What type of DB is this? MySQL? What engine?
How do you insert the data? With FUDAPI?
Do you COMMIT the data after the insert?

Report message to a moderator

Re: The database disappears when I log out and back in [message #166546 is a reply to message #166545]

Thu, 12 January 2012 11:14

bbnewbie

Messages: 27
Registered: December 2011

Karma: 0

Junior Member

Thanks for replying so quickly.

Answers:
> I'm using MySQL.
> I upload the file through phpmyadmin. I structured the data to match the database.
> I didn't COMMIT the data. I'm not sure what that is.

Report message to a moderator

Re: The database disappears when I log out and back in [message #166547 is a reply to message #166546]

Thu, 12 January 2012 11:56

bbnewbie

Messages: 27
Registered: December 2011

Karma: 0

Junior Member

Okay, it looks like the data was committed. I'm able to see it and manipulate it in FudForum. But when I log out, it reverts to the 3 manually entered logins

Report message to a moderator

Re: The database disappears when I log out and back in [message #166548 is a reply to message #166547]

Thu, 12 January 2012 12:46

bbnewbie

Messages: 27
Registered: December 2011

Karma: 0

Junior Member

I'm wondering if I'm missing data in a critical field that causes the forum to kick out the uploaded ones or if there's a reference issue.

[Updated on: Thu, 12 January 2012 15:54]

Report message to a moderator

Re: The database disappears when I log out and back in [message #166551 is a reply to message #166548]

Sat, 14 January 2012 22:07

bbnewbie

Messages: 27
Registered: December 2011

Karma: 0

Junior Member

This is the error I'm getting when I run the php script to upload the data:

Fatal error: SQL error has occurred, please contact the administrator of the forum and have them review the forum's SQL query log in /home/fightof8/FUDforum/include/core.inc on line 260

Report message to a moderator

Re: The database disappears when I log out and back in [message #166557 is a reply to message #166551]

Mon, 16 January 2012 16:53

naudefj

Messages: 3771
Registered: December 2004

Karma: 28

Senior Member
Administrator
Core Developer

You can view errors in the Error Log Viewer.

Report message to a moderator

Previous Topic:	Converting a database with encrypted passwords
Next Topic:	Possibly utf-8 problem in conversion

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 19:31:12 GMT 2024

Total time taken to generate the page: 0.08804 seconds