View Single Post
Old August 25th, 2007, 07:15 PM   #1 (permalink)
Big Tom
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