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 :: Polls :: Message Navigator
| Subscribe to topic | Remove from bookmarks 		 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
 remove from buddy list
stop ignoring 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: 3771
Registered: December 2004
Karma: 28
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).

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 05:36 Go to previous messageGo to next message
bbnewbie is currently offline  bbnewbie   
Messages: 27
Registered: December 2011
Karma: 0
Junior Member
 remove from buddy list
stop ignoring 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.

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 05: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
 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?

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 06:14 Go to previous messageGo to next message
bbnewbie is currently offline  bbnewbie   
Messages: 27
Registered: December 2011
Karma: 0
Junior Member
 remove from buddy list
stop ignoring 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.

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 06:56 Go to previous messageGo to next message
bbnewbie is currently offline  bbnewbie   
Messages: 27
Registered: December 2011
Karma: 0
Junior Member
 remove from buddy list
stop ignoring 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

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 07:46 Go to previous messageGo to next message
bbnewbie is currently offline  bbnewbie   
Messages: 27
Registered: December 2011
Karma: 0
Junior Member
 remove from buddy list
stop ignoring 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
 remove from buddy list
stop ignoring 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

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 11:53 Go to previous message
naudefj is currently offline  naudefj   South Africa
Messages: 3771
Registered: December 2004
Karma: 28
Senior Member
Administrator
Core Developer
 add to buddy list
ignore all messages by this user
You can view errors in the Error Log Viewer.

Report message to a moderator

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: Mon Oct 14 11:36:05 EDT 2024

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

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