PhotoPost Photo Gallery Sales PhotoPost Sales Toll Free Phone Number
Mon-Fri 9am-4pm EST
  PhotoPost Photo Sharing Photo Gallery    Visualize community tm
| | | | | | | | |

Go Back   PhotoPost Community > PhotoPost Support > PhotoPost Classifieds Support > Classifieds Suggestions

Classifieds Suggestions Have an idea to make Classifieds even better?

Reply
 
LinkBack Thread Tools Rate Thread Display Modes
Old August 25th, 2007, 08:15 PM   #1 (permalink)
Junior Member
Verified Customer
 
Join Date: Aug 2007
Posts: 15
Installation routine

I had some problems with the installation - actually the load of the database (very likely cause by timeouts because of server load at my webhoster). Re-running the installation script did not work because the tables were already there. My suggestions:
Insert this right after the
// SQL queries array
$query = array();
lines
Quote:
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}admlog ";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}favorites";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}laston";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}categories";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}comments";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}products";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}settings";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}sort";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}admingroups";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}notify";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}users";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}ipcache";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}iponline";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}adtypes";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}feedback";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}stats";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}payments";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}bidding";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}bids";
$query[] = "DROP TABLE IF EXISTS zipData";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}cache";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}extrafields";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}productextras";
$query[] = "DROP TABLE IF EXISTS {$pp_db_prefix}currency";
Second suggestion:

Add a line
Quote:
print "<b>1 - Line: ".$iquery."</b><br />";
right after this in the upgrade/install file
for ( $x=0; $x < count($query); $x++) {
$iquery = $query[$x];
$iquery = str_replace( ";", "", $iquery );

That avoids timeouts and shows that something is still going on....

Last but not least: Add the prefix to to zipcode table...

Tom
Big Tom is offline   Reply With Quote
Old June 28th, 2008, 09:50 PM   #2 (permalink)
Junior Member
Verified Customer
 
Join Date: Aug 2007
Posts: 15
Looks like the latest (06-2008) install file has the same issues.

Tom
Big Tom is offline   Reply With Quote
Old June 28th, 2008, 11:07 PM   #3 (permalink)
Photopost Developer
Verified Customer
 
Chuck S's Avatar
 
Join Date: Jun 2002
Location: Abingdon,MD
Posts: 52,693
what issue is that you get duplicate errors if you run through install twice that does not indicate an error with the install
__________________
Photopost Developer and Support Engineer

Please do not PM me for support or sales questions. Thank you for your understanding.
Chuck S is offline   Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Bug in Current users routine Arjan Photopost Pro Bug Reports 1 November 6th, 2006 05:40 PM
Installation puckparches Photopost Pro Installation & Upgrades 2 June 25th, 2006 08:42 PM
Installation Help Please kurv Classifieds Installation & Upgrades 9 August 22nd, 2005 10:34 AM
Installation fails between step 2 and step 3 when running installation script SigEp441 Classifieds Installation & Upgrades 2 July 19th, 2005 10:41 PM
How do I integrate an existing PP installation with an existing Ipb installation? petrucci Photopost Pro How Do I...? 2 April 21st, 2005 08:00 AM


All times are GMT -5. The time now is 11:53 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 3.2.0