Database Error

[Artimedia]

Hi,

I just moved yesterday my website from one server/host to another. I copied all the directory where all the files  where and I tried to import the database in phpmyadmin. I was always getting an import error:

Error
SQL query:

CREATE TABLE `501sttp_events` (

id int( 11 ) NOT NULL AUTO_INCREMENT ,
id_member int( 11 ) NOT NULL ,
date int( 11 ) NOT NULL ,
textvariable mediumtext NOT NULL ,
link mediumtext NOT NULL ,
description mediumtext NOT NULL ,
allowed mediumtext NOT NULL ,
eventid int( 11 ) ,
ON tinyint( 4 ) ,
PRIMARY KEY ( id ) ) TYPE = MYISAM ;


MySQL said: 

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'on tinyint(4),
  PRIMARY KEY (id)
) TYPE=MyISAM' at line 10

So, I removed in notepad the text that corresponded to the creation of the table `501sttp_events`. After that, I successfully imported the database in phpmyadmin. Then I manually created the table `501sttp_events'. I think I created it correctly because I copied the number and ID of fields, colation, index, A-I, attributes, etc... From the same table on the original install in the first server/host (which I didn't delete).

Apparently everything was fine but now, I'm getting lots of errors. For instance, if I go to TP Downloads and click on a folder, I get the following:

Database Error:

Unknown column 'dlm.author_id' in 'where clause'
File: /home/legiaoco/public_html/Sources/TPSubs.php
Line: 2453

Also, if I go to Profile>TinyPortal and click on any of the links, I get errors such as:

Fatal error: Call to undefined function tp_summary() in /home/legiaoco/public_html/Sources/Profile.php on line 363

I am using TP 1.0 Beta 5.0 and SMF 1.1.11. My URL is at: http://www.legiao501.com/index.php

Thanks in advance for your support.

Edit: I noticed that the .sql database file that I imported when restoring the database at phpmyadmin, had many references to my previous site url, like:

http://www.artimedia.pt/legiao501/mgal_data
/home/artimedi/public_html/legiao501/mgal_data

where as now they are:

http://www.legiao501.com/mgal_data
/home/legiaoco/public_html/legiao501/mgal_data

If I make a "replace all" in Dreamweaver to correct these urls in the database file, will it solve the problem?

[IchBin]

All of your issues have been covered in the forum if you do a search you'll find that out. As for the dreamweaver comment, that's tough to say. Wouldn't hurt to try if you have a backup.