Error during upgrade from 5.5 to 5.6

The Wedge · November 25th, 2006, 09:58 AM

I have no idea what this is. I had my photopost professionally installed and upgraded just a week ago. I don't understand why I have these problems.

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( 3, 6 ) NOT NULL DEFAULT '0', date INT( 15 ) NOT NULL DEFAULT '0' )
Error: Table 'search' already exists

My CP says that I'm upgraded to 5.6 but I'm not comfortable with this. The install didn't say finished. Last thing I saw was this error with no option to move forward. How do I fix this?

Chuck S · November 25th, 2006, 03:19 PM

duplicate mysql error means you ran the script twice

The Wedge · November 25th, 2006, 04:24 PM

Quote:

Originally Posted by Chuck S

duplicate mysql error means you ran the script twice

No, I ran it once. I know for a fact. What is the solution with this? Now I notice my search doesn't work.

Chuck S · November 25th, 2006, 04:33 PM

what do you mean search does not work are you specifying a date range etc

The Wedge · November 25th, 2006, 04:48 PM

it doesn't work when I choose a date range either. Plus on the main page there is no date range option. Obviously something is wrong. And I'm 100% positive I didn't run any script twice.

you can try for yourself www.sicktracks.com/galleries

Chuck S · November 26th, 2006, 02:29 PM

Make sure the search table you have is ours and not from some hack you have installed for vbulletin. The search table in Photopost must be installed for your search to work. We have another user I was reading he had a search table and fessed up to a vb hack having a table name of that nature

The Wedge · November 26th, 2006, 04:09 PM

how do I know if it's from photopost or not? And what search table does vbulletin use? If this is from a hack then it's from an old version of the site when I had vb 2.2.9. I recently upgraded everything. But every site I've done with vb regardless of hacks has a "search" table.

Michael P · November 26th, 2006, 04:14 PM

Is your photopost installed in the same database as vBulletin? Does your PhotoPost installation have a prefix?

The Wedge · November 26th, 2006, 04:24 PM

no it doesn't have a prefix and yes it is in the same database as vB. If you are going to ask why it was done like this then the answer is because I had you guys initially install this back a few years ago. So that is how it was done

Chuck S · November 26th, 2006, 05:29 PM

If this is a hack from vb you can uninstall the hack for vb and then run our upgrade and you should be fine.

The Wedge · November 26th, 2006, 05:50 PM

vB HAS a search table already in there. Not from a hack. I just checked a site that has only vB installed on it with no hacks. it was just installed from a new database.

Chuck S · November 26th, 2006, 10:21 PM

I would suggest renaming your photopost tables to include a table prefix like pp_ to not conflict with vBulletin.

The Wedge · November 26th, 2006, 10:26 PM

Why wasn't that done on the initial install?

How do I know which tables are photoposts?

Michael P · November 26th, 2006, 10:29 PM

The default for installation is to add pp_ as a table prefix;

pp_admingroups
pp_admlog
pp_cache
pp_categories
pp_comments
pp_ecards
pp_exif
pp_extrafields
pp_favorites
pp_ipcache
pp_iponline
pp_laston
pp_notify
pp_perpage
pp_photoextras
pp_photos
pp_photoviews
pp_search
pp_settings
pp_sort
pp_sortmemb
pp_stylesheet
pp_usergroups
pp_users

Michael P · November 26th, 2006, 10:35 PM

Here are the SQL commands that you can copy and paste (be sure to close your gallery first).

Code:

Content visible to verified customers only.

You'll need to edit your config-inc.php and change

$pp_db_prefix = "pp_";

And you'll have to create the search table:

Code:

Content visible to verified customers only.

The Wedge · November 27th, 2006, 06:36 AM

Thanks. After I do this I will be able to run the install again? Do you see any problems with the steps already completed last time I tried to install?

Michael P · November 27th, 2006, 06:52 AM

If you are running install for the first time, you can just remove the PhotoPost tables and run install again using pp_ as your prefix (you dont need to rename the tables if this is a new installation).

I assumed you were modifying an existing installation.

The Wedge · November 27th, 2006, 07:09 AM

I meant upgrade

Michael P · November 27th, 2006, 07:12 AM

Oh, if everything else worked okay, you wouldn't need to run it again after doing this.

The Wedge · November 27th, 2006, 08:01 AM

i tried this on my test site and I see that after I rename the tables the old tables are still there in my phpmyadmin. Is this normal? Should I delete these old tables?