Now I have ALREADY Searched the old posts. Now maybe I did not enter the right query string, but I DID try.

So now here is my question:

I am getting an error when validating links:

DBSQL (6113):

Fatal Error: Unable to execute query: SELECT * FROM Validate_Attach WHERE DataID = ? . Reason: Table 'lessonps.Validate_Attach' doesn't exist at Links/DB_Utils.pm line 143

My site was just migrated to a new server by my hosting company, and I have worked out all of the other problems *so far*, but I am unable to find the solution to this one in old posts.

After you are done yelling at me for 'already having to answer this problem', could you please direct me to the RIGHT place?

Thanks for your help, and sorry for not being able to find this in a previous thread - In Advance.

Well, your attitude is no better, and this is a post that probably doesn't deserve an answer as it stands.

But, if you read the error message, it is telling you that your table doesn't exist. Why? Check your layout configuration. I can't tell from this.

http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/

Pugdog,

I have always appreciated your help, there are just some occasions when certain people make you feel like an idiot for posting a problem in this forum. I am now hesitant due to the belittled feeling that I get after being told how stupid I am for asking the question in the first place. Through this process it takes approximately 10 more posts than are necessary to solve the initial problem. Therefore, I stated that I have already completed the tasks that are usually thrown back at me.

Aside from that, it appears that it is looking for a table called: Validate_Attach
There is no table (that I can find) named 'Validate_Attach'. So, I made a dummy site, and installed LINKS SQL and imported an old links2.0 back-up file. The import worked fine, and appears to work without issues. But I was unable to find the table 'Validate_Attach' in that site either.

I have no idea what kind of information is needed to troubleshoot this problem, and I know nothing about SQL. I would contact Alex for direct help, but I have tried that 2 times, and never got any reply, for those problems.

If this thread does not deserve a response due to my initial post, then I will accept where I stand, and deal with not being able to add links.

When your host transferred the database (I would personally not have allowed them to do that)...they probably did not transfer all the tables.

What I would recommend doing is re-setting up your Links database via the setup.cgi, so that all the tables will be re-built....then you can import data into the tables.

I assume you have recent clean backups of your tables.

Regards,

Eliot Lee

You can just re-run setup.cgi

Just make a copy of your .defs directory.

It won't over write any tables, and if any tables are missing, it will add them (the only create command that will succeed).

Then, copy your def files back, (to reset all your weights) and you'll be set up.

The best way to move a database is to dump the structure, then dump the data. then import it back into to the new database.



http://www.postcards.com
FAQ: http://www.postcards.com/FAQ/LinkSQL/