sql_layer line286 [uid]

Guest

hi nukerz! i have a small problem, in my page's footer, there is:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/symbio/public_html/includes/sql_layer.php on line 286
Unknown column 'uid' in 'field list'

i searched the forum, and found out that this should happen only, when the portal is upgraded from 6.0 to 6.5, but i made a fresh PHPNuke 6.5 installation, everything works fine accept this little thing :/

do i have to remove uid somehow? ... please help Wink

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

If it was a fresh install then this should only happen if you have added a block/module that isn't 6.5 ready.

[Rest edited out - misread original post]

Guest

yes, i added wysiwyg module, but it's 6.5 compatible :/

i have added some blocks and modules too, but that was a long time ago and then the problem did not occur.

maybe i should make some sql changes by hand?

Guest

very strange :S ... should there be a tabla calle "field_list" or something?.. i didn't find one in my database..

i just checked original nuke.sql dump and there was nothing like field_list, same is with eh wysiwyg module. :/

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

Like I said earlier, check the modules/blocks you just added. Verify that the tables are in the database that they need. Also, I deleted your last post because it was not related at all to this thread. Resubmit it under a new thread and in the proper forum.

Guest

all the blocks, that are in my homepage, were in phpnuke blocks folder from the start (i have added only Enhanced Downloads module, which is not the problem (+it's for 6.5)).. and like i said, the problems started when i installed wysiwyg module .. still .. maybe i should rename all the "uid" tables to "user_id" ?

Guest

i just realized that this error is displayed for logged in users.

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

Symbio wrote:

all the blocks, that are in my homepage, were in phpnuke blocks folder from the start (i have added only Enhanced Downloads module, which is not the problem (+it's for 6.5)).. and like i said, the problems started when i installed wysiwyg module .. still .. maybe i should rename all the "uid" tables to "user_id" ?

uid was changed to user_id for base nuke tables. If you have code that is addressing the base nuke tables, then you will need to make that change. If this is in the wysiwyg module, then verify through phpMyAdmin what the column names are. If uid is NOT on the table it is calling and user_id is, then change it. That would also negate your statement that wysiwyg is ready for 6.5. Contact the author if that is the case.

Guest

i didnt modify the mysql database but i changed the wysiwyg, now the uid error ise gone (i change all "select uid"'s to "select user_id" and $uid to $user_id) but no there's ANOTHER error :/

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/symbio/public_html/includes/sql_layer.php on line 286
Unknown column 'uname' in 'where clause'

Guest

sheesh. .i removed (successfully ...whoo Smile

) wysiwyg module and there's no error anymore.. now i know what the problem was.. but solution was too stealth for me Razz

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

Symbio wrote:

i didnt modify the mysql database but i changed the wysiwyg, now the uid error ise gone (i change all "select uid"'s to "select user_id" and $uid to $user_id) but no there's ANOTHER error :/

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/symbio/public_html/includes/sql_layer.php on line 286
Unknown column 'uname' in 'where clause'

It appears you do not have the 6.5 port if there is one. If you read the CHANGES log that came with nuke 6.5 you will see all of the column changes.

Quote:

- Some "nuke_users" table fields renamed. This is a very important change to have full compatibility with
phpBB 2.x Forums modules. Original name => Renamed fields are:
uid => user_id
uname => username
email => user_email
url => user_website
user_intrest => user_interests
pass => user_password

Guest

hm...i didn't read that file.. but i'll try that later:)