getting close.....

[JayH]

I installed reviewpost tonight at http://www.canamspyderforums.com/market, and am close to getting it working (I think) I am getting the following errors, any suggestions?:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/.rasputin/jay_herbert/canamspyderforums.com/market/forums/vb3.php on line 33

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/.rasputin/jay_herbert/canamspyderforums.com/market/forums/vb3.php on line 429

looking at line 33 I see "queryv"

Should it be something else?

Thanks in advance

[JayH]

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/.rasputin/jay_herbert/canamspyderforums.com/market/forums/vb3.php on line 33

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home/.rasputin/jay_herbert/canamspyderforums.com/market/forums/vb3.php on line 429

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/.rasputin/jay_herbert/canamspyderforums.com/market/forums/vb3.php on line 67

[Chuck S]

Thats an easy one. Try reinstalling except this time make sure on the config your vb license is entered correctly as well as the correct vb database details there. Now go through install and on step 4 make sure you select vb3 integration and where it asks you to specify your correct vb table prefix and cookie prefix enter those there for a successful install. It would appear the table prefix has not been entered.

[JayH]

So I just rerun the install.php?

I pulled all parameters for reviewpost from the config file for photopost we are running, the only one I was not 100% sure of was the database prefix, so I left it blank. Step 3 (or 4?) suggested "bb" for vBulletin, where do I find if that is the right prefix? I did check the VB3 box.

Thanks in advance for the assistance.

[Chuck S]

Yes correct rerun install and on step 4 specify your correct vb3 table prefix.

[JayH]

Originally Posted by Chuck S

Yes correct rerun install and on step 4 specify your correct vb3 table prefix.

Thanks,

I have only one error, the stylesheets are working and it looks like it is supposed to.... this is the last error:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/.rasputin/jay_herbert/canamspyderforums.com/market/forums/vb3.php on line 33


I put in bb for the cookie, but have no idea how to find the table prefix, help

It also looks like the Home · Search · Member List · are going to /cgi-system for some reason? the Register seems to go to the right place though

[Chuck S]

You keep doing the same mistake. You are not entering your correct table prefix for vb. That is located in your vb config.php file in the includes directory of your forum.

[JayH]

// ****** TABLE PREFIX ******
// Prefix that your vBulletin tables have in the database.
// ## Changed Old value: ''
$config['Database']['tableprefix'] = 'vb_';


put vb_ in the table prefix......

and after I put in the right stuff in FOUR other places... IT'S ALIVE....

I'm sure when I poke around a bit I'll have a few more questions.

Thanks a bunch for the help!

[Chuck S]

enjoy your evening let me know if you need anything else.

[JayH]

I've got it all sorted out and it is running nice, A few quick questions,

1) Can you tell me which template this is in:

"Find the lowest price for (item here)"

It shows up when I go all the way into an item.

2) Is there a way to edit an item once posted?

3) It would be nice if there was a field for a link to the product, is this possible for me to add without to much fuss?

Thanks in Advance,

JayH

[Chuck S]

1. showproduct template but there is an option in the showproduct option to show a dealtime link or not as well as pick which service to use.

2. you if you have set permission to edit products when viewing the product there will be an edit link.

3. I am not sure what you mean by a field for a link for the product.

[JayH]

Great:

Originally Posted by Chuck S

1. showproduct template but there is an option in the showproduct option to show a dealtime link or not as well as pick which service to use.

Excellent, is there a way to get an amazon associate number tied to these searches?

Originally Posted by Chuck S

2. you if you have set permission to edit products when viewing the product there will be an edit link.

Thanks, which setting section is this under? I can't seem to find it.

Originally Posted by Chuck S

3. I am not sure what you mean by a field for a link for the product.

When a person initially uploads the product, it would be nice to have a field for them to enter the products web site:

Enter the Product Manufacturer:

Enter Product web site (e.g. http://www.productsite.com):

Product Model Name (e.g. GeForce256 32MB):

Images of product to upload (if any, leave blank if not):

To help users find your product, please enter a few (up to 10) descriptive keywords (separated by spaces):
Product description

also, I found this:

Your Commission Junction click-through URL

It looks like a way to tie into commision junction?

[Chuck S]

Cant say anything about amazon personally do not use them. The dealtime links are essentially search links.

You set permissions in Admin => Edit Usergroups

You can set up an extra field for each category in Admin => Edit Categories just make one that says Product Url etc and on upload they will be presented with a box to enter a url.

[JayH]

Originally Posted by Chuck S

Cant say anything about amazon personally do not use them. The dealtime links are essentially search links.

You set permissions in Admin => Edit Usergroups

You can set up an extra field for each category in Admin => Edit Categories just make one that says Product Url etc and on upload they will be presented with a box to enter a url.

Got it, the area is starting to look pretty nice.....

I am using reviewpost for a motorcycle site, and one of the Catagories is for dealers, which is causing a little confusion due to the menu and field descriptions.

Can you point me to the template(s) the "Upload Products" title is so I can change it to "Upload Product or Dealer" and I'd also like to change these default field descriptions in it's appropriate template to make them apply to products, services, and dealers:

Choose a category
Enter the Product Manufacturer:
Product Model Name (e.g. GeForce256 32MB):
Images of product to upload (if any, leave blank if not):
To help users find your product, please enter a few (up to 10) descriptive keywords (separated by spaces):
Product description


Thanks!!!

[Chuck S]

The uploadproduct template is the upload template and you can edit language file strings from admin if you have your language file set to writable via ftp in the directory.