[extremly urgent] table search deleted while upgrade to 5.62

PyroMarkus · December 16th, 2006, 12:14 PM

Hi there,

please, I really really need urgently help:

I prepared an upgrade from vB 3.0.x to 3.6.4 and from Photopost 4.81 to 5.62 locally. I changed styles etc. and everything went fine.

Today I tried to upgrade my production server, which is heavily visited nowadays.

I closed vB and photopost,
uploaded all files for vB
run upgrade-script for vB
all went fine - vB is 3.6.4
I uploaded all files for PP
run upgrade script
first choice was "4.82" (but this gives a blank page)
so I started with "4.85/.86" - scripts worked till last one,
I got an error:

Quote:

PhotoPost Upgrade
Preparing to update database...

Error performing MySQL command: CREATE TABLE search ( searchid INT( 12 ) NOT NULL AUTO_INCREMENT PRIMARY KEY , userid INT( 12 ) NOT NULL DEFAULT '0', searchtype VARCHAR( 1 ) NULL , searchterms VARCHAR( 250 ) NULL , searchdate VARCHAR( 5 ) NULL , cats MEDIUMTEXT NULL , name VARCHAR( 64 ) NULL , preview SMALLINT( 1 ) NOT NULL DEFAULT '1', idlist MEDIUMTEXT NULL , numresults INT( 5 ) NOT NULL DEFAULT '0', ipaddress VARCHAR( 15 ) NULL , searchtime FLOAT( 6, 6 ) NOT NULL DEFAULT '0', date INT( 15 ) NOT NULL DEFAULT '0' )
Error: Table 'search' already exists

Upgrade complete! You should continue to next step

Whoow, was what that?! No I have heavy problems:

Photopost looks like shown on attachment: the upgrade on the categories must have gone wrong
and vB is not running anymore, because table "search" was deleted - from PP

I cannot believe!

What went wrong - is vB 3.6.4 not compatible with PP 5.62 because they own a same called table? How can that be? And what is this category problem? Trying to show some photos is successfull.

And furthermore I am logged in in vB, Photopost recognizes me but does not show me the admin-link and trying to open adm-index.php says "you are not a valid adminsitrator".

I really need urgent help - what to do?

Thanks a lot in advance!

PyroMarkus · December 16th, 2006, 12:19 PM

... wrong info ...

PyroMarkus · December 16th, 2006, 12:24 PM

... wrong info ...

PyroMarkus · December 16th, 2006, 12:52 PM

Ok, I see, there was a conflict - found some threads.
Now I could copy table "search" from the local vB 364 installation and run the sql on the production server. vB is running again, thanks god, and PP is able to search to, so its using the "searchid" table already.
The hell knows why the conflict occoured with my installation scripty from 5.62...

But the layout problem still exists and that I am not an valid administrator. What to you suggest how to fix this?

Is the installation to be safed or looks it to you, as if the upgrade failed?!

Any hints how to fix it, please...
Thanks!

PyroMarkus · December 16th, 2006, 01:21 PM

I think this could be configuration problem.

I found some images not showing up because they have the old styles in their path:

domain.de/album/stylesheets/dark-borders/report.gif

See: stylesheets/dark-borders is from photopost 4.81. And I cannot change the configuration because I am not recognized as valid admin.

Please, what shell I do?

PyroMarkus · December 16th, 2006, 01:48 PM

And while searching it seems not to find anything and it does not list the categories.

But they are in table "categories" in database.

Please, I need support.
Thanks a lot!

Chuck S · December 16th, 2006, 09:11 PM

Giving us a true url to your site can help immensely here when seeking assistance. If you did not properly run the 4.82 upgrade then I would think this is your issue since that upgrade is missing

Yes your Photopost was not running a table prefix and neither is your forum so this is what caused your conflict since table names where crossing as far as search but you resolved this.

I think I found a url for your site but it does not exist where your telling us it exists. Does not seem there is an album directory on your server any longer.

PyroMarkus · December 17th, 2006, 12:54 AM

Thank you Chuck for assisting again!

The URL is correct but to avoid thousands of people seeing the "destroyed" PP I renamed index.php to index_562.php temporarelly.

I have some infos which may be important. First I have to say that I do not blame PP beeing destroyed or to destroy vB. But anyhow, something must have gone wrong and maybe it was my fault.

1.- I used the scripts from 5.62 downloaded on 12-08-2006 and copied all the scripts over the existing 4.81 dir

2.- I forgot to change config-int.php (not -inc) from local system to the server/internet paths (you should mention in upgrade.txt!). I did it now, but it does not change anything and if the file is used to be written somewhere in database, in db could remain some local values. Is this the case or is the file used as file, not for putting the values into db?

3.- I am not 100% sure but I thought that my local upgrade worked perfect without upgrade 4.82. Anyway, could I do the sql steps from upgrade.php manually now or "is it to late", because following updates changed it again?

Code:

Content visible to verified customers only.

4.- if we do not manage to save this installation/upgrade I could try to use my backups. But, since vB, vba cmps and PP are in the same database without prefixes (will change that later): what tables EXACTLY belong to PP 4.81, please?

Are they exactly as Michael posted here?

I would try to copy those tables into the database and untar the data-dir (is this necessary?!) to have PP 4.81 again to reupgrade.

5.- we don't have FTP on our server (SCP only), so access is a little difficult. But if you think it could help I could give you access to the database to have a look.

Thank you a lot, the users are really crying. This is high saison till New Years Eve...

Yours
Pyro

PyroMarkus · December 17th, 2006, 01:37 AM

One more info to be sure: I did had 4.81 not 4.82

Although the old config file says only
// PhotoPost Pro Version Number
$VERSION = "4.8";

I checked in db and an old version (and the new, faulty upgraded db) both dont have the columns "ugnovote" or "uplimit" which was added in 4.82 upgrade.

So, try manually SQL?!

Thanks again!

Chuck S · December 17th, 2006, 09:41 AM

I would suggest you rename those tables as suggested here to add a prefix and alter your config to add that prefix

Adding a prefix to your PhotoPost tables

You can then rerun the 4.82, 5.5 and 5.6 upgrade scripts you should be fine.

PyroMarkus · December 17th, 2006, 10:47 AM

Dear Chuck,

thanks again!

I inserted the 4.81 photopost db into an new database called "photopost".
I changed access in config-inc.php
I tried to run upgrade 4.82 but the page refreshed and offered upgrade 4.82 again - tables were not altered
I run ALL SQL commands from 4.82 upgrade manually in phpmyadmin -> success
I started with upgrade 4.85 and updated successfully untill 5.61

That's for the history.
Now I have only slight problems left - catagories and search work perfect now.

But:
I am recognized as Administrator (admin-link is offered) but when clicking it the old login page from PP 4.81 returns. I can successfully log in but cannot enter adm-index.php.

$ppdateformat is listed everwhere where should be shown a date
some (!) parts refer to old styles in album/stylesheets/dark-borders/...
So some gif's are missing and some styles do not fit.

I think first is to enter admin panel - what to you suggest, please?
Or, how to find in database tables where PP 5.62 refers to old styles?!

Best regards!

Chuck S · December 17th, 2006, 11:46 AM

I would suggest adding this to the top of upgrade.php and try runningt 4.82 upgrade

$skip_exheader="yes";

PyroMarkus · December 17th, 2006, 12:08 PM

Sorry, what is this for, please?

In the end all updates went smooth from 4.82 to 5.61. I did the 4.82 SQL commands all one by one manually with success and afterwards the update scripts starting from 4.85. I would say: all done.

When now rerunning 4.82 I will get database errors?!

Thanks again - you are a great help!

Chuck S · December 17th, 2006, 02:18 PM

I would suggest you let the 4.82 upgrade run as it should since you hand enter queries with the wrong variable info which the upgrades gets from your config file which is why I gave you that to add to your upgrade so you could run it correctly

PyroMarkus · December 17th, 2006, 02:18 PM

Ok, done.

I checked "settings" table and found, that lot of settings did only have a php-variable but no value. See screenshot.

Furthermore the old "dark-borders" were set as theme and not "vB style intergration"

That's it - all is fine. I even can go indadmin panel because the cookie value was a variable too.

I think I did all nessessary upgrade steps, but I don't know, what was missing.

Ahhhh, the adminlog table was not renamed to admlog. So something went wrong, but now is fine.

If anybody has same problems: check "settings" table with phpmyadmin...

Thanks a lot Chuck for beeing with me!

PyroMarkus · December 17th, 2006, 02:19 PM

ok, crosses messages - now I know why I had variables in my tables. But I think now is fine.

Thanks a lot!

PyroMarkus · December 18th, 2006, 02:57 AM

Ok, Chuck, one thing occoured - maybe you have again an hint, please?

Search within "title" and "description" works perfect.

But when I search within "comments" the result set looks pretty good, this means the correct thumbs show up with the correct comments. so the search itself was ok. But then clicking on the thumbs leads to Nirwana - "the photo does not exist anymore in the database". So the thumbs are not linked correctly to the showphoto...

Example: search for "material" in "comments" (please change domainname as you know):
http://mydomain.de/album/search.php?searchid=135

The thumbs are fine, so the found comments, but the links are corrupt.

eg. one photo of me in the result set (real address):
http://mydomain.de/album/showphoto.php?photo=16782

but the result set links to
http://mydomain.de/album/showphoto.php?photo=40179

Do you have any idea, please?
Thanks in advance!

PyroMarkus · December 18th, 2006, 06:08 AM

One more hint regarding this:

very seldom the first text line of first comment in "comshow" is repeated in each and every following comment listed below.

Any idea, please?!

PyroMarkus · December 18th, 2006, 06:51 AM

OK, THIS IS PP BUG!

The same behavior (wrong linking to images when searching within comments) is to see here:

Actual comshow, actually first photo links to:
http://www.photopost.com/photopost/s...php?photo=5259

And wrong linking when searched within comments (eg for "Blimey"):
http://www.photopost.com/photopost/s...p?searchid=326

links to
http://www.photopost.com/photopost/s...hp?photo=21303

(with or w/o thumb)

So, any quick fix just for this?

And what to do with the repeating of the first line, sometimes, in comshow (see above)?

Anybody see this?

Thanks a lot!

Chuck S · December 18th, 2006, 07:44 AM

Please ensure you have uploaded all the new files and this you can post a url example as I dont know what your site is sorry. I dont remember with as many people I help who or what sites I looked at 2 days ago.

Let's see you keep saying comshow which is wrong your talking about the search comments function in search. Well here is a search of my comments on 5.62

http://www.reeftalk.com/gallery/search.php?searchid=12

Please ensure to redownload the code and replace the templates and core php files. This reminds me of an initial issue in the 5.61 release