Upgrading to 2.42 from 2.1 - which upgrade script do I use?

[ludachris]

Here are my options - which one do I choose if I'm running 2.1?

1.0 -> 1.1 ......Upgrade from PhotoPost Classifieds 1.0 -> 1.1
1.1 -> 1.8 ......Upgrade from PhotoPost Classifieds 1.1 -> 1.8
1.8 -> 2.0 ......Upgrade from PhotoPost Classifieds 1.8 -> 2.0
2.0x -> 2.11 ......Upgrade from PhotoPost Classifieds 2.0x -> 2.1
2.3 -> 2.42 ......Upgrade from PhotoPost Classifieds 2.3 -> 2.4

As you can see, there is no clear option for 2.1 users.

[Chuck S]

Just the last one

[ludachris]

Thanks Chuck - finished the upgrade, but I'm receiving two errors on my index page:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/mysite.com/html/classifieds/forums/vb3.php on line 358

And:
Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /var/www/mysite.com/html/classifieds/index.php on line 96

[ludachris]

Arghhh - looks like all pages are displaying errors of some time. They all say something about:

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource

[Chuck S]

try running the 2.0 upgrade then

[ludachris]

Okay, I've done that - now I get this:

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

[Chuck S]

You sure you had version 2.1??

You need to change this in pp-inc.php from 0 to 2 so we can see what error is going on

$showsqldebug = 2;

Now this requires you to already be logged in as admin. However you can remove the code in bold at this line to show to everyone

if ( $User['adminedit'] == 1 && $showsqldebug == 2 ) {


Double check all new files have been uploaded here. Without the exact error being posted here I can not assist anyfurther till then

[ludachris]

Chuck, should the error now show up after doing that edit? Because the error message is the same.

[Chuck S]

At the bottom of your page


Page generated in 0.21614 seconds with 6 queries
1: SELECT userid,username,email,password,usergroupid,timezoneoffset,salt,membergroupids FROM ppc_user WHERE username='' (0.00037 sec)
2: SELECT id,header,footer,headtags,template FROM ppc_categories WHERE id=0 (0.00062 sec)
3: REPLACE INTO ppc_iponline (userid,ipaddr,date,what,item) VALUES ('','69.250.134.65','1129944198','index','0') (0.00067 sec)
4: DELETE FROM ppc_iponline WHERE date < 1129943598 (0.00029 sec)
5: DELETE FROM ppc_iponline WHERE date < 1129943598 (0.00015 sec)

There is the issue that I see. Your database info for vb3 is wrong. You also setting the vb3 table prefix as ppc??

[ludachris]

Yes, my classifieds tables are using ppc_ as the table prefix. I set it up like that and it's been running fine with the previous versions. How is the info for vb3 wrong? Where would I have changed that? I looked over my config file and it's the same as it was before... was I supposed to change something? Are we supposed to change it from vb3 to vb35 in the user registration settings?

[Chuck S]

Look at the query I posted it is looking at the vb3 user table as ppc_user??

that is surely wrong.

Check in the settings table setting 83 for whatprefix you have set for vb3 table.

also check the database info to see if its right

[ludachris]

Thanks Chuck I got it working. Two questions though - my classifieds tables have a ppc_ prefix (which is mentioned in my config file). Should I have erased that prefix in the config file before I did the upgrade? It's been in the config file for as long as I can remember.

Also, should I be using the new config file or the old one? Currently I have the old one in there with the version # changed.

[Chuck S]

No somewhere it looks like your vb3 table prefix changed maybe when you upgraded vb3 who knows

[caliman]

Hi Chuck -

I just did the upgrade from 2.1 to 2.42 as well..

I think I did it right, but I did have some errors as well... although it appears to be working now. These are my errors:

Content visible to verified customers only.

Should I be worried about this? My classified appears to be working...

These are the files I uploaded for the upgrade and instructions:

1) Perform a backup of your database.
2) Shut down your ads area by selecting Closed in the Edit Config area.
3) Upload the files:

All the main directory files, except for config-inc.php and install.php
templates/*
forums/*
languages/*
images/*
help/*

4) From the upgrades directory, upload the scripts to your main Classifieds directory and run upgrade.php (or, if you are just upgrading 1.8.X, you can just run the upgrade18.php script). This script will update your database; once it has finished you can remove all the upgrade*.php files.
5) Open your forum in the Edit Config by setting the value to "Open".

Also I am still running vB 3.0.7, I will upgrade to 3.5 after I upgrade all of your products per your advice.

Am I ok?

[Chuck S]

Your fine that is just saying it does not have permission to delete those scripts or it cant find them

If they exist you can delete them by hand

[caliman]

Cool. That's great. Thanks C.