Error Code When View Product

[newbornhero]

Hi,
I see this error code when view a product.

Content visible to verified customers only.

How to fix this ?
Thanks in advance.

[Chuck S]

What is the full error line?

[newbornhero]

I see this code only..
Is it safe if i remove the code in = reviewpost/forums/vb3.php (line 199) ?

[Chuck S]

No you can not remove anything you must find out whats your issue.

Providing us accurate full info as noted in the announcements at the top of all the support forums can help.

Try making sure in admin global options the debug option is set to display errors and lets see what the error is.

I would assume based on the error you are trying to view a product when you get this error. I can guess that maybe its this but can not say further without more detailed information from you.

Maybe post 6 in this thread maybe the location field is missing in vb?

Photo not found in the database!

[newbornhero]

Ok,this is what line in my vb3.php

Content visible to verified customers only.

You mean i need to add below field to my database to fix it ?

Content visible to verified customers only.

[Chuck S]

No I do not

I mean that the default vbulletin has a location profile field which is field2. You need to use phpmyadmin and add that field back into vbulletin.

of course I am just guessing here since I see no other information here.

[newbornhero]

I have enable reviewpost debug mode.
Here is the error message =

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: SELECT u.username,u.homepage,u.usertitle,u.posts,u.joindate,uf.field2,s.host,t.signature,sigpic.filename,u.sigpicrevision,avatar.avatarpath, NOT ISNULL(customavatar.filedata) AS hascustomavatar,u.avatarrevision FROM user u LEFT JOIN userfield uf ON uf.userid=u.userid LEFT JOIN session s ON s.userid=u.userid LEFT JOIN usertextfield t ON t.userid=u.userid LEFT JOIN sigpic AS sigpic ON sigpic.userid=u.userid LEFT JOIN sigparsed AS sigparsed ON sigparsed.userid=u.userid LEFT JOIN avatar AS avatar ON (avatar.avatarid = u.avatarid) LEFT JOIN customavatar AS customavatar ON (customavatar.userid = u.userid) WHERE u.userid=86 LIMIT 1

Result: Unknown column 'uf.field2' in 'field list'

Database handle: Resource id #286

[Chuck S]

Yes my post is right on then. You want to add that field2 in the userfield table of vbulletin database. My query should work for you in phpmyadmin just make sure you add any forum table prefix your install might have. Use your vb database tool.

[newbornhero]

Can i execute your query using vbulletin maintenance option in admincp ?

[Chuck S]

Yes I did list that in my last reply you could also use your vbulletin database tool. You just need to make sure running my query to add in any table prefix if you have one.

[newbornhero]

Chuck,
I do your instruction but not working.
Something must be wrong.

I need more detail instruction.
My Database name= rp1
Please check attachment.

[Chuck S]

I do not understand what it is you do not understand what I told you to do. You do not need to worry about database names when using your vb database tool as your issuing a query against the vb database.

Yes you have entered the query in your vb database tool that much your picture shows however have you verified your vbulletin database tables do not use a table prefix?

I did state you would have to add your table prefix on the query. Your table prefix of vb you can clearly see if you list your tables or view your config file.

That is the missing piece of the puzzle I would suspect your not giving me any info to work on here.

[newbornhero]

Chuck,
I see no prefix on my vbulletin config.php

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
$config['Database']['tableprefix'] = '';

Can i run your query now ?

[Chuck S]

Sure if there is no prefix my query should work fine.

[newbornhero]

sorry for late reply.
Your query is not working.
Also i see new problem when try to add a category.
It read : (i enable debug mode)

We're sorry, but the system experienced an unrecoverable error. Please try again later.

Script:

Query: INSERT INTO rp_categories (id,catname,description,catorder,thumbs,parent,header,footer,headtags,password,ugnoview,ugnoupload,ugnopost,ugnoanno, template,extra1,extra2,extra3,extra4,extra5,extra6,sortorder,frames) VALUES(NULL,'frfrfrfrf','','6','yes',0,'','','', '', '', '', '', '', '0', '', '', '','', '', '', '', '')

Result: Field 'theme' doesn't have a default value

Database handle: Resource id #282

[Chuck S]

What happens if you turn strict mode off in mysql setup?

[newbornhero]

Not working.
I tried to disable mysql.ini strict mode using=

# Set the SQL mode to strict
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

with

# Set the SQL mode to strict
sql-mode="NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"

[Chuck S]

Did you restart the server after the change?

[newbornhero]

Working great after restart my server.
About this error code

Warning: mysql_fetch_row() expects parameter 1 to be resource, boolean given in [path]\review\forums\vb3.php on line 199

I still see this code when view a product.
===========================================
Also want to ask,is there any security issue when i turn strict mode off in mysql ?

[Chuck S]

Did you add the field we suggested earlier in this thread as this still tells me you have not.