FUDforum
Fast Uncompromising Discussions. FUDforum will get your users talking.
Home » FUDforum Development » Converters » The database disappears when I log out and back in
Show: Today's Messages :: Polls :: Message Navigator
Switch to threaded view of this topic Create a new topic Submit Reply
The database disappears when I log out and back in [message #166541] Thu, 12 January 2012 01:11 Go to next message
bbnewbie is currently offline  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 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
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 Go to previous messageGo to next message
bbnewbie is currently offline  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 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
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 Go to previous messageGo to next message
bbnewbie is currently offline  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 Go to previous messageGo to next message
bbnewbie is currently offline  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 Go to previous messageGo to next message
bbnewbie is currently offline  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 Go to previous messageGo to next message
bbnewbie is currently offline  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 Go to previous message
naudefj is currently offline  naudefj   South Africa
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

  Switch to threaded view of this topic Create a new topic Submit Reply
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) ] [ RSS ]

Current Time: Sun Nov 24 09:13:58 GMT 2024

Total time taken to generate the page: 0.02838 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.1.3.
Copyright ©2001-2023 FUDforum Bulletin Board Software