Just upgraded, two problems

Swanny · November 11th, 2005, 04:03 PM

Hey all. I just upgraded my ReviewPost today... went from v2.5.2 to 3.11. I did it by deleting all files except for data, and then re-uploaded everything (yes, I updated config-inc.php).

Anywho, now I have two problems.
1. When I view a product review, the date does not show up. It comes up as YYYY-MM-DD, which is how I set it up in the Admin Panel. Why is that?
2. In the footer of each page it shows this: Powered by: ReviewPost --REPLACEME-- Copyright 2005 All Enthusiast, Inc. Why is the version number not there? It shows correctly in config-inc.php, and when I'm in the Admin Panel.

As an example, see here: http://www.fordf150.net/reviews/show...php/product/41

Help!

Swanny · November 11th, 2005, 04:32 PM

Just to add to that... during the ugprade process I got these errors:
Performing MySQL command: ALTER TABLE rp_iponline DROP INDEX userid ... Error: Can't DROP 'userid'. Check that column/key exists
Performing MySQL command: ALTER TABLE rp_products DROP INDEX approved ... Error: Can't DROP 'approved'. Check that column/key exists
Performing MySQL command: ALTER TABLE rp_products DROP INDEX date ... Error: Can't DROP 'date'. Check that column/key exists

Not sure if that matters...

Chuck S · November 11th, 2005, 04:40 PM

No big issues on queries etc there or anything

One note I suggest you check your data format in admin cause there are no issues with date that I see

http://www.reeftalk.com/reviews/show...p/product/1760

Swanny · November 11th, 2005, 04:42 PM

ReefTalk isn't my site????

The date is set to YYYY-MM-DD in the Admin Panel.

Swanny · November 11th, 2005, 04:45 PM

Update.... I changed YYYY-MM-DD to yyyy-mm-dd and now the date shows up correctly. I guess that field is case sensitive.

So any ideas for problem #2?

Chuck S · November 11th, 2005, 05:53 PM

I beleive I already answered that anything else you meantioned was of no concern

No reeftalk was my site and was just showing dates work

Swanny · November 11th, 2005, 07:09 PM

OK, I still have one problem though:
2. In the footer of each page it shows this: Powered by: ReviewPost --REPLACEME-- Copyright 2005 All Enthusiast, Inc. Why is the version number not there? It shows correctly in config-inc.php, and when I'm in the Admin Panel.

Chuck S · November 11th, 2005, 07:19 PM

Check your file pp-inc.php lines 274-275 should be this

Code:

Content visible to verified customers only.

Okay well they are not capitals

Swanny · November 11th, 2005, 07:30 PM

That is exactly my code. I even copied and pasted your code into pp-inc.php. It still doesn't show right in the footer.

Hmmm.... if you take a look at the link I posted originally you'll see it says "--REPLACEME--" in caps.

Perhaps the problem has to do with the caps?

So I took a look at id 37 in the rp_settings db. The contents of that record is:

Code:

Content visible to verified customers only.

So I changed it to --replaceme-- in lowercase in the db. All that did is remove the version number. Is it fixed? Take a look now:
http://www.fordf150.net/photos/showp...8/limit/recent

Chuck S · November 11th, 2005, 07:36 PM

yes it is fixed

it needs to be lowercase as noted in my post

Swanny · November 11th, 2005, 07:41 PM

So if I understand correctly, with version 3.11 the version number no longer shows up in the app itself (i.e. what the users see). It only shows up for me the admin in the admin control panel? Is that correct?

Chuck S · November 11th, 2005, 07:46 PM

you got it