[testpig]

OK....back home and on the job.

I have deleted the lot, emptied the database and started from scratch. Too many tweaks to the script and I've lost focus. The root cause is that when running step 3 I get a LONG list of database errors (looks to be every table added to the database). Following the errors list I get the install text and button to proceed to step 4, so I had previously continued the install.

step 3: MySQL error reported: [CREATE TABLE pp_admlog (id int(10) NOT NULL auto_increment,adminuser varchar(50) NOT NULL default '',description varchar(255) NOT NULL default '',datestamp int(20) NOT NULL default '0',ip varchar(35) NOT NULL default '',PRIMARY KEY (id)) TYPE=MyISAM]
Result: Table 'pp_admlog' already exists
Database: ppclassifieds

Followed by a list of:

Error: Table 'pp_admlog' already exists
Error: Table 'pp_favorites' already exists
Error: Table 'pp_laston' already exists
Error: Table 'pp_categories' already exists
Error: Duplicate entry '1' for key 1
Error: Duplicate entry '2' for key 1

Previously I got a blank screen at step3 so I added this code relating to the zip file. This allowed me to proceed , but with the above errors!

Open up the install.php file and delete the lines to import the zipData.sql

// Upload the zipcode data (if present)
$query = @file("zipData.sql");

for ( $x=0; $x < count($query); $x++) {
$iquery = $query[$x];
$iquery = str_replace( ";", "", $iquery );
$setup = mysql_query($iquery, $link);
if ( !$setup ) print "<b>Error: ".mysql_error()."</b><br />";
}

You can then run the upgrade.php and import zipcodes that way

This got me through step3, but with errors. If I remove the code I get a blank screen, but when I go into PHP myadmin the tables have been added to the dbase.

I have the settings set up to run the classifieds in one database, and the second set of fields set to my VB3 forum database. I had thought this would add classifieds info to its own bdase whilst referencing the VB3 dbase for user info etc.

So I'm open to suggestions. The issue starts with the addition of the database tables. I added the zip file mod to overcome it. Curiously I cant add the zip file with the upgrade script as it also errors out (possibly because I've already ftp'd the file? DO I even need the zip file code? or is there something else I should add here to get me through step three? Not sure but there is certainly an issue when adding the tables.

Cheers,