Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's v7.0 Customized Distro
Author Message
Xeno14
New Member
New Member


Joined: Oct 30, 2004
Posts: 17

PostPosted: Sat Oct 30, 2004 10:18 am Reply with quote

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
 
View user's profile Send private message
TheosEleos
Life Cycles Becoming CPU Cycles


Joined: Sep 18, 2003
Posts: 960
Location: Missouri

PostPosted: Sat Oct 30, 2004 10:27 am Reply with quote

Check to see if the nuke_bbconfig table exists.

_________________
Only registered users can see links on this board! Get registered or login! 
View user's profile Send private message Visit poster's website AIM Address ICQ Number
Xeno14
PostPosted: Sat Oct 30, 2004 11:25 am Reply with quote

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
Site Admin/Owner


Joined: Aug 27, 2002
Posts: 17086

PostPosted: Sat Oct 30, 2004 11:30 am Reply with quote

Just strip down the sql that you used for your site and extract only the sql that you need for the missing tables.
 
View user's profile Send private message
Xeno14
PostPosted: Sat Oct 30, 2004 11:33 am Reply with quote

which tables do i need for the forums to fully function?
 
Raven
PostPosted: Sat Oct 30, 2004 11:45 am Reply with quote

All tables that begin with nuke_bb for starters. If it doesn't work after that, start over and reload all tables.
 
Xeno14
PostPosted: Sat Oct 30, 2004 11:53 am Reply with quote

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
PostPosted: Sat Oct 30, 2004 11:59 am Reply with quote

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
PostPosted: Sat Oct 30, 2004 12:07 pm Reply with quote

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
PostPosted: Sat Oct 30, 2004 12:10 pm Reply with quote

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
PostPosted: Sat Oct 30, 2004 12:12 pm Reply with quote

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 Crying or Very sad
 
TheosEleos
PostPosted: Sat Oct 30, 2004 12:16 pm Reply with quote

You have to use the sql included with 7.4.

I don't have the time to install for you. Sorry.
 
Xeno14
PostPosted: Sat Oct 30, 2004 12:21 pm Reply with quote

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
PostPosted: Sat Oct 30, 2004 1:05 pm Reply with quote

Yes you can.

Be sure to delete all previous databse tables.
 
Xeno14
PostPosted: Sat Oct 30, 2004 2:09 pm Reply with quote

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
PostPosted: Sat Oct 30, 2004 3:21 pm Reply with quote

Does this happen to anyone who tries to register?

What version of php is your server running?
 
Xeno14
PostPosted: Sat Oct 30, 2004 3:32 pm Reply with quote

it happens to anyone, im running phpnuke 7.4
 
TheosEleos
PostPosted: Sat Oct 30, 2004 3:44 pm Reply with quote

Have you applied chatserv patches?
Only registered users can see links on this board! Get registered or login!

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
PostPosted: Sat Oct 30, 2004 3:51 pm Reply with quote

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
 
TheosEleos
PostPosted: Sat Oct 30, 2004 8:54 pm Reply with quote

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!

Then go to Only registered users can see links on this board! Get registered or login! 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
PostPosted: Sun Oct 31, 2004 4:21 am Reply with quote

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 Only registered users can see links on this board! Get registered or login! but not Only registered users can see links on this board! Get registered or login!
 
TheosEleos
PostPosted: Sun Oct 31, 2004 8:07 am Reply with quote

Have you gon into your forums config and set it all up?
 
Xeno14
PostPosted: Sun Oct 31, 2004 9:27 am Reply with quote

yeah, ill send you a pm with the access to see if it is all set up properly?
 
Display posts from previous:       
This forum is locked: you cannot post, reply to, or edit topics.   This topic is locked: you cannot edit posts or make replies.    Ravens PHP Scripts And Web Hosting Forum Index -> Raven's v7.0 Customized Distro

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©