Unknown column 'uid' in 'field list'
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL resul resource
in
/usr/home/sl/public_html/includes/sql_layer.php on line 288
SOLUTION:
Open footer.php and replace all instances of <i>UID</i>, with <i>user_id</i> and all instances of <i>uname</i> with <i>username</i>
---
Quote:
Logged-in, registered users cant access modules set to 'Registered Users Only'. They still get the 'restricted access' message even though they are already logged in. (And <i>Your_Account</i> is set for visible to everyone).
TEMPORARY FIX FOR THE ABOVE IS POSTED LATER IN THIS THREAD
p.s. That READ ME was excellent.
Last edited by XEULAS on Sat Nov 08, 2003 5:35 am; edited 2 times in total
XEULAS Captain
Joined: Oct 20, 2003
Posts: 335
Posted:
Fri Oct 31, 2003 9:03 am
Quote:
Avatars are not working properly, including upload your own avatar
There are a number of fixes posted for this, here is the shortest one that works: (NOTE- none of the fixes I saw let you leave the phpbb avatar directories set to the default)
There should also be a blank.gif file in
modules/Forums/images/
modules/Forums/images/avatars
modules/Forums/images/avatars/gallery
NOTE that most of the current scripts (like includes/javascript.php, your_account index.php) point to 'gallery' which I why I've stuck with the gallery directory.
Last edited by XEULAS on Sun Nov 09, 2003 8:56 am; edited 4 times in total
XEULAS Captain
Joined: Oct 20, 2003
Posts: 335
Posted:
Fri Oct 31, 2003 9:10 am
Post edited and saved for future release.
Last edited by XEULAS on Sat Nov 01, 2003 7:27 pm; edited 1 time in total
XEULAS Captain
Joined: Oct 20, 2003
Posts: 335
Posted:
Sat Nov 01, 2003 6:37 pm
If anyone is having problems with their old login block, I saw a problem posted that I experienced too and posted my fix. This is related to: if you are NOT using the default nuke login block. http://nukecops.com/postt12941.html
NOTE: The latest version of the http://gnaunited.com user_info block (which has login, private messages, whos online, etc .. all in one block, works GREAT with nuke 7.01)
Last edited by XEULAS on Sat Nov 08, 2003 5:53 am; edited 1 time in total
XEULAS Captain
Joined: Oct 20, 2003
Posts: 335
Posted:
Sat Nov 01, 2003 6:59 pm
Thought it wise to post the fact that fixes for things are in the works, as you can tell from this post (NOTE THE ADMIN NOTICE AT THE BOTTOM, so you don't start goin and applyin patches all over the place....)-
Quote:
The latest patch for PHP-Nuke
Just about all variables have been secured against sql injection by running a check on their content before inserting anything into the database tables and after having extracted anything from them as well, any module that had not been secured before has been included as well as all admin files. Most files have been converted to the new abstraction layer, i will do my best to finish the ones the are not yet converted this week, time at which i should be back full time.
Since i have had no real chance to test these files you should make a backup of your current files before uploading these.
Downloads:
Nuke 6.0 - Nuke 6.5 - Nuke 6.6-6.8 - Nuke 6.9 & Nuke 7.0 (This last version is not the full pack, 7.0 can be downloaded at phpnuke.org).
I can't stress this enough, make a backup before doing anything, the files have not been tested.
Admin Note: These patches are only online to let others know what is headed their way, do not use them for now as they have been reported to have errors.
XEULAS Captain
Joined: Oct 20, 2003
Posts: 335
Posted:
Sat Nov 01, 2003 7:16 pm
Nukecops webmaster:
I notice you have the same problem as described in the post, above, regarding Your_Account and avatars. I have a broken avatar pic here at nukecops right now. I think if you apply the 'fix' above you should be all set.
Just a guess... of course, I have no clue what you are running back there.
XEULAS Captain
Joined: Oct 20, 2003
Posts: 335
Posted:
Tue Nov 04, 2003 2:01 pm
Where IS the place to discuss nuke 7+? I cant even find forums over at phpnuke.org, are they called something else over there?
I joined the CLUB and payed and all, but there is no help there either. Where DOES one go to contact the author(s)? I don't imagine this all falls on the shoulders of NukeCops, but there must be SOMEWHERE to go for help.
Last edited by XEULAS on Sat Nov 08, 2003 5:44 am; edited 1 time in total
MerchantPal Nuke Cadet
Joined: Nov 04, 2003
Posts: 4
Posted:
Tue Nov 04, 2003 3:37 pm
The Club is mainly for DL access to stuff not yet released publically. I think that all Nuke support forums, archives, etc. are sponsored by NukeCops.com .. I guess you must have started the thread for 7.01b. I'm searching for the same thing and found you .. Perhaps one of us should start it as a topic .. I'm looking for answers to the Registered User Restrictions problems with 7.01b .. I'll try the login you posted ..
Been working with 7.01b for only the last few days, so I dunno that any of my understanding of the support forum logistics is correct ..
-- RA
XEULAS Captain
Joined: Oct 20, 2003
Posts: 335
Posted:
Tue Nov 04, 2003 4:38 pm
WHOO HOOO! A HUMAN BEING!
The login problem wasnt necessarily related the 'registered user still restricted problem'.
After you log in as a registered user (not admin), click MEMBER LIST. It probably wont let you in, BUT, at the very bottom of the page, do you get a MYSQL error? (this would be the Unknown column 'uid' in 'field list'
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL resul resource in sql_layer.php on line 288 error)
MerchantPal Nuke Cadet
Joined: Nov 04, 2003
Posts: 4
Posted:
Tue Nov 04, 2003 7:00 pm
Perhaps in the upgrading MySQL tables from previous version. I don't get this problem in 7.01b, which is first ver I've installed.
The "strange restricted access problem for registered users" does seem to be a beta bug .. topic found way into the "Post Install" forum .. I've posted a temporary way to disable (but not fix) the problem ..
[UPDATE 2003 11 10 - I removed the temporary fix that was here, because a permanent/complete fix has been found. Go here http://nukecops.com/postp68271.html
]
My fix was to give everyone access to almost everything.
Last edited by XEULAS on Mon Nov 10, 2003 1:02 pm; edited 2 times in total
XEULAS Captain
Joined: Oct 20, 2003
Posts: 335
Posted:
Thu Nov 06, 2003 11:42 am
--------------
Last edited by XEULAS on Mon Nov 10, 2003 1:03 pm; edited 1 time in total
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
