sql help

Client Joined: Mar 09, 2005 Posts: 157

2 of my installations that required sql import didn't work so I think I didn't import the sql correctly. Here's what I did open up phpmyadmin, went to my database, went to sql, browsed to the sql I wanted. Then it says successful import or whatever. Is that right, why isn't it working. btw the 2 installations are wb block manager and who-is-where block 2.1. Please help.

Posted: Sun Mar 27, 2005 11:03 am

Which message did`t you get after the sql import ? Are there any new tables in the DB ?

Btw: who is where is easy to install.

Posted: Sun Mar 27, 2005 11:14 am

i haven't had much success with sql import, i try reading up on it and i did exactly like it says. I get a message saying succesful something i forgot and I checked the db and I saw wb block manager as well as who-is-where tables in there. The tables are the list on the left, is that correct? Thanks for helping. What could be the problem

Posted: Sun Mar 27, 2005 11:19 am

The new tables are in the list. Thats correct. I found only one new table for the who is where block. If you have all new tables -whats the problem ? You have to activate the blocks.

If you have any error in your db you can repair there or optimize.But be carefully.I always optimize my db especial the table nuke_sessions.

Posted: Sun Mar 27, 2005 12:04 pm

activate blocks in admin.php? yup of course I did that already. The who-is-where block shows up fine, its just that it doesn't show any members on there at all.

Posted: Sun Mar 27, 2005 12:33 pm

I visit your site, but I could`t see the new block. Ok, have you chanced the my-headers.php in the folder includes ?

Maybe read the install.txt from the whoiswhere again .

Posted: Sun Mar 27, 2005 12:43 pm

i made it so that only admin can see it. Here I'll make it so everyone can see. Check back to my site. I never had a my-header.php so I just used the one that came with the installation for version 2.1

Posted: Sun Mar 27, 2005 12:46 pm

believe me i've spent days on this problem. I've read the installation back and forth. It is simple installation I dont know why its not working

Posted: Sun Mar 27, 2005 12:51 pm

I believe you it`s a simple installation. Smile

I hate installation and updates and thats my job all the time.
I saw your block. Something goes wrong you should install it new.

Posted: Sun Mar 27, 2005 12:55 pm

how to reinstall? Should I delete the who-is-where table and insert it in again?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

Help me understand what the problem is. I am not clear from these posts. And, what is the url?

Posted: Sun Mar 27, 2005 1:03 pm

unll.net. I think I did everything correct but nothign shows up in the block who-is-where.

Posted: Sun Mar 27, 2005 1:17 pm

Are you sure the block is made for nuke v7.6? You might try contacting the author and ask him what the problem might be.

Posted: Sun Mar 27, 2005 1:24 pm

do u not use 7.6 for ur site Raven? Does your whoiswhere block work? The intallation for version 2.1 says it works with 6.5+. Anyway I think it's not a version problem because there are a lot of v7.6. I think Susan has 7.6 since she's pretty up to date with her site and her whoiswhere block works fine.

Posted: Sun Mar 27, 2005 2:05 pm

No, I do not use 7.6. But that who-is-where block that you use is not mine. My block works on 7.6.

Posted: Sun Mar 27, 2005 2:07 pm

lol ill try ur block then god d*** this has got to be the most frustrating thing everrrrrrrrrrrrrrrrrrrrrrrrrrrrr.

Posted: Sun Mar 27, 2005 2:16 pm

I get a blank page in the block when I try yours. And in the module, it just say 2users online and I can't click nothing.

Posted: Sun Mar 27, 2005 2:57 pm

I don´ t use Nuke 7.6 and my who is where version is this:

WHO IS WHERE 2.3 for phpnuke 5.x,6.x and +

Works fine.

Posted: Sun Mar 27, 2005 4:45 pm

I'm about to pull all my hair out........................ I installed who-is-where 2.0,2.1,2.3 (works w/ all nuke versions) none worked. I even installed Jag Online which took like half an hour itself. The installation was SUCCESSSSSSFUUL (it says) and when I go to activate the block guess what I get "There is a problem right now with this block" on the fregggin block, omfg and I spent even more time searching everywhere to see if people have similar problems but couldn't find nothing! If anyone have a clue tell me plzzzzzzzzzzzzzzzzzz, is it the server, is it me, is it sql wtf is it???????????????/

Posted: Sun Mar 27, 2005 7:38 pm

You have not installed my wiw block correctly. That's why you're receiving that error. I know this can be frustrating. There's nothing wrong with the server. Maybe you need to set it aside until tomorrow and then just try reinstalling it? If you go over the installation instructions again, maybe you'll see what might have been missed.

Posted: Sun Mar 27, 2005 10:56 pm

I looked it over carefully.... and I realized I inserted the second part into index instead of module. Having fixed that problem, now the module works but the block still doesn't. So that being the only 2 steps besides importing the sql (and adding the files to ftp), I went back to phpmyadmin and clicked on the table nuke_wiw_m just to see if anything look odd (bec i dont know wtf I'm doing) and I see <img src"https://unll.net:2083/3rdparty/phpMyAdmin/themes/original/img/s_warn.png">No index defined! Should I define an index? I spent most of today, let me rephrase that I've WASTED most of today getting nothing done so if I can get this out of the way tonight then it's atleast a step forward. Thanks

Posted: Sun Mar 27, 2005 11:11 pm

No, you don't need an index. "I've WASTED most of today getting nothing done" - welcome to our world ROTFL

- Have you activated the block?

Posted: Sun Mar 27, 2005 11:12 pm

BTW, something is wrong with your site - it never stops trying to load. Looks like a runaway block or something.

Posted: Sun Mar 27, 2005 11:27 pm

It seems to load fine to me but I'll check it out. Yes I activated it but in the block it has that page cannot be found thing.

Posted: Sun Mar 27, 2005 11:30 pm

It never loads, at least for a visitor. Activate the block so i can see what the url is that it can't find.