Missing Table - session

fpoole · February 15th, 2006, 09:40 AM

I've upgraded vbull (vb), photopost(pp) and vbportal (vbp) and probably missed one level in pp...

might have started later on in the steps and should have dropped down to an older version, but did match the ver nmbr to what was in the admin panels.

Getting error messages ;

Quote:

MySQL Error : Table 'pnwhosti_pspp.session' doesn't exist
Error Number : 1146

Same as other posts, can't log into admin panel and checked the cookies on the vb config, but couldn't find what to match to in pp config or config-int?

Anyway, appears that I'm missing the Session Table
So my question is (unless it's something else?)

What's the best way of getting it back up..

I saw a post on re upload the Templates Folder? meaning everything??
and
Uploading the scripts... the scripts??.. Where or what to look for?
remove the config-inc.php AND?? the -int.php?

Can you point me to the link that has the best way of doing this.. I see bit's and pieces, but there's always something left out.. like the cookies on 171-173.. lost me on that one...

any help would be appreciated..

www.psdivers.com

I guess to get the table in there??

thanx much..

Zachariah · February 15th, 2006, 10:02 AM

Quote:

MySQL Error : Table 'pnwhosti_pspp.session' doesn't exist
Error Number : 1146

- missing vBulletin sessions table

You can try to run the upgrade script for VB to see it it will add that missing table.

Do you have a way to phpMyAdmin or some way to edit the database ?

fpoole · February 15th, 2006, 08:10 PM

Yes, I have access to phpMyAdmin, but believe this is a PhotoPost (pp) Table as it's asking for access to the Photopost DB the "..._pspp" identifies to me the ps(divers)pp (photopost)... so thinking it's a photopost table that I missed when I did the upgrade... like it's a new table added since the last version??? and I didn't go back far enough to create it in the upgrade scripts???

Lost here...
thanx...

Chuck S · February 15th, 2006, 08:14 PM

Photopost does not have a sessions table.

We update the vbulletin session table entry but if your not supplying the proper database info for vbulletin then your going to get this error.

Check your vbulletin table prefix in the photopost settings table setting 83 and check to ensure you have the vbulletin database info entered correctly in the config-inc.php file

fpoole · February 15th, 2006, 09:19 PM

Ok, will do... but I'm lost on these reference numbers.. like 83, what are those referring to... also saw some in other post for the cookies 173 or something like that..
The vb database doesn't have any prefix that I'm aware of.. not seeing anything in the DB...
thanx..

Chuck S · February 16th, 2006, 07:58 AM

Okay well you said you where familiar with phpmyadmin those are id numbers of rows in the settings tables which correspond to the entries noted for database prefix of the forum and cookie setting.

The only other problem you could have here is if there is no prefix for the forum then when you installed photopost you specified the wrong database for the vbulletin forum on install.

fpoole · February 16th, 2006, 08:26 AM

Oh, ok, got it on the ID numbers and the rows.. will check it out, thanx

there isn't a prefix on the vbull data base
separate db for pp and that is pp_
I do have the settings for the vb cookies at "bb" but I thought that unrelated to the DB itself..

I just reinstalled vb and will do the same with pp... but not sure I got clarifications on the correct way of doing that...

- re-upload the "Template" Folder
- re-upload the "Install" folder and re-rerun the upgrade starting fruther back??

Also I'm still not able to log in to the pp admin, I know it's a simple setting somewhere, but have checked the license # but cant find the Cookie setting option in the config-inc.php (thought it down towards the bottom below the vb license number)
and don't see it in the config-int.php

I appreciate the help Chuck, but I can't tell if I should be concentrating on Photopost or vBull... the guy (sa) at vbull rudely told me "Dont come running here. This topic is rather old. Make your own ." not a clue what that means...

and since you've indicated pp doesn't have a sessions table... and vbull does.. little confused...
Any thoughts would be helpfu...
I'm thinking I need to delete all and start over with a recovery... but everything seems to be working OK, so hate to do that..

http://www.psdivers.com/forums/?styleid=1
http://www.psdivers.com/photopost/
http://www.psdivers.com/reviewpost/

but can't bring up vbportal, cleared the bbstyleid, at one time, but think it's not showing is due to the error message..

thanx...

fpoole · February 16th, 2006, 08:27 AM

Here's latest error message if that helps at all:

Quote:

Database error in vBulletin 3.5.3:

Invalid SQL:

INSERT IGNORE INTO session
(sessionhash, userid, host, idhash, lastactivity, location, styleid, languageid, loggedin, inforum, inthread, incalendar, badlocation, useragent, bypass)
VALUES
('9eceeea38c06dd7dc389a6345e4770b8', 2, '67.168.47.233', 'ada16c6890d3b56f52741cd7f3b5201d', 1140099240, '/modules.php?name=Jig', 0, 0, 0, 0, 0, 0, 0, 'Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; Maxthon; SV1; MyIE2)', 0);

MySQL Error : Table 'pnwhosti_pspp.session' doesn't exist Error Number : 1146
Date : Thursday, February 16th 2006 @ 09:14:00 AM
Script : http://www.psdivers.com/modules.php?name=Jig
Referrer :
IP Address : 67.168.47.233
Username : xxxxxx
Classname : vb_database

Chuck S · February 16th, 2006, 09:00 AM

Your issue doesnt even have to do with photopost look at the script

The script causing that error is your vbportal

fpoole · February 16th, 2006, 09:03 AM

Ok, point is mute now.
I'm doing a full recovery..

Appreciate the help so far, will be back I'm sure.. ;-))

Thanx much Chuck..

Chuck S · February 16th, 2006, 09:23 AM

Turn off the photos block hack you have in vbportal or code it correctly to select the forums database after the photo block is done