Switched servers and cant post comments.

Guest

All,

I recently had to switch servers and copied mysql database to the new server and put a new copy (same version) of Nuke 6.5 on the new server. Everything seemed to work ok until I tried to post a comment. It does nothing. Any help would be appreciated.

Thanks
Matt

BTW.. the dns hasn't been updated yet but you can reach the site from here. http://38.114.135.221/index.php

Again thanks

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Try another theme. When you mouse over the word Comments, you do not have a complete/correct link. So, try another theme to see if it's your theme.

Guest

no go... =o(

I just cant figure out what i messed up...

Thanks
Matt

Guest

Actually I really cant do anything now. Everything is giving me a "cant access file directly" error. Hmm....

Its time for sleep but if anyone has any ideas I would love to here them.

I put the analyze.php in the root directory to try to anwser any questions.

Thanks again
Matt

General Joined: Mar 22, 2003 Posts: 5233 Location: USA

Have you purposely hidden the left blocks? If so, just for a test, restore the default configuration to see if it works. before customizing it.

Guest

Ok,

Here is whats going on and what I have done so far.

First, Raven was right with the links being incorrect. Why is this?

I have created a new database with brand new tables and information and reuploaded the whole nuke install and this is still doing the same thing. Did I do something incorrectly with the upload or could this be a problem on the server?

Any help will be greatly appreciated.

Matt

Posted: Sat May 10, 2003 3:54 pm

try uploading the /modules/News/index.php from the nuke 6.5 tar
(im guessing you might be using the one from you backup)

Guest

disgruntledtech,

No go... But thanks for the suggestion.

Matt

Guest

All,

UPDATE:

I decided to "poke" around in the code to see whats actually happening and see why this isn't working... This is what I found out.

When modules\news\index.php is called to do its thing and gets to this point:

$sql = "SELECT sid, catid, aid, title, time, hometext, bodytext, comments, counter, topic, informant, notes, acomm, score, ratings FROM ".$prefix."_stories $qdb $querylang ORDER BY sid DESC limit $storynum";

$result = $db->sql_query($sql);

while ($row = $db->sql_fetchrow($result)) {

ect...

:while loading the variables, it does not load the $s_sid variable (or maybe the sql query isn’t returning the sid field).
This is the only variable that seems not to be getting loaded.
You can take a look at the site; I should still have it up www.mattdaley.com.

I just added this after each variable was loaded:

echo "variable = $variable <br />";

That may give you a clue to whats going on.

Secondly, I ran that exact same sql statement on the database and it IS returning the sid (outside php).

Does anyone know whats going on here?

Thanks for any help
Matt

Posted: Mon May 12, 2003 3:17 am

i think it might be theme specific but i cant create a new user

Code:

Fatal error: Cannot redeclare head() (previously declared in /home/snowwons/www.mattdaley.com/docs/header.php:29) in /home/snowwons/www.mattdaley.com/docs/header.php on line 28

i get that during reg
and i get the email but it sez no user in db when i activate

do you get this error on other themes?

if not, post the theme.php wher i can have a look at it(make a copy and give it a .txt extension if ya want) and i'll try and track it down

Guest

Disgruntled,

Im sorry, that was something I was working on before I switched servers. I didn't have time / plain forgot that there was an error in that. Basically what it is, I have modified the youraccount module to allow users to automatically register, without have to click the account activation link. I didn't have it quite done yet and just fixed the problem that you were having.

Thanks
Matt

btw... even with the error you were still registered. The reason for the database error was because you allready were activated.

Guest

I restored my index.php in the news module dir because all that "extra stuff" was bothering me. The only real thing it showed was that the variable s_sid was not getting loaded from the data base. If you need to see it just tell me and i'll switch them back.

Thanks everyone for their help so far... Hopefully this will get figured out in time.

Matt

Guest

ITS FIXED

All right now I need to know why it broke Razz

Here is what I did to fix it.

Trying to figure out where the problem was I dove into the php manual to find out how to turn error handling on. Well I found that and when I loaded the page I found (a bunch of notices) and one in particular the stood out from the rest.

Notice: Undefined index: in /home/snowwons/www.mattdaley.com/docs/modules/News/index.php on line 80

So I searched around to find out what this meant... Didn't find a thing. I figured this was something to with MySQL being an index error and all, but after playing with the code it was an array error.

The array was being filled correctly from the database call as shown here with a print_r() command.

Array ( [0] => 18 [sid] => 18 [1] => 0 [catid] => 0 [2] => matt daley [aid] => matt daley [3] => A little piece [title] => A little piece [4] => 2003-05-09 16:05:21 [time] => 2003-05-09 16:05:21 [5] => For those of you who knew / knew of / seen her.

5 and a half great years and six months of mixed blessings.

Rest in Peace Girl.
Bacardi (1997 - 2003) [hometext] => For those of you who knew / knew of / seen her.

5 and a half great years and six months of mixed blessings.

Rest in Peace Girl.
Bacardi (1997 - 2003) [6] => [bodytext] => [7] => 0 [comments] => 0 [8] => 0 [counter] => 0 [9] => 1 [topic] => 1 [10] => matt daley [informant] => matt daley [11] => [notes] => [12] => 0 [acomm] => 0 [13] => 0 [score] => 0 [14] => 0 [ratings] => 0 )

So... Since this was an Index error I figured it couldn't find 'sid' in the array for some reason, so I just tried the numerical equivalent of '0'. It worked.

Now the ten million dollar question. Why couldn't it find the 'sid' in the array?

Thanks all for your suggestions
Matt

Guest

For reference this is the code I changed.

from:

Code:

while ($row = $db->sql_fetchrow($result)) {
$s_sid = $row[sid];
$catid = $row[catid];
$aid = $row[aid];
$title = $row[title];

to:

Code:

while ($row = $db->sql_fetchrow($result)) {
$s_sid = $row[0];
$catid = $row[catid];
$aid = $row[aid];
$title = $row[title];

Matt