phpBB : Critical Error & Warning

milenko · **phpBB : Critical Error & Warning -** 02-15-2003, 06:45 PM

OK I had phpnuke 6.0, upgraded to phpnuke 6.5. Downloaded your smartdark for 6.5 and then Uploaded everything, ran upgrade and boom said good to go. Went to change theme in Adminstration Preferences to smartdark by default. Went to Blocks Administration and noticed all my old blocks were gone. Then I look above the bar where it list block info and it reads :

Quote:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/virtual/site38/fst/var/www/html/includes/sql_layer.php on line 286

I cannot add any blocks and nuke is only showing Messages & Storys.
Then I went to check the new ported forum and I got the folling error:

Quote:

phpBB : Critical Error

Error doing DB query userdata row fetch

DEBUG MODE

SQL Error : 1054 Unknown column 'u.uid' in 'where clause'

SELECT u.*, s.* FROM nuke_bbsessions s, nuke_users u WHERE s.session_id = 'e1865139864c6bdd29ee81fa97c69d0e' AND u.uid = s.session_user_id

Line : 255
File : /home/virtual/site38/fst/var/www/html/includes/sessions.php

Any Idea's?

Martin · 02-15-2003, 09:37 PM

Only a few know about 6.5. Mikem might be able to help when he gets back. Maybe in 8 or so hours from now I hope. Not really sure where he went. You might try searching at http://bbtonuke.sourceforge.net in the mean time.

milenko · 02-15-2003, 09:54 PM

thanks bro, been there, searched nothing yet. And I cannot post thier! moderators only :cry:

Martin · 02-15-2003, 09:57 PM

All I can say is make sure all your files got uploaded into the folders where they go. Sometimes a file wont go up on ftp and you have to check.

mikem · 02-16-2003, 11:24 AM

STOP RIGHT THERE!

You say you upgraded from Nuke6.0 with phpBBport to Nuke6.5?

Where did you get an upgrade script? Or did you NOT have phpBB forums before you upgraded to 6.5?

If you had phpBB forums as your Forum in 6.0 instead of Splatt, then the upgrade script that came with Nuke6.5 WILL NOT WORK!

mikem

milenko · 02-16-2003, 05:47 PM

I have the latest phpnuke6.5. I uploaded everything as usual, in the 6.5 release it tells you:

Quote:

PHP-Nuke: Web Portal System
===========================

To Upgrade from previous PHP-Nuke versions just install
the new files and from your web browser launch after
copying the selected upgrade from "upgrades" directory
to your site's root (/) dir:

http://www.yoursite.com/upgrade60-65.php

It's all...

I followed what it said. In the upgrade readme.
I have currently running : phpBB 2.0.3. So I wasnt running splatt, and now I am lost......
8O

mikem · 02-16-2003, 08:41 PM

Please tell me you backed up your database?

Also, like I said before, the Upgrade script in Nuke6.5 Beta8 is ONLY for users running a STOCK PHP-Nuke6.0 site with NO phpBB forums integrated. Were your Forums the ported ones from Tom's site?

Here is th eupgrade script for upgrading a site running Nuke6.0 with phpBB ported Forums to Nuke6.5

http://nukecops.com/downloads-file-36-details-nukebbsql.php_{t.tar.gz_format}.html

mikem

milenko · 02-18-2003, 03:46 AM

ok no my forums were not ported. What I did today was something strange. I went ahead and re-uploaded nuke 6.0, after doing so smartdark appeared. I realize smartdark is for 6.0 w/ported phpbb forums, or nuke6.5, which I don't have. So right now im running php6.0 with smartdark running on my site along with my old non-ported phpbb forum. Which is cool for me. However I am now running into some more troubles. No more errors, but when I try to move or adjust blocks nothing happens, no errors or anything. Also I tried to validate a download that was submitted and nuke would just give me the screen where it says click to validate and when I do, it ask me to check them all. So I do that, then every download says "OK!" But in admin panel, it is still displaying the download waiting to be validated. IM thinking something is wrong with my sql database? My forum and besides the above info is working, do you think it would hurt to re-upload nuke 6.5? sorry for the long post, and thank you for the help thus far.

mikem · 02-18-2003, 03:43 PM

Ok so first you say you upgraded to Nuke6.5. Now you are saying that you don't have Nuke6.5.
I'm lost.
If you were running Nuke6.0 to begin with. And you were running phpBB Forums SEPARATE, then I don't know what to do.

If you ran any upgrade script, then the reason your Nuke 6.0 is not working now is because your Database was changed by the upgrade script.
That is why I asked if you made a backup of your DB first.

mikem