Install Problem Creating Tables

[craven]

I finally got around to trying to update my site and set up goes fine until I get to the New Install/Upgrade page. When I choose Upgrade I get the following failed messages and the idx_link & idx_link_temp tables are deleted.

Creating new tables ....

idx_checkurl....ok
idx_sessions....ok


Altering tables ....

idx_category add header....failed
idx_category add footer....failed
idx_category add related....failed
idx_category add page_title....failed
idx_category add hits....failed
idx_category add order_num....failed
idx_link add official_review....ok
idx_link add keywords....failed
idx_link add cat1....ok
idx_link add cat2....ok
idx_link add sp_cat....ok
idx_link add sp_cat_date_limit....ok
idx_link add sp_cat_order....ok
idx_link add suspended....ok
idx_link add index title....failed
idx_link_temp add official_review....ok
idx_link_temp add keywords....failed
idx_link_temp add cat1....ok
idx_link_temp add cat2....ok
idx_link_temp add sp_cat....ok
idx_link_temp add sp_cat_date_limit....ok
idx_link_temp add sp_cat_order....ok
idx_link_temp add suspended....ok


Reorder columns in idx_link table ....

create temporary table....failed
lock idx_link....ok
copy idx_link -> temporary....failed
unlock tables....ok
drop table idx_link....ok
create table idx_link....failed
copy temporary -> idx_link....failed
drop temporary table....failed


Reorder columns in idx_link_temp table ....

create temporary table....failed
lock idx_link_temp....ok
copy idx_link_temp -> temporary....failed
unlock tables....ok
drop table idx_link_temp....ok
create table idx_link_temp....failed
copy temporary -> idx_link_temp....failed
drop temporary table....failed


Done


The when I go to admin I get thie error message.
Fatal error: Call to a member function on a non-object in /home/httpd/html/mysite.com/admin/summary.php on line 31

My host is using MySQL version 4.0.15-standard now so I'm not sure why upgrading would be a problem. I do have several custom fields including the custom field keywords on my site.

I'm trying to upgrade from 3.04. All paths are set correctly. Any Suggestions?

Thanks,

Craven

[esm]

since I have no knowledge, I'd find out why the following SQL commands failed:
alter table idx_category add header text NOT NULL
alter table idx_category add footer text NOT NULL

that's why you got the following:
idx_category add header....failed
idx_category add footer....failed

some of dody's "failed" are ok. but not this.
everything was downhill after the first add header "failed"

[craven]

If I run a new install everything goes as planned. The script has no problem creating the tables. It's only when updating that I have this problem.

It is really strange how the 2 link tables are being totally deleted. I'm going to keep working on it today and see what I can accomplish!

Craven

[esm]

in looking at the update script I see where the altered 3.0 link table is copied to a temp table, then dropped, then a 3.1 link table is created and the temp link table just created is copied into the new 3.1 link table.

must be some sort of mysql problem. maybe check with your host.

can you import the data from your backup into the new install? Not sure if there are any issues with that. You'd have to look at the install script to see if there are any problems with that.

[craven]

The problem with importing the backup is that when you import a backup file from 3.04 that has custom fields into 3.1 then the data is imported to the wrong tables.

I'm going to contact my host to see if the problem could reside on their end.

Thanks,

Craven

[esm]

Originally posted by craven
The problem with importing the backup is that when you import a backup file from 3.04 that has custom fields into 3.1 then the data is imported to the wrong tables.

That does not compute but I am having a rough day today. Can't seem get my brain working!

So you are saying that a field in the 3.0 link table ends up in 3.1 category table. Or something similar (just change the table names).

If you create a new INDEXU database and then create all the custom fields in the appropriate tables, then the import should work. Unless I forgot something, which I usually do!

[craven]

Thats what I thought too. I did a new install, created the custom fields the same, then imported it.

I have the custom fields

city
county
phone
fax
keywords

Title, Url, descripton, contact name, e-mail is put into the correct fileds but the custom fields are not. EX: Phone number is not in the custom field phone anymore.

Sorry if I'm not being clear enugh! I have been working on so many different things my head is ready to explode!

I've been unemployed for the last 4 months and have been trying to get something going before the unemployment runs out

Craven

[esm]

if you are using the INDEXU import, you may want to read this:

http://www.nicecoder.com/community/s...&threadid=1406

you might want to check with your unemployment office on the exact date of your last check. They did extend it during the summer.

I'd be curious how you plan to replace your income with a links directory. So would everyone else.

[craven]

Yes! Maybe this is the problem. I'll give this a shot sometime tonight!

I checked with them sometime back and they said they couldn't tell me until my unemployment runs out whether I would be able to receive the extension. Maybe they just want me to get a job now

I have several other sites besides my directory and I'm hoping they start bringing it in! Of course, who doesn't!

Thanks,

Craven

[craven]

Nothing works! Sometimes this is just so frustrating!

I've tried using the upgrade, importing and creating a backup of the database then uploading then restoring it into the new version!

I can't think of what could be wrong. My host says everything is working fine on their end!

[esm]

well, when you do not get the results you expect, there is generally something wrong with the "query." (or, it is doing exactly what you tell it to do and you think (incorrectly, as it turns out) it should be doing something else.

rather than use the INDEXU import feature, use phpmyadmin or mysqlman to import the file. maybe that will show an error.

post one of the SQL statements. maybe that will help.

[craven]

Bad news for me! After moving to the new server with MySQL 4 I've been experiencing severe slow down and site outages. My host claims it's Indexu and it's persistent connections! Although I've modified the files that Dody and Sophia suggested.

Now I'm moving back to the old server with MySQL 3.22 for now. Hopefully Version 4 will be compatible with it!

Thanks for the help ESM but I guess this is one problem I don't need solved anymore! Even though it would have been nice to figure out.

Thanks,

Craven