Sub Menu
Links Menu
Online Users

In total there are 265 users online :: 2 registered, 0 hidden and 263 guests

Most users ever online was 1091 on Wed Aug 16, 2023 5:27 pm

Registered users: Bing [Bot], Google [Bot] based on users active over the past 60 minutes

Database trouble

General discussion of anything. Discuss a topic in and out of IntegraMOD

Moderator: Integra Moderator

Database trouble

PostAuthor: MWE_001 » Wed Mar 28, 2007 9:08 pm

Hello all. I recently switched server and had loads of trouble. all is well now BUt whn i dumped my database to run the site, not everything is working. All I did was open it in word pad and copy paste in the database query box. Not correct im sure. Is there a better way to do it?
Last edited by MWE_001 on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
"Don't gain the world and lose your soul, wisdom is better than silver and gold" -Bob Marley

If you build it, I can break it! ~ Whispered in the tone of the movie Field of Dreams.
User avatar
MWE_001
Sr Integra Member
Sr Integra Member
 
Posts: 1265
Likes: 0 post
Liked in: 0 post
Images: 12
Joined: Fri Apr 21, 2006 6:59 pm
Cash on hand: 0.00
Location: Illinois

Re: Database trouble

PostAuthor: Helter » Fri Mar 30, 2007 11:04 am

if your db is small enough, that should work fine. Your problems are most likey caused by file permissions, or incorrect urls in your db phpbb_config. Try running cookie mod. It will fix most of the dir probs. You will still have to go through and look for old dir references
Last edited by Helter on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
Always use Protection
Image


Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4168
Likes: 0 post
Liked in: 0 post
Images: 0
Joined: Sat Mar 11, 2006 3:46 pm
Cash on hand: 187.60
Location: Seattle Wa
IntegraMOD version: IM 3

Re: Database trouble

PostAuthor: MWE_001 » Sat Mar 31, 2007 2:45 am

My Db is like 3.5 megs I dont think thats bad ehh? Im querying the Db from phpMyAdmin directly and not the user Db in ACP.

I fixed all the links in the Db prior to dumping data in the Db. The issue is, in some of my tables, the items and data are there, its just not reflecting the changes on submit and does not show up on site. It s kind of like the good ol problem in phpBB Security when you install it and go to set your admins and Mods and it wont save the info. it defaults back to 1 admin 0 mods.......

Hope that helped some. My methods of explanation tend to s*ck from time to time. <img>
Last edited by MWE_001 on Wed Dec 31, 1969 4:00 pm, edited 1 time in total.
"Don't gain the world and lose your soul, wisdom is better than silver and gold" -Bob Marley

If you build it, I can break it! ~ Whispered in the tone of the movie Field of Dreams.
User avatar
MWE_001
Sr Integra Member
Sr Integra Member
 
Posts: 1265
Likes: 0 post
Liked in: 0 post
Images: 12
Joined: Fri Apr 21, 2006 6:59 pm
Cash on hand: 0.00
Location: Illinois


Return to General Discussion

Who is online

Registered users: Bing [Bot], Google [Bot]

cron