PhotoPost Community

PhotoPost Community (http://www.photopost.com/forum/)
-   ReviewPost Installation & Upgrades (http://www.photopost.com/forum/reviewpost-installation-upgrades/)
-   -   SMF integration (http://www.photopost.com/forum/reviewpost-installation-upgrades/140322-smf-integration.html)

porridgefactory June 19th, 2009 04:13 AM

SMF integration
 
I have installed reviewpost on an smf forum here
MicrostockGroup.com

The reviewpost is here
Main Index - My Product Gallery

On installation I told reviewpost to use my SMF database and when looking in mysql that is confirmed. I have set the cookie settings, but the login/out doesn't seem to work?

Also I have no idea of how to get the two to look 'integrated' can someone push me in the right direction?

thanks,
tyler.

porridgefactory June 19th, 2009 06:16 AM

On the admin page for reviewpost there only shows 1 user, so it can't be drawing from my smf database.

I have read that reviewpost tries to guess where the members table is but how does it know that it has the smf_ prefix. I didn't enter that anywhere.. could that be the problem?

Chuck S June 19th, 2009 09:08 AM

If your only grabbing one user and your forum has many more I would suspect you did not install correctly to integrate with smf. You might need to reinstall and make sure everything is entered correctly on reinstall.

porridgefactory June 19th, 2009 09:14 AM

thanks for the reply,

Well I suppose it isn't grabbing any because the only user is the 'admin' user I had to set up.

I would agree it isn't syncing with the SMF forum but I have no idea what is wrong. I have gone through the settings many times but couldn't find any errors.

Am I suppose to enter the smf_ prefix somewhere?

Chuck S June 19th, 2009 09:21 AM

Well all you can do is rerun through the install and be careful to enter all the proper information asked. Make sure you select external integration and choose SMF 1 or 2 and answer everything correct.

porridgefactory June 19th, 2009 09:24 AM

Yes, I have done that several times in an attempt to fix the problem but haven't had any luck.

For integration is this setting
Reviewpost Database Prefix (cannot be changed once set)
supposed to be the same as the smf forum prefix or is this asking if I want to set up a prefix for the reviewpost tables.

Chuck S June 19th, 2009 09:29 AM

No that is not suppose to be the same.

You need to enter your reviewpost database info where its asked.

You need to enter the smf database info in the user database portion

You need to select smf under external integration.

You need to input the proper cookie name and the proper database table prefix where asked.

If you answer everything then it will be integrated correctly. If you can login with a user from smf it is integrated.

porridgefactory June 19th, 2009 09:39 AM

You need to enter your reviewpost database info where its asked.
Done - I put the reviewpost data inside the smf forum database with a different prefix

You need to enter the smf database info in the user database portion
Done


You need to select smf under external integration.

Where is this setting

You need to input the proper cookie name and the proper database table prefix where asked.
I believe I have done this correctly. I have tried a number of different options, none of them worked, but I believe that is because I haven't got reviewpost to find my members table.

If you answer everything then it will be integrated correctly. If you can login with a user from smf it is integrated.

Chuck S June 19th, 2009 10:18 AM

You need to enter your reviewpost database info where its asked.
Done - I put the reviewpost data inside the smf forum database with a different prefix

You need to enter the smf database info in the user database portion
Done


You need to select smf under external integration.
Where is this setting

The third step of install it asks you internal or external.

It then goes to step 4 where is asks all the forum stuff make sure you select the proper version of SMF and then fill out the proper info.

Like I said if you properly install you will be able to authenticate any user in smf in reviewpost.

porridgefactory June 19th, 2009 10:27 AM

perhaps step 3 is the problem then. Currently, in the installation, when I click
Click here to continue to Step 3 -->

I click there, and then get a long list of database errors

Quote:

Step 3: MySQL error reported: [CREATE TABLE rp_reviewtypes (id int(12) NOT NULL default '0', reviewtype varchar(64) NOT NULL default '', isactive tinyint(1) NOT NULL default '0', PRIMARY KEY (id), UNIQUE KEY id (id)) TYPE=MyISAM]
Result: Table 'rp_reviewtypes' already exists
Database: microsto_smf

Step 3: MySQL error reported: [INSERT INTO rp_reviewtypes VALUES (0, 'Regular', 1)]
Result: Duplicate entry '0' for key 1
Database: microsto_smf

Step 3: MySQL error reported: [INSERT INTO rp_reviewtypes VALUES (1, 'Customer Service', 0)]
Result: Duplicate entry '1' for key 1
Database: microsto_smf

etc..
which I am guessing is correct because those tables now exist from before.

But that is all, I am not forwarded to a step 3, I just sit there on an error page.

Chuck S June 19th, 2009 10:34 AM

The table to select an internal or external install is most definately there. Try scrolling down the page. You must complete a full proper install to be installed correctly.

porridgefactory June 19th, 2009 11:49 AM

no, there isn't any tables to fill in on that page. It is just a long long list of smf errors on a white page.

Code:

Content visible to verified customers only.
I have pasted the whole page now.

Chuck S June 19th, 2009 11:58 AM

You need to wait for the page to finish.

Chuck S June 19th, 2009 12:03 PM

Main Index - My Product Gallery

Thats what I see

You cat turn off the category cache and see what stats it loads under global options as it recognizes the user I registered in smf

You also need to set permissions correctly and maybe upgrade group names as it does indeed look like you did not install correctly

porridgefactory June 19th, 2009 12:38 PM

Quote:

Originally Posted by Chuck S (Post 1248950)
You need to wait for the page to finish.

I did. It has been sitting on that same white page for 30minutes now. :)

Chuck S June 19th, 2009 12:39 PM

Main Index - My Product Gallery

Your reviewpost seems fine

I see 2952 users


All times are GMT -5. The time now is 06:48 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97