forum error

New Member Joined: Oct 30, 2004 Posts: 17

hey raven youve fixed quite a few of my problems without knowing as i search the forums and found an answer.
but i have one which is really stumped me

Code:

phpBB : Critical Error





Could not query config information





DEBUG MODE





SQL Error : 1146 Table 'sfa.nuke_bbconfig' doesn't exist





SELECT * FROM nuke_bbconfig





Line : 218


File : e:\domains\s\sfa-clan.org\user\htdocs\modules\Forums\common.php

this happens when i click on my forums icon in the admin.php
any ideas would be appreciated
thx in advance
Xeno14

posted in wrong place, sorry, please move to correct place

registered · Posted: Sat Oct 30, 2004 10:27 am

Check to see if the nuke_bbconfig table exists.

Posted: Sat Oct 30, 2004 11:25 am

it doesnt exist, it should have been created?

the only bb table i have is bb_topics !
does anyone have a query that can install the tables i need?

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

Just strip down the sql that you used for your site and extract only the sql that you need for the missing tables.

Posted: Sat Oct 30, 2004 11:33 am

which tables do i need for the forums to fully function?

Posted: Sat Oct 30, 2004 11:45 am

All tables that begin with nuke_bb for starters. If it doesn't work after that, start over and reload all tables.

Posted: Sat Oct 30, 2004 11:53 am

ive added all the tables i need starting with nuke_bb and now it says

Code:

phpBB : Critical Error





Could not obtain lastvisit data from user table





DEBUG MODE





SQL Error : 1054 Unknown column 'user_id' in 'where clause'





SELECT * FROM nuke_users WHERE user_id = '1'





Line : 73


File : e:\domains\s\sfa-clan.org\user\htdocs\includes\sessions.php

im not re-installing my tables again, its taken a week just to get the front page working properly. with all the modules, even then i have to enter a 3 values manually.
ive been trying to find someone who can sort it, ill give them my acces but no-one seems to know what they are doing lol

Posted: Sat Oct 30, 2004 11:59 am

Your modules won't be affected by reinstalling the tables. If you have installed addons that affected the structure of the tables then that's another issue. Since it's not working now, you can either live without the forums or drop all the tables and start over. Something is missing somewhere. As I said, the modules and blocks won't be affected other than if they need to alter a table.

Posted: Sat Oct 30, 2004 12:07 pm

to get my modules working i have to enter the mod_group field manually,
to get the blocks to actually come up, i had to put an sql code. nothing seems to work without an error message in it.
do you know anyone that i can give my access to, so they can do it as they know what they are doing? please, ive been working on this for a week straight.

Posted: Sat Oct 30, 2004 12:10 pm

Backup your current database.

Delete the whole thing then do a fresh install of the database.

If you don't like the results then just use your backup.

It looks like when you did your first install your sql query did not execute completely.

You will regret it down the road if you don't get it right from the beginning.

Posted: Sat Oct 30, 2004 12:12 pm

im using the nukesql.php from 6 and im using phpnuke7.4 my nukesql from any other version never works. it just refreshes the page when i click run the tests.

ive tryed re-installing several times and it hsnt worked once Crying or Very sad

Posted: Sat Oct 30, 2004 12:16 pm

You have to use the sql included with 7.4.

I don't have the time to install for you. Sorry.

Posted: Sat Oct 30, 2004 12:21 pm

hmmz
can i copy the text from the nuke.sql that came with phpnuke7.4 and input it through the SQL query of phpmyadmin?

Posted: Sat Oct 30, 2004 1:05 pm

Yes you can.

Be sure to delete all previous databse tables.

Posted: Sat Oct 30, 2004 2:09 pm

thx a whole lot, it worked
ahh i can now access the forums.
but now i have more errors.
when a user wants to register, after you click finish at the end of a registration..

Code:

Warning: mail(): SMTP server response: 554 <*****@*****.****.com>: Recipient address rejected: Relay access denied in e:\domains\s\sfa-clan.org\user\htdocs\modules\Your_Account\index.php on line 150

any ideas please post ^_^

Posted: Sat Oct 30, 2004 3:21 pm

Does this happen to anyone who tries to register?

What version of php is your server running?

Posted: Sat Oct 30, 2004 3:32 pm

it happens to anyone, im running phpnuke 7.4

Posted: Sat Oct 30, 2004 3:44 pm

Have you applied chatserv patches?

http://www.nukeresources.com/downloadview-details-899-Nuke_7.4_Patched.html

Download and follow the instructions in the readme.html document.

What version of php is the server running. Not what version of nuke are you running.

Posted: Sat Oct 30, 2004 3:51 pm

how do i find that out? its not hosted locally
i have 7.4 patched installed

Only registered users can see links on this board! Get registered or login!

here are all the errors

Posted: Sat Oct 30, 2004 8:54 pm

Unzip this file and put the phpinfo.php file into your main directory (same place as mainfile.php and config.php probably).

http://www.phenylshouse.com/members/prophet/phpinfo.zip

Then go to http://www.sfa-clan.org/phpinfo.php and read the top of the page and tell me what version of nuke you have.

You may also want to find out if you hosts allows sending email from the server (just a thought).

Posted: Sun Oct 31, 2004 4:21 am

Code:

PHP Version 4.3.2 





System | Windows NT IIS643 5.2 build 3790  


Build Date | May 28 2003 15:06:05  


Server API | ISAPI  


Virtual Directory Support | enabled  


Configuration File (php.ini) Path|  C:\WINDOWS\php.ini  


PHP API | 20020918  


PHP Extension | 20020429  


Zend Extension | 20021010  


Debug Build | no  


Thread Safety | enabled  


Registered PHP Streams | php, http, ftp, compress.zlib

hope you understand cuz i dont have a clue!lol
i rang up my host and they said that the form email needs to be an sfa-clan.org email address !
i cant find anywhere to put an email in for a form Confused

wierd thing, it works with admin@sfa-clan.org but not whatever_mine_is@hotmail.com

Posted: Sun Oct 31, 2004 8:07 am

Have you gon into your forums config and set it all up?

Posted: Sun Oct 31, 2004 9:27 am

yeah, ill send you a pm with the access to see if it is all set up properly?