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 :: Unread Messages :: Show Polls :: Message Navigator
| Subscribe to topic | Bookmark topic 
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] Wed, 11 January 2012 20:11 Go to next message
bbnewbie is currently offline  bbnewbie   
Messages: 27
Registered: December 2011
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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: Wed, 11 January 2012 20: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 00:17 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
FUDforum will delete old session data (based on your settings), but won't remove users (unless specifically requested by an admin).
Re: The database disappears when I log out and back in [message #166544 is a reply to message #166543] Thu, 12 January 2012 05:36 Go to previous messageGo to next message
bbnewbie is currently offline  bbnewbie   
Messages: 27
Registered: December 2011
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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.
Re: The database disappears when I log out and back in [message #166545 is a reply to message #166544] Thu, 12 January 2012 05:52 Go to previous messageGo to next message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
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?
Re: The database disappears when I log out and back in [message #166546 is a reply to message #166545] Thu, 12 January 2012 06:14 Go to previous messageGo to next message
bbnewbie is currently offline  bbnewbie   
Messages: 27
Registered: December 2011
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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.


Re: The database disappears when I log out and back in [message #166547 is a reply to message #166546] Thu, 12 January 2012 06:56 Go to previous messageGo to next message
bbnewbie is currently offline  bbnewbie   
Messages: 27
Registered: December 2011
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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


Re: The database disappears when I log out and back in [message #166548 is a reply to message #166547] Thu, 12 January 2012 07:46 Go to previous messageGo to next message
bbnewbie is currently offline  bbnewbie   
Messages: 27
Registered: December 2011
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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 10: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 17:07 Go to previous messageGo to next message
bbnewbie is currently offline  bbnewbie   
Messages: 27
Registered: December 2011
Karma: 0
Junior Member
add to buddy list
ignore all messages by this user
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
Re: The database disappears when I log out and back in [message #166557 is a reply to message #166551] Mon, 16 January 2012 11:53 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3632
Registered: December 2004
Karma: 17
Senior Member
Administrator
Core Developer
add to buddy list
ignore all messages by this user
You can view errors in the Error Log Viewer.
Quick Reply
Formatting Tools:   
  Switch to threaded view of this topic Create a new topic
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: Wed Dec 13 15:50:44 EST 2017

Total time taken to generate the page: 0.00750 seconds