ptadmin Posted November 18, 2008 Share Posted November 18, 2008 Ok, This is a bit weird and want to see if anyone has ever had this issue. I am working at setting up File Servers so I can have tcadmin pull from it in Chicago. When I go to do the File Servers option in tcadmin and go to create it I am getting a MySQL error ERROR [42S02] [MySQL][ODBC 3.51 Driver][mysqld-5.0.45-community-nt]Table 'tcadmin.tc_file_servers' doesn't exist SQL Command: INSERT INTO TC_FILE_SERVERS (FILE_SERVER_ID, DATACENTER_ID, DISPLAY_NAME, USER_ID, PASSWORD, SERVER_IP, FTP_PORT, PATH_TO_GAMES, SYNC_SERVER, SYNC_PAGE) VALUES ('TCFS55051248755', 'TC3626758020880', 'Test', 'tcadmin', 'MRXRzM0zNcq0+w/7Icct2Q==', ftpinfohere, 21, '/Games', 0, 'http://www.yourtcafileserver.com/fileserver.aspx') Ok so I understand this error is completely related to MySQL so here is the problem. The tc_file_servers table in mysql will not let us do anything. It will not let us delete it and create a new one it will not let us edit it it basically will not let us do anything to it. It has no data in it like it is supposed to so tcadmin knows where to write the data. Anyone have any ideas what the heck?? How we could force delete the tc_file_servers table and create a new one. Link to comment Share on other sites More sharing options...
VicToMeyeZR Posted November 18, 2008 Share Posted November 18, 2008 Well that says that table doesn't exist at all. Have you installed the MySQL Manager? It sure is nice for editing your databases if you don't know how to use the command line. But looking at that error, it doesn't exist, so I don't know how you can delete what isn't there. It looks like you would need to to a DROP tcadmin.tc_file_servers Then make a create with those ---->(FILE_SERVER_ID, DATACENTER_ID, DISPLAY_NAME, USER_ID, PASSWORD, SERVER_IP, FTP_PORT, PATH_TO_GAMES, SYNC_SERVER, SYNC_PAGE) in it. Link to comment Share on other sites More sharing options...
ptadmin Posted November 19, 2008 Author Share Posted November 19, 2008 That is what is weird, If you look in through an option called Catalog you dont even see tc_file_servers but if you go into the query browser it still has tc_file_servers and cant edit, cant remove basically cant do anything with that table. We already created a proper one named tc_file_server but we cant save over tc_file_servers so its just sitting there and like it does not know that it is gone. Link to comment Share on other sites More sharing options...
VicToMeyeZR Posted November 19, 2008 Share Posted November 19, 2008 What are you using to look at your database? MySQL Manager? or something else? Link to comment Share on other sites More sharing options...
ECF Posted November 19, 2008 Share Posted November 19, 2008 Support ticket time.... Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.