Reviewpost 2.9 VB3enhanced Error

[paratek]

When in the category editor, if the bottom check box that states "Check box to apply these settings and permissions to all children" is checked, the following error occurs when hitting Save changes:

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

Script: adm-cats

Query: SELECT children FROM categories where id='2'

Result: Table 'para-tek_forums.categories' doesn't exist

Database handle: Resource id #7

[Detomah]

yup, getting the identical problem...

UPDATE rp_categories SET dochildren='1' WHERE id=23

The query returned with an errorcode of:

Unknown column 'dochildren' in 'field list'

Also getting this when trying to view a category:

SELECT children FROM categories where id='10'

The query returned with an errorcode of:

Table 'totalformat_com_-_1.categories' doesn't exist

When I click on a sub category, it is taking me to custom view, not to the category selected.

This is a clean fresh intall.

I am noticing that when I try to set the ReviewPost Database Table Prefixes option in the integration section, it is saving fine, but on reload, it shows blank again.

This is a review section KILLER. It renders the software useless, so speedy response and fix for this bug would seriously be much appreciated.

Sorry, not hijacking your thread here, just think we are suffering from the same bug.

[Chuck S]

Line 426 of adm-cats.php

$querya="SELECT children FROM {$Globals['pp_db_prefix']}categories where id='$catid'";

needs to be

$querya="SELECT children FROM {$Globals['rp_db_prefix']}categories where id='$catid'";

Line 505 of adm-cats.php

$blockview = "";

add above it this

$catid .= $children;

Line 559 of adm-cats.php

$sql = "UPDATE {$Globals['pp_db_prefix']}categories SET ugnoview='$blockview',ugnoupload='$blockup',ugnopost='$blockpost',ugnovote='$blockvote',ugnoanno='$blockanno' WHERE id=$catid";

needs to be

$sql = "UPDATE {$Globals['rp_db_prefix']}categories SET ugnoview='$blockview',ugnoupload='$blockup',ugnopost='$blockpost',ugnovote='$blockvote',ugnoanno='$blockanno' WHERE id=$catid";

[Detomah]

Originally Posted by omegatron

Line 1021 of adm-cats.php

There is no line 1021?

I also tried searching the file for the line of code and couldn't find it?

Are you sure it's that file?

[Chuck S]

try 559

[Detomah]

Ok got that, same error though:

UPDATE rp_categories SET dochildren='1' WHERE id=23

The query returned with an errorcode of:

Unknown column 'dochildren' in 'field list'

In your code above, I also had to make a tiny change to get it to work

$catid .= $children

TO

$catid .= $children;

Although I doubt that has made any difference really except stop the parse error.

It still showing the custom page rather any categories.

I deleted all the categories and added them back again to see if that would make any difference, but it didn't.

Edit: It's also still not letting me set the "RP_" prefix for the integration reviewpost bit.

[Chuck S]

The adm-cats as I have outlined the above fixes indeed works fine. I have it working on my install

As far as the integration not letting you save your table prefix this is confirmed although this would not affect anything in Reviewpost. The only place that is used is in the future if we ever released hacks to show reviewposts products and cats on the VB main index. Right now there is no such files so no harm no foul. However if you want to fix it edit adm-misc.php and find this line

<td class="{$Style['tddetails']}" align="left" width="40%"><input type="text" size="35" value="$pp_db_prefix" name="newprefix" class="bginput"></td>

change it to this

<td class="{$Style['tddetails']}" align="left" width="40%"><input type="text" size="35" value="$rp_db_prefix" name="newprefix" class="bginput"></td>

[Detomah]

Originally Posted by omegatron

The adm-cats as I have outlined the above fixes indeed works fine. I have it working on my install

Ok, I won't worry about the table prefix for now then, that obvioulsy isn't effecting anything else.

I'll go back and redo the fix you've mentioned and see if I get anywhere, I don't think I made any typos, but you never know... Hopefully it will work for me too.

[Chuck S]

Basically the fix is real simple

Michael threw this in there real quick for me when we did 2.9 as I like this feature alot in Photopost.

The issue is simple

find and replace

pp_db_prefix and replace with rp_db_prefix

thats all my fixes above do is just put the right prefix on a few querues
so do a global replace maybe you missed one.

The only other fix was just adding the $catid .= $children; line where specified

[Detomah]

Still not working.

http://www.totalformat.com/reviews/showcat.php?cat=35 <-- meant to be a category called book reviews.

Banging my head time, now...

Edit: I'll go see if there are any missed anywhere, like you say.

[Detomah]

Ok, still not working, i'm going to delete the whole program and database bits for it and try a fresh reinstall and see if that gets me anywhere, if not I am gonna cry.

[Michael P]

line 481 should read:

Content visible to verified customers only.

I'll update the adm-cats.php in the build to try and make this easier.

[Michael P]

I just updated two files in the build:

adm-cats.php
adm-misc.php

Grab those files from the current build and you should be okay.

[paratek]

Yup..that one fixed it.....Looks great Michael

[Detomah]

Ok, i've spent the best part of 15hours on this now and I am pretty sure I have done it right, i've installed reviewpost and photoshop a good few times and have never had anything this infuriating happen with it before. I know it's not your fault though, but I would love to get it resolved.

Ok here is my review section: http://www.totalformat.com/reviews/

I have set up various categories and products testing it and it still has a big problem for me at the moment.

What is actually happening:

Ok i've worked it down to the fact, if I Contains Thumbnails? set as NO, as an option for a category it shows the next level catgory.

If I have Contains Thumbnails? set as YES, as an option, it will only show the custom page.

I have double checked absolutely everything I can possibly think of, all the paths, the mysql paths, etc have installed it completely clean and fresh, have uploaded every single file individually in ASCII or BINARY as is needed, have treble checked the CHMOD of each bit, but I am still getting this issue.

I am using the updated files that were put there this evening too.

What am I doing wrong?

[Detomah]

OK, still basjing my head against the wall trying to figure this out...

I am noticing that at the bottom of the page for every category i'm getting this showing:

SELECT id,user,userid,cat,date,title,description,keywords,bigimage,views,approved,rating,manu,numreviews FROM RP_products WHERE approved='1' ORDER BY disporder,manu

Now I know it shouldn't be showing, but i'm damned if I can figure out where it's coming from.

Anyway, example page of were it is showing: http://www.totalformat.com/reviews/showcat.php?cat=3

[Chuck S]

bottom of showcat.php removed this

echo "$query"; me doing testing fixing the search engine and left it in by mistake

[Detomah]

Originally Posted by omegatron

bottom of showcat.php removed this

echo "$query"; me doing testing fixing the search engine and left it in by mistake

Ah ok, that's that little bit sorted.

However... The main problem is seriously still happening here.

I have 3 sub categories set up from the parent BOOKS, each with 1 test product added to that category.

Category 2

category 3

Category 4

Product 1

Product 2

Product 3

Now click on any category and tell me you can't see the issue.

Each category is showing all the products, not just the product in it's own category.

The categories are not displaying properly.

Ok....

Fried Herrings
Test For Herrings
Test For kippers
Test For salmon

These 4 categories are all empty and are spawnd from a different parent, yet if you click on any of them, you see exactly the same thing, the products which are in categories 2,3 and 4 as a list.

I am using the updated code that was provided and I have checked in the database and the tables are there and the categories are in their proper places and I am not getting any database errors.

I'm now getting desperate here, cause a large chunk of my main homepage is includes from the review section normally and they are currently blank spaces or errors due to the relevent categories not being there due to this fresh install.

Please check it out for me and see if there is some tiny bug somewhere that has been missed. It simply looks to me like the category pages are not being called properly, but I can't see where myself and do not know the coding for this script well enough to be able to pinpoint it.

On Reeftalk, I noticed you are suffering from this exact same issue... This category Cat61 does not have any products, yet it is showing a list of every product in your database. It is the same which ever of your categories you click on, you get the same full list, not just the products in that category.

Even on Photopostdev, you click on the hardware category which only has 2 products, yet it is showing multiple products, as it is also showing the products from the sports car category which it definately should not be doing.

[Michael P]

Yes, it is indeed something small. At the top opf showcat, find this line and make the change in bold;

if ( !isset($cat) || empty($cat) || !is_numeric($cat) ) $cat = "myprod";

[Detomah]

Originally Posted by Michael P

Yes, it is indeed something small. At the top opf showcat, find this line and make the change in bold;

if ( !isset($cat) || empty($cat) || !is_numeric($cat) ) $cat = "myprod";

Raaar, WOOT, yes, OMG... and all silly joyful comments like that...

It works again, if you couldn't tell.

And that's why I stay very loyal to these products, I know there's always an answer and a resolution to queries or problems.

Thanks a lot.