forum error

Xeno14 · 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

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

Check to see if the nuke_bbconfig table exists.

Xeno14 · New Member Joined: Oct 30, 2004 Posts: 17

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?

Raven · Posted: Sat Oct 30, 2004 11:30 am

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

Xeno14 · New Member Joined: Oct 30, 2004 Posts: 17

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

Raven · 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.

Xeno14 · New Member Joined: Oct 30, 2004 Posts: 17

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

Raven · 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.

Xeno14 · New Member Joined: Oct 30, 2004 Posts: 17

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.

TheosEleos · 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.

Xeno14 · New Member Joined: Oct 30, 2004 Posts: 17

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

TheosEleos · 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.

Xeno14 · New Member Joined: Oct 30, 2004 Posts: 17

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

TheosEleos · Posted: Sat Oct 30, 2004 1:05 pm

Yes you can.

Be sure to delete all previous databse tables.

Xeno14 · New Member Joined: Oct 30, 2004 Posts: 17

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 ^_^

TheosEleos · 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?

Xeno14 · New Member Joined: Oct 30, 2004 Posts: 17

it happens to anyone, im running phpnuke 7.4

TheosEleos · Posted: Sat Oct 30, 2004 3:44 pm

Have you applied chatserv patches?

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

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.

Xeno14 · New Member Joined: Oct 30, 2004 Posts: 17

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 to the forums!

here are all the errors

TheosEleos · 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).

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

Then go to

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

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).

Xeno14 · New Member Joined: Oct 30, 2004 Posts: 17

Code:

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

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

but not

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

TheosEleos · Posted: Sun Oct 31, 2004 8:07 am

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

Xeno14 · New Member Joined: Oct 30, 2004 Posts: 17

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