Recently upgraded to 2.42 from 2.1 - page not found

ludachris · December 31st, 2005, 01:45 PM

So I uploaded the files and ran the upgrade script. At first, I had a mysql error at the top of the page - something about VB3.php line 358. I remembered this problem from a previous upgrade - it had to do with my VB3 table prefix. Well, I've tried changing the prefix in phpmyadmin directly, editing the config file, and it doesn't fix the problem. The script still things there is a table prefix.

Now, all of the sudden, the page just shows up as Not Found. I have no clue as to what's going on. I've reuploaded all the files just in case I deleted one by accident. Nothing does the trick. This all happened after I upgraded to vb3.5 and started getting that mysql error. I figured I needed to upgrade the classifieds script, which brought me to this point. I always have bad luck upgrading this script.

ludachris · December 31st, 2005, 01:56 PM

Here's what the debugging says:

Page generated in 0.37720 seconds with 17 queries
1: SELECT u.userid,u.username,u.email,u.password,u.usergroupid,u.timezoneoffset,s.sessionhash,u.salt,u.membergroupids FROM user u LEFT JOIN session s ON s.userid=u.userid WHERE u.userid='1' (0.00113 sec)
2: SELECT groupid,cpaccess,modaccess,uploadsize,uploads,comments,editpho,editposts,reqmod,highlight,bold,italic FROM ppc_usergroups WHERE groupid=6 LIMIT 1 (0.00018 sec)
3: SELECT id,ugnoupload,ugnoanno,ugnoview,ugnopost,catname,parent,children,thumbs,header,footer,headtags FROM ppc_categories (0.00014 sec)
4: SELECT id,header,footer,headtags,template FROM ppc_categories WHERE id=500 (0.00009 sec)
5: REPLACE INTO ppc_iponline (userid,ipaddr,date,what,item) VALUES ('ludachris','24.9.187.231','1136056351','index','') (0.00022 sec)
6: DELETE FROM ppc_iponline WHERE date < 1136055751 (0.00022 sec)
7: DELETE FROM ppc_iponline WHERE date < 1136055751 (0.00010 sec)
8: SELECT c.id, c.catname, c.description, c.catorder, c.parent, c.thumbs, c.children, c.products, p.id, p.user, p.userid, p.date FROM ppc_categories c LEFT JOIN ppc_products p ON c.lastproduct=p.id ORDER BY c.catorder ASC (0.00068 sec)
9: SELECT cat,laston FROM ppc_laston WHERE userid=1 (0.00011 sec)
10: SELECT item, count(*) FROM ppc_iponline GROUP BY item (0.00045 sec)
11: SELECT data FROM datastore WHERE title = 'userstats' (0.00009 sec)
12: SELECT SUM(views), count(*) FROM ppc_products WHERE approved=1 (0.00010 sec)
13: SELECT count(*) FROM ppc_comments (0.00006 sec)
14: SELECT amt_sold,ads_sold FROM ppc_stats (0.00006 sec)
15: SELECT userid,date FROM ppc_iponline ORDER BY date DESC (0.00032 sec)
16: SELECT id,user,userid,cat,title,bigimage,views, id*0+RAND() as rand_col FROM ppc_products WHERE approved=1 AND status=0 AND cat != 1 ORDER BY rand_col DESC (0.13006 sec)

ludachris · January 1st, 2006, 09:13 PM

Can I please get some support for this question soon, I'm trying to get my Classifieds back online after the upgrade and can't afford too much more downtime. I realize this is a holiday weekend, but I could use some help asap. Thanks.

Chuck S · January 2nd, 2006, 12:10 PM

Well post 2 is easy in pp-inc.php set this to 0

$showsqldebug=2;

As far as vb3.php line 358 that would suggest you have missed running a required upgrade script cause your missing a field in your classifieds usergroup table. Although more than likely it seems that possibly you have not uploaded the new vb3.php file as I can not find a usergroup alteration since the 1.8 upgrade where highlight is added. You could try running the query on line 356 in phpmyadmin to see exactly the issue or post what you have for that query here

ludachris · January 2nd, 2006, 01:06 PM

So an update - I found that I was missing the usergroup table somehow. I put in the backup table I had and ran the upgrades again. The whole section still comes up as Page Not Found. Why would it do this?

Chuck S · January 2nd, 2006, 01:53 PM

Do you have a link to what you mean? What page is not found etc. I don't see a clear explanation here of what you mean.

ludachris · January 2nd, 2006, 05:39 PM

I have my installation in the /classifieds/ directory on my site. When I point my browser to the installation, I get Page Not Found.

When I manually type in the admin URL, the left frame shows up, but the content is being pulled from my Gallery installation.... now I'm really confused.

Chuck S · January 2nd, 2006, 06:02 PM

Looks to me like you have cross installed classifieds over a photopost database install. Thats at least one thing I would think of off the top of my head. Did you ensure if you installed this in the same database as photopost that it had a different prefix?

ludachris · January 2nd, 2006, 06:38 PM

How is it possible to install classifieds over a photopost database when upgrading? I used the original config file. My PP tables have no prefix, my PPC tables have ppc_ prefix.

I just reverted all of my backed-up classifieds database tables and uploaded all of the 2.1 files again. I'm using the correct config file... why is it not fixed? Everything is how it should be and yet it's still pointing to my gallery installation. Why?

Chuck are you on YIM? If so, could you PM me your handle? I need some help with this today and it would be way easier to IM or call you instead of posting in this forum.

Chuck S · January 2nd, 2006, 06:50 PM

Quote:

Originally Posted by ludachris

Everything is how it should be and yet it's still pointing to my gallery installation. Why?

This is what I am asking you.

The program would not point to your photopost unless you have done so which is what I am assuming here.

It might help if you post your classifieds and photopost installations so we can see what you mean. I have looked at some of your sites but I do not see any photopost installed on all 3 that I see listed in your members area.

ludachris · January 2nd, 2006, 06:54 PM

I've checked phpmyadmin - the classifieds settings (paths, URLs) in the db are correct - they're pointing to the classifieds installation like they should be. The config file is pointing to the correct directory for classifieds. Yet I get a page not found. And when I type in the admin URL, it points to the wrong directory.

PM'd you the installation info.

Chuck S · January 2nd, 2006, 07:01 PM

You did exactly as I stated. You installed classifieds into your old photopost database with the same table prefix.

Look at your gallery url you gave me. The page has errors and look at the footer that says Photopost classifieds not Photopost Pro.

This could only happen if you upgraded/installed into an already existing photopost database. Bet the table prefix in your config file is the one for your gallery as well.

By the way your classifieds is closed so I see nothing but one look at your gallery confirms what I stated in post 8

ludachris · January 2nd, 2006, 07:06 PM

The reason why the gallery now looks as if it's running a classifieds installation is because I tried changing the options in the gallery admin to point to the classifieds installation. I didn't figure that would work, but it was a desperation attempt. I actually didn't install the classifieds over the gallery - all the gallery data is there by looking at phpmyadmin.

The big question here is, after I've reverted to a backup copy of my ppc_ classifieds tables, uploaded all old files and config file, why does it not work again? Basically, what do I do? It still should theoretically work right now. By the way, my classifieds are set to OPEN, not closed (when looking in phpmyadmin).

Chuck, you pointed out what you think might have happened, but failed to give me a resolution. I don't believe I installed the classifieds over the gallery. And if I did, so what? That should have screwed up the gallery, not the classifieds. I reimported all my classifieds tables from a backup and reuploaded all of the last good working files. It should work now, but it doesn't. The gallery might not work, but that doesn't matter right now. I want the classifieds to work. Please tell me what to do next.

ludachris · January 2nd, 2006, 07:32 PM

Oh well, looks like Chuck left... there goes another day of work. I am no closer to getting this to work than I was this morning. I'm really getting tired of this script and the support. This is getting extremely frustrating. You ask a question one day and hopefully someone will answer it the next day. And if I'm lucky, I might even get this resolved 3 days from now. You guys really need to offer telephone support for the price of this software.

Chuck S · January 2nd, 2006, 08:05 PM

If you are upgrading classifieds you need to ensure you are using a working database with no issues. You then upload all the new files except config file and then run the upgrade script and upgrade the database.

Your issue is your config file is pointing to your gallery table prefix's not your classifieds prefix. I beleive I pointed this out in my last post.

Edit your config file for classifieds after uploading a working classifieds database and point to those tables by entering the correct table prefix and or database info. Run the upgrade script. As long as your paths and url's etc are all correct and your upgrading the proper tables you should be fine.

ludachris · January 2nd, 2006, 08:18 PM

Chuck, I've upgraded this script a few times now. I know the process. As I said, though I don't think I did anything wrong, I reverted to a backup. I've uploaded the previous good files. I've checked the config file 20 times to make sure it's pointing to the correct directory. I've checked phpmyadmin to make sure the database settings are pointing to the correct directory. I've tried manually changing the database prefix in phpmyadmin - doesn't change anything.

The config file is pointing to the correct directory. What do I try next?

Chuck S · January 2nd, 2006, 08:21 PM

What is your $pp_db_prefix set to in your classifieds config-inc.php?

You clearly upgraded your photopost tables not your classifieds table when you upgraded which means classifieds is using your photopost tables not your classifieds tables which is why its trying to go to your gallery not classifieds when you load the program.

You need to set the proper prefix in the config-inc.php for classifieds to see the proper tables.

ludachris · January 2nd, 2006, 08:31 PM

Chuck, that may be the case, but like I've said, I've set the variable to ppc_ and it doesn't work. I'm feeling a bit defeated right now. Can it be that I'm using an outdated config file? I've been using the same one with every upgrade. Let me try using the original that came with 2.1

ludachris · January 2nd, 2006, 08:37 PM

So I was able to get it working by uploading the original config file. I still don't completely understand why it worked. All I did was copy the info over from one config file to the other. I had tried changing variables left and right and it wouldn't work. I guess the config file version matters that much?

Chuck S · January 2nd, 2006, 08:39 PM

Yes you always use the original config file from your version your running.

There is nothing else I know of other than what I have stated here. You are pointing your classifieds at this point to photopost database. If you PM me the admin login maybe I can see your classifieds but as I have priorly pointed out I can only see your gallery not classifieds.

Given the fact your gallery was upgraded with classifieds info this told me what you did here since the upgrade script is going to get the database and table info from your config file in classifieds and upgrade the database. This could only happen if your config file in classifieds had your gallery info instead.

EDIT.. I see you posted the same time as me

Your config file you where using had to be from the photopost not classifieds