Crash on Upgrade from 3.1 to 4.2

scalemotorcars · February 9th, 2011, 06:25 PM

Well, I know duplicates are normal and Character Set not working for 4.0 sql but for some reason my problem originates around the phrases.

Oh and I did try to upgrade from 3.0+ since I read thats when the phrases we added.

It seems to start with there errors....

Code:

Content visible to verified customers only.

The next page looks like this but about 100 lines longer

Code:

Content visible to verified customers only.

Seems phrases are not getting added or never got added. Like I said I ran the upgrade from 3.0 forward but no luck.

--------------------------------------------------------------

DB is correct and so is the user and password. If I replace the old 3.1 pp-inc.php file the classifieds looks fairly normal. If I use the new pp-inc.php I get a white page so Im leaving the old 3.1 in place until I get an answer here.

scalemotorcars · February 9th, 2011, 08:11 PM

It refuses to create the phrases table and language table. Ive tried all three user id's and passwords that I know work with the DB and nothing.

This is an example of the error.

Error: Table 'forum_scalemotorcars_com.cp_phrases' doesn't exist

Error: Table 'forum_scalemotorcars_com.cp_languages' doesn't exist

I also noticed this line on the page before these errors.

Error: Can't DROP 'description'. Check that column/key exists

Chuck S · February 10th, 2011, 07:44 AM

Maybe try removing this from those queries?

Code:

Content visible to verified customers only.

scalemotorcars · February 10th, 2011, 08:14 AM

How do I do that?

Chuck S · February 10th, 2011, 08:22 AM

You can edit the upgrade php and remove what I noted from the language and phrases table inserts or add these queries below to phpmyadmin to the database

Code:

Content visible to verified customers only.

scalemotorcars · February 10th, 2011, 08:46 AM

Thanks Chuck, that fixed the phrases but I still have a problem.

The (edit settings) links do not work and it's stuck on version 3.1

Edit... I just noticed the classifieds index also shows version 4.1 not 4.2 ???

scalemotorcars · February 10th, 2011, 09:15 AM

This might also help. When I click on a link in the admin I get this error emailed to me.

Code:

Content visible to verified customers only.

Chuck S · February 10th, 2011, 09:34 AM

Have you upgraded all your files? For instance there is no description field in the settings table in our newer versions. There is no reference in our downloaded files to a settings table description field so first upload all the new files. Next if you still have issues then see below. But based on your attachment you are trying to use an old classifieds adm-misc.php with the new versions. That simply not going to work.

Therefore did you run all applicable upgrades? That field was removed in the 3.0-3.1 upgrade. If you continue to have issues then post a site url.

scalemotorcars · February 10th, 2011, 10:30 AM

I just uploaded all files again and it seems to have fixed the issue.

I have 3 last questions thats not directly related...

#1 I use vb integration. Is there a list of core files needed to run PP-Pro or PP-Clas. It seems like allot of bloat to have all those extra files on the server if non are used.

#2 Why is enlargit used with classifieds and not lightbox like in PP-pro?

#3 And please correct me if Im wrong but the pp-c navbar is in pp-inc and if I want to removed or change links thats the place to do it.

Thanks again Chuck, top notch service as always...

Chuck S · February 10th, 2011, 11:38 AM

1. All the files uploaded are used by our products. The only real extra files could be in the templates directory depending on your install.

For instance you could delete all templates in the templates folder except the vb4enhanced folder if your using vb4 with the integration on.

2. They are different products and code branches. ReviewPost and Classifieds have more codewise to compare to one another versus the gallery which is different with different features.

3. You can edit the menubar there yes but I would never remove it unless you properly code those links elsewhere for display.

scalemotorcars · February 10th, 2011, 11:51 AM

Thanks Chuck.

#1 thanks, thats what I was thinking also.

#2 Ive been all over the forum and I think there is a lightbox hack for classifieds but I couldn't find it. Do you remember seeing it and if so where is it?

#3 And again thanks for the info on 3. Ive messed with it before you still have your suggestions. I just wanted to make sure...

Chuck S · February 10th, 2011, 11:59 AM

1. K

2. No sorry dont follow hacks so no idea there

3. K